Insert Into Database From Array Using PHP

Question

I have database A with field hotel,order_type and description. I want insert value to database A from array $new_array.

//array $new_array

Array
(
[0] => Array
    (
        [order_type] => 1
        [currency] => 26
        [net] => 
        [rate] => 
        [amount] => 
        [bank_surcharge] => 
        [ticket] => 
        [profit] => 
        [selling_price] => 
        [description] => a
        [hotel] => 1
        [vendor] => 11
    )

[1] => Array
    (
        [order_type] => 2
        [currency] => 27
        [net] => 
        [rate] => 
        [amount] => 
        [bank_surcharge] => 
        [ticket] => 
        [profit] => 
        [selling_price] => 
        [description] => b
        [hotel] => 1
        [vendor] => 11
    )
...
...
}

i tried this script but nothing happened :(

for($i = 0; $i < sizeof($new_array['order_type']); $i++){
    mssql_query("INSERT INTO A(hotel_id, order_type,    description) 
    VALUES('$new_array[$i]', '$new_array[$i]', '$new_array[$i]')");
}

How to do this with php? please anyone help me.

i think you don't have to pass sizeof($new_array['order_type'] you may try count($new_array) — Manwal
– Manwal, Commented Oct 31, 2013 at 7:48
thanks for all nice people out there who help me out.. you're all the best — kroseva
– kroseva, Commented Oct 31, 2013 at 8:09

Vin.AI · Accepted Answer · 2013-10-31 08:01:14Z

3

Try to pass Connection reference and loop as:

foreach($new_array as $each){
    mssql_query($conn, "INSERT INTO A(hotel_id, order_type, description) 
    VALUES('{$each['hotel']}', '{$each['order_type']}', '{$each['description']}')");
}

edited Oct 31, 2013 at 8:01

answered Oct 31, 2013 at 7:51

Vin.AI

2,4373 gold badges22 silver badges42 bronze badges

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

2 Comments

Allen Chak Over a year ago

query using mssql but the connection created for mysql

Vin.AI Over a year ago

Thanks @AllenChak, I missed db. It was MS-Sql. I though it is MySQL. kroseva please try again. changed for MS-Sql.

Allen Chak · Accepted Answer · 2013-10-31 07:54:23Z

2

1) your loop is invalid, should be sizeof($new_array)

2) your array data access for SQL statement is invalid

for($i = 0; $i < sizeof($new_array); $i++){
    mssql_query("INSERT INTO A(hotel_id, order_type, description) VALUES({$new_array[$i]['hotel']}, '{$new_array[$i]['type']}', '{$new_array[$i]['description']}')");
}

answered Oct 31, 2013 at 7:54

Allen Chak

1,9801 gold badge11 silver badges24 bronze badges

Comments

matewka · Accepted Answer · 2013-10-31 07:51:03Z

2

Does this help?

foreach($new_array as $item) {
    mssql_query("INSERT INTO A (hotel_id, order_type, description) 
    VALUES('". $item['hotel'] ."', '". $item['order_type'] ."', '". $item['description']. "')");
}

foreach is very similar to for loop but it simply iterates over all array elements. You don't need to care about the array size.

answered Oct 31, 2013 at 7:51

matewka

10.2k3 gold badges36 silver badges43 bronze badges

Comments

david · Accepted Answer · 2013-10-31 07:51:23Z

1

foreach ($new_array as $val){
    mysql_query("INSERT INTO A(order_type, description) VALUES($val['order_type'], $val['description'])");
}

This code doesn't insert hotel_id because it is primary key of the table A.

answered Oct 31, 2013 at 7:51

david

3,2289 gold badges33 silver badges43 bronze badges

Comments

david · Accepted Answer · 2013-10-31 07:54:38Z

0

for ($i = 0; $i < sizeof($new_array['order_type']); $i++) {
    mssql_query("INSERT INTO A(hotel_id, order_type, description) VALUES ('$new_array[$i]["hotel"]', '$new_array[$i]["order_type"]', '$new_array[$i]["description"]')");
}

This should work I guess, haven't tested it though.

edited Oct 31, 2013 at 7:54

david

3,2289 gold badges33 silver badges43 bronze badges

answered Oct 31, 2013 at 7:51

Arun Jose

3655 silver badges16 bronze badges

1 Comment

Allen Chak Over a year ago

invalid variable of $new_array['order_type'] for function sizeof()

Serhat Akay · Accepted Answer · 2013-10-31 07:51:00Z

-1

Try this

for($i = 0; $i < sizeof($new_array['order_type']); $i++){
    mssql_query("INSERT INTO A(hotel_id, order_type,    description) 
    VALUES('".$new_array[$i]['hotel']."', '".$new_array[$i]['order_type']."', '".$new_array[$i]['description']."')");
}

answered Oct 31, 2013 at 7:51

Serhat Akay

5343 silver badges10 bronze badges

1 Comment

Allen Chak Over a year ago

invalid variable of $new_array['order_type'] for function sizeof()

Collectives™ on Stack Overflow

Insert Into Database From Array Using PHP

6 Answers 6

2 Comments

Comments

Comments

Comments

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

1 Comment

1 Comment

Related