如何使用php在远程mysql服务器上查看或编辑或创建表

Question

I am trying to access a mysql server on a remote machine using php. I tried viewing data in table, I am using below php script. Please let me know if I am missing something.

<?php
    $conn = mysql_connect("192.168.1.1","root","password");
    $db = mysql_select_db("charan", $conn);
?>

<?php 
   echo "<ul>";
   $sql = "select * from arista";
   $query = mysql_query($sql);

   while ($row = mysql_fetch_array($query)) {
         echo "<li>Username:$row[0]</li><li>DOB:</li><br/>";
   }
?>

Answer 1

For PHP >= 5.5 you will need to use MySQLi connector.

// this connect with the database
$con = new mysqli("192.168.1.1", "root", "password", "charan");
// here is the SQL query
$sql_query= "select * from arista";
// now execute the query
$result = $con->query($sql_query);

echo "<ul>";
while($row = $result->fetch_assoc()) {
    echo "<li>Username:" . $row['username'] . "</li><li>DOB:</li><br/>";
}
echo "</ul>";

It may works.