標籤：php資料庫 php基礎教程學習總結
1.資料庫的串連
$dbc = mysql_connect(hosetname, username, password);
2.Mysql錯誤處理
mysql_error();顯示錯誤的詳實報告
3.建立和選擇資料庫
建立：mysql_query(‘CREATE DATABASE somedb’);
選中：mysql_select_db(‘somedb‘); //每次執行查詢前都要選中資料庫
4.建立表
$query = ‘CREATE TABLE my_table(id INT PRIMARY KEY, information TEXT);將建立語句先賦予一個變數
mysql_query($query);//再將變數放入mysql_query()函數
5.插入資料
同建立表，每個查詢都賦予一個變數，然後再將變數傳遞給mysql_query()函數：
$query = " INSERT INTO entries(entry_id, title, entry, data_entered) VALUES(0, ‘title‘, ‘$entry‘, NOW())";
mysql_query($query);
6.安全查詢資料
對於使用者輸入的一段查詢，用mysql_real_escape_string($var)對可能危險的字元如單引號，進行轉義（將在其前加一個反斜線）
7.從資料庫中進行檢索資料
需要將查詢的結果複製給一個變數：
$query = ‘SELECT * FROM users WHERE ( name = myname)‘;
$result = mysql($query);
8.刪除資料
$query = ‘DELETE FROM users WHERE name = myname LIMIT 1‘;
$result = mysql($query);
9.更新
$query = UPDATE tablename SET column1 = value, colunmn2 = value WHERE some_column = value‘;
$result = mysql($query);
編碼測試：ws.php
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>test</title><base> </head> <body> <?php
//串連資料庫，並選中if ($dbc = @mysql_connect('localhost', 'root', '')){if (@mysql_select_db('mydata')){print '<p>selected!</p>';}else{print '<p>can not select error: '. mysql_error().'</p>';}}else{print '<p>can not connect. error: '. mysql_error().'</p>';}
//建立表/*$create = 'CREATE TABLE myTable(id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100) NOT NULL)';print "<p>create……</p>";if (@mysql_query($create)){print '<p>created!</p>';}else {print '<p>can not create error: '. mysql_error().'</p>';}mysql_close();*/
//插入資料$insert = 'INSERT INTO myTable (id, name) VALUES (12345, "charles")';if (@mysql_query($insert)){print '<p>inserted!</p>';}else {print '<p>can not insert error: '. mysql_error().'</p>';}mysql_close();?><div><p>This is the foot of the document</p></div></body> </html>
php基礎教程——5資料庫總結
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
