Configurando a Connections com MySQL
Não consigo fazer os arquivos do site encontrarem o database MySQL
O modelo de connections da Hospedagem é assim:
<?
error_reporting(E_ALL ^ E_DEPRECATED);
echo time()."<br>";
$dbserver = "IP";
$dbname = "NOME DO BANCO";
$dbuser = "USUARIO DO BANCO";
$dbpassword = "SENHA DO BANCO";
$connect=mysql_connect($dbserver,$dbuser,$dbpassword) or die("Unable to Connect");
mysql_select_db($dbname) or die("Could not open the db");
$showtablequery="SHOW TABLES FROM $dbname";
$query_result=mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($query_result)){
echo $showtablerow[ 0]."<br>";
}
mysql_close($connect);
?>
**Eu apontei assim:**
$dbserver = "145.247.368.5";
$dbname = "o300651419_dados";
$dbuser = "o300651419_usuario";
$dbpassword = "senhadb";
**Então ficou assim:**
<?
error_reporting(E_ALL ^ E_DEPRECATED);
echo time()."<br>";
$dbserver = "145.247.368.5";
$dbname = "o300651419_dados";
$dbuser = "o300651419_usuario";
$dbpassword = "senhadb";
$connect=mysql_connect($dbserver,$dbuser,$dbpassword) or die("Unable to Connect");
mysql_select_db($dbname) or die("Could not open the db");
$showtablequery="SHOW TABLES FROM $dbname";
$query_result=mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($query_result)){
echo $showtablerow[ 0]."<br>";
}
mysql_close($connect);
?>
**Mas as páginas do site dão o erro:**
**Notice**: Use of undefined constant E_DEPRECATED - assumed 'E_DEPRECATED' in **/home/****o300651419****/public_html/Site/Connections/ligacao.php** on line **2**
1501020206
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/o300651419/public_html/Site/Connections/ligacao.php on line 10
Unable to Connect
Alguém pode me dizer onde ESTOU ERRRANDO?
Discussão (7)
Carregando comentários...