TalkPHP - View Single Post - Generated form, how to get POST content and insert it in mysql

Peuplarchie · 08-13-2012, 02:27 AM

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 !

08-13-2012, 02:27 AM	#1 (permalink)
Peuplarchie The Acquainted Join Date: May 2008 Location: Québec Posts: 104 Thanks: 10	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 ! __________________ That's why we are not alone on earth... let's build !