mysql php 连接查询_php mysql 连接 查询 更新

/**

* 对象的方式 写

*/

$mysqli = new mysqli(); //创建对象

$mysqli->connect('localhost','root','root','wx_new_shop','3307'); //链接数据库

$mysqli->set_charset('utf8'); // 中文乱码问题

$_result = $mysqli->query('SELECT * from wxshop_member where member_id = 6816146 '); // 查询

$_row = $_result->fetch_assoc(); // 数组显示

$_result = $mysqli->query('update wxshop_member SET member_user_id = 11 WHERE member_id = 6816146'); // 更新

// 以过程的方式写

$con = mysqli_connect('localhost','root','root','wx_new_shop','3307');

mysqli_set_charset($con, 'utf8');

$query = mysqli_query($con, 'SELECT * from wxshop_member where member_id = 6816146 ');

$_result = mysqli_fetch_assoc($query);

echo "

";

var_dump($_result);