<?php
# 建立连接
$servername='127.0.0.1:3306';
$username='root';
$password='';
$conn=new mysqli($servername,$username,$password);
if ($conn->connect_error){
echo "连接失败";
}
else {
echo "连接成功";
}
echo "<br>";
# 创建数据库jia
$sql="create database jia";
if ($conn->query($sql)==true){
echo "创建成功";
}
else {
echo "创建不成功".$conn->error;
}
echo "<br>";
#关闭连接 连接jiang数据库
$conn->close();
$servername='127.0.0.1:3306';
$username='root';
$password='';
$dbname='jia';
$conn=new mysqli($servername,$username,$password,$dbname);
if ($conn->connect_error){
echo "连接失败";
}
else {
echo "连接成功";
}
echo "<br>";
#创建数据表
$table='create table cjy (account char(10) not null primary key,passwd char(10),username char(10))';
if ($conn->query($table)==true){
echo "创建成功";
}
else {
echo "创建不成功".$conn->error;
}
echo "<br>";
#插入数据
$sql="insert into cjy (account,passwd,username)
values('admin','password','admin'),
('Jack','jackto123','Jack'),
('Alice','aliceto456','Alice')";
if ($conn->query($sql)==true){
echo "数据插入成功";}
else {
echo "数据插入不成功".$conn->error;
}
echo "<hr>";
$account=$_POST['account'];
$passwd=$_POST['passwd'];
$sql='select * from cjy ';
$result=$conn->query($sql);
if ($result->num_rows>0){
while($row=$result->fetch_array()){
if($row['account']==$account && $row['passwd']==$passwd){
echo "恭喜".$row['username']."登陆成功!";
exit;}
}}
$sql='select * from cjy';
$result=$conn->query($sql);
if ($result->num_rows>0){
while($row=$result->fetch_array()){
if($row['account']!=$account && $row['passwd']!=$passwd){
echo"非法登录!";
exit;}
}}
?>
PHP连接数据库
最新推荐文章于 2024-10-14 16:42:33 发布
本文详细描述了如何使用PHP语言连接到MySQL服务器,创建数据库和数据表,以及实现基本的用户注册和登录验证功能。
摘要由CSDN通过智能技术生成