使用php在MySql中远程连接疑问 [英] remote connection doubt in MySql using php

问题描述

php文件在我的系统中，数据库在我的服务器192.168.1.25中，所以

i创建了我的文件名conn.php

php file is in my system and the database is in my server "192.168.1.25", so
i created my file name "conn.php"

<?php
$dbhost = '192.168.1.25:3306';
$dbuser = 'root';
$dbpass = '';
$database = 'sample';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
/*mysql_select_db($database, $conn);*/
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
mysql_select_db('sample', $conn);

$sql = 'select * from test';

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_NUM))
{
    echo "EMP ID :{$row[0]}  <br> ".
         "EMP NAME : {$row[1]} <br> ".
         "EMP SALARY : {$row[2]} <br> ".
         "--------------------------------<br>";
}
mysql_free_result($retval);
echo "Fetched data successfully\n";
mysql_close($conn); 
?>


</body>
</html>
</html>

i得到此错误，如下所示



无法获取数据：未选择数据库



请帮助我，

提前感谢...

i got this error, given below

"Could not get data: No database selected"

please help me,,
thanks in advance...

推荐答案

dbhost = ' 192.168.1.25:3306';

dbhost = '192.168.1.25:3306';

dbuser = ' 根;

dbuser = 'root';

dbpass = ' ';

dbpass = '';

这篇关于使用php在MySql中远程连接疑问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！