Questions tagged [database-connection]
A database connection is a facility that allows client software to communicate with database server software, whether on the same machine or not. A connection is required to send commands and receive answers.
12
questions
0
votes
0answers
8 views
Which is the best way to use database connection in phtml file in Magento 2
Which is the best way to use database connection in phtml file in Magento 2
Only for fetching single result from the custom table table
because most of the time I am facing error like "User ...
3
votes
2answers
69 views
How do I get connection to database by entering Database details in Magento 2?
I want to get custom database connection by adding database details in my custom script without using ResourceConnection.
In Magento 1 we can do like this
$conn = new \mysqli($servername, $username, ...
2
votes
1answer
34 views
Run Magento 2 cron with a different database user
Is it possible to run Magento 2 cron tasks under a different database user? This user will be able to connect to the same database as the website itself, and have exactly the same privileges; perhaps ...
1
vote
0answers
25 views
magento 2 custom connection needs to be manually closed?
I have created a second database on the same server as magento database, then I've created a module that fetches data from the second database. In order to fetch data from the second database I have ...
0
votes
0answers
35 views
Magento 2 : How connect Magento with Neo4j Graphical Database
Does any one know how to connect Magento 2 with Neo4j Graphical Database ?
There is a PHP client library (composer require graphaware/neo4j-php-client:^4.0) which i have updated in Magento project, ...
0
votes
1answer
29 views
How to create a complete group tab to admin?
I want to add a group tab in
system > configuration > general > general.
This tab will contain a text area where the user will be able to modify the text.
This text area will be connected ...
0
votes
0answers
38 views
Do I need to manually close database connections?
I have a shop (Magento 1.9) with ~40.000 products.
Every night they will be imported/updated via cronjob. There are other cronjobs that do various database operations as well.
In my import script ...
1
vote
1answer
592 views
Magento 2.2 - Fatal error: Uncaught Error: Call to undefined method Magento\Framework\App\ResourceConnection::load()
Fatal error: Uncaught Error: Call to undefined method Magento\Framework\App\ResourceConnection::load() in
/var/www/html/magento2_dev/vendor/magento/framework/Model/AbstractModel.php:536
Just adding ...
2
votes
2answers
754 views
How to recover env.php file in Magento 2?
is there any way to recover the env.php file. As my file deleted unexpectedly when editing using command line. Now file is empty and showing with 0 size in the ftp. As i don't have the backup of the ...
2
votes
0answers
35 views
Problem connecting to db after securing phpmyadmin with htaccess & htpasswd
I recently having an idea of securing my phpmyadmin portal, So i added htaccess and htpasswd to add another layer of protection
[![enter image description here][1]][1]
And I realized that my web ...
2
votes
1answer
157 views
Magento 2 master slave connection for DB
I am planning to enable Master and slave connection on my Magento site.
Magento team suggest me to check my 3rd party and custom modules support this master/slave config or not.
I am not sure how can ...
2
votes
1answer
665 views
Magento 2 - read and write connection for custom query
I am using Magento 2.2.5 EE. I need to write some custom queries Select and Insert
I know how to write custom query, its simple:
Create new connection:
$objectManager = \Magento\Framework\App\...
