drti52047 2014-05-30 14:41
浏览 73
已采纳

php本地连接mysql数据库

I try to make a simple IOS app that can connect to mysql database and read one table. But my php code does't work and really have no idea why, it's seems correct to me. The database is in a raspberry phpmyadmin server and the server works great. I will put my code here and please tell me what's wrong.

<?php

$host = "192.168.2.193";
$db = "produtos";
$user = "root";
$pass = "1234";

$connection = mysql_connect($host, $user, $pass);

if(!$connection)
{
die("Database server connection failed.");
}
else
{
//attempt to select the database
$dbconnect = mysql_select_db($db, $connection);

//check to see if we could select the database
if(!dbconnect)
{
       die("Unable to connect to the specified database!");
}
else
{
    $query = "SELECT * FROM produtos";
    $resultset = mysql_query($query, $connection);

    $records = array();

    //loop throught all our records and add them to our array

    while ($r = mysql_fetch_assoc($resultset))
    {
        $records[] = $r;
    }

    echo json_ecode($records);
    echo $resultset; 

}
}

?>
  • 写回答

1条回答 默认 最新

  • dongshan9338 2014-05-30 15:31
    关注

    Based on the question:

    use mysqli_connect rather than mysql_connect because mysql_connect is deprecated and will not work someday. Also what is the the error you are getting? change your die() statement to something more helpful die(mysqli_error($connection));

    Based on your comment:

    That error would suggest that you either A) don't have the right IP address or B) there is a network issue between your host server and the SQL server, is this code running on the same server that is hosting the SQL database? if so then you can probably just use localhost for your $host

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 进行基于用户的协同过滤推荐,使用准确率和召回率评价推荐模型的效果
  • ¥15 关于#cesium#的问题:cesium 根据经纬度、高度、方位角、俯仰角和距离求另一点高度
  • ¥15 word脚注设置不起空格符号
  • ¥15 为什么apriori的运行时间会比fp growth的运行时间短呢
  • ¥15 求解密json或者美化
  • ¥15 帮我解决一下膳食平衡的线性规划模型的数据实例
  • ¥40 万年历缺少农历,需要和阳历同时显示
  • ¥250 雷电模拟器内存穿透、寻基址和特征码的教学
  • ¥15 关于Java的学习问题
  • ¥15 如何使用chatgpt完成文本分类任务?