dongpan3001 2012-08-29 02:29
浏览 33
已采纳

无法连接到MySQL数据库

I'm trying to conntect to a mysql database for the first time. Can you see what's not working correctly below? I get an error on line 3. What would my server address look like from Godaddy to my database? I found that address in my control panel.

Thanks for any help. Never programmed using PHP before.

<body>
<?php
 $con = mysql_connect("MydbName.db.3924516.hostedresource.com ","Userid","password");
 if (!$con)
 {
  die('Could not connect: ' . mysql_error());
 }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Gallerys");

echo "<table border='1'>
 <tr>
 <th>Thumb Url </th>
 <th>Gallery Url</th>
 </tr>";

while($row = mysql_fetch_array($result))
{
  echo "<tr>";
  echo "<td>" . $row['THUMBURL'] . "</td>";
  echo "<td>" . $row['GALLERYURL'] . "</td>";
  echo "</tr>";
}
echo "</table>";

mysql_close($con);
?> 

</body>
  • 写回答

2条回答 默认 最新

  • dongleiqiao4906 2012-08-29 02:58
    关注

    Try check back the authenication settings, you might use the wrong host, username or password.

        <?php
    $con = mysql_connect("usually it is localhost","your MYSQL username","your MYSQL password"); 

// Checking the login details. 
// Example of default xampp login details: $con = mysql_connect("localhost","root","");  
// Xampp MYSQL default does not have password. 

    if (!$con) // If the login details are wrong, it will should an error.
      {
      die('Could not connect: ' . mysql_error());
      }
    ?>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？