当前位置：网站首页>Making message board with PHP + MySQL

Making message board with PHP + MySQL

2022-04-23 04:52:00 【yizecellophp】

Forms index.php

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> Message board </title>
</head>
<body>
<span> Message board </span>
<div>
<form action="liuyan.php" method="post">
<table>
    <tr>
    <td><input type="text" name="user" placeholder=" Net name "/></td>
    </tr>
    <tr>
    <td><textarea name="contern" cols="50" rows="5" placeholder=" Message content "></textarea></td>
    </tr>
<input type="submit" value=" Leave a message "/>
</form>
</div>
<div>
<?php
$cc=mysqli_connect("localhost","root","");  // Connect MySQL database 
$db=mysqli_select_db($cc,"test");   // Select database 
$sql="select * from liuyan";  // see liuyan Table all data 
$re=mysqli_query($cc,$sql);  // perform SQL sentence 
echo "<table width='800'>";
echo "<tr><th> Message user </th><th> Message content </th><th> Message time </th></tr>";
while($r=mysqli_fetch_array($re,MYSQLI_BOTH)){  // Loop output data 
echo "<tr><td>".$r['name']."</td><td>".$r['content']."</td><td>".$r['time']."</td></tr>";
}
echo "</table>";
?>
</div>
</body>
</html>

MySQL Database table content

PHP Process page liuyan.php

<?php
date_default_timezone_set("Asia/Shanghai");  // Set time zone ： East eight 
$c=$_POST["contern"]; // Get the submitted form contern Value 
if(empty($c)){  // If $c It's empty 
echo "<script type='text/javascript'>alert(' The message content cannot be empty ');history.back();</script>";  // Popup 
}else{
    $u=$_POST["user"];  // Get the submitted form user Value 
if(empty($u)){   // If $u It's empty 
echo "<script type='text/javascript'>alert(' Message user cannot be empty ');history.back();</script>";  // Popup 
}else{
$t=date("Y-m-d,H:m:s");  // Acquisition time 
$c=trim($c);  // Remove the spaces at both ends 
$c=htmlspecialchars($c);  // hold html Convert labels to entities 
$c=addslashes($c);  // escape 
$cc=mysqli_connect("localhost","root","");  // Connect MySQL database 
$db=mysqli_select_db($cc,"test");  // choice test database 
$sql="insert into liuyan (name,content,time) values ('$u','$c','$t')";
$r=mysqli_query($cc,$sql); // perform SQL sentence 
if($r){  // If SQL Statement executed successfully 
echo "<script type='text/javascript'>alert(' Message success ！');history.back();</script>";  // Popup 
}else{
echo "<script type='text/javascript'>alert(' Message failed ');history.back();</script>";  // Popup 
}
mysqli_close($cc); // Close the connection to the database 
}
}
?>