try{
$dbms='mysql'; //数据库类型 ,对于开发者来说,使用不同的数据库,只要改这个,不用记住那么多的函数
$host='127.0.0.1'; //数据库主机名
$dbName='books'; //使用的数据库
$user='root'; //数据库连接用户名
$pass=''; //对应的密码
$dsn="$dbms:host=$host;dbname=$dbName";
$pdo = new PDO($dsn, $user, $pass); //初始化一个PDO对象,就是创建了数据库连接对象$pdo
*/
//echo $_POST['bookname'];
//插入出数据库语句,图片数据前要加上0x,用于表示16进制数
//$query = "insert into book(name,createtime,price,author,publish) value('$bookname','$booktime','$bookprice','$bookauthor','$bookpublish')";
//$query = "insert into images(pic) values('".$name."','".$type."',0x".$imgdata.")")
//$query = "insert into book(name,createtime,price,author,publish,pic) values(':name',':createtime',':price',':author',':publish',0x".$imgdata.")";
//$query = "insert into book(name,createtime,price,author,publish,pic) values(?,?,?,?,?,0x".$imgdata.")";
//$result=$pdo->prepare($query); //准备查询语句
//$result=$pdo->prepare("insert into book(name,createtime,price,author,publish,pic) values(?,?,?,?,?,0x".$imgdata.")"); //准备查询语句
//$result=$pdo->prepare("insert into book(name,createtime,price,author,publish,pic) values(?,?,?,?,?,0x.?)");
//$result=$pdo->prepare("insert into book(name,createtime,price,author,publish) values(?,?,?,?,?)");
//echo $_POST['imagedata'];
$result=$pdo->prepare("insert into book(name,createtime,price,author,publish,pic) values(?,?,?,?,?,?)");
//echo $_POST['bookname'];
/*
$result->bindValue(1,$_POST['bookname']);
$result->bindValue(2,$_POST['booktime']);
$result->bindValue(3,$_POST['bookprice']);
$result->bindValue(4,$_POST['bookauthor']);
$result->bindValue(5,$_POST['bookpublish']);
$result->bindValue(6,$_POST['imagedata']);
*/
// echo "
".time()."
"// echo $_POST['imagedata'];
/*
$result->bindParam(':name', $_POST['bookname']);
$result->bindParam(':createtime',$_POST['booktime']);
$result->bindParam(':price', $_POST['bookprice']);
$result->bindParam(':author',$_POST['bookauthor']);
$result->bindParam(':publish',$_POST['bookpublish']);
*/
/*
if($result->execute() > 0)
{
echo "
insert pic success\n";
echo "
}
else
{
echo "
}
}
catch(PDOException $e)
{
die("Error:".$e->getMessage()."
");
}