mysql方式连接数据库案例
1.php
/*
create table cont(
id int auto_increment primary key,
title varchar(100),
content varchar(200),
pubtime int
)charset utf8;
*/
header("Content-type:text/html; charset=utf-8");
$conn=mysqli_connect('127.0.0.1','','');
mysqli_query($conn,'use html');
mysqli_query($conn,"set names utf8");
$title =$_POST['title'];
$cont =$_POST['cont'];
$time =time();
$sql = "insert into cont (title,content,pubtime) values ('$title','$cont',now())";
if(mysqli_query($conn,$sql)){
echo '成功';
}else{
echo "失败";
}
?>
留言板列表
序号 |       标题 |       内容 |
$sql="select * from cont";
$result = $conn->query($sql);
//$row=mysqli_fetch_row($result);
$res=array();
while($arr=mysqli_fetch_assoc($result)){
$res[]=$arr;
}
// var_dump($res);
foreach($res as $v){
?>
<?php echo $v["id"] ?><?php echo $v["title"] ?><?php echo $v["content"] ?>}
?>
不一样
序号 | 标题 | 内容 |
$sql="select * from cont order by id desc";
$result = $conn->query($sql);
while ( $row=mysqli_fetch_assoc($result)) {
?>
<?php echo $row['id'] ?><?php echo $row['title'] ?><?php echo $row['content'] ?>}
?>
?>
1.html
标题:
内容: