|
|
register.php
<?php
$link = mysqli_connect(&#39;localhost&#39;, &#39;root&#39;, &#39;root&#39;, &#39;blog&#39;);
if (isset($_POST[&#39;username&#39;]) && isset($_POST[&#39;password&#39;])) {
// 接收用户登录的信息
$username = $_POST[&#39;username&#39;];
$pwd = $_POST[&#39;password&#39;];
$time = time();
$sql = &#34;insert into `users`(`username`, `password`, `ctime`, `ltime`) values(&#39;$username&#39;, &#39;$pwd&#39;, $time, $time)&#34;;
mysqli_query($link, $sql);
echo &#39;ok&#39;;
} else {
?>
<form method=&#34;post&#34; action=&#34;register.php&#34;>
用户名：<input type=&#34;text&#34; name=&#34;username&#34;><br/>
密码：<input type=&#34;password&#34; name=&#34;password&#34;><br/>
<input type=&#34;submit&#34; value=&#34;注册&#34;>
</form>
<?php } ?>
blog.sql
CREATE DATABASE `blog`;
USE `blog`;
CREATE TABLE `users` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) DEFAULT NULL,
`password` VARCHAR(50) DEFAULT NULL,
`ctime` INT(11) DEFAULT NULL,
`ltime` INT(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; |
|
发表于 2023-1-18 21:32:13