当前位置：Gxlcms > 数据库问题 > 小白简单留言板（3）-将数据库信息写入网页

小白简单留言板（3）-将数据库信息写入网页

时间：2021-07-01 10:21:17 帮助过：35人阅读

<?php //把留言板（1）中的文件格式改为php，修改后 2 include("connect.php");//连接数据库 3 $sql = "select * from msg order by id desc"; 4 $mysqli_result = $db->query($sql); 5 if($mysqli_result === false){ 6 die("sql语句错误"); 7 } 8 //else echo "获取数据库信息成功"; 9 $rows = []; 10 //$mysqli_result->fetch_array(MYSQL_ASSOC))获取$mysqli_result中最先的一行数据 11 while($row = $mysqli_result->fetch_array(MYSQL_ASSOC)){ 12 $rows[] = $row;//把每一行数据存入rows[]中 13 //echo "用户名：{$row[‘user‘]} <br/>"; 14 //echo "内容；{$row[‘content‘]} <br/>"; 15 } 16 //var_dump($rows);//判断是否获取成功 17 18 ?> 19 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 20 <html xmlns="http://www.w3.org/1999/xhtml"> 21 <head> 22 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 23 <title>留言板</title> 24 <style type="text/css"> 25 .head {text-align:center;color:#FAA261;} 26 .wrap { 27 width:600px; 28 margin:0px auto; 29 //background:#390; 30 } 31 .input .content{ 32 margin-bottom:5px; 33 width:594px; 34 height:150px; 35 } 36 .input .submit{float:right;} 37 .output {margin-top:5px;background:#CCC;padding:3px;margin-top:20px;} 38 .output .user{color:#95F;} 39 .output .time{float:right;color:#6C0;} 40 </style> 41 </head> 42 <body> 43 <div class="wrap"> 44 <h1 class="head">留言板</h1> 45 46  47 <div class="input"> 48 <form action="save.php" method="post"> 49 <textarea name="content" class="content" autofocus="autofocus" placeholder="请输入留言内容：" ></textarea><br/> 50 <label for="text">用户名：</label> 51 <input name="user" type="text" class="user"/> 52 <input type="submit" class="submit" value="提交留言"/> 53 </form> 54 </div> 55 56  57 <?php 58 foreach($rows as $row){ 59 ?> 60 <div class="output"> 61 <span class="user">用户：<?php echo $row[‘user‘]; ?></span> 62 <span class="time"><?php echo date("Y-m-d H:i:s",$row[‘time‘]);?></span> 63 <div class="content"> 64 <?php echo $row["content"]; ?> 65 </div> 66 </div> 67 <?php 68 } 69 ?> 70 71 72 </div> 73 </body> 74 </html>

<span style="color: #008080;"> 1</span> <?php<span style="color: #008000;">//</span><span style="color: #008000;">连接数据库</span>
<span style="color: #008080;"> 2</span>     <span style="color: #800080;">$host</span> = "127.0.0.1"<span style="color: #000000;">;
</span><span style="color: #008080;"> 3</span>     <span style="color: #800080;">$user</span> = "root"<span style="color: #000000;">;
</span><span style="color: #008080;"> 4</span>     <span style="color: #800080;">$pwd</span> = "root"<span style="color: #000000;">;
</span><span style="color: #008080;"> 5</span>     <span style="color: #800080;">$dbname</span> = "mydb"<span style="color: #000000;">;
</span><span style="color: #008080;"> 6</span>     <span style="color: #800080;">$db</span> = <span style="color: #0000ff;">new</span> mysqli(<span style="color: #800080;">$host</span>, <span style="color: #800080;">$user</span>, <span style="color: #800080;">$pwd</span>, <span style="color: #800080;">$dbname</span><span style="color: #000000;">);
</span><span style="color: #008080;"> 7</span>     <span style="color: #008000;">//</span><span style="color: #008000;">var_dump($db);</span>
<span style="color: #008080;"> 8</span>     <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$db</span>->connect_errno != 0){<span style="color: #008000;">//</span><span style="color: #008000;">判断数据库是否连接成功</span>
<span style="color: #008080;"> 9</span>         <span style="color: #0000ff;">echo</span> <span style="color: #800080;">$db</span>-><span style="color: #000000;">connect_errno;
</span><span style="color: #008080;">10</span>         <span style="color: #0000ff;">die</span>("数据库连接失败"<span style="color: #000000;">);
</span><span style="color: #008080;">11</span> <span style="color: #000000;">    }
</span><span style="color: #008080;">12</span>     <span style="color: #008000;">//</span><span style="color: #008000;">else echo"成功";</span>
<span style="color: #008080;">13</span>     <span style="color: #800080;">$db</span>->query("SET NAMES UTF8");<span style="color: #008000;">//</span><span style="color: #008000;">设置数据库传输数据的编码，不然乱码</span>
<span style="color: #008080;">14</span> ?>

标签：一个 name 数据库数据 tom 语句 NPU user soc time

小白简单留言板（3）-将数据库信息写入网页

人气教程排行