Capture Form Info as well as Table ID - Please Help

PHP
1

Hi Guys,

I am rather new to PHP scripting and using it to capture information to a MySQL database. I have created a web based system that asks users to login and then capture certain informtion. However I have having trouble getting all the informaion to write to the databases as required.

  1. I would like all my pages to be part of a session login i.e. a user needs to be logged in to access a page. But I am unsure of how to link this to the userinfo table I created.
  2. When submitting a form I would like the id field from the userinfo table to be populated into the form table in this example to the customer_services_tracker table.

Please see below my code for the two php files

Thanks.

  <?php
         
          $con = mysql_connect("localhost","root","root");
        if (!$con)
          {
          die('Could not connect: ' . mysql_error());
          }
          mysql_select_db("mydatabase", $con);
         
         
          $a= $_POST[id];
         // echo $a;
         
          $result = mysql_query("SELECT id FROM userinfo WHERE username='$a'");
        while($row = mysql_fetch_array($result))
             {
         
        $c= $row['id'];
          $sql="INSERT INTO customer_services_tracker
          (id
          , customer_name
          , customer_email_address
          , case_number
          , msisdn
          , route_cause
          , escalatedto
          , province
          , comments)
          
        VALUES
        ('$c'
        ,'$_POST[customer_name]'
        ,'$_POST[customer_email_address]
        ,'$_POST[case_number]'
        ,'$_POST[msisdn]'
        ,'$_POST[route_cause]'
        ,'$_POST[escalatedto]'
        ,'$_POST[province]'
        ,'$_POST[comments]')";
         
        mysql_query($sql,$con);  
              }
         
        echo "1 record added";
         
         
        mysql_close($con)
         

         
?>


<title> CS</title>
<script type="text/javascript">
var count = 0;
var delay = 250;
var text = " - CUSTOMER SERVICES                              ";
function scroll () {
  document.title = text.substring(count, text.length) + text.substring (0, count)
  if (count < text.length) {
    count ++;
  } else {
    count = 1;
  }
  setTimeout ("scroll(1)", delay);
}
scroll();
</script>
<LINK REL="SHORTCUT ICON" HREF="favicon.ico">

<script language="javascript" src="js\\customer_services_list.js"></script>



<style type="text/css">
<!--
#form1 table tr td {
        color: #FFF;
}
#form1 table tr td {
        font-family: Tahoma, Geneva, sans-serif;
}
#form1 p {
        color: #FFF;
        font-size: 30px;
        font-weight: bold;
        text-align: center;
        font-family: Tahoma;
}
-->
</style>
</head>
<link rel="stylesheet" type="text/css" href="css/layout_customer_services.css"/>
<body>
<form id="form1" name="form1" method="post" action="new10.php" onSubmit="return ValidateForm(); true">
<table width="200" border="0">
  <tr>
    <td><img src="images/logo.gif" alt="Logo" width="164" height="93" align="left" /></td>
  </tr>
</table>
<table width="60%" border="0" align="center" img="images/background3.png">
  <tr>
    <td height="94"><p align="justify"> - CUSTOMER SERVICES</p>
        </td>
  </tr>
  <tr>
    <td>
        <table width="36%" border="0" align="center" cellpadding="2" cellspacing="0">
                <tr>
                <td width="29%" align="right" valign="middle"><strong>Customer Name :</strong></td>
                <td>
                <input type="text" name="customer_name" width="70%" align="left" valign="middle">
                </td>
                </tr>
                <tr>
                <td width="29%" align="right" valign="middle"><strong>E-Mail Address :</strong></td>
                <td>
                <input type="text" name="customer_email_address" width="70%" align="left" valign="middle">
                </td>
                
                </tr>
                <tr>
                <td width="29%" align="right" valign="middle"><strong>Case Number :</strong></td>
                <td>
                <input type="text" name="case_number" width="70%" align="left" valign="middle">
                </td>
                </tr>
                
                <tr>
                <td width="29%" align="right" valign="middle"><strong>MSISDN :</strong></td>
                <td>
                <input type="text" name="msisdn" width="70%" align="left" valign="middle">
                </td>
                </tr>
                
                <tr>      
            <td width="29%" align="right" valign="middle">
                <strong>Route Cause :</strong></td>
        <td width="71%" align="left" valign="middle">
                <select name="route_cause" id="call_reason">
                        <option value="">Select the Call Reason</option>
                        <option value="Account Balance Enquiry">Account Balance Enquiry</option>
                        <option value="Account Not Received">Account Not Received</option>
                        <option value="ACF Enquiry">ACF Enquiry</option>
                        <option value="Add & Remove Product">Add & Remove Product</option>
                        <option value="Airtime Balance Enquiry">Airtime Balance Enquiry</option>
                        <option value="Airtime Reset Enquiry">Airtime Reset Enquiry</option>
                        <option value="Blacklisting Enquiry">Blacklisting Enquiry</option>
                        <option value="Cancellation Request">Cancellation Request</option>
                        <option value="Case Logged Follow Up">Case Logged Follow Up</option>
                        <option value="Change Banking Details">Change Banking Details</option>
                        <option value="Credit Limit Enquiry">Credit Limit Enquiry</option>
                        <option value="Free SMS Disappeared">Free SMS Disappeared</option>
                        <option value="Free SMS Enquiry">Free SMS Enquiry</option>
                        <option value="GPRS Barred">GPRS Barred</option>
                        <option value="Handset Enquiry">Handset Enquiry</option>
                        <option value="Hotline Enquiry">Hotline Enquiry</option>
                        <option value="Insurance Enquiry">Insurance Enquiry</option>
                        <option value="International Roaming Enquiry">Int. Roaming Enquiry</option>
                        <option value="Invoice Dispute Enquiry">Invoice Dispute Enquiry</option>
                        <option value="Lost/Stolen Phone (DT)">Lost/Stolen Phone (DT)</option>
                        <option value="MMS Enquiry">MMS Enquiry</option>
                        <option value="Monthly Reset Commitment">Monthly Reset Commitment</option>
                        <option value="Monthly Reset SMS">Monthly Reset SMS</option>
                        <option value="M'tshele Nine Nine">M'tshele Nine Nine</option>
                        <option value="Network Signal Enquiry">Network Signal Enquiry</option>
                        <option value="Phone As a Modem">Phone As a Modem</option>
                        <option value="Pin Puk Request">Pin Puk Request</option>
                        <option value="Port In Enquiry">Port In Enquiry</option>
                        <option value="Port Out Enquiry">Port Out Enquiry</option>
                        <option value="Process SIM Swap">Process SIM Swap</option>
                        <option value="Product Information">Product Information</option>
                        <option value="Remove Call Barrings">Remove Call Barrings</option>
                        <option value="Remove Hotline">Remove Hotline</option>
                        <option value="Repairs Enquiry">Repairs Enquiry</option>
                        <option value="Retentions Enquiry">Retentions Enquiry</option>
                        <option value="RICA Enquiry">RICA Enquiry</option>
                        <option value="Sales Lead">Sales Lead</option>
                        <option value="Send GPRS & MMS Settings">Send GPRS & MMS Settings</option>
                        <option value="Service Installation">Service Installation</option>
                        <option value="SIM Delivered Inactive">SIM Delivered Inactive</option>
                        <option value="SMS Centre No.">SMS Centre No.</option>
                        <option value="Unable to Make/Receive Calls">Unable to Make/Receive Calls</option>
                        <option value="Unable to Receive SMS">Unable to Receive SMS</option>
                        <option value="Unable to Send SMS">Unable to Send SMS</option>
                        <option value="Unable to Use GPRS">Unable to Use GPRS</option>
                        <option value="Update Personal Details">Update Personal Details</option>
                        <option value="Voicemail Diverts">Voicemail Diverts</option>
                        <option value="Voucher/Vcharge Enquiry">Voucher/Vcharge Enquiry</option>
                        <option value="V-Rewards Enquiry">V-Rewards Enquiry</option>

        </select>
                </td>
      </tr>
                  
          
          
          
          
          
        <tr>      
        <td width="29%" align="right" valign="middle">
                <strong>Escalated To :</strong></td>
        <td width="71%" align="left" valign="middle">
                <select name="escalatedto" id="escalated_to">
                        <option value="">Select the Escalation</option>
                        <option value="Billing Query">Billing Query</option>
                        <option value="Collections">Collections</option>
                        <option value="Crops">Crops</option>
                        <option value="Data">Data</option>
                        <option value="Eventum">Eventum</option>
                        <option value="Finance">Finance</option>
                        <option value="Insurance">Insurance</option>
                        <option value="Repairs">Repairs</option>
                        <option value="Retentions">Retentions</option>
                        <option value="Scrubs">Scrubs</option>
                        <option value="Team Leader/ Manager">Team Leader/ Manager</option>
                        <option value="Telesales Resolver Team">Telesales Resolver Team</option>


        </select>
                </td>
      </tr>
          
          
          
          
          
        <tr>      
        <td width="29%" align="right" valign="middle">
                <strong>Province :</strong></td>
        <td width="71%" align="left" valign="middle">
                <select name="province" id="province">
                        <option value="">Select the Province</option>
                        <option value="Eastern Cape">Eastern Cape</option>
                        <option value="Gauteng">Gauteng</option>
                        <option value="Kwa-Zulu Natal">Kwa-Zulu Natal</option>
                        <option value="Limpopo">Limpopo</option>
                        <option value="Mpumalanga">Mpumalanga</option>
                        <option value="North West">North West</option>
                        <option value="Northern Cape">Northern Cape</option>
                        <option value="Polokwane">Polokwane</option>
                        <option value="Western Cape">Western Cape</option>
                        <option value="Other">Other</option>
        </select>
                </td>
      </tr>
                 
                <tr>
                <td width="29%" align="right" valign="middle"><strong>Comments :</strong></td>
                <td>
                <textarea rows ="5" cols="30" name="comments">
                </textarea>
                </td>
                </tr>

         
      <tr>
        <td>
                <p>
          <input type="reset" value="Reset Form"><input type="Submit" value="Submit">
        </p>
                </td>
      </tr>
          
        <tr>
                <td>
                <a href="admin_tracker.html">Admin</a> 
                </td>
        </tr>
        <tr>
                <td>
                <a href="billing_tracker.html">Billing</a> 
                </td>
        </tr>
        <tr>
                <td>
                <a href="retail_support_tracker.html">Retail Support</a> 
                </td>
        </tr>
        <tr>
                <td>
                <a href="technical_support_tracker.html">Technical Support</a> 
                </td>
        </tr>

        
    </table></td>
  </tr>
</table>
<p align="justify">&nbsp;</p>
<p>&nbsp; </p>
<p align="justify">&nbsp;</p>
</form>
</body>
</html>



<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydatabase", $con);


$sql="INSERT INTO customer_services_tracker 
(customer_name
,customer_email_address
,case_number
,msisdn
,route_cause
,escalatedto
,province
,comments)

VALUES
('$_POST[customer_name]'
,'$_POST[customer_email_address]'
,'$_POST[case_number]'
,'$_POST[msisdn]'
,'$_POST[route_cause]'
,'$_POST[escalatedto]'
,'$_POST[province]'
,'$_POST[comments]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

PLEASE HEP GUYS I REALLY NEED THIS. Thanks so much