PHP Array Explode Twice

Question

I have an array which I need to insert into multiple rows of database. The structure of array is like:

$var = "Name1,Age1,DOB1,Relation1.Name2,Age2,Dob2,Relation2.";//And so on, depending on users input

(Dot indicates new line whereas Comma indicates new column) I need to insert it into database like this:

I first stored all rows in an array like:

$rowsToInsert = explode (".",$var);

I have now:

$rowsToInsert[0] = Name1,Age1,DOB1,Relation1;
$rowsToInsert[1] = Name2,Age2,DOB2,Relation2; 
...And So on...

Problem:

What is the fastest way to store these array elements into database having Name, Age, DOB, Relation columns?

Darren · Accepted Answer · 2015-06-12 06:51:23Z

1

May be this will work

$rows = explode (".",$var);
$addslash = addslashes($rows);

foreach($addslash as $val) {
    $val_str = str_replace("," ,"','", $val);
    $sql = "INSERT INTO tablename (Name, Age, DOB, Relation) VALUES ('" .$val_str. "')";
}

edited Jun 12, 2015 at 6:51

Darren

13.1k4 gold badges44 silver badges81 bronze badges

answered Jun 12, 2015 at 6:50

Syed mohamed aladeen

6,8134 gold badges36 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

PHP Array Explode Twice

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related