PHP訪問MySQL數(shù)據(jù)庫數(shù)據(jù)方法步驟及例子

1、PHP訪問MySQL數(shù)據(jù)庫操作方法步驟(增、刪、改、查):1、檢查并過濾來自用戶的數(shù)據(jù)(與網(wǎng)站安全有關)：過濾操作是通過對$_POSTsearchterm變量定義簡短名稱變量的值應用trim() 函數(shù)來實現(xiàn)的。$searchterm = trim($_POSTsearchterm)2、建立一個到適當數(shù)據(jù)庫的鏈接：$conn = mysql_connect($db_server, $db_user, $db_pwd);其中 $db_server 為 MySQL 服務器，例如$db_server = localhost；$db_user為用戶名，例如$db_ _user = root；$db_pw

2、d為密碼，可以為空。3、選擇數(shù)據(jù)庫：$my_db = mysql_select_db($db_name,$conn)； 其中$db_name為數(shù)據(jù)庫的名稱；$conn為上一步驟獲得的資源。4、執(zhí)行查詢語句，并做不同的操作：$result = mysql_query($sql, $conn);其中$sql指的是不同的操作，例如：$sql = select * from user where username=Jack;指的是查詢表格 user 當 中usename為Jack的信息。查詢完后一般會繼續(xù)執(zhí)行后一步的查詢結果返回到 數(shù)組操作。$sql = DELETE FROM user WHERE

3、id = 1;指的是查詢表格 user 當中 id=1的信息，并將其刪除。$sql = INSERT INTO user (id,name) values (T, bbb);指的是給 user 表添 力口一行，id=1，name=bbb。$sql = UPDATE user SET name = aaa where name = bbb指的是將 name 為bbb 的改為 name=aaa。5、獲取查詢結果到數(shù)組：$userInfo = mysql_fetch_assoc($result);將上一步查詢出來的結果賦給數(shù)組 $userInfo6、關閉數(shù)據(jù)庫鏈接：mysql_close($conn

4、);7、將數(shù)組從數(shù)組中取出并顯示：$usename = $userInfousername;$userpsw = $userInfouserpsw;echo your name is ”.$username.”;echo your pass word is .$userpsw.;PHP訪問MySQL數(shù)據(jù)庫操作例子：1、先寫一個數(shù)據(jù)庫配置文件如下：db_config.php我們先寫一個純粹面向過程的方式來讀取數(shù)據(jù)庫中的用戶信息：viewuser_mysql.php?php/ viewuser_mysql.phprequire_once(db_config.php); 包含配置文件.$sql =

5、select * from user where username=Jack ;/* 把將要進行數(shù)據(jù)庫操作的 代碼賦值給$sql*/$conn = mysql_connect($db_server, $db_user, $db_pwd);/建立 mysql 連接$my_db = mysql_select_db($db_name,$conn);/ 選擇數(shù)據(jù)庫$result = mysql_query($sql, $conn); / 執(zhí)行查詢語句，并執(zhí)行$sql 操作$userInfo = mysql_fetch_assoc($result); / 返回查詢結果到數(shù)組mysql_close($co

6、nn); /關閉數(shù)據(jù)庫連接$username = $userInfousername; 將數(shù)據(jù)從數(shù)組取出$userpsw = $userInfouserpsw;$userage = $userInfouserage;$usergrade = $userInfousergrade;echo your name is .$username.; 輸出數(shù)據(jù)echo your pass word is ”.$userpsw.”;echo your age is .$userage.;echo your grade is .$usergrade.;?2、我們再寫一個刪除數(shù)據(jù)庫中的用戶信息：/數(shù)據(jù)庫配置文件

7、$db_server = localhost;$db_user = root;$db_pwd =;$db_name = test;$id = 4;$sql1 = select * from user where id = $id;$sql2 = DELETE FROM user WHERE id = $id;$conn = mysql_connect($db_server, $db_user, $db_pwd); /建立 mysql 連接mysql_select_db($db_name, $conn); 選擇數(shù)據(jù)庫$query = mysql_query($sql1, $conn);/ 執(zhí)行查詢語句if (mysql_num_rows($query) /判斷上個步驟是否查找