php範例程式碼之使用MySQLi介面

標籤：

1234567891011121314151617181920212223242526272829303132333435363738

<?php  //串連參數  $host="localhost";  $user="root";  $pwd="111111";  $db="test";     $linkID =mysqli_connect($host,$user,$pwd,$db); //建立一個mysql串連     if(!$linkID){    echo "<font color=‘red‘>unable to connect!</font>";  }     $SQL_SELECT_SYMBOLS="select * from symbols";     $result=mysqli_query($linkID,$SQL_SELECT_SYMBOLS)or die("error in query :$query. ".mysql_errno()); //執行SQL語句     if(mysqli_num_rows($result)>0){    echo ‘<table cellpadding="10" border="1">‘;    echo ‘<tr><th>id</th><th>country</th><th>animal</th><th>cname</th></tr>‘;     while($row=mysqli_fetch_row($result)){        echo "<tr>";        echo "<td>".$row[0]."</td>";        echo "<td>".$row[1]."</td>";        echo "<td>".$row[2]."</td>";        echo "<td>".$row[3]."</td>";        echo "</tr>";     }     echo "</table>";  }  else{    echo "記錄未找到!";  }     mysqli_free_result($result); //釋放記錄集所佔用的記憶體     mysqli_close($linkID); //關閉資料庫連接?>

php範例程式碼之使用MySQLi介面