Php中使用INSERT插入数据语句的方法

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin', '35')");

mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire', '33')");

mysql_close($con);
?>

/*
* 资料保存
* 程序：刘兴
* 时间:2010-6
*/
?>


require_once(“gxpass.php”);//引入密码验证
require_once(“connDB.php”);//引入数据库连接参数
$zl=$_POST;

//数据保存
list ($pid,$pname)=split(‘-’,$zl[people]);
$year=$zl[year];
$jd=$zl[jd];
foreach($zl as $key => $value){
if (strstr($key,”fs”)) {
if (strstr($key,”kfs”)){
$khxm=substr($key,3,strlen($key)-3);
$fs=$zl[$key];
continue;
} //www.111cn.nEt
else{
$khxm=substr($key,2,strlen($key)-2);
}
$khfs=$value;
$khinfo=$zl[$khxm];
$sql=”delete from khzl where peopleid=’$pid’ and khbm=’$khxm’ and time=’$jd’ and year=’$year’”;
$result=mysql_query($sql) ;
$sql=”INSERT INTO khzl (peopleid ,khbm ,fenshu ,time ,year ,info,fs ) VALUES (‘$pid’, ’$khxm’, $khfs, ’$jd’, ’$year’, ’$khinfo’,'$fs’)”;
$fs=0;
$result=mysql_query($sql);
}
}
?>