Using PHP/HTML to update informationin MySQL

•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 397,839 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,595 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Thread Tools Display Modes
Views: 348 | Replies: 6
•
Join Date: Jun 2008
Posts: 5
Reputation: johnathanamber is an unknown quantity at this point
Rep Power: 0
Solved Threads: 0
johnathanamber johnathanamber is offline
Offline
Newbie Poster
Using PHP/HTML to update informationin MySQL

Jun 30th, 2008
Morning eveyrone,

Alrightly then, I've already got an HTML form that uses PHP to send information to an MySQL database.

I also already have a search form that allows me to search for current information that is already in the database.

This is what I want to do, but I am not sure how to go about getting this done correctly:

I have an STF (Service Tracking Form) that I use to track issues.

I want to create a search form to gather the correct information from the MySQL database.

Then I want the user to be able to change and update the fields using the same form they used to send the information to the database, obviosuly it doesn't have to be the EXACT same HTML file but I want the form to look the same.

Lastly I want the user to be able to submit the updated form information and replace the old information.

To give an idea as to how involved this is here is a copy of the form and PHP file used to send information to the database: stf.html, sendstfdb.php.

stf.html
 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<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>
Note: Once forms have been submitted, they can not be updated or changed.<br />
Please submit only completed and closed STFs.<br />
</center>
<form name="stf" method="POST" action="http://asdtsg.com/sendstfdb.php" onsubmit="return checkForm();">
<!-- onSubmit="return CheckRequiredFields()" -->
 
<!-- Begin Master Table -->
<table align="left" valign="top" width="650">
<tr>
<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" /><br />
<font face="arial" size="2">Contact Phone Number 1:</font><br />
<input type="text" size="18" name="contactphone1" maxlength="100" /><br />
<font face="arial" size="2">Contact Phone Number 2:</font><br />
<input type="text" size="18" name="contactphone2" maxlength="100" /><br />
<font face="arial" size="2">Contact Fax Number:</font><br />
<input type="text" size="18" name="contactfax" maxlength="100" /><br />
<font face="arial" size="2">Contact Affiliation:</font><br />
<select name="contactaffiliation">
<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" /><br />
<font face="arial" size="2">Contact Method:</font><br />
<select name="contactmethod">
<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="1" name="site" maxlength="3" /><br />
<font face="arial" size="2">WPN:</font><br />
<input type="text" size="18" name="wpn"/><br />
<font face="arial" size="2">Site Status:</font><br />
<select name="sitestatus">
<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 =""></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"/><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 =""></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"/><br />
<font face="arial" size="2">Assigned Engineer:</font><br />
<select name="assignedengineerlist">
<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"/>
</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 =""></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 />
<input type="text" size="10" name="stfno" maxlength="8" /><br />
<font face="arial" size="2">EDF No.:</font><br />
<input type="text" size="10" name="edfno" maxlength="20" /><br />
<font face="arial" size="2">Ext. Ref. No.:</font><br />
<input type="text" size="10" name="erno" maxlength="20" />
</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" /> @ <input name="timereceived" type="text" size="6" maxlength="5" /><select name="ampmreceived"><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" /> @ <input name="timeresponded" type="text" size="6" maxlength="5" /><select name="ampmresponded"><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" /> @ <input name="timeresolved" type="text" size="6" maxlength="5" /><select name="ampmresolved"><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" /> @ <input name="timescheduled" type="text" size="6" maxlength="5" /><select name="ampmscheduled"><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) -->
 
</td>
</tr>
<tr>
<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 =""></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" />
</td>
<td width="32%" style="border: 1px black solid;" valign="top">
<font face="arial" size="2">Component:</font><br />
<select name="servicedesccomponentlist">
<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
DaniWeb Home > Forums > Web Development > PHP

Using PHP/HTML to update informationin MySQL

Using PHP/HTML to update informationin MySQL
