-
<?php //1.连接 $link = mysqli_connect(‘localhost’,’root’,’root’,’test’) or die(‘Connect Error:’.mysqli_connect_errno().”:”.mysqli_connect_error()); //2.编码 mysqli_set_charset($link,’UTF8’); //3.查询 $sql=“INSERT user(username,password,age) VALUES(‘a’,’a’,11);”; $res=$mysqli_query($link,$sql); if($res){ echo ‘AUTO_INCREAMENT:’.$mysqli_insert_id($link); echo ‘<hr/>’; echo ‘AFFECTED_ROWS:’.$mysqli_affected_rows($link); }else{ echo ‘ERROR:<br/>’; echo mysqli_errno($link).”:”.mysqli_error($link); } print_r($link); ?>查看全部
-
4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);查看全部
-
mysqli 优势查看全部
-
为什么的输出的时间比实际上少了7个小时？查看全部
-
$sql = "INSERT mysqli(usename,password,age) VALUES(?,?,?)"; $mysqli_stmt = $mysqli->prepare($sql);//准备预处理语句 $username='dyb'; $password=md5('dyb'); $age=12; $mysqli_stmt->bind_param('ssi',$username,$password,$age);//绑定参数 if($mysqli_stmt->execute()){ echo $mysqli_stmt->insert_id; }else{ echo $mysqli_stmt->error; }查看全部
-
if($res && $res->num_rows>0){<br> echo $mysqli_result->num_rows;<br> $rows = $mysqli_result->fetch_all();//获取结果集中的所有记录。<br> $rows = $mysqli_result->fetch_all(mysql_num);//数字索引<br> $rows = $mysqli_result->fetch_all(MYSQLI_ASSOC);//关联<br> $rows = $mysqli_result->fetch_all(MYSQLI_BOTH);//都有<br> $rows = $mysqli_result->fetch_row()//返回结果集中的第一个记录<br> $rows = $mysqli_result->fetch_assoc();//索引<br> $rows = $mysqli_result->fetch_array();//二者都有<br> $rows = $mysqli_result->fetch_object()//对象形式返回<br> <br> <br> $mysqli_result->data_seek(0);调正结果集中的指针到首部<br> print_r （$rows）<br> <br> <br> }else{<br> echo '没有条数'<br> }<br> <br> 循环显示<br> while($row = $mysqli_result->fetch_assoc()){<br> print_r($row);<br> $rows[] = $row;<br> <br> }<br> <br> 释放结果集<br> $mysqli_result->free();<br> <br> 关闭连接<br> $mysqli->close();查看全部
-
$mysqli = new musqli('localhost','root','test'); if($mysqli->connect_errno){ die('connect error:'.$mysqli->connect_error); } $mysqli->set_charset ('utf8'); //执行单条查询语句 $sql = "INSERT user(username,password) VALUES('king','king')，('king2','king2')，('king3','king3')，('king4','king4');"; $res = $mtsqli->query($sql); if($res){ echo'恭喜您注册成功，您是网站的第'.$mysqli->insert_id().位用户 echo '有'.$mysqli->affectd_rows.'记录被影响'. //id子增长，提取最新插入的 }else{ echo 'ERROR'.$mysqli->errno.":"$mysqli->error; }查看全部
-
6. 查询 $sql=“SELECT id,username,password,email FROM user”; $res=mysqli_query($link,$sql); //echo mysqli_num_rows($res); if($res && mysqli_num_rows($res)>0){ while($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){ //print_r($row); $rows[]=$row; } } print_r($rows); mysqli_free_result($res); //释放结果集 7. 关闭连接 mysqli_close($link);查看全部
-
4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);查看全部
-
<?php //1.验证mysqli是否已经安装 //phpinfo(); //2.检查扩展已经加载 var_dump(extension_loaded("mysqli")); var_dump(extension_loaded("curl")); echo "<hr/>"; //3.检查函数是否存在 var_dump(function_exists("mysqli_connect")); echo "<hr/>"; print_r( get_loaded_extensions()); echo "<hr/>"; ?>查看全部
-
4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);查看全部
-
1.建立到mydql数据的链接 $mysqli = @new mysqli('localhost','root','root','test'); 或者$mysqli = new mysqli() $mysqli->connect('127.0.0.1','root','root','text'); 2.打开指定的数据库 $musqli->select_db('test'); //$mysqli->connect_errno 错误编号 //$mysqli->connect_error 错误信息 if($mysqli->connect_errno){ die('connect error:'$mysqli->connect_error); } echo '客户端的信息:'.$mysqli->client_info; 或者echo $mysqli->get_client_info(); echo“客户端的版本：”$mysqli->cilent_version. 服务器信息 $mysqli->server_info $mysqli->get_server_info(); 2.设置字符集： $mysqli->set_charset('utf8'); //3：执行sql查询 $sql=<<<EOF CREATE TABLE IF NOT EXISTS mysqli( id TINYINT UNSIGNED AUTO_INCREMENT KEY, username VARCHAR(20) NOT NULL); EOF $res = $mysqli->query($sql); 返回值可能是布尔值或者是mysqli_result对象。 4.关闭连接 $mysqli->close();查看全部
-
<?php class Comment{ private $data = array(); function __construct($data){ $this->data = $data; } public static function validate(){ if(!(filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL))){ $errors['email'] = '请输入邮箱'; } if(!(filter_input(INPUT_POST,'url',FILTER_VALIDATE_URL))){ $url = ''; } if(!(fileter_input(INPUT_POST,'content',FILTER_CALLBACK,array('op tions'=>'Comment::validate_str') ))){ $errors['content'] = '请输入内容'; } if( !(filter_input(INPUT_POST,'username',FILTER_CALLBACK,array('options'=>'Comment::validate_str'))) ){ $errors['username'] = '请输入用户名'; } $options = array('option'=>array('min_range'=>1,'max_range'=>5)); if(!(filter_input(INPUT_POST,'face',FILTER_VALIDATE_INT,$options))){ $errors['face'] = '请选择合法头像'; } if(!empty($errors)){ $arr = $errors; return false; } $arr = $data; $arr['eamil'] = trim($arr['email']); return true; } } ?>查看全部
-
基于面向过程和面向对象的使用 支持预处理语句 支持事务查看全部
-
$mysqli = new mysqli('localhost', 'root', '', 'test'); if($mysqli->connect_error){ echo 'connect Error:'.$mysqli->connect_error; }查看全部
举报
0/150
提交
取消