Analyze the operation of mysql using the mysqli extension library in PHP_PHP tutorial

1. Use the mysqli extension library in PHP to perform mysql dql operations

Copy the code The code is as follows:

header("Content-type: text/html;charset=utf-8");
//mysqli operates mysql database (object-oriented method)
//1. Create MySQLi object
$mysqli =new MySQLi("localhost","root","root","test");
if($mysqli->connect_error){
die("Connection failed" .$mysqli->connect_error);
}
//2. Operation database (send sql)
$sql="select *from user1";
//3. Processing results
$res =$mysqli->query($sql);
//var_dump($res);
//fetch_assoc fetch_array fetch_object
while($row=$res->fetch_row() ){
var_dump($row);
/* foreach($row as $val){
echo '--'.$val;
}
echo '
🎜>

The following is process-oriented



Copy code

The code is as follows:

header("Content-type: text/html;charset=utf-8"); $mysqli=mysqli_connect("localhost","root","root","test");

if(!$mysqli){

die("Connection failed".mysqli_connect_error());
}
$sql="select *from user1";
$res=mysqli_query($ mysqli,$sql);
//var_dump($res);
while($row=mysqli_fetch_row($res)){

foreach ($row as $val){

echo '-'.$val;
}
echo '
';
}
//Release memory
mysqli_free_result($res);
mysqli_close($mysqli);
?>



2. Use the mysqli extension library in PHP to operate mysql dml

Copy code
The code is as follows:

//Use the mysqli extension library to perform crud operation on mysql header( "Content-type: text/html;charset=utf-8");

$mysqli = new MySQLi("localhost","root","root","test");

if($mysqli ->connect_error){
          die("Connection failed".$mysql->connect_error); ,password,email,age) values ​​('lucy',md5('lucy'),'lucy@163.com',17)";
//Delete a record
//$sql="delete from user1 where id =80";
//Update a record
$sql="update user1 set age=20 where id=7";
$res=$mysqli->query($sql );
if(!$res){
echo "Operation failed".$mysqli->error;
}else{
if($mysqli->affected_rows>0){
           echo "Success"; ;close() ;
?>



3. Encapsulate




Copy the code

The code is as follows:

class SqlHelper{

private $mysqli;
//Written here first, and configure the hard-coded things in a file in the future
private static $host="localhost";
private static $user="root";
private static $pwd="root";
private static $db="test";
public function __construct( ){

$this->mysqli=new MySQLi(self::$host,self::$user,self::$pwd,self::$db);
if($this ->mysqli->connect_error){
                                                                                                                                                 $this- >mysqli->query ("set names utf8"); ;query ($sql) or die ($this->mysqli->error); 🎜>             $res =$this->mysqli->query($sql) or die($this->mysqli->error); return 0;//Failed
                                                                                                                                                                                                                                                                                                                                                                                                                  ; 2;//No impact
                                                                                                                             



http://www.bkjia.com/PHPjc/328020.html

www.bkjia.com

true

http: //www.bkjia.com/PHPjc/328020.html

TechArticle

1. Use the mysqli extension library in PHP to copy the dql operation of mysql. The code is as follows: ?php header(" Content-type: text/html;charset=utf-8"); //mysqli operates mysql database (object-oriented...