PHP数据库连接语句:
$conn=mysql_connect ("localhost","root", ""); //连接数据库所需信息
mysql_select_db("zx_test"); //选择库
mysql_query("SET NAMES 'GBK'"); //强制将取得的结果转化为”GBK”编码格式
$execc="select * from tbl_message order by messageId desc limit 1 "; //创建sql语句
$resultc=mysql_query($execc); //执行sql语句
while($rsc=mysql_fetch_array($resultc)){
//将执行结果以数组的形式存到$rsc,同时遍历输出
echo "类别ID:".$r[0]."
";
echo "用户名:".$rsc[2]."
";
echo "地址:".$rsc[3]."
";
echo "电话:".$rsc[4]."
";
}
?>
表单代码:
//表单
通过里面的action属性来连接到PHP页面。用户名: | |
地址: | |
电话: | |
评论类别: | $conn=mysql_connect ("localhost","root", ""); mysql_select_db("zx_test"); mysql_query("SET NAMES 'GBK'"); $slt="select * from tbl_category"; $result=mysql_query($slt); while($rsc=mysql_fetch_array($result)){ echo "该评论ID:".$rsc[0]." echo" $rsc[1] "; } ?> |
留言内容: | |
PHP获取前端页面表单传来的值:
$name = $_POST["name"]; //POST里面的变量是表单中属性的name对应的值
$address = $_POST["address"];
$tel = $_POST["tel"];
$category = $_POST["categoryId"];
$message = $_POST["message"]