Capture Form Info as well as Table ID

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
SalientAnimal
Forum Newbie
Posts: 11
Joined: Mon May 31, 2010 10:01 am

Capture Form Info as well as Table ID

Post by SalientAnimal »

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.

Code: Select all

	<?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)
	 

	 
?>

Code: Select all

<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>

Code: Select all

<?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)
?> 

Post Reply