php批量数据更新,php 批量保存数据与批量更新数据

if ($insert && $insertsql) {php 批量保存数据与批量更新数据

$keystr = $valstr = $tmp = '';

foreach($insertsql as $key => $val) {

if ($val) {

$keystr .= $tmp.$key;

$valstr .= $tmp."'".addslashes($val)."'";

$tmp = ',';

}

}

if ($keystr && $valstr) {

dbconn($dbhost,$dbuser,$dbpass,$dbname,$charset,$dbport);

m(q("INSERT INTO $tablename ($keystr) VALUES ($valstr)") ? 'Insert new record of success' : mysql_error());

}

}

if ($update && $insertsql && $base64) {

$valstr = $tmp = '';

foreach($insertsql as $key => $val) {

$valstr .= $tmp.$key."='".addslashes($val)."'";

$tmp = ',';

}

if ($valstr) {

$where = base64_decode($base64);

dbconn($dbhost,$dbuser,$dbpass,$dbname,$charset,$dbport);

m(q("UPDATE $tablename SET $valstr WHERE $where LIMIT 1") ? 'Record updating' : mysql_error());

}

}

本文原创发布php中文网，转载请注明出处，感谢您的尊重！