- mysqli_connect() 函数来连接数据库。
- mysqli_select_db() 来选取一个数据库。
- mysqli_query() 执行sql语句
<?php
$conn = mysqli_connect('localhost', 'root','');
if (!$conn){
die('could not connect:'.mysqli_error($conn));
}
echo '数据库链接成功','<br>';
mysqli_query($conn,'set names utf8');
mysqli_select_db($conn, 'test');
$title = $_POST['title'];
$content = $_POST['content'];
$time = time();
$sql = "insert into msg"."(title,content,pubtime)"."values"."('$title','$content','$time')";
print_r($sql.'<br>');
$rs = mysqli_query($conn,$sql);
if (!$rs){
die('无法插入数据'.mysqli_error($conn));
}
echo '数据插入成功','<br>';
$sql = "select * from msg";
$rs = mysqli_query($conn,$sql);
if(! $rs )
{
die('无法读取数据: ' . mysqli_error($conn));
}
while ($row = mysqli_fetch_assoc($rs)){
echo '<li><a href="du.php?id=',$row['id'],'">'.$row['title'].'</a><li>';
}
mysqli_close($conn);