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条)

报告相同问题？

悬赏问题

  • ¥100 有偿求数字经济对经贸的影响机制的一个数学模型，弄不出来已经快要碎掉了
  • ¥15 这个公式写进SIMULINK中的function模块的代码中应该是什么样的
  • ¥15 javaweb登陆的网页为什么不能正确连接查询数据库
  • ¥15 数学建模数学建模需要
  • ¥15 已知许多点位，想通过高斯分布来随机选择固定数量的点位怎么改
  • ¥20 nao机器人语音识别问题
  • ¥15 怎么生成确定数目的泊松点过程
  • ¥15 layui数据表格多次重载的数据覆盖问题
  • ¥15 python点云生成mesh精度不够怎么办
  • ¥15 QT C++ 鼠标键盘通信