標籤：localhost tool set img query while doctype dtd attr
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>無標題文檔</title></head><body><?php//建一個串連，造一個連線物件$db = new MySQLi("localhost","root","123","mydb");//判斷是否出錯/*if(mysqli_connect_error()){ echo "串連失敗！"; exit;}*/mysqli_connect_error()?die("串連失敗"):"";//寫SQL語句$sql = "select * from Info";//執行SQL語句，返回結果集對象$reslut = $db->query($sql);//從結果集中讀取資料,返回數組//$attr = $reslut->fetch_all(); //讀取所有資料，返回索引二維數組//$attr = $reslut->fetch_array(); //讀取當前指標指向的資料，返回索引關聯都存在的數組//$attr = $reslut->fetch_assoc(); //返回關聯陣列//$attr = $reslut->fetch_row(); //返回索引數組//$attr = $reslut->fetch_object(); //返回對象/*$arr = array();while($attr = $reslut->fetch_row()){ array_push($arr,$attr);}var_dump($arr);*/?></body></html>
下面是另一個
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>無標題文檔</title></head><body><?php//造連線物件$db = new MySQLi("localhost","root","123","mydb");//寫SQL語句$sql = "insert into info values(‘p003‘,‘張三‘,‘1‘,‘n001‘,‘1990-2-3‘)";//執行SQL語句$result = $db->query($sql);/*if($result){ echo "執行成功！";}else{ echo "執行失敗！";}*///$result->fetch_row();?></body></html>
PHP資料訪問
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
