PHP+MYSQL宠物主题动态网页设计源码+数据库，大学生期末大作业，PHP课程设计

PHP+MYSQL宠物主题动态网页设计源码+数据库，大学生期末大作业，PHP课程设计

前言

提示：本文采用PHP对数据库进行操作：
本文就介绍了PHP实现对MySQL数据库的增删改查操作基础内容。

效果展示

主要功能及代码

数据库连接 conn.php

<?php
$conn=mysqli_connect('127.0.0.1','root','root','pet');
mysqli_query($conn,"set names utf8");
session_start(); 
?>

注册 regdo.php

<?php 
include 'conn.php';
	if ($_POST){//检测是否有post表单数据
        if(!$_POST['username']){//如果没有username值
            echo '<script type="text/javascript">alert("请输入用户名");history.back();</script>';
            die;
        };
        if($_POST['password'] !== $_POST['repassword']){//如果两次密码输入不同
            echo '<script type="text/javascript">alert("两次输入密码不同");history.back();</script>';
            die;
        };
        
        $query = mysqli_query($conn,"select username from user where username = '{$_POST['username']}'");
        if(mysqli_fetch_array($query,MYSQLI_ASSOC)){//如果用户名已经被注册
            echo "<script type='text/javascript'>alert('用户名已经被注册');history.back();</script>";
            die;
        };
        mysqli_query($conn,"insert into user (username,password,tel,datetime) values ('{$_POST['username']}','{$_POST['password']}','{$_POST['tel']}',now())") or die(mysqli_error($conn));//把用户名密码写入数据库
        echo "<script type='text/javascript'>alert('注册成功');window.location.href='login.html';</script>";//跳转到登录页
};
?>

登录

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php 
include 'conn.php';
if ($_POST){
 	$query = mysqli_query($conn,"select * from user where username='{$_POST['username']}' && password='{$_POST['password']}'");//查询用户表中的用户名数据
    $rows= mysqli_fetch_array($query,MYSQLI_ASSOC);
	if (!$rows){//如果没有提示密码有误
 		echo "<script type='text/javascript'>alert('帐号或者密码有误!');history.back();</script>";//提示帐号密码有误并返回
 	}else{
		$_SESSION['username'] = $_POST['username'];//写入session
		$_SESSION['userid'] = $rows['id'];
		echo "<script type='text/javascript'>alert('登录成功!');window.location.href='index.html';</script>";
  	}
}
?>

数据库

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


--
-- 表的结构 `user`
--

CREATE TABLE `user` (
  `id` mediumint(6) NOT NULL,
  `username` varchar(20) CHARACTER SET utf8 NOT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `password` varchar(40) CHARACTER SET utf8 NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 转存表中的数据 `user`
--

INSERT INTO `user` (`id`, `username`, `tel`, `password`, `datetime`) VALUES
(1, 'doy', '13933322211', '123456', '2021-04-25 22:22:46'),
(2, 'doy2', '14333322222', '123456', '2021-04-25 22:25:01');

--
-- 转储表的索引
--

--
-- 表的索引 `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `user`
--
ALTER TABLE `user`
  MODIFY `id` mediumint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!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 */;

源码分享

链接: https://pan.baidu.com/s/1EFhekYWsXq3RBJ-gQJC__g?pwd=v5vu 提取码: v5vu 复制这段内容后打开百度网盘手机App，操作更方便哦