how to insert multiple php array values into mysql for the same table?

Question

Hi I am very new to php and I am having 3 php arrays namely bookname, bookprice and bookisbn, I need to insert the values like

"bookisbn" "bookname" "bookprice" into mysql

eg:

isbn1 bookname1 bookprice1 
isbn2  bookname2 bookprice2
isbn3  bookname3 bookprice3

As of now I tried to iterate the three arrays something like,

foreach($booknamearray as $bookname && $bookpricearray as $bookprice && $bookisbnarray as $bookisbn) { .. }

and

while($booknamearray as $bookname && $bookpricearray as $bookprice && $bookisbnarray as $bookisbn){ .. }

Nothing worked me, please kindly help me out to achieve this.

Thanks in advance, Naveen.

General_Twyckenham · Accepted Answer · 2013-07-18 15:55:42Z

2

Assuming they all have the same number of elements, you can use a for loop, and make a string of all the values:

for($i = 0; $i < count($booknamearray); $i++) {
    $str = $booknamearray[$i] . " " . $bookpricearray[$i] . " " . $bookisbnarray[$i];
    //Insert $str into db
}

edited Jul 18, 2013 at 15:55

answered Jul 17, 2013 at 18:34

General_Twyckenham

2,2612 gold badges22 silver badges37 bronze badges

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

5 Comments

Orangepill Over a year ago

You are mixing js and php should be count($booknamearray) not $booknamearray.length

Orangepill Over a year ago

the joys of mixed language development :)

Naveen Over a year ago

@General_Twyckenham: Its worked for me Thanks. Please Let me know if the length various, length will not vary in the above cases, but I may need to add the "bookofferprice" in the future. how to do in this case ?

Naveen Over a year ago

Hey I think for the "bookofferprice" (various array length) below mentioned Marc B solution works I guess, Am I right ?

General_Twyckenham Over a year ago

I think both Marc's solution and my solution will be able to handle adding bookofferprice, assuming the indices are the same. And yes, I did forget bookisbnarray[$i], good catch.

Marc B · Accepted Answer · 2013-07-17 18:35:01Z

0

While you don't say so explicitly, I'm guessing your 3 arrays have their various values in the SAME KEY, e.g.

$booknamearray[0] -> 'name1';
$bookisbnarray[0] -> 'isbn1';
$bookpricearray[0] -> 'price1';

In which case you can do

foreach($booknamearray as $key => $name) {
   $isbn = $bookisbnarray[$key];
   $price = $bookpricearray[$key];
   etc...
}

answered Jul 17, 2013 at 18:35

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

how to insert multiple php array values into mysql for the same table?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related