PHP INSERT INTO - Can I use an array to populate field names?

Question

What I am wondering is how you can use INSERT INTO if you don't know how many fields there will be in advance. My project involves adding columns if required. Therefore my code will look like this:

$query = "INSERT INTO table (could be any amount) VALUES (could be any amount)";

Is it possible to populate the 'could be any amount' parts from arrays? These could be as follows:

$array1 = (fieldname, fieldname, fieldname);
$array2 = (value, value, value);

Thanks in advance for any help you can give.

Gaurav · Accepted Answer · 2011-04-07 13:14:30Z

7

$array2 = array_map('mysql_real_escape_string', $array2);
$query = "INSERT INTO table (`".implode("`,`", $array1)."`)"
         ." VALUES ('".implode("','", $array2)."')";

But You should not use such bad practices.

edited Apr 7, 2011 at 13:14

answered Apr 7, 2011 at 12:37

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

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

Collectives™ on Stack Overflow

PHP INSERT INTO - Can I use an array to populate field names?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related