標籤：
使用PHP操作資料庫有兩種方式
下面示範使用第一種方式：
<!doctype html><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body> <?php $conn = mysql_connect("localhost", "root", "zxbbugu"); if(!$conn) { die("Could not connect:" . mysql_error()); } mysql_select_db("test", $conn); //mysql_query("SET NAMES utf8"); $result = mysql_query("INSERT INTO mytable(headline, create_time) VALUES(‘中國‘, ‘" . date("Y-m-d h:i:s") . "‘);"); if( $result < 1) { echo "insert error!"; } $query = mysql_query("SELECT * FROM mytable LIMIT 100 OFFSET 0;"); while ($row = mysql_fetch_array($query, MYSQL_BOTH)) { echo "<p>", $row["id"], " - " , $row["headline"], " - ", $row["create_time"], "</p>"; } mysql_close(); ?> </body></html>
下面是使用PDO方式：
<!doctype html><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body> <?php $pdo = new PDO("mysql:host=localhost;dbname=test", "root", "zxbbugu"); $stmt = $pdo->prepare(‘SELECT * FROM mytable WHERE id = :id‘); $stmt->execute(array(":id"=>1)); foreach ($stmt as $row) { echo $row["headline"]; } $result = $pdo->exec("INSERT INTO mytable(headline, create_time) VALUES(‘中國‘, ‘" . date("Y-m-d h:i:s") . "‘);"); if($result) { $str = sprintf("add data completed, lastupdateid=%s", $pdo->lastInsertId()); echo $str; } $rs = $pdo->query("SELECT * FROM mytable"); while ($row = $rs->fetch()) { echo "<p>", $row["id"], " - " , $row["headline"], " - ", $row["create_time"], "</p>"; } ?> </body></html>
建議使用PDO方式，這樣可以減少SQL注入安全性問題。（php5以上建議使用PDO方式做資料庫操作）
[PHP] - mysql 資料庫操作
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
