<?php
* Q4:输入查询语句咋没反应
* A4:注意查询语句中的“’”前面要加“\”转义符。
* */
$link = mysqli_connect('localhost', 'sssss', '','class',3306) or die("连接数据库失败");
mysqli_query($link,"set names utf8'");
/*$link = mysqli_connect('localhost:3306', 'sssss', '') ; mysql_connect已经废除,现在使用mysqli*/
//$sql=' insert into user_info (username,password,USERID)values(\'插入\',\'insert\',4);';//我是增
//$sql='DELETE FROM user_info WHERE username=\'插入\'';//我是删
//$sql='UPDATE user_info SET password = \'1001\' WHERE username = \'wsnd\'';//我是改
//$sql='select * from user_info';//我是查
$result=mysqli_query($link,$sql);
$arr=array();//定义空数组
while($row =mysqli_fetch_array($result,MYSQLI_ASSOC)){
echo $row["username"] ." ".$row["password"]." ".$row["USERID"];
}
mysqli_close($link);
?>