<?php
// 引入数据库配置文件 config.php
header("Content-type:text/html;charset=UTF-8");
@$link = mysql_connect('localhost','root','')or die('数据库服务器连接失败');
// 链接数据库“ks”数据表名 可修改
mysql_select_db('czsc')or die('数据库链接失败');
mysql_query('set names utf8');
// 开启session
session_start();if(!empty($_POST)){
if(!empty($_FILES)){
// 二维数组进行降维处理
$picture = $_FILES['picture'];
//var_dump($_FILES);
// 设置上传文件的类型,成功则可以,不成功则禁止上传
switch ($picture['type']) {
case 'image/png':
$ok = 1;
break;
case 'image/jpeg':
$ok = 1;
break;
case 'image/jpg':
$ok = 1;
break;
case 'image/gif':
$ok = 1;
break;
default:
$ok = 0;
break;
}
// 取出文件原名称,为了获取文件后缀名
$oldname = $picture['name']; // 将原文件名称以‘.’为分割符分割成数组
$type = explode('.', $oldname);
// 重新拼接为新的文件名
$newname = time().'.'.$type[1];
//var_dump($newname);
// 判断文件大小及文件类型是否正确
if($picture['size'] < 6000000000 && $ok == 1){
//var_dump($picture['tmp_name']);
// 将缓存文件重命名后并移动保存
move_uploaded_file($picture['tmp_name'], "../czj/$newname");
}else{
echo '<script type="text/javascript">alert(\'上传文件过大,或文件类型不符合\');</script>';
} } $Booksmodify = $_POST['Booksmodify'];
$BooksId = $_POST['BooksId'];
$BooksCategory = $_POST['BooksCategory'];
$BooksNumber = $_POST['BooksNumber'];
$BooksPrice = $_POST['BooksPrice'];
$Booksxq = $_POST['Booksxq'];
$Booksup = $_POST['Booksup'];
$Bookstj = $_POST['Bookstj'];
$sql = "INSERT INTO `books`(`Booksmodify`,`BooksId`,`BooksCategory`,`picture`,`BooksNumber`,`Booksxq`,`Booksup`,`BooksPrice`,`Bookstj`) VALUES ('$Booksmodify', '$BooksId','$BooksCategory','$newname','$BooksNumber','$Booksxq','$Booksup','$BooksPrice','$Bookstj')";
$query = mysql_query($sql);
if($query!=false){
echo '<script type="text/javascript">alert(\'添加成功\');</script>';
}
if($query != false){
header("location:./splist.php"); }
}
require './sptianjia.html';
?>
// 引入数据库配置文件 config.php
header("Content-type:text/html;charset=UTF-8");
@$link = mysql_connect('localhost','root','')or die('数据库服务器连接失败');
// 链接数据库“ks”数据表名 可修改
mysql_select_db('czsc')or die('数据库链接失败');
mysql_query('set names utf8');
// 开启session
session_start();if(!empty($_POST)){
if(!empty($_FILES)){
// 二维数组进行降维处理
$picture = $_FILES['picture'];
//var_dump($_FILES);
// 设置上传文件的类型,成功则可以,不成功则禁止上传
switch ($picture['type']) {
case 'image/png':
$ok = 1;
break;
case 'image/jpeg':
$ok = 1;
break;
case 'image/jpg':
$ok = 1;
break;
case 'image/gif':
$ok = 1;
break;
default:
$ok = 0;
break;
}
// 取出文件原名称,为了获取文件后缀名
$oldname = $picture['name']; // 将原文件名称以‘.’为分割符分割成数组
$type = explode('.', $oldname);
// 重新拼接为新的文件名
$newname = time().'.'.$type[1];
//var_dump($newname);
// 判断文件大小及文件类型是否正确
if($picture['size'] < 6000000000 && $ok == 1){
//var_dump($picture['tmp_name']);
// 将缓存文件重命名后并移动保存
move_uploaded_file($picture['tmp_name'], "../czj/$newname");
}else{
echo '<script type="text/javascript">alert(\'上传文件过大,或文件类型不符合\');</script>';
} } $Booksmodify = $_POST['Booksmodify'];
$BooksId = $_POST['BooksId'];
$BooksCategory = $_POST['BooksCategory'];
$BooksNumber = $_POST['BooksNumber'];
$BooksPrice = $_POST['BooksPrice'];
$Booksxq = $_POST['Booksxq'];
$Booksup = $_POST['Booksup'];
$Bookstj = $_POST['Bookstj'];
$sql = "INSERT INTO `books`(`Booksmodify`,`BooksId`,`BooksCategory`,`picture`,`BooksNumber`,`Booksxq`,`Booksup`,`BooksPrice`,`Bookstj`) VALUES ('$Booksmodify', '$BooksId','$BooksCategory','$newname','$BooksNumber','$Booksxq','$Booksup','$BooksPrice','$Bookstj')";
$query = mysql_query($sql);
if($query!=false){
echo '<script type="text/javascript">alert(\'添加成功\');</script>';
}
if($query != false){
header("location:./splist.php"); }
}
require './sptianjia.html';
?>
$BooksId = $_POST['BooksId'];
$BooksCategory = $_POST['BooksCategory'];
$BooksNumber = $_POST['BooksNumber'];
$BooksPrice = $_POST['BooksPrice'];
$Booksxq = $_POST['Booksxq'];
$Booksup = $_POST['Booksup'];
$Bookstj = $_POST['Bookstj']; 在请求当前php的时候,如上所示参数 没有以post方式传送过来