How to add multiple row from arrays in database in php

Question

I have four arrays $V1, $V2, $V3, $V4 and for this I did the following code but the data are not inserted:

$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']."')";

}

Thats probably because you dont actually sent the query you built to the server for execution! What database extension are you using? mysqli_ or PDO — RiggsFolly
– RiggsFolly, Commented Apr 5, 2017 at 10:52
Strings containing a SQL Query do not get magically processed — RiggsFolly
– RiggsFolly, Commented Apr 5, 2017 at 10:54
Every time you use the mysql_ database extension in new code this happens it is deprecated and has been for years and is gone for ever in PHP7. If you are just learning PHP, spend your energies learning the PDO or mysqli database extensions and prepared statements. Start here — RiggsFolly
– RiggsFolly, Commented Apr 5, 2017 at 10:55

Tushar · Accepted Answer · 2017-04-07 12:00:37Z

3

Hi please use following code using PDO if you want to INSERT bulk data:

$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();
            }

answered Apr 7, 2017 at 12:00

Tushar

465 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tarun modi Over a year ago

It's not possible in mysql?

Tushar Over a year ago

If you want to work with bulk insert you want to use mysqli or pdo.

Collectives™ on Stack Overflow

How to add multiple row from arrays in database in php

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related