1.接受數據

if($_POST){

$uname?=?trim($_POST[‘uname‘]);

$pasd?=?md5($_POST[‘pasd‘]);

2.查詢數據庫

$conn?=?new?mysqli(‘localhost‘,‘root‘,‘root‘,‘qiye‘);

$sql?=?"select?*?from?admin?where?uname?=?‘$uname‘?and?pasd?=?‘$pasd‘?";

$res?=?$conn->query($sql);

if($conn->error){

die($conn->error);

}

$info?=?$res->fetch_assoc();

3. 判斷數據

if($res->num_rows?>?0){

setcookie(‘admin‘,$info[‘id‘]);

header(‘Location:index.php‘);

}else{

$msg=?‘賬號或者密碼錯誤‘;

}

$conn->close();

}

4.獲取mysql報錯信息$coon->error;

二 、文件上傳

if($_FILES){

1.獲取文件后綴

$temp=explode(".",$_FILES["img"]["name"]);

$extension=end($temp);

2.判斷文件類型和大小

if($_FILES["img"]["name"]=="image/png"?||?$_FILES["img"]["name"]=="image/gif"?||?$_FILES["img"]["name"]=="image/jpeg"?||?$_FILES["img"]["name"]=="image/jpg"?&&?$_FILES["img"]["size"]<=204800){

3.拼接文件名

$uname?=?‘../uploads‘.time().mt_rand(100,999).‘.‘.$extension;

4.存儲到目錄

move_uploaded_file($_FILES["img"]["tmp_name"],$uname);

5.?存入數據庫

$conn = new mysqli(‘localhost‘,‘root‘,‘root‘,‘denglu‘);

$sql = "insert into product (img) values(‘$uname‘)";

$res = $conn->query($sql);

var_dump($uname);

$conn->close();

6.調取數據庫中的圖片

$connn = new mysqli(‘localhost‘,‘root‘,‘root‘,‘denglu‘);

$sqll = " select * from product where id =x";

$ress = $connn->query($sqll);

$r = $ress->fetch_assoc();

$connn->close();

?>

}

}

}