将键值对数组插入mysql数据库

Question

Hello quick question for you guys/gals

I have a javascript object that displays as follows in the console.

Object { 10= "[e-mail]", 18="[e-mail]", 20="[e-mail]"}

Passing this object to the backend CI Controller thru AJAX I've created the following function with CI.

function NewEMail(){
 //this is the array coming from ajax
 $test = $this -> input -> post('sendValue');
 print_r($test);

 if(is_array($test)){
  foreach($test as $t){
  //Insert the values in to the db from here.
  }
 }
}

the response from php for the print_r is as follows

Array([10] => [e-mail] [18] => [e-mail] [20] => [e-mail])  

I would like to push each element and value to a new row as follows.

EMAIL_TABLE

| id | cus_id | email   |  
| 1  | 10     | [e-mail] |  
| 2  | 18     | [e-mail] |   
| 3  | 20     | [e-mail] | 

Where the 'id' is auto incremented how ever 'cus_id' and 'email' are read and stored from the array.

Any help or directions to helping me solve this would be greatly appreciated!

Thank you for reading, Regards.

Answer 1

Set id as an auto_increment primary key column in your table.

create table email (
    id int unsigned primary key auto_increment,
    cus_id int unsigned,
    email varchar(50)
);

insert into email (cus_id, email) values ('$cusid', '$email');

id will then take care of itself, all you have to do is leave it alone when inserting.

PHP code to do this in a loop:

foreach ($test as $cusid => $email) {
    $querystring = "insert into users (cus_id, email) values ('$cusid', '$email')";
    myqsli_query($querystring);
}