sql:
-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: 2022-03-11 17:38:30 -- 服务器版本: 10.1.13-MariaDB -- PHP Version: 5.6.21 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `a` -- -- -------------------------------------------------------- -- -- 表的结构 `search` -- CREATE TABLE `search` ( `id` int(11) NOT NULL, `content` text COLLATE utf8_vietnamese_ci NOT NULL COMMENT '内容' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_vietnamese_ci; -- -- 转存表中的数据 `search` -- INSERT INTO `search` (`id`, `content`) VALUES (21, '陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵'), (22, '陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵'), (23, '陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵'), (24, '陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵陈作业贵'), (25, '陈作业贵'), (26, '陈作业贵'), (27, '陈作业贵'), (28, '陈作业贵'), (29, '陈作业贵'), (30, '陈作业贵'), (31, '陈作业贵'), (32, '陈作业贵'), (33, '陈作业贵'), (34, '陈作业贵'), (35, 'liwenaaaa'), (36, '66666666666'); -- -- Indexes for dumped tables -- -- -- Indexes for table `search` -- ALTER TABLE `search` ADD PRIMARY KEY (`id`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `search` -- ALTER TABLE `search` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
php代码:
<?php header("Content-type:text/html;charset=utf-8"); ?> <style> body{ background:#ccc; } .blue { background:rgba(255,123,169); width: 260px; height:auto; } </style> 论坛留言<br> <form name="myForm" action="cyg.php" method="post" onsubmit="return check()"> <textarea name="text"></textarea> <br><br> <input type="submit" value="发布回帖"> </form> <script> function check(){ if(document.myForm.text.value==""){ alert("不能为空"); return false; } return true; } </script> <?php if(!empty($_POST['text'])){ $str = $_POST['text']; $link=mysqli_connect('localhost','root','','a'); //然后是指定php链接数据库的字符集 mysqli_set_charset($link,'utf8'); $sql = "INSERT INTO search(content) VALUES ('{$str}')";//把发言的数据插入数据库中,然后后面点击按钮从数据库中读取出来 mysqli_query($link,$sql);//运行sql $sql="select * from search"; $result=mysqli_query($link,$sql);//运行sql while ($row=mysqli_fetch_array($result)) { # code... echo "<div class='blue'>{$row['content']}</div><br>"; } } ?>
效果: