SQL

来源：互联网发布：电梯网络远程视频监控编辑：程序博客网时间：2024/06/05 05:06

$conn = @ mysql_connect($dbHost, $dbUser, $dbPwd);
if(!$conn){
$arr['msg'] = "连接数据库失败!";
echo json_encode($arr);exit;
}
mysql_query("SET NAMES 'utf8'");
$version = mysql_get_server_info($conn);
if($version < 4.1){
$arr['msg'] = '数据库版本太低!';
echo json_encode($arr);exit;
}

if(!mysql_select_db($dbName, $conn)){
if(!mysql_query("CREATE DATABASE IF NOT EXISTS `".$dbName."`;", $conn)){
$arr['msg'] = '数据库 '.$dbName.' 不存在，也没权限创建新的数据库！';
echo json_encode($arr);exit;
}else{
$arr['n']=0;
$arr['msg'] = "成功创建数据库:{$dbName}<br>";
echo json_encode($arr);exit;
}

}

$sql="insert into product(title,headtitle,keywords,description,bigpid,contents,image,pid,bigimage) values('$_POST[title]','$_POST[headtitle]','$_POST[keywords]','$_POST[description]','$_POST[bigpid]','$_POST[contents]','$_POST[image]','$_POST[pid]','$_POST[bigimage]')";
mysql_query($sql);