Inserting Data to mysql db

[redrabbit]

Hello everyone,

My website has a backend administration system that allows me to add/edit/view the data on my website.

I have started making a page that i can select the page i want to add stuff to, then when the form is submitted, input boxes appear for all fields and then i can enter data.

So when this data is entered, i want to dynamically add this to a database.

Instead of doing this:
mysql_query("insert into table values ('bleh', 'noooo', 'booby')", $link);

I want to do something like this :

mysql_query("insert into table values ($field_name)", $link);
so the field name will be replaced by the ... field name.

I have successfully done this on the edit page, as its just a case of looping through the fields updating $field_name with the posted variable.

However im not sure how to do this on a Add page.

Any ideas ?

[sneakyimp]

assuming you have POSTed values to a php page and further assuming that your POSTed variable identifiers match your databse, something like this might work

$sql = "INSERT INTO TABLE ";
$field_names = "(";
$values = "(";

// let's suppose your key=>value pairs are in $_POST
$boolFirst = true;
foreach($_POST as $key=>$value) {
   if (!$boolFirst) {
      $field_names .= ",";
      $values .= ",";

   $field_names .= $key;
   $values .= mysql_escape_string($value);

   }
   $boolFirst = false;
}
$field_names .= ")";
$values .= ")";

$sql .= $field_names . " VALUES " . $values . ";";

i haven't test this or anything, but it should be pretty close?

[redrabbit]

Yes, that worked thanks.

I know have a really good backend admin system. Hooray!

Thanks.