{"id":6812,"date":"2022-09-05T06:37:07","date_gmt":"2022-09-05T01:07:07","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-error-while-connecting-to-database-on-hosted-server\/"},"modified":"2022-09-05T06:37:07","modified_gmt":"2022-09-05T01:07:07","slug":"solved-error-while-connecting-to-database-on-hosted-server","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-error-while-connecting-to-database-on-hosted-server\/","title":{"rendered":"[Solved] Error while connecting to Database on hosted server"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Sidenote:<\/strong> Assuming the credentials are correct, given to you by your web host.<\/p>\n

There are several problems with this code (taken from a comment you left).<\/p>\n

Firstly, three of your declarations are not quoted and are being treated as constants. <\/p>\n

PHP error reporting would have thrown notices of undefined constants.<\/p>\n

These are treated as constants:<\/p>\n

 $username=b31_16461744; \n $pass=test123; \n $dbname=b31_16461744_user; \n<\/code><\/pre>\n
You are also referencing the wrong variable for the username being $user<\/code> which should be $username<\/code>. Error reporting would have signabled an undefined variable notice.<\/p>\n
Then you’re mixing mysql_<\/code> with mysqli_<\/code> syntax. Those different MySQL APIs do NOT intermix. You must use the same one throughout your code.<\/p>\n
Sidenote: The other question you posted Access denied for user ‘test123’@’192.168.0.38’ (using password: NO) you are using sql306.byethost31.com<\/code> for the host. Make sure that is correct. I have no idea what settings that host wants you to use.<\/p>\n
<?php \n     $localhost=\"localhost\"; \n     $username=\"b31_16461744\"; \n     $pass=\"test123\"; \n     $dbname=\"b31_16461744_user\"; \n     $a= mysqli_connect($localhost, $username, $pass); \n     mysqli_select_db($a, $dbname); \n     if($a)\n     { \n       echo \"connected..\";\n     } \n     else \n     { \n       echo \"not...!!\"; \n     }\n?>\n<\/code><\/pre>\n
or just use all four parameters:<\/p>\n
<?php \n     $localhost=\"localhost\"; \n     $username=\"b31_16461744\"; \n     $pass=\"test123\"; \n     $dbname=\"b31_16461744_user\"; \n     $a= mysqli_connect($localhost, $username, $pass, $dbname); \n\n     if($a)\n     { \n       echo \"connected..\";\n     } \n     else \n     { \n       echo \"not...!!\" . mysqli_error($a); \n     }\n?>\n<\/code><\/pre>\n
However, your else<\/code> with the echo does not help you. Use mysqli_error()<\/code> to get the real error.<\/p>\n
I.e.: or die(\"Error \" . mysqli_error($a));<\/code><\/p>\n
Example from the manual<\/p>\n
$link = mysqli_connect(\"myhost\",\"myuser\",\"mypassw\",\"mydb\")\n        or die(\"Error \" . mysqli_error($link)); \n<\/code><\/pre>\n
References:<\/p>\n