通过PHP执行sql
<?php
$host = '127.0.0.1';
$user = 'root';
$psd = '123456';
$dbname = 'sql-practise';
$db = new mysqli($host, $user, $psd, $dbname);
if ($db->connect_errno <> 0) {
echo '连接失败。' . '<br>';
echo '错误原因在:' . $db->connect_error;
}
$db->query('SET NAMES UTF8');
$sql = "INSERT into msg (content,user,intime) values('shan','user',1234)";
$check = $db->query($sql);
if ($check == true) {
echo 'query执行成功';
} else {
echo 'query执行失败';
}
实例:获取数据库数据
<?php
$host = '127.0.0.1';
$user = 'root';
$psd = '123456';
$dbname = 'sql-practise';
$db = new mysqli($host, $user, $psd, $dbname);
if ($db->connect_errno <> 0) {
echo '连接失败。' . '<br>';
echo '错误原因在:' . $db->connect_error;
}
$db->query('SET NAMES UTF8');
$sql = "SELECT * FROM msg";
$mysqli_result = $db->query($sql);
$rows=[];
while ($row = $mysqli_result->fetch_array(MYSQLI_ASSOC)) {
$rows[$row['id']]=$row;
}
var_dump($rows);