Message in connect to DB

[berrutti]

What is happening here, when a try to connect to my DB?

Fatal error: Uncaught PDOException: could not find driver in /home/wiolxdeu/domains/prbcursos.x10.bz/public_html/Conexao.php:3 Stack trace: #0 /home/wiolxdeu/domains/prbcursos.x10.bz/public_html/Conexao.php(3): PDO->__construct() #1 /home/wiolxdeu/domains/prbcursos.x10.bz/public_html/cabecalho.php(4): require_once('/home/wiolxdeu/...') #2 /home/wiolxdeu/domains/prbcursos.x10.bz/public_html/index.php(5): require_once('/home/wiolxdeu/...') #3 {main} thrown in /home/wiolxdeu/domains/prbcursos.x10.bz/public_html/Conexao.php on line 3

The file Conexao.php has this commands:
$bd = new PDO("mysql:host=localhost; dbname=wiolxdeu_ramiro; charset-UTF8", "wiolxdeu_ramiro", "XXXXXXXXX");

 

[ctyrd]

What is happening here, when a try to connect to my DB?

Have you check php version and check if "pdo_mysql" extension is enabled. https://prbcursos.x10.bz:2222

 

[berrutti]

Yes, it's enabled and my version of PH is correct.

 

[ctyrd]

$bd = new PDO("mysql:host=localhost; dbname=wiolxdeu_ramiro; charset-UTF8", "wiolxdeu_ramiro", "XXXXXXXXX");

Is that line:11 in Conexao.php or what is line:11? http://prbcursos.x10.bz

 

[berrutti]

The line 11 is:
$bd = new PDO("mysql:host=localhost; dbname=wiolxdeu_ramiro; charset-UTF8", "wiolxdeu_ramiro", "XXXXXXXXX");
XXXXXXX is my password

 

[berrutti]

 

[ctyrd]

Maybe syntax, is it $bd = or $db = and extra " marks. Try something like

$db = new PDO('mysql:host=localhost;dbname='.DBNAME, 'user', 'password');

 

[berrutti]

In my local machine it works.
I only define my local database.
But i'll try it.

 

[berrutti]

It doesn't work.
Same error.
I don't know what is happening.
In my local machine it works (with my local definitions).

 

[ctyrd]

@berrutti
You'll have to search, Do you have a phpinfo.php file in the public_html dirctory?

<?php phpinfo();?>

Check for errors in error logs https://prbcursos.x10.bz:2222/

Try enabling "pdo_dblib" and "nd_pdo_mysql"

• Server: DA PMA Signon (Localhost via UNIX socket)
• Server type: MariaDB

 

[berrutti]

No, I don't have a phpinfo.php file in the public_html directory.
I'll try to enable "pdo_dblib" but doesn't work.
I'll see the errors log.

 

[berrutti]

I create the file phpinfo.php and here is the result:

 

[berrutti]

My local machine version (it works) is

PHP Version 8.2.0​

 

[ctyrd]

phpinfo.php can help find the trouble. It is very difficult searching for issues on script written at home, running on a hosting server software.

pdo_mysql.default_socket - /var/lib/mysql/mysql.sock

Check error logs.

 

[ctyrd]

I'll see the errors log.

Check the pdo drivers in your phpinfo mysql is not enabled.

yours: dblib, firebird, oci, odbc, pgsql, sqlite
mydrivers: mysql, sqlite

PHP 7.4.33 - phpinfo()

 

[berrutti]

I tested it on another provider, 000webhost, and it worked perfectly there. So thanks for the help. In the future I intend to come back and test again here, because I really liked X10hosting, but for now I'm going there. Thank you so much for everything.

 

[spacresx]

x10 hosting does not provide any script support.
other forum users may offer advice or suggestions if available.

what kind of script is Conexao.php ?
is this part of your x10 settings or is it a 3rd party script ?

 

[berrutti]

It's my php file.
I made it.
<?php
$bd = new PDO("mysql:host=localhost; dbname=wiolxdeu_ramiro; charset-UTF8", "wiolxdeu_ramiro", "XXXXXX");
$bd -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>
I removed the other comments.
he problem line is: $bd = new PDO("mysql:host=localhost; dbname=wiolxdeu_ramiro; charset-UTF8", "wiolxdeu_ramiro", "XXXXXX");

In my index.php at first:
require_once 'Conexao.php';