数据库我已经测试通过了。 if($id=="") $query="insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('$id','$yz_id','$yz_name','$yz_sex','$yz_date','$yz_hk','$yz_zj','$yz_zjh','$yz_add','$yz_jname','$yz_tel','$yz_bz')"; $query1="insert into yz_rzb(id,yz_id,yz_lx,yz_fh,yz_fj,yz_rzsj,yz_dqsj) values('$id','$yz_id','$yz_lx','$yz_fh','$yz_fj','$yz_rzsj','$yz_dqsj')"; else $query="update yz_ryb set yz_id='$yz_id',yz_name='$yz_name',yz_sex='$yz_sex',yz_hk='$yz_hk',yz_date='$yz_date',yz_zj='$yz_zj',yz_zjh='$yz_zjh',yz_add='$yz_add',yz_jname='$yz_jname',yz_tel='$yz_tel',yz_bz='$yz_bz' where id=$id"; exequery($connection,$query); 求解?
PHP如何实现?
原先只插入一张表数据如下: if($id=="") $query="insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('$id','$yz_id','$yz_name','$yz_sex','$yz_date','$yz_hk','$yz_zj','$yz_zjh','$yz_add','$yz_jname','$yz_tel','$yz_bz')";
else $query="update yz_ryb set yz_id='$yz_id',yz_name='$yz_name',yz_sex='$yz_sex',yz_hk='$yz_hk',yz_date='$yz_date',yz_zj='$yz_zj',yz_zjh='$yz_zjh',yz_add='$yz_add',yz_jname='$yz_jname',yz_tel='$yz_tel',yz_bz='$yz_bz' where id=$id"; exequery($connection,$query);现在要插入两张表的数据如下:insert into yz_rzb(id,yz_id,yz_lx,yz_fh,yz_fj,yz_rzsj,yz_dqsj) values('4','8','8','8','8','8','8'); insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('3','8','8','8','8','8','8','8','8','8','8','8'); commit;请问PHP如何写。
可以连续向三个表中插入数据呀。PHP处理是按从上至下的顺序执行的。
你先插入第一个表,再插入第二个,第三个。
if($id=="")
$query="insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('$id','$yz_id','$yz_name','$yz_sex','$yz_date','$yz_hk','$yz_zj','$yz_zjh','$yz_add','$yz_jname','$yz_tel','$yz_bz')";
$query1="insert into yz_rzb(id,yz_id,yz_lx,yz_fh,yz_fj,yz_rzsj,yz_dqsj) values('$id','$yz_id','$yz_lx','$yz_fh','$yz_fj','$yz_rzsj','$yz_dqsj')";
else
$query="update yz_ryb set yz_id='$yz_id',yz_name='$yz_name',yz_sex='$yz_sex',yz_hk='$yz_hk',yz_date='$yz_date',yz_zj='$yz_zj',yz_zjh='$yz_zjh',yz_add='$yz_add',yz_jname='$yz_jname',yz_tel='$yz_tel',yz_bz='$yz_bz' where id=$id";
exequery($connection,$query);
求解?
if($id=="")
$query="insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('$id','$yz_id','$yz_name','$yz_sex','$yz_date','$yz_hk','$yz_zj','$yz_zjh','$yz_add','$yz_jname','$yz_tel','$yz_bz')";
else
$query="update yz_ryb set yz_id='$yz_id',yz_name='$yz_name',yz_sex='$yz_sex',yz_hk='$yz_hk',yz_date='$yz_date',yz_zj='$yz_zj',yz_zjh='$yz_zjh',yz_add='$yz_add',yz_jname='$yz_jname',yz_tel='$yz_tel',yz_bz='$yz_bz' where id=$id"; exequery($connection,$query);现在要插入两张表的数据如下:insert into yz_rzb(id,yz_id,yz_lx,yz_fh,yz_fj,yz_rzsj,yz_dqsj) values('4','8','8','8','8','8','8');
insert into yz_ryb(id,yz_id,yz_name,yz_sex,yz_date,yz_hk,yz_zj,yz_zjh,yz_add,yz_jname,yz_tel,yz_bz) values('3','8','8','8','8','8','8','8','8','8','8','8');
commit;请问PHP如何写。