数据库的简单操作
header
(
"Content-type:text/html;charset=utf-8"
);
$host = "localhost" ;
$user = "root" ;
$password = "root" ;
$port = 3306 ;
$db = "baixing" ;
$connection = new mysqli( $host , $user , $password , $db );
if (! $connection ){
die ( "error:" . $connection -> connect_error );
}
//如果乱码,就需使用$connection->query("SET NAMES 'UTF8'"),并在首部加上header("Content-type:text/html;charset=utf-8");
//$result = $connection->query("select * from listinfo");
//1.读取fetch_array()result中的内容
while($row = $result->fetch_array()){
获取数据的两种方式
echo $row["Id"]." :username ".$row["username"]." :password= ".$row["password"];
echo "<br>";
echo "id:".$row[0]." username= ".$row[1]." password= ".$row[2]."<br>";
}
2.获取一个对象
while($row = $result->fetch_object()){
echo $row->Id.":user = ".$row->username.":password = ".$row->password;
}
3.fetch_all()获取一个包含所有查询内容的数组
//$myArr = $result->fetch_all();
//foreach($myArr as $item){
// echo $item[0]."."."user = ".$item[1]." "."password = ".$item[2]."<br>";
//}
$host = "localhost" ;
$user = "root" ;
$password = "root" ;
$port = 3306 ;
$db = "baixing" ;
$connection = new mysqli( $host , $user , $password , $db );
if (! $connection ){
die ( "error:" . $connection -> connect_error );
}
//如果乱码,就需使用$connection->query("SET NAMES 'UTF8'"),并在首部加上header("Content-type:text/html;charset=utf-8");
//$result = $connection->query("select * from listinfo");
//1.读取fetch_array()result中的内容
while($row = $result->fetch_array()){
获取数据的两种方式
echo $row["Id"]." :username ".$row["username"]." :password= ".$row["password"];
echo "<br>";
echo "id:".$row[0]." username= ".$row[1]." password= ".$row[2]."<br>";
}
2.获取一个对象
while($row = $result->fetch_object()){
echo $row->Id.":user = ".$row->username.":password = ".$row->password;
}
3.fetch_all()获取一个包含所有查询内容的数组
//$myArr = $result->fetch_all();
//foreach($myArr as $item){
// echo $item[0]."."."user = ".$item[1]." "."password = ".$item[2]."<br>";
//}
//$connection->close();