PHP表单提交后数据库怎么会空白??

来源:百度知道 编辑:UC知道 时间:2024/05/22 00:32:59
<?php
session_start();
include ("conn/conn.php");
$operator = $_SESSION['name'];
$barcode = $_POST['barcode'];
$bookName = $_POST['bookname'];
$typeId = $_POST['typeid'];
$author = $_POST['author'];
$bookcaseid = $_POST['bookcase'];
$translator = $_POST['translator'];
$isbn = $_POST['ISBN'];
$price = $_POST['price'];
$page = $_POST['page'];
$inTime = date("Y-M-D");
$sql = mysql_query("insert into tb_bookinfo(barcode, bookname, typeid, author, translator, ISBN, price, page, bookcase, inTime, operator)values('$barcode',
'$bookName','$typeId','$author','$translator','$isbn','$price','$page','$bookcaseid','$inTime','$operator')");
echo "<script language='javascript'>alert('图书信息添加成功!');

是不是sql里面少空格了?
insert into tb_bookinfo(barcode, bookname, typeid, author, translator, ISBN, price, page, bookcase, inTime, operator) _{空格下}values('$barcode',
'$bookName','$typeId','$author','$translator','$isbn','$price','$page','$bookcaseid','$inTime','$operator')