| Peuplarchie |
08-13-2012 02:27 AM |
Generated form, how to get POST content and insert it in mysql
Good day all,
I'm working on a thing which lets the member create, edit, delet it's own table and data.
I have a form in a table which list the table data, this form should add a row.
Here is it's code :
PHP Code:
$tid = $_GET['id']; $tname = $_GET['tname'];
$con = mysql_connect($server, $login, $password); if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db($db, $con);
$query = "SELECT * FROM $tname"; $resultv = mysql_query($query); if (($resultv)||(mysql_errno == 0)) { echo "<table width='100%' border=\"1\">\n"; echo "<tr>"; echo "<td align='center'><b>Options</b></td>"; if (mysql_num_rows($resultv)>0) { //loop thru the field names to print the correct headers $i = 0; while ($i < mysql_num_fields($resultv)) { echo "<th>". mysql_field_name($resultv, $i) . " <a href=\"tableau.php?act=delcol&opt=tableau&tname=".$tname."&cname=".mysql_field_name($resultv, $i)."\" title=\"DELETE COLUMN : ". mysql_field_name($resultv, $i) . "\"><img src=\"Images/stock_delete-column.png\" align=\"bottom\"></a></th>\n"; $i++; } echo "</tr>"; echo "<tr><form name=\"formadd\" method=\"post\" action=\"tableau.php?add=row\">\n"; //loop thru the field names to print the correct headers $i = 0; echo "<td align='center'><input type=\"submit\" value=\"Ajouter\"></td>"; while ($i < mysql_num_fields($resultv)) { echo "<td align='center'><input type=\"text\" name=\"". mysql_field_name($resultv, $i) . "\"</td>\n"; $i++; } echo "</form></tr>\n"; //display the data while ($rowv = mysql_fetch_array($resultv,MYSQL_ASSOC)) { echo "<tr><td><br></td>\n"; foreach ($rowv as $data) { if ($data == "") { echo "<td align='center'><br></td>\n"; }else{ echo "<td align='center'>". $data . "</td>\n"; } } } }else{ echo "<tr><td colspan='" . ($i+1) . "'>No Results found!</td></tr>\n"; }
echo "</table>"; }else{ echo "Error in running query :". mysql_error(); }
My issue is to receive the data and insert it in the database.
I have know clue how to put the POSTs into variable so I can Insert it in the query..
Can somebody help me ?
Take care !
|