Using PHP/HTML to update informationin MySQL

johnathanamber 0 Newbie Poster · 2008-07-08T01:49:25+00:00

All,

OK so I've created my search form and it works fine. It populates most of the fields with the correct information from the MySQL DB. Now I only have two problems... how to replace the correct record on the DB and how to populate the <select></select> fields with the MySQL information in the HTML form.

Any ideas?

God bless,
Johnathan

johnathanamber 0 Newbie Poster · 2008-07-10T20:57:26+00:00

OK, I've corrected the < select > field problem... now, how do I replace the correct record in the mysql database.

I have the folllowing code thus far for the updatestfdb.php file which takes the info from the form to the DB.

<?php
$con = mysql_connect("localhost","stf","stf"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect to the ASDTSG database: ' . mysql_error()); 
} 
mysql_select_db("asdtsg", $con); //Replace with your MySQL DB Name
$contactname=mysql_real_escape_string($_POST['contactname']); //This value has to be the same as in the HTML form file  //This value has to be the same as in the HTML form file
$contactphone1=mysql_real_escape_string($_POST['contactphone1']); //This value has to be the same as in the HTML form file
$contactphone2=mysql_real_escape_string($_POST['contactphone2']); //This value has to be the same as in the HTML form file
$contactfax=mysql_real_escape_string($_POST['contactfax']); //This value has to be the same as in the HTML form file
$contactaffiliation=mysql_real_escape_string($_POST['contactaffiliation']); //This value has to be the same as in the HTML form file
$contactemail=mysql_real_escape_string($_POST['contactemail']); //This value has to be the same as in the HTML form file
$contactmethod=mysql_real_escape_string($_POST['contactmethod']); //This value has to be the same as in the HTML form file
other fields...

$sql="UPDATE stf SET (contactname, contactphone1, contactphone2, contactfax, contactaffiliation, contactemail, contactmethod, other fields...) = VALUES ('$contactname', '$contactphone1', '$contactphone2', '$contactfax', '$contactaffiliation', '$contactemail', '$contactmethod', 'other fields...')"; 

if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error()); 
} 
echo "The STF that you've modified was successfully added to the database."; 
mysql_close($con);
?>

God bless and thank you,
Johnathan

Shanti C 106 Posting Virtuoso · 2008-07-11T10:34:57+00:00

Helloo..
k.Thats fine...
Tel, how did you get your record from database means by using one id,you was getting the records from db to update now,by using that id ,you can update your record now...
Using where clause in update query...

ANy doubt tel me...

Shanti C 106 Posting Virtuoso · 2008-07-11T10:41:12+00:00

send your database also...

johnathanamber 0 Newbie Poster · 2008-07-11T20:15:44+00:00

Shanti and everyone else,

OK, I've actually gotten several of my problems corrected.

I've correct any HTML and PHP form. I am able to submit and retrieve forms, I can even update, the problem... is that ALL forms are updated instead of just a single form.

Here is the PHP file that displays the form that I search for:

updatestf.php

<?php
include('dbconnect.php');
//Credentials for the MySQL Database
//$hostname = "localhost"; // Our DB server.
//$username = "stf"; // The username you created for this database.
//$password = "stf"; // The password you created for the username.
//$usertable = "stf"; // The name of the table you made.
//$dbName = "asdtsg"; // This is the name of the database you made.

//Connect to the STF MySQL Database
//MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to the Database. Please make sure that your username/password/DB name and host are correct.<br />Also, make sure that the database can be accessed. You can test this by going to the following link: <a href='http://asdtsg.com/dbtest.php'>http://asdtsg.com/dbtest.php</a>.");
//@mysql_select_db( "$dbName") or die("Unable to select database. Please verify that the database name is correct.");

//query details table begins
$query = mysql_query("SELECT * FROM stf WHERE $fieldname1 LIKE '%$criteria1%'"."AND $fieldname2 LIKE '%$criteria2%'"."ORDER BY site, stfno, datereceived, timereceived, dateresolved, timeresolved");
//$query = mysql_query("SELECT * FROM stf WHERE $metode LIKE '%$search%' LIMIT 0, 50");
while ($row = @mysql_fetch_array($query))
{
$variable999=$row["id"];
$variable1=$row["contactname"];
$variable2=$row["contactphone1"];
$variable3=$row["contactphone2"];
$variable4=$row["contactfax"];
$variable5=$row["contactaffiliation"];
$variable6=$row["contactemail"];
$variable7=$row["contactmethod"];
$variable8=$row["site"];
$variable9=$row["wpn"];
$variable10=$row["sitestatus"];
$variable11=$row["accountmanagerlist"];
$variable12=$row["accountmanagernotlisted"];
$variable13=$row["submitterlist"];
$variable14=$row["submitternotlisted"];
$variable15=$row["assignedengineerlist"];
$variable16=$row["assignedengineernotlisted"];
$variable17=$row["servicecategorylist"];
$variable18=$row["stfno"];
$variable19=$row["edfno"];
$variable20=$row["erno"];
$variable21=$row["stfstatus"];
$variable22=$row["edfstatus"];
$variable23=$row["turnoverstatus"];
$variable24=$row["datereceived"];
$variable25=$row["timereceived"];
$variable26=$row["ampmreceived"];
$variable27=$row["dateresponded"];
$variable28=$row["timeresponded"];
$variable29=$row["ampmresponded"];
$variable30=$row["dateresolved"];
$variable31=$row["timeresolved"];
$variable32=$row["ampmresolved"];
$variable33=$row["datescheduled"];
$variable34=$row["timescheduled"];
$variable35=$row["ampmscheduled"];
$variable36=$row["servicedescsystemlist"];
$variable37=$row["servicedescsystemnotlisted"];
$variable38=$row["servicedesccomponentlist"];
$variable39=$row["servicedesccomponentnotlisted"];
$variable40=$row["servicedescrevision"];
$variable41=$row["anticipatedglobaleffect"];
$variable42=$row["servicedescriptioninformation"];
$variable43=$row["serviceressystemlist"];
$variable44=$row["serviceressystemnotlisted"];
$variable45=$row["servicerescomponentlist"];
$variable46=$row["servicerescomponentnotlisted"];
$variable47=$row["serviceresrevision"];
$variable48=$row["serviceresolutioninformation"];
?>
<html>
<head>
<title>Service Tracking Form</title>

<script language="JavaScript" type="text/JavaScript">
function checkForm(thisform)
{

// First check the required fields.

if(document.stf.contactname.value=='')
{
alert("The Contact Name is a required field!");
return false;
}
if(document.stf.contactemail.value=='')
{
alert("The Contact Email is a required field!");
return false;
}
if(document.stf.contactaffiliation.value=='')
{
alert("The Contact Affiliation is a required field!");
return false;
}
if(document.stf.contactmethod.value=='')
{
alert("The Contact Method is a required field!");
return false;
}
if(document.stf.site.value=='')
{
alert("The Site is a required field!");
return false;
}
if(document.stf.wpn.value=='')
{
alert("The WPN is a required field!");
return false;
}
if(document.stf.sitestatus.value=='')
{
alert("The Site Status is a required field!");
return false;
}
if(document.stf.accountmanagerlist.value=='')
{
alert("The Account Manager is a required field! If the Name is not listed please choose 'See Below' and enter the AM's name in the field below the drop down list.");
return false;
}
if(document.stf.submitterlist.value=='')
{
alert("The Sumitter is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.assignedengineerlist.value=='')
{
alert("The Assigned Engineer is a required field! If the name is not listed please choose 'See Below' and enter the name in the field below the drop down list.");
return false;
}
if(document.stf.servicecategorylist.value=='')
{
alert("The Service Category is a required field!");
return false;
}
if(document.stf.stfno.value=='')
{
alert("The STF Number is a required field!");
return false;
}
if(document.stf.stfstatus.value=='')
{
alert("The STF Status is a required field!");
return false;
}
if(document.stf.edfstatus.value=='')
{
alert("The EDF Status is a required field!");
return false;
}
if(document.stf.turnoverstatus.value=='')
{
alert("The Turn Over Status is a required field!");
return false;
}
if(document.stf.datereceived.value=='')
{
alert("The Date Received is a required field!");
return false;
}
if(document.stf.timereceived.value=='')
{
alert("The Time Received is a required field!");
return false;
}
if(document.stf.ampmreceived.value=='')
{
alert("The Time AM/PM Received is a required field!");
return false;
}
if(document.stf.dateresponded.value=='')
{
alert("The Date Responded is a required field!");
return false;
}
if(document.stf.timeresponded.value=='')
{
alert("The Time Responded is a required field!");
return false;
}
if(document.stf.ampmresponded.value=='')
{
alert("The Time AM/PM Responded is a required field!");
return false;
}
if(document.stf.dateresolvedvalue=='')
{
alert("The Date Resolved is a required field!");
return false;
}
if(document.stf.timeresolved.value=='')
{
alert("The Time Resolved is a required field!");
return false;
}
if(document.stf.ampmresolved.value=='')
{
alert("The Time AM/PM Resolved is a required field!");
return false;
}
if(document.stf.servicedescsystemlist.value=='')
{
alert("The Service Description System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicedesccomponentlist.value=='')
{
alert("The Service Description Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}
if(document.stf.servicedescriptioninformation.value=='')
{
alert("The Service Description Information is a required field!");
return false;
}
if(document.stf.serviceresolutioninformation.value=='')
{
alert("The Service Resolution Information is a required field!");
return false;
}
if(document.stf.serviceressystemlist.value=='')
{
alert("The Service Resolution System is a required field! If the system is not listed please choose 'See Below' and enter the system in the field below the drop down list.");
return false;
}
if(document.stf.servicerescomponentlist.value=='')
{
alert("The Service Resolution Component is a required field! If the component is not listed please choose 'See Below' and enter the component in the field below the drop down list.");
return false;
}

chosen = ""
len = document.stf.stfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.stfstatus[i].checked){
  chosen = document.stf.stfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The STF Status is a required field! Please choose whether the STF is Opened or Closed.");
  return false;
}

chosen = ""
len = document.stf.edfstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.edfstatus[i].checked){
  chosen = document.stf.edfstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The EDF Status is a required field! Please choose whether an EDF Status is Opened or Closed.");
return false;
}

chosen = ""
len = document.stf.turnoverstatus.length;
 
for(i=0;i<len;i++){
 if(document.stf.turnoverstatus[i].checked){
  chosen = document.stf.turnoverstatus[i].value;
 }
}
 
if(chosen ==""){
  alert("The Turn Over Status is a required field! Please choose whether the site has been turnec over to the Technical Services Group or not.");
return false;
}

return true;
}
</script>

</head>
<body>
<center><font face='arial'>Please note: You will have to refill in the STF Status, EDF Status and the Turnover Status radio options.</font>


<br style="page-break-before: always" />

<form name="stf" method="POST" action="http://asdtsg.com/updatestfdb.php" 
    onsubmit="return checkForm();" style="height: 43px; width: 624px">
    
<input type="hidden" VALUE="$variable999" NAME="id">

<!-- Begin Master Table -->
<table align="left" valign="top" width="650">
<!-- Begin Master Row 1 -->
<tr>
<!-- Begin Master Cell 1 -->
<td>

<!-- Begin STF Main Table 1 (STF Information) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Inner Table 1 -->
<table align="left" width="26%">
<tr>

<!-- Begin STF Logo -->
<td valign="top" style="border: 1px black solid;">
<center>
<img src="http://asdtsg.com/images/stories/ARINC%20logo.jpg"><br />
<font face="arial" size="4">
Service Tracking<br />
Form</font>
</center>
</td>
<!-- End STF Logo -->

</tr>
<tr>

<!-- Start STF Contact -->
<td style="border: black solid 1px;">
<font face="arial" size="2">Contact Name:</font><br />
<input type="text" size="18" name="contactname" maxlength="100" value="<?php print ("$variable1"); ?>" /><br />
<font face="arial" size="2">Contact Phone Number 1:</font><br />
<input type="text" size="18" name="contactphone1" maxlength="100" value="<?php print ("$variable2"); ?>" /><br />
<font face="arial" size="2">Contact Phone Number 2:</font><br />
<input type="text" size="18" name="contactphone2" maxlength="100" value="<?php print ("$variable3"); ?>" /><br />
<font face="arial" size="2">Contact Fax Number:</font><br />
<input type="text" size="18" name="contactfax" maxlength="100" value="<?php print ("$variable4"); ?>" /><br />
<font face="arial" size="2">Contact Affiliation:</font><br />
<select name="contactaffiliation">
<option value="<?php echo ("$variable5") ?>"><?php echo ("$variable5") ?></option> 
<option value =""></option> 
<option value ="ARINC Personnel">ARINC Personnel</option> 
<option value ="Airline Personnel">Airline Personnel</option> 
<option value ="Airport Personnel">Airport Personnel</option> 
<option value ="AFL">AFL</option> 
<option value ="AMS">AMS</option> 
<option value ="ASA">ASA</option> 
<option value ="Ascent">Ascent</option> 
<option value ="BAGS">BAGS</option> 
<option value ="BAR">BAR</option> 
<option value ="Blackhawk Systems">Blackhawk Systems</option> 
<option value ="Citrix Systems Inc.">Citrix Systems Inc.</option> 
<option value ="CSI">CSI</option> 
<option value ="Damarel">Damarel</option> 
<option value ="EDS">EDS</option> 
<option value ="ESP">ESP</option> 
<option value ="FASL">FASL</option> 
<option value ="Fujitsu">Fujitsu</option> 
<option value ="GigaNet">GigaNet</option> 
<option value ="IBM">IBM</option> 
<option value ="IBS">IBS</option> 
<option value ="ICT">ICT</option> 
<option value ="IDS">IDS</option> 
<option value ="IER">IER</option> 
<option value ="Intelisys">Intelisys</option> 
<option value ="Intermec">Intermec</option> 
<option value ="JIT">JIT</option> 
<option value ="Kinetics">Kinetics</option> 
<option value ="Lufthansa Systems">Lufthansa Systems</option> 
<option value ="Menzies Aviation">Menzies Aviation</option> 
<option value ="MPHASIS">MPHASIS</option> 
<option value ="Navitaire">Navitaire</option> 
<option value ="GLOGIC">QLOGIC</option> 
<option value ="Sabre">Sabre</option> 
<option value ="SITA">SITA</option> 
<option value ="ServiceTec">ServiceTec</option> 
<option value ="Travsys">Travsys</option> 
<option value ="Ultra">Ultra</option> 
<option value ="UNISYS">UNISYS</option> 
<option value ="Vidtronix">Vidtronix</option> 
<option value ="Other">Other</option> 
</select><br />
<font face="arial" size="2">Contact Email:</font><br />
<input type="text" size="18" name="contactemail" maxlength="100" value="<?php print ("$variable6"); ?>" /><br />
<font face="arial" size="2">Contact Method:</font><br />
<select name="contactmethod">
<option value="<?php echo ("$variable7") ?>"><?php echo ("$variable7") ?></option> 
<option value =""></option>
<option value ="ais_support@arinc.com">ais_support@arinc.com</option>
<option value ="Hotline">Hotline</option>
<option value ="Internal Identification">Internal Identification</option>
<option value ="Office Email">Office Email</option>
<option value ="Office Phone Call">Office Phone Call</option>
</select>
</td>
<!-- End STF Contact -->

</tr>
</table>
<!-- End Inner Table 1 -->

<!-- Begin Inner Table 2 -->
<table align="left" width="36%">
<tr>

<!-- Begin STF Site -->
<td  style="border: 1px black solid;">
<font face="arial" size="2">Site:</font><br />
<input type="text" size="2" name="site" maxlength="3"  onBlur="javascript:this.value=this.value.toUpperCase();" value="<?php print ("$variable8"); ?>" /><br />
<font face="arial" size="2">WPN:</font><br />
<input type="text" size="18" name="wpn" value="<?php print ("$variable9"); ?>"/><br />
<font face="arial" size="2">Site Status:</font><br />
<select name="sitestatus">
<option value="<?php echo ("$variable10") ?>"><?php echo ("$variable10") ?></option> 
<option value =""></option>
<option value ="All">All</option>
<option value ="Airport Systems Division (ASD)">Airport Systems Division (ASD)</option>
<option value ="Asia Pacific Division (APD)">Asia Pacific Division (APD)</option>
<option value ="Europe Middle East Africa (EMEA)">Europe Middle East Africa (EMEA)</option>
</select><br />
<font face="arial" size="2">Account Manager:</font><br />
<select name="accountmanagerlist">
<option value="<?php echo ("$variable11") ?>"><?php echo ("$variable11") ?></option> 
<option value =""></option>
<option value ="All">All</option>
<option value ="----------APD----------">----------APD----------</option>
<option value ="Allen Olano">Allen Olano</option>
<option value ="Glen Oliveiro">Glen Oliveiro</option>
<option value ="Koichi Mikami">Koichi Mikami</option>
<option value ="Sabrina Lai">Sabrina Lai</option>
<option value ="Willy Kim">Willy Kim</option>
<option value ="Yoshiyuki Tawara">Yoshiyuki Tawara</option>
<option value ="----------ASD----------">----------ASD----------</option>
<option value ="Carmen Corraro">Carmen Corraro</option>
<option value ="Grant Decker">Grant Decker</option>
<option value ="Jeff Byers">Jeff Byers</option>
<option value ="John Dungan">John Dungan</option>
<option value ="Marian Bracho">Marian Bracho</option>
<option value ="Salley Philpott">Salley Philpott</option>
<option value ="Tawnya Templeton">Tawnya Templeton</option>
<option value ="Tony Blockton">Tony Blockton</option>
<option value ="---------EMEA---------">---------EMEA---------</option>
<option value ="Carlos Jodar">Carlos Jodar</option>
<option value ="Chris Young">Chris Young</option>
<option value ="Debra Lawrence">Debra Lawrence</option>
<option value ="James Needham">James Needham</option>
<option value ="Linda Judge">Linda Judge</option>
<option value ="Mahira Khan">Mahira Khan</option>
<option value ="Marco Delu">Marco Delu</option>
<option value ="Melanie Reiser">Melanie Reiser</option>
<option value ="Peter Webb">Peter Webb</option>
<option value ="Rob Debruijn">Rob Debruijn</option>
<option value ="Robin Santall">Robin Santall</option>
<option value ="Stefano Boccafoglia">Stefano Boccafoglia</option>
<option value ="Taania Hobden">Taania Hobden</option>
<option value ="Tracey Atkinson">Tracey Atkinson</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="accountmanagernotlisted" value="<?php print ("$variable12"); ?>"/><br />
</td>
<!-- End STF Site -->

</tr>
<tr>

<!-- Begin STF Submitter -->
<td align="left" valign="top"  style="border: 1px black solid;">
<font face="arial" size="2">Submitter:</font><br />
<select name="submitterlist">
<option value="<?php echo ("$variable13") ?>"><?php echo ("$variable13") ?></option> 
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="submitternotlisted" value="<?php print ("$variable14"); ?>"/><br />
<font face="arial" size="2">Assigned Engineer:</font><br />
<select name="assignedengineerlist">
<option value="<?php echo ("$variable15") ?>"><?php echo ("$variable15") ?></option> 
<option value =""></option>
<option value ="Aaron Downing">Aaron Downing</option>
<option value ="Ercan Kadakal">Ercan Kadakal</option>
<option value ="Greg Gatz">Greg Gatz</option>
<option value ="Johnathan Morlock">Johnathan Morlock</option>
<option value ="Matt Sirkis">Matt Sirkis</option>
<option value ="Patrick Hicks">Patrick Hicks</option>
<option value ="Stephen Khan">Stephen Khan</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input type="text" size="18" name="assignedengineernotlisted" value="<?php print ("$variable16"); ?>"/>
</td>
<!-- End STF Submitter -->

</tr>
<tr>

<!-- Start Issue Info -->
<td style="border: black solid 1px;" align="left">
<font face="arial" size="2">Service Category</font><br />
<select name="servicecategorylist">
<option value="<?php echo ("$variable17") ?>"><?php echo ("$variable17") ?></option> 
<option value =""></option>
<option value ="ARINC Software">ARINC Software</option>
<option value ="Circuit Error">Circuit Error</option>
<option value ="Configuration Change">Configuration Change</option>
<option value ="Configuration Error">Configuration Error</option>
<option value ="Hardware Error">Hardware Error</option>
<option value ="Host Error">Host Error</option>
<option value ="Information Request">Information Request</option>
<option value ="Network Error">Network Error</option>
<option value ="Power Outage">Power Outage</option>
<option value ="Software Deployment">Software Deployment</option>
<option value ="Software Upgrade">Software Upgrade</option>
<option value ="Third-Party Software">Third-Party Software</option>
<option value ="User Error">User Error</option>
<option value ="Unknown">Unknown</option>
<option value ="Other">Other</option>
</select><br />
</td>
<!-- End Issue Info -->

</tr>
</table>
<!-- End Inner Table 2 -->

<!-- Begin Inner Table 3 -->
<table align="left" width="35%" valign="top">
<tr>
<td style="border: 1px black solid">

<!-- Begin STF No. -->
<table>
<tr>
<td align="left" valign="top">
<font face="arial" size="2">STF No.:</font><br />
<!-- Applied the Numbers Only javascript to this input. -->
<input type="text" size="10" name="stfno" maxlength="8" onkeyup="this.value = this.value.replace (/\D+/, '')" value="<?php print ("$variable18"); ?>" /><br />
<font face="arial" size="2">EDF No.:</font><br />
<input type="text" size="10" name="edfno" maxlength="20" value="<?php print ("$variable19"); ?>" /><br />
<font face="arial" size="2">Ext. Ref. No.:</font><br />
<input type="text" size="10" name="erno" maxlength="20" value="<?php print ("$variable20"); ?>" />
</td>
<!-- End STF No. -->

<!-- Begin STF Status -->
<td align="left" valign="top">
<table width="100%">
<tr>
<td>
<font face="arial" size="2">STF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="stfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="stfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">EDF Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="edfstatus" value="Open" />
<font face="arial" size="1">Open</font>
</td>
<td>
<input type="radio" name="edfstatus" value="Closed" />
<font face="arial" size="1">Closed</font>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<font face="arial" size="2">Turn Over Status:</font><br />
</td>
</tr>
</table>
<table>
<tr>
<td>
<input type="radio" name="turnoverstatus" value="Yes" />
<font face="arial" size="1">Yes</font>
</td>
<td>
<input type="radio" name="turnoverstatus" value="No" />
<font face="arial" size="1">No</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Status -->

</td>
</tr>
<tr>
<td style="border: 1px black solid">

<!-- Begin STF Date/Time -->
<table>
<tr>
<td>
<font face="arial" size="2">Date/Time Received:</font><br />
<input name="datereceived" type="text" size="6" maxlength="10" value="<?php print ("$variable24"); ?>" /> @ <input name="timereceived" type="text" size="6" maxlength="5" value="<?php print ("$variable25"); ?>" /><select name="ampmreceived"><option value="<?php echo ("$variable26") ?>"><?php echo ("$variable26") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Responded:</font><br />
<input name="dateresponded" type="text" size="6" maxlength="10" value="<?php print ("$variable27"); ?>" /> @ <input name="timeresponded" type="text" size="6" maxlength="5" value="<?php print ("$variable28"); ?>" /><select name="ampmresponded"><option value="<?php echo ("$variable29") ?>"><?php echo ("$variable29") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Resolved:</font><br />
<input name="dateresolved" type="text" size="6" maxlength="10" value="<?php print ("$variable30"); ?>" /> @ <input name="timeresolved" type="text" size="6" maxlength="5" value="<?php print ("$variable31"); ?>" /><select name="ampmresolved"><option value="<?php echo ("$variable32") ?>"><?php echo ("$variable32") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
<font face="arial" size="2">Date/Time Scheduled:</font><br />
<input name="datescheduled" type="text" size="6" maxlength="10" value="<?php print ("$variable33"); ?>" /> @ <input name="timescheduled" type="text" size="6" maxlength="5" value="<?php print ("$variable34"); ?>" /><select name="ampmscheduled"><option value="<?php echo ("$variable35") ?>"><?php echo ("$variable35") ?></option> <option value =""></option><option value ="AM">AM</option><option value ="PM">PM</option></select><br />
</td>
</tr>
</table>
<!-- End STF Date/Time -->

</tr>
</table>
<!-- End Inner Table 3 -->

</td>
</tr>
</table>
<!-- End STF Main Table 1 (STF Information) -->

</br>

</td>
<!-- End Master Cell 1 -->
</tr>
<!-- End Master Row 1 -->
<!-- Begin Master Row 2 -->
<tr>
<!-- Begin Master Cell 2 -->
<td>

<!-- Begin STF Main Table 2 (STF Service Description) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Description Table -->
<table width="99%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="servicedescsystemlist">
<option value="<?php echo ("$variable36") ?>"><?php echo ("$variable36") ?></option> 
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedescsystemnotlisted" type="text" size="29" value="<?php print ("$variable37"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicedesccomponentlist">
<option value="<?php echo ("$variable38") ?>"><?php echo ("$variable38") ?></option> 
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicedesccomponentnotlisted" type="text"  size="29" value="<?php print ("$variable39"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="servicedescrevision" type="text" size="29" value="<?php print ("$variable40"); ?>" /><br />
<font face="arial" size="2">Anticipated Global Effects:</font><br />
<input name="anticipatedglobaleffect" type="text" size="29" value="<?php print ("$variable41"); ?>" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Description Information:</font><br />
<center>
<textarea name="servicedescriptioninformation" cols="73" rows="20"><?php print ("$variable42"); ?></textarea>
</center>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- End STF Main Table 2 (STF Service Description) -->

</td>
<!-- End Master Cell 2 -->
</tr>
<!-- End Master Row 2 -->
<!-- Begin Master Row 3 -->
<tr>
<!-- Begin Master Cell 3 -->
<td>

<!-- Begin STF Main Table 3 (STF Service Resolution) -->
<table align="left" valign="top" width="650">
<tr>
<td style="border: thin black solid;" valign="top">

<!-- Begin Service Resolution Table -->
<table width="640">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution</font>
</td>
</tr>
<tr>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">System:</font><br />
<select name="serviceressystemlist">
<option value="<?php echo ("$variable43") ?>"><?php echo ("$variable43") ?></option> 
<option value =""></option>
<option value ="AODB">AODB</option>
<option value ="BRS">BRS</option>
<option value ="CUSS">CUSS</option>
<option value ="FIDS">FIDS</option>
<option value ="iMuse">iMuse</option>
<option value ="MUSE/NT">MUSE/NT</option>
<option value ="RPS">RPS</option>
<option value ="Security">Security</option>
<option value ="vMuse">vMuse</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="serviceressystemnotlisted" type="text" size="29" value="<?php print ("$variable44"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicerescomponentlist">
<option value="<?php echo ("$variable45") ?>"><?php echo ("$variable45") ?></option> 
<option value =""></option>
<option value ="AirDB">AirDB</option>
<option value ="AirVue">AirVue</option>
<option value ="ATTS">ATTS</option>
<option value ="AVRS">AVRS</option>
<option value ="Babel">Babel</option>
<option value ="BagLink">BagLink</option>
<option value ="BDCS">BDCS</option>
<option value ="EasyCheck">EasyCheck</option>
<option value ="GateFlow">GateFlow</option>
<option value ="IDMS">IDMS</option>
<option value ="iMuse Express">iMuse Express</option>
<option value ="InfoHub">InfoHub</option>
<option value ="LBA2">LBA2</option>
<option value ="LDCS">LDCS</option>
<option value ="LodeStone">LodeStone</option>
<option value ="Onvoy">Onvoy</option>
<option value ="Tagtrak">Tagtrak</option>
<option value ="Vanguards">Vanguard</option>
<option value ="---------Other---------">---------Other---------</option>
<option value ="See Below">See Below</option>
</select><br />
<input name="servicerescomponentnotlisted" type="text" size="29" value="<?php print ("$variable46"); ?>" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Revision:</font><br />
<input name="serviceresrevision" type="text" size="29" value="<?php print ("$variable47"); ?>" /><br />
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="100%">
<font face="arial" size="2">Service Resolution Information:</font><br />
<center>
<textarea name="serviceresolutioninformation" cols="73" rows="20"><?php print ("$variable48"); ?></textarea>
</center>
</td>
</tr>
</table>
<input type="submit" name="submit" value="Submit STF"  /><input type="reset" value="Reset STF">
</td>
</tr>
</table>
<!-- End STF Main Table 3 (STF Service Resolution) -->

</td>
<!-- End Master Cell 3 -->
</tr>
<!-- End Master Row 3 -->
</table>
<!-- End Master Table -->

</form>

</center>

</body>
</html>
<?php
}

//Error message that displays of the search come sup with nothing.
$XX = "
<center>Sorry, an STF was not found with the search criteria:<br />
<table style='border: thin solid black'>
<tr>
<td style='border: 1px solid gray'>Search Field Name:</td>
<td style='border: 1px solid gray'>Search Field Criteria:</td>
</tr>
<tr>
<td><font color='blue'>$fieldname1</font></td>
<td><font color='red'>$criteria1</font></td>
</tr>
<tr>
<td><font color='blue'>$fieldname2</font></td>
<td><font color='red'>$criteria2</font></td>
</tr>
</table><br />
Please close this window and try again.</center>";

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}

//end
?>

Here is the PHP file that sends the update information to the DB:

updatestfdb.php

<?php
$con = mysql_connect("localhost","stf","stf"); //Replace with your actual MySQL DB Username and Password
if (!$con) 
{ 
die('Could not connect to the ASDTSG database: ' . mysql_error()); 
} 
mysql_select_db("asdtsg", $con); //Replace with your MySQL DB Name
$id=($_GET['id']);
$contactname=mysql_real_escape_string($_POST['contactname']); //This value has to be the same as in the HTML form file  //This value has to be the same as in the HTML form file
$contactphone1=mysql_real_escape_string($_POST['contactphone1']); //This value has to be the same as in the HTML form file
$contactphone2=mysql_real_escape_string($_POST['contactphone2']); //This value has to be the same as in the HTML form file
$contactfax=mysql_real_escape_string($_POST['contactfax']); //This value has to be the same as in the HTML form file
$contactaffiliation=mysql_real_escape_string($_POST['contactaffiliation']); //This value has to be the same as in the HTML form file
$contactemail=mysql_real_escape_string($_POST['contactemail']); //This value has to be the same as in the HTML form file
$contactmethod=mysql_real_escape_string($_POST['contactmethod']); //This value has to be the same as in the HTML form file
$site=mysql_real_escape_string($_POST['site']); //This value has to be the same as in the HTML form file
$wpn=mysql_real_escape_string($_POST['wpn']); //This value has to be the same as in the HTML form file
$sitestatus=mysql_real_escape_string($_POST['sitestatus']); //This value has to be the same as in the HTML form file
$accountmanagerlist=mysql_real_escape_string($_POST['accountmanagerlist']); //This value has to be the same as in the HTML form file
$accountmanagernotlisted=mysql_real_escape_string($_POST['accountmanagernotlisted']); //This value has to be the same as in the HTML form file
$submitterlist=mysql_real_escape_string($_POST['submitterlist']); //This value has to be the same as in the HTML form file
$submitternotlisted=mysql_real_escape_string($_POST['submitternotlisted']); //This value has to be the same as in the HTML form file
$assignedengineerlist=mysql_real_escape_string($_POST['assignedengineerlist']); //This value has to be the same as in the HTML form file
$assignedengineernotlisted=mysql_real_escape_string($_POST['assignedengineernotlisted']); //This value has to be the same as in the HTML form file
$servicecategorylist=mysql_real_escape_string($_POST['servicecategorylist']); //This value has to be the same as in the HTML form file
$stfno=mysql_real_escape_string($_POST['stfno']); //This value has to be the same as in the HTML form file
$edfno=mysql_real_escape_string($_POST['edfno']); //This value has to be the same as in the HTML form file
$erno=mysql_real_escape_string($_POST['erno']); //This value has to be the same as in the HTML form file
$stfstatus=mysql_real_escape_string($_POST['stfstatus']); //This value has to be the same as in the HTML form file
$edfstatus=mysql_real_escape_string($_POST['edfstatus']); //This value has to be the same as in the HTML form file
$turnoverstatus=mysql_real_escape_string($_POST['turnoverstatus']); //This value has to be the same as in the HTML form file
$datereceived=mysql_real_escape_string($_POST['datereceived']); //This value has to be the same as in the HTML form file
$timereceived=mysql_real_escape_string($_POST['timereceived']); //This value has to be the same as in the HTML form file
$ampmreceived=mysql_real_escape_string($_POST['ampmreceived']); //This value has to be the same as in the HTML form file
$dateresponded=mysql_real_escape_string($_POST['dateresponded']); //This value has to be the same as in the HTML form file
$timeresponded=mysql_real_escape_string($_POST['timeresponded']); //This value has to be the same as in the HTML form file
$ampmresponded=mysql_real_escape_string($_POST['ampmresponded']); //This value has to be the same as in the HTML form file
$dateresolved=mysql_real_escape_string($_POST['dateresolved']); //This value has to be the same as in the HTML form file
$timeresolved=mysql_real_escape_string($_POST['timeresolved']); //This value has to be the same as in the HTML form file
$ampmresolved=mysql_real_escape_string($_POST['ampmresolved']); //This value has to be the same as in the HTML form file
$datescheduled=mysql_real_escape_string($_POST['datescheduled']); //This value has to be the same as in the HTML form file
$timescheduled=mysql_real_escape_string($_POST['timescheduled']); //This value has to be the same as in the HTML form file
$ampmscheduled=mysql_real_escape_string($_POST['ampmscheduled']); //This value has to be the same as in the HTML form file
$servicedescsystemlist=mysql_real_escape_string($_POST['servicedescsystemlist']); //This value has to be the same as in the HTML form file
$servicedescsystemnotlisted=mysql_real_escape_string($_POST['servicedescsystemnotlisted']); //This value has to be the same as in the HTML form file
$servicedesccomponentlist=mysql_real_escape_string($_POST['servicedesccomponentlist']); //This value has to be the same as in the HTML form file
$servicedesccomponentnotlisted=mysql_real_escape_string($_POST['servicedesccomponentnotlisted']); //This value has to be the same as in the HTML form file
$servicedescrevision=mysql_real_escape_string($_POST['servicedescrevision']); //This value has to be the same as in the HTML form file
$anticipatedglobaleffect=mysql_real_escape_string($_POST['anticipatedglobaleffect']); //This value has to be the same as in the HTML form file
$servicedescriptioninformation=mysql_real_escape_string($_POST['servicedescriptioninformation']); //This value has to be the same as in the HTML form file
$serviceressystemlist=mysql_real_escape_string($_POST['serviceressystemlist']); //This value has to be the same as in the HTML form file
$serviceressystemnotlisted=mysql_real_escape_string($_POST['serviceressystemnotlisted']); //This value has to be the same as in the HTML form file
$servicerescomponentlist=mysql_real_escape_string($_POST['servicerescomponentlist']); //This value has to be the same as in the HTML form file
$servicerescomponentnotlisted=mysql_real_escape_string($_POST['servicerescomponentnotlisted']); //This value has to be the same as in the HTML form file
$serviceresrevision=mysql_real_escape_string($_POST['serviceresrevision']); //This value has to be the same as in the HTML form file
$serviceresolutioninformation=mysql_real_escape_string($_POST['serviceresolutioninformation']); //This value has to be the same as in the HTML form file

echo $sql="UPDATE stf SET contactname='$contactname', contactphone1='$contactphone1', contactphone2='$contactphone2', contactfax='$contactfax', contactaffiliation='$contactaffiliation', contactemail='$contactemail', contactmethod='$contactmethod', site='$site', wpn='$wpn', sitestatus='$sitestatus', accountmanagerlist='$accountmanagerlist', accountmanagernotlisted='$accountmanagernotlisted', submitterlist='$submitterlist', submitternotlisted='$submitternotlisted', assignedengineerlist='$assignedengineerlist', assignedengineernotlisted='$assignedengineernotlisted', servicecategorylist='$servicecategorylist', stfno='$stfno', edfno='$edfno', erno='$erno', stfstatus='$stfstatus', edfstatus='$edfstatus', turnoverstatus='$turnoverstatus', datereceived='$datereceived', timereceived='$timereceived', ampmreceived='$ampmreceived', dateresponded='$dateresponded', timeresponded='$timeresponded', ampmresponded='$ampmresponded', dateresolved='$dateresolved', timeresolved='$timeresolved', ampmresolved='$ampmresolved', datescheduled='$datescheduled', timescheduled='$timescheduled', ampmscheduled='$ampmscheduled', servicedescsystemlist='$servicedescsystemlist', servicedescsystemnotlisted='$servicedescsystemnotlisted', servicedesccomponentlist='$servicedesccomponentlist', servicedesccomponentnotlisted='$servicedesccomponentnotlisted', servicedescrevision='$servicedescrevision', anticipatedglobaleffect='$anticipatedglobaleffect', servicedescriptioninformation='$servicedescriptioninformation', serviceressystemlist='$serviceressystemlist', serviceressystemnotlisted='$serviceressystemnotlisted', servicerescomponentlist='$servicerescomponentlist', servicerescomponentnotlisted='$servicerescomponentnotlisted', serviceresrevision='$serviceresrevision', serviceresolutioninformation='$serviceresolutioninformation' WHERE id='$id'"; 

/* 'stf' is the name of the MySQL table where the form data will be saved. The names between the 1st set of ( and ) are the respective table fields. After that, all of the '$xxxx' are the related field names form the list above which are the same names within the HTML form. */

if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error()); 
} 
echo "The STF that you've modified was successfully updated in the database."; 
mysql_close($con);
?>

As I said, the problem is updating one (1) form and not all. I've added the WHERE statement to attempt to select the ID of the form, which right now doesn't work.

Any ideas?

Thank you and God bless,
Johnathan

johnathanamber 0 Newbie Poster · 2008-07-11T20:17:16+00:00

Oh, and sorry, here is the STF table from my DB... you can tell that all of the forms were updated at the same time:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 11, 2008 at 09:13 AM
-- Server version: 5.0.18
-- PHP Version: 5.1.2
-- 
-- Database: `asdtsg`
-- 

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

-- 
-- Table structure for table `stf`
-- 

CREATE TABLE `stf` (
  `id` int(11) NOT NULL auto_increment,
  `contactname` varchar(255) default NULL,
  `contactphone1` varchar(255) default NULL,
  `contactphone2` varchar(255) default NULL,
  `contactfax` varchar(255) default NULL,
  `contactaffiliation` varchar(255) default NULL,
  `contactemail` varchar(255) default NULL,
  `contactmethod` varchar(255) default NULL,
  `site` varchar(255) default NULL,
  `wpn` varchar(255) default NULL,
  `sitestatus` varchar(255) default NULL,
  `accountmanagerlist` varchar(255) default NULL,
  `accountmanagernotlisted` varchar(255) default NULL,
  `submitterlist` varchar(255) default NULL,
  `submitternotlisted` varchar(255) default NULL,
  `assignedengineerlist` varchar(255) default NULL,
  `assignedengineernotlisted` varchar(255) default NULL,
  `servicecategorylist` varchar(255) default NULL,
  `stfno` varchar(255) default NULL,
  `edfno` varchar(255) default NULL,
  `erno` varchar(255) default NULL,
  `stfstatus` varchar(255) default NULL,
  `edfstatus` varchar(255) default NULL,
  `turnoverstatus` varchar(255) default NULL,
  `datereceived` varchar(255) default NULL,
  `timereceived` varchar(255) default NULL,
  `ampmreceived` varchar(255) default NULL,
  `dateresponded` varchar(255) default NULL,
  `timeresponded` varchar(255) default NULL,
  `ampmresponded` varchar(255) default NULL,
  `dateresolved` varchar(255) default NULL,
  `timeresolved` varchar(255) default NULL,
  `ampmresolved` varchar(255) default NULL,
  `datescheduled` varchar(255) default NULL,
  `timescheduled` varchar(255) default NULL,
  `ampmscheduled` varchar(255) default NULL,
  `servicedescsystemlist` varchar(255) default NULL,
  `servicedescsystemnotlisted` varchar(255) default NULL,
  `servicedesccomponentlist` varchar(255) default NULL,
  `servicedesccomponentnotlisted` varchar(255) default NULL,
  `servicedescrevision` varchar(255) default NULL,
  `anticipatedglobaleffect` varchar(255) default NULL,
  `servicedescriptioninformation` longtext,
  `serviceressystemlist` varchar(255) default NULL,
  `serviceressystemnotlisted` varchar(255) default NULL,
  `servicerescomponentlist` varchar(255) default NULL,
  `servicerescomponentnotlisted` varchar(255) default NULL,
  `serviceresrevision` varchar(255) default NULL,
  `serviceresolutioninformation` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

-- 
-- Dumping data for table `stf`
-- 

INSERT INTO `stf` VALUES (1, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (2, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (3, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (4, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (5, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (6, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (7, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (20, 'a', 'a', 'a', 'a', 'ARINC Personnel', 'a', 'ais_support@arinc.com', 'AAA', 'a', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Open', 'Closed', 'No', 'a', 'a', 'AM', 'a', 'a', 'AM', 'a', 'a', 'AM', 'a', 'a', 'AM', 'AODB', '', 'AirDB', '', '', '', 'aaaaa', 'AODB', '', 'AirDB', '', '', 'aaaaa');
INSERT INTO `stf` VALUES (8, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (9, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (10, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (11, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (12, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (13, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (14, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (15, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (16, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (17, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (18, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');
INSERT INTO `stf` VALUES (19, '111', '111', '111', '111', 'ARINC Personnel', '111', 'ais_support@arinc.com', '111', '1', 'All', 'All', '', 'Aaron Downing', '', 'Aaron Downing', '', 'ARINC Software', '11111111', '', '', 'Closed', 'Closed', 'No', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', '1', '1', 'AM', 'AODB', '', 'AirDB', '', '', '', '1', 'AODB', '', 'AirDB', '', '', '1');

Using PHP/HTML to update informationin MySQL

Recommended Answers

All 6 Replies

Using PHP/HTML to update informationin MySQL

Recommended Answers Collapse Answers

All 6 Replies

Recommended Answers