php for 写入多行数据库,如何在php中的数据库中添加多行数组

我有四个数组$V1,$V2,$V3,$V4,为此,我做了以下代码,但没有插入数据：

$max_count = max(array(count($_POST['kw_coukw']), count($_POST['combin_kws']), count($_POST['combined_kws']), count($_POST['combine_kws_city'])));

for($cat1 = 0; $cat1 < $max_count; $cat1++) {

if($cat1 <= count($_POST['kw_coukw'])){

$V1 = $_POST['kw_coukw'][$cat1];

}else{

$V1 = 0;

}

if($cat1 <= count($_POST['combin_kws'])){

$V2 = $_POST['combin_kws'][$cat1];

}else{

$V2 = 0;

}

if($cat1 <= count($_POST['combined_kws'])){

$V3 = $_POST['combined_kws'][$cat1];

}else{

$V3 = 0;

}

if($cat1 <= count($_POST['combine_kws_city'])){

$V4 = $_POST['combine_kws_city'][$cat1];

}else{

$V4 = 0;

}

$qry = "INSERT INTO seo_sentence_rl_pg_create_kw (seo_sent_pg_cre_id,kw_1_id,kw_124_id,kw_1234_id,kw_1234_city_id,customized_keyword,customized_title,description) VALUES ('".$_POST['pagenm']."','".$V1."','".$V2."','".$V3."','".$V4."','".$_POST['cuskeyword']."','".$_POST['custitle']."','".$_POST['description']."')";

}

解决方法:

嗨如果要插入批量数据,请使用以下代码使用PDO：

$sql_insert = "INSERT INTO seo_sentence_rl_pg_create_kw (seo_sent_pg_cre_id,kw_1_id,kw_124_id,kw_1234_id,kw_1234_city_id,customized_keyword,customized_title,description) VALUES (:seo_sent_pg_cre_id, :kw_1_id, :kw_124_id, :kw_1234_id, :kw_1234_city_id, :customized_keyword, :customized_title, :description)";

//Prepare our statement using the SQL query.

$statement = $pdo->prepare($sql_insert);

//Bind our values to our parameters

for($cat1 = 0; $cat1 < $max_count; $cat1++) {

if($cat1 < count($_POST['kw_coukw'])){

$V1 = $_POST['kw_coukw'][$cat1];

}else{ $V1 = 0; }

if($cat1 < count($_POST['combin_kws'])){

$V2 = $_POST['combin_kws'][$cat1];

}else{ $V2 = 0; }

if($cat1 < count($_POST['combined_kws'])){

$V3 = $_POST['combined_kws'][$cat1];

}else{ $V3 = 0; }

if($cat1 < count($_POST['combine_kws_city'])){

$V4 = $_POST['combine_kws_city'][$cat1];

}else{ $V4 = 0; }

$statement->bindValue(':seo_sent_pg_cre_id', $_POST['pagenm']);

$statement->bindValue(':kw_1_id', $V2);

$statement->bindValue(':kw_124_id', $V3);

$statement->bindValue(':kw_1234_id', $V4);

$statement->bindValue(':kw_1234_city_id', $V5);

$statement->bindValue(':customized_keyword', $_POST['cuskeyword']);

$statement->bindValue(':customized_title', $_POST['custitle']);

$statement->bindValue(':description', $_POST['description']);

$inserted = $statement->execute();

}

标签：php,arrays,mysql,database,string

来源： https://codeday.me/bug/20190627/1307748.html