PHP method to connect to mysql database

This article mainly introduces the steps of connecting PHP to mysql database. It has a very good reference value. Let’s take a look at it with the editor.

Connect to the database:

Use Object-oriented method;

1. Create a mysqli object and a connection object

2. Prepare a SQL statement

3. Execute the SQL statement, if it is a query statement. Successfully return results and objects

4. Find data from the result set object;

Query attributes Code:

query($sql); //判断返回是否有内容,执行成功 if($reslut) { //如果成功了，从结果集对象里找到数据； $attr = $reslut->fetch_all(); //返回索引数组：$attr = $reslut->fetch_row() //返回关联数组：tch_assoc(); //返回对象：$attr = $reslut->fetch_object(); //返回既有索引又有关联：$arrt = $reslut->fetch_array(); var_dump($attr); ?>

The final return value is a set object. In order to see the results clearly, we use fetch_all(), fetch_row() ; fetch_object();

Add, delete and modify statements:

Add a piece of information:

//造连接对象 $db = new MySQLi("localhost","root","12345678","heiheihei"); //准备SQL语句 $sql = "insert into cou values('3-111','嘿嘿','803')"; //执行SQL语句 $r = $db ->query($sql); if($r)//如果$r是ture { echo "执行成功"; } else { echo "执行失败"; }

Change a message:

query($sql); if($r) { echo "执行成功"; } else { echo "执行失败"; } ?>

Delete:

query($sql); if($r) { echo "执行成功"; } else { echo "执行失败"; } ?>

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

php PDO implements method to determine whetherconnectionis available

Detailed interpretation of the shared databasemethod of connectingbetween Node.js modules (graphic tutorial)

php implements mysqlConnectionDetailed explanation of pool effect steps

The above is the detailed content of PHP method to connect to mysql database. For more information, please follow other related articles on the PHP Chinese website!