how to insert data from a incrimented table row into the db

sarmenhb · 06-26-2008, 10:14 PM

if i have a table whose rows are incrimented when the user clicks on the link "add row" how can i add the data put into each field into the db?

here is an example of what i mean
Tryit Editor v1.4

if there were textboxes in each new row that was created, how do i pass those values into a db?

thanks

delayedinsanity · 06-26-2008, 10:24 PM

Assign them to an array, and loop through the array when you add the data to the table.

HTML Code:

<input type="text" name="row_data[]" value="" />

When you use [] in the input fields name value, it adds all data to an array of the same name. Then you could use a foreach or for loop to spin through them and add them to the database however you like.
-m

sarmenhb · 06-26-2008, 11:45 PM

Quote:

Originally Posted by delayedinsanity

Assign them to an array, and loop through the array when you add the data to the table.

HTML Code:

<input type="text" name="row_data[]" value="" />

When you use [] in the input fields name value, it adds all data to an array of the same name. Then you could use a foreach or for loop to spin through them and add them to the database however you like.
-m

thanks but what if this is my code

HTML Code:

<input type="text" name="row_data[1]" value="" />
<input type="text" name="row_data[2]" value="" />
<input type="text" name="row_data[3]" value="" />
<input type="text" name="row_data[4]" value="" />
<input type="text" name="row_data[5]" value="" />

what kind of php do i use to loop through this and to the db?

would it look liek this? its just a guess

Code:

for($i=0;$i<count($row_data);$i++) {

$query = mysql_query("insert into table values(null,'$_POST['row_data[i]]'");
}

delayedinsanity · 06-27-2008, 01:15 AM

Don't worry about putting the numbers in there, though you can, PHP will automagically assign them a number. I actually did this just recently on a page where I was setting configuration values, and the code looked like (after performing sanitization of the data elsewhere and error checking it as well):

PHP Code:


			
// Get the database connection
$this->pSQLconn = $pSQL->returnSQL();

// Add the new data to the database
foreach ($aData as $key => $value)
{
    $q = sprintf("UPDATE `".TBL_PREFIX."config` SET cfg_value='%s' WHERE cfg_name='%s'", $this->pSQLconn->real_escape_string($value), strtoupper($key));
    $bSuccess = ($this->pSQLconn->query($q)) ? true : false;
    if ($bSuccess === false) break; // If there were any problems along the way, drop out
}

return (bool) $bSuccess;

However I tend to favour foreach when I can over for loops, but you could do it just like you were saying too. Note that this was from an associative array, from a numerical array I would just use a foreach ($row_data as $value) .. since you probably don't need the number unless you're using that in the database table.
-m