PHP - Inserting Records From Database Into Form.

I want to pull some records  plus unique key from one mysql table and then use them as questions in a form/questionnaire.

The post form will have six radio buttons  to the right of the fields pulled with the key posted but hidden and will wirte to another table.

I guess this is a templating question- as I've successfully retrieved the table 1 records via a query - I just can't seem to use them in the form. Below is the code I'm using to view table "PCM1"

<?php // query.php
require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());

$query = "SELECT * FROM pcm1";
$result = mysql_query($query);

if (!$result) die ("Database access failed: " . mysql_error());

$rows = mysql_num_rows($result);

for ($j = 0 ; $j < $rows ; ++$j)
{
echo 'RID: '   . mysql_result($result,$j,'mcde')  ;
echo 'Statement: '    . mysql_result($result,$j,'oppclub')    . '<br />';

;
}

First of all excuse me if this topic is inappropriate in this forum. But I think it's rather a PHP problem.

I can't figure out multiple duplicate database records on submitting a form.

The database table have two columns:  the first one 'Id' with AUTO_INCREMENT and the second one 'Name'.

Here's the php code for database insertion and the form:
------------------------------------------------------------------

<?php

if($_GET['add_name']){
    $host = *******;
    $user = *******';
    $pass = *******;
    $db = *******;
    $con = mysql_connect($host,$user,$pass) or die;
    mysql_select_db($db,$con);
   
    $name = $_GET['add_name'];
    $sql = "INSERT INTO names (Name) VALUES ('$name')";
    mysql_query($sql);
}

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="GET">
Your Name:
<input name="add_name" type="text"  />
<input type="submit" value="Submit" />
</form>

------------------------------------------------------------------

After submitting the form to itself once I have multiple Name entries with different Ids. The curious thing is that with Chrome browser
I get two duplicate records, with Mozilla - three of them.
Seems like mysql_query runs multiple times.

It works fine when submitting the form to a separate script and not to itself.

Do I miss something? It must be very basic.

Lets say I have this database:

table brand [brandID] [brandName] where brandID -> auto increment and one brand always has the same brandID
table product [brandID] [productID] [price] where productID -> auto increment

I want to insert new product into the database using only values [brandName] and [price]
and want brandID and productID to be created automatically


I use this form:

<form id="insertingDataToBrand" action="administratorCode.php" method="post">
   <div>Brand Name: <input type="text" name="brandName"/></div>
   <div>Price: <input type="text" name="price"/></div>
</form>

And here is the php code:

<?php
   //connection to database
   include 'connectToDatabase.php';
   
   //data retrieveing
   $brand = $_POST['brandName'];
   $price = $_POST['price'];
      
   //As I am inserting to two different tables I use two INSERT statements
   $sql = "INSERT INTO brand (brandName) values ('$brand')";
   
   mysql_query($sql) or die (mysql_error());
   
   //as brandID is created automatically I am going to insert the same value to another table
   $last_id = mysql_insert_id ();

   $sql = "INSERT INTO product (price, brandID) values ('$price', '$last_id')";
      
?>

This should work just fine (it doesnt tho) BUT my question is:

I have 3 different brands (brand A with brandID 1, brand B with brandID 2, brand C with brandID 3).
When want to insert brand D, automatically created brandID should be automatically set to 4. BUT
when I want to insert product of the same brand, lets say brand A (with different productID) brandID is automatically set to 4(or higher) as well.

What do I have to do(use) so it would be able to realise what brandID should be added?

Thanks a lot.

So I've spent 2 days now searching the web on how to make my checkbox array on my form insert the value selected by the user into my database. Here is the code that I've written. All fields except for the checkbox array works fine.

<?php virtual('/budgets/Connections/connAdmin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
 
  if (isset($_POST['submit'])) {
    $workStyle = $_POST['art_photos'];

    // Setting up a blank variable to be used in the coming loop.
    $allStyles = "";

    // For every checkbox value sent to the form.
    foreach ($workStyle as $style) {
      // Append a string called $allStyles with the current array element, and then add a comma and a space at the end.
      $allStyles .= $style . ", ";
    }

    // Delete the last two characters from the string.
    $allStyles = substr($allStyles, 0, -2);

    echo "<p>The resulting string is: <strong>$allStyles</strong></p>\r\n";

  }



if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO daily_budget (rundate, slug, reporter, budgetInfo, notes, `section`, deadline, art_photos sidebar, sBudget) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['rundate'], "text"),
                       GetSQLValueString($_POST['slug'], "text"),
                       GetSQLValueString($_POST['reporter'], "text"),
                       GetSQLValueString($_POST['budgetInfo'], "text"),
                       GetSQLValueString($_POST['notes'], "text"),
                       GetSQLValueString($_POST['section'], "text"),
                       GetSQLValueString($_POST['deadline'], "text"),
                  GetSQLValueString($_POST['art_photos'], "text"),
                       GetSQLValueString($_POST['sidebar'], "text"),
                       GetSQLValueString($_POST['sBudget'], "text"));

  mysql_select_db($database_connAdmin, $connAdmin);
  $Result1 = mysql_query($insertSQL, $connAdmin) or die(mysql_error());
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Budget Record</title>

</head>

<body>
<?php
if (isset($error)) {
   echo '<ul>';
   foreach($error as $alert) {
      echo "<li class='warning'>$alert</li>\n";
   }
   echo '</ul>';
}
?>
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
  <table align="center" width="60%" border="2" bgcolor="#FFFFFF">
    <tr valign="baseline">
      <td width="14%" align="right" nowrap="nowrap"><STRONG>Rundate:</STRONG></td>
      <td width="86%">
        <input type="text" name="rundate" size="30" value="" id="jQueryUICalendar2"/>
        <script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar2").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
              </script></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><STRONG>Section:</STRONG></td>
      <td>
        <select name="section">
        <option value=""></option>
          <option value="A1">A1</option>
          <option value="Pickup All">Pickup All</option>
          <option value="Region">Region</option>
          <option value="Atlantic">Atlantic</option>
            <option value="Business">Business</option>
          <option value="Features">Features</option>
          <option value="Sports">Sports</option>
        </select>
     </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Slug:</strong></td>
      <td><span id="sprytextfield2">
      <input type="text" name="slug" value="" size="32" />
      <span class="textfieldRequiredMsg">REQUIRED</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Budget Information:</strong></td>
      <td><span id="sprytextarea1">
        <textarea name="budgetInfo" cols="50" rows="4"></textarea>
<span class="textareaRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 11px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Notes:</strong></td>
      <td><input type="text" name="notes" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Reporter:</strong></td>
      <td><span id="sprytextfield3">
        <input type="text" name="reporter" value="" size="32" />
      <span class="textfieldRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Deadline:</strong></td>
      <td><input type="text" name="deadline" size="30" value="Enter date" id="jQueryUICalendar1"/><script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar1").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
              </script> </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Artwork:</strong></td>
      <td><label>
          <input type="checkbox" name="art_photos[]" value="factbox" id="art_photos_0"  />
          Factbox</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="graphic" id="art_photos_1" />
          Graphic</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="photo" id="art_photos_2" />
          Photo</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="video" id="art_photos_3"  />
          Video</label>
      <br /></td>
    </tr>
        <tr>
       
    </tr>
       <tr valign="baseline">
      <td nowrap="nowrap" align="right">      <strong>Sidebar:</strong></td>
      <td valign="baseline"><span id="spryradio2">
        <label>
          <input type="radio" name="sidebar" value="y" id="sidebar_0" />
          Yes</label>
        <br />
        <label>
          <input type="radio" name="sidebar" value="n" id="sidebar_1" />
          No</label>
        <br />
        <span class="radioRequiredMsg"><strong style="font-size: 11px">REQUIRED.</strong></span></span>
       
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Sidebar Information:</strong></td>
      <td><input type="text" name="sBudget" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1" />
</form>

<p>&nbsp;</p>
<h3><a href="/new_budget/admin/manage_budgets.php"><strong>View your budget entry, make changes or delete your budget.</strong></a></h3>
<script type="text/javascript">
<!--
jQuery("#jQueryUICalendar1").datepicker();
jQuery("#jQueryUICalendar2").datepicker();
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "none", {maxChars:15, validateOn:["change"]});
var sprytextarea1 = new Spry.Widget.ValidationTextarea("sprytextarea1", {validateOn:["change"]});
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3");
var spryradio2 = new Spry.Widget.ValidationRadio("spryradio2");
//-->
</script>
</body>
</html>