flashbangpro
-
Posts
45 -
Joined
-
Last visited
Never
Posts posted by flashbangpro
-
-
Isn't this a date_reported field?
<tr valign="baseline"> <th nowrap align="right">Date That Maintenace/Repair Issues Reported:</th> <td> <?php echo date_picker("date_reported")?></td> </tr> -
Here is what it gave me -
Notice: Undefined index: date_reported in /data/9/0/28/4/517493/user/528148/htdocs/jednewdb/updated_maint.php on line 11
UPDATE service_info SET `service_date`='', `date_reported`='', `issues_reported`='', `service_performed`='', `rts`='', `odomread`='', `odomdate`='', `status`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id='73'
Line 11 is
$date_reported = mysql_prep($_POST['date_reported']);
-
Do I echo query string by taking out the redirect and adding
<?php echo $_SERVER['QUERY_STRING']; ?>
-
Its not showing any errors and updates all fields I enter data into except the date field I am using the date picker with.
-
I am wanting to have a drop down date picker on my maintenance vehicle update forms.
The date picker shows up and allows you to choose a date, but it does not insert/update any information in the MySQL database table. I'm wanting to do this to all my date fields but as of now I'm just testing on the first date field in the form.
Here is the code I am working with
Functions file -
<?php function date_picker($name, $startyear=NULL, $endyear=NULL) { if($startyear==NULL) $startyear = date("Y")-100; if($endyear==NULL) $endyear=date("Y")+50; $months=array('','January','February','March','April','May', 'June','July','August', 'September','October','November','December'); // Month dropdown $html="<select name=\"".$name."month\">"; for($i=1;$i<=12;$i++) { $html.="<option value='$i'>$months[$i]</option>"; } $html.="</select> "; // Day dropdown $html.="<select name=\"".$name."day\">"; for($i=1;$i<=31;$i++) { $html.="<option $selected value='$i'>$i</option>"; } $html.="</select> "; // Year dropdown $html.="<select name=\"".$name."year\">"; for($i=$startyear;$i<=$endyear;$i++) { $html.="<option value='$i'>$i</option>"; } $html.="</select> "; return $html; } ?>Maintenance Form -
<?php session_start();?> <?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php // get value of id that sent from address bar $id=$_GET['id']; $_SESSION['id'] = $id; // Retrieve data from database $sql="SELECT * FROM service_info WHERE id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); $result1 = mysql_query("SELECT name, number, issue_comments FROM service_info WHERE id='$id'"); echo "<table border='1'> <tr> <th>Vehicle Name</th> <th>Vehicle Number </th> <th>Issue Comments </th> </tr>"; while($row = mysql_fetch_array($result1)) { echo "<tr>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['number'] . "</td>"; echo "<td>" . $row['issue_comments'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> <html> <body> <h1>Maintenace Repair Form </h1> <section> <section> <form method="post" name="form1" action="updated_maint.php"> <table align="center"> <tr valign="baseline"> <th nowrap align="right">Issue Being Reported:</th> <td><select name="issues_reported" > <option value=""></option> <option value="Engine">Engine</option> <option value="Transmission">Transmission</option> <option value="Differential">Differential</option> <option value="Electrical">Electrical</option> <option value="Tires">Tires</option> <option value="Brakes">Brakes</option> <option value="HVAC">HVAC</option> <option value="Lighting">Lighting</option> <option value="Accident">Accident</option></select></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date That Maintenace/Repair Issues Reported:</th> <td> <?php echo date_picker("date_reported")?></td> </tr> <tr valign="baseline"> <th nowrap align="right">Scheduled Service Date:</th> <td> <input type="text" name="service_date" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Maintenace/Repair Service Performed W/Comments:</th> <td> <textarea name="service_performed" rows="3" cols="27"></textarea></td> </tr> <tr valign="baseline"> <th nowrap align="right">Status:</th> <td><select name="status" > <option value=""></option> <option value="In Service">In Service</option> <option value="Out of Service">Out of Service</option> <option value="In Service Repair Pending">In Service Repair Pending</option> </select></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date Maintenace/Repair Service Performed:</th> <td><input type="text" name="date_service_performed" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date OF Follow-up Work / If Needed:</th> <td> <input type="text" name="date_of_followup" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Service In Progress:</th> <td><select name="service_in_progress" > <option value=""></option> <option value="Yes">Yes</option> <option value="No">No</option> </select></td> </tr> <tr valign="baseline"> <th nowrap align="right">Projected Date Return To Use:</th> <td> <input type="text" name="date_return_use" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Projected Time Return Use:</th> <td> <input type="text" name="time_return_use" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Actual RTS:</th> <td> <input type="text" name="rts" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Odometer Reading:</th> <td> <input type="text" name="odomread" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date Of Odometer Reading:</th> <td><input type="text" name="odomdate" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Nonrepairable Issues Found W/Comments:</th> <td> <textarea name="issues_nonrepairable" rows="3" cols="27"></textarea></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date Nonrepairable Issues Found:</th> <td> <input type="text" name="date_nonrepairable_issues" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Repair Made:</th> <td> <textarea name="comments" rows="3" cols="27"></textarea></td> </tr> <input type="hidden" name="id" value = "$id" /> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"> </form> <a href="service_list_update.php">Cancel</a> <p> </p> </section> <!-- end .content --></h2> </section> </body> </html>Update File -
<?php ini_set('display_errors',1); error_reporting(E_ALL); ?> <?php session_start();?> <?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php $id = $_SESSION['id']; $service_date = mysql_prep($_POST['service_date']); $date_reported = mysql_prep($_POST['date_reported']); $issues_reported = mysql_prep($_POST['issues_reported']); $service_performed = mysql_prep($_POST['service_performed']); $status = mysql_prep($_POST['status']); $date_service_performed = mysql_prep($_POST['date_service_performed']); $date_of_followup = mysql_prep($_POST['date_of_followup']); $service_in_progress = mysql_prep($_POST['service_in_progress']); $rts = mysql_prep($_POST['rts']); $odomread = mysql_prep($_POST['odomread']); $odomdate = mysql_prep($_POST['odomdate']); $date_return_use = mysql_prep($_POST['date_return_use']); $time_return_use = mysql_prep($_POST['time_return_use']); $issues_nonrepairable = mysql_prep($_POST['issues_nonrepairable']); $date_nonrepairable_issues = mysql_prep($_POST['date_nonrepairable_issues']); $comments = mysql_prep($_POST['comments']); ?> <?php $query = "UPDATE service_info SET `service_date`='$service_date', `date_reported`='$date_reported', `issues_reported`='$issues_reported', `service_performed`='$service_performed', `rts`='$rts', `odomread`='$odomread', `odomdate`='$odomdate', `status`='$status', `date_service_performed`='$date_service_performed', `date_of_followup`='$date_of_followup',`service_in_progress`='$service_in_progress', `date_return_use`='$date_return_use', `time_return_use`='$time_return_use', `issues_nonrepairable`='$issues_nonrepairable', `date_nonrepairable_issues`='$date_nonrepairable_issues', `comments` ='$comments' WHERE id='$id' "; $result = mysql_query($query, $connection); if ($result) { // Success! redirect_to("service_list_update.php"); } else { // Display error message. echo "<p>Maintenance Info Creation Failed.</p>"; echo "<p>" . mysql_error() . "</p>"; } echo "<p>Error: " . mysql_error() . " SQL: $query</p>"; ?>Thank you, any help or suggestions are appreciated.
-
Forgot ' at end of email address
-
I have searched books, videos, and other forums on how to do this without any luck getting mine to work properly. The form is inserted into database fine, but I don't receive the email notification.
Here is the code
<html> <body> <ul> <li><a href="vehicle_list.php" title="">SEVICE ORDER LIST</a></li> <li><a href="index.php">LOG OUT</a></li> </ul> </div> <h1>Vehicle Repair Form</h1> <section> <section> <form method="post" name="form1" action="vehicle_info.php"> <table align="center"> <tr valign="baseline"> <th nowrap align="right">Vehicle Name:</th> <td> <input type="text" name="name" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Vehicle Number:</th> <td> <input type="text" name="number" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Vehicle Vin Number:</th> <td> <input type="text" name="vin_number" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Location:</th> <td> <input type="text" name="location" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Status:</th> <td> <input type="text" name="status" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">RTS:</th> <td> <input type="text" name="rts" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Odometer Reading:</th> <td> <input type="text" name="odomread" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Date Of Odometer Reading:</th> <td><input type="text" name="odomdate" value="" size="32"></td> </tr> </tr> <tr valign="baseline"> <th nowrap align="right">Issue Being Reported:</th> <td><select name="issues_reported" > <option value="Engine">Engine</option> <option value="Transmission">Transmission</option> <option value="Differential">Differential</option> <option value="Electrical">Electrical</option> <option value="Tires">Tires</option> <option value="Brakes">Brakes</option> <option value="HVAC">HVAC</option> <option value="Lighting">Lighting</option> <option value="Accident">Accident</option></select></td> </tr> <tr valign="baseline"> <th nowrap align="right">Issue Comments:</th> <td> <textarea name="issue_comments" rows="3" cols="27"></textarea> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"> </form> <a href="vehicle_list.php">Cancel</a> <p> </p> </section> <!-- end .content --></h2> </section> <?php // The message $message = "Vehicle Was Added To Database"; // In case any of our lines are larger than 70 characters, we should use wordwrap() $message = wordwrap($message, 70); // Send mail('xxxxxxxxxx@gmail.com, 'Vehicle update', $message); ?> </body> </html>I got the mail code from http://php.net/manual/en/function.mail.php
Greatly appreciate all advice.
-
Thank you, that is what I was missing, Is there a way to mark this as resolved?
-
Ok I will move them above session start and added print $query and this is what I got....
Notice: Undefined index: id in /data/9/0/28/4/517493/user/528148/htdocs/jednewdb/updated_maint.php on line 9
Notice: Undefined index: service_in_progress in /data/9/0/28/4/517493/user/528148/htdocs/jednewdb/updated_maint.php on line 16
UPDATE service_info SET `date_next_maint`='8/23/12', `date_reported`='8/20/12', `scheduled_service_date`='8/20/12', `service_performed`='', `date_service_performed`='8/20/12', `date_of_followup`='',`service_in_progress`='', `date_return_use`='8/24/12', `time_return_use`='23:00', `issues_nonrepairable`='', `date_nonrepairable_issues`='testing', `comments` ='' WHERE id=''
I don't understand how it isn't defined when it is the correct id on the maint_update page
-
The maint_update page url shows that it is pulling the correct id from the service_list_update page. I don't understand how there is no $id
-
Ok I had forgot my single quotes on WHERE id='$id' ";
So now I have no errors, but the data hasn't been updated either.
-
I have just realized that the INSERT clause apparently doesn't take a WHERE so I have switched back to UPDATE and this is the error I recieved
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 SQL: UPDATE service_info SET `date_next_maint`='testing', `date_reported`='testing', `scheduled_service_date`='testing', `service_performed`='', `date_service_performed`='testing', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=
-
Seriously at this point I'm starting to think you're trolling.
You set the fields to blank values. Of course they are blank. What did you expect?
I realize you may not want to help me anymore and I understand I can be frustrating not knowing all that you know, Thank you for the help you have given.
-
Why would I be trolling? If I didn't seriously need help with this I wouldn't take my time to make suggested adjustments and keep reposting.
-
When I used update and was only updating one field it blanked out all the others so I thought using insert would just change the field I needed.
-
Ok I had everything working yesterday, but when I updated a few fields and then when back to update a few others, it deleted the previous updated fields and set them to blank, so not I am trying INSERT INTO service_info WHERE id=$id and this is the error I get and these are the updated pages involved.
Maintenance Info Creation Failed.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`date_next_maint`='testing', `date_reported`='testing', `scheduled_service_d' at line 1
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`date_next_maint`='testing', `date_reported`='testing', `scheduled_service_d' at line 1 SQL: INSERT INTO service_info `date_next_maint`='testing', `date_reported`='testing', `scheduled_service_date`='testing', `service_performed`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='1', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=
When I go to maint_update page, the url shows id='whatever record clicked' so it is getting the id from the records page.
Here is records page service_list_update
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Service Order Database</title> <link href="nav.css" rel="stylesheet" type="text/css"><!--[if lt IE 9]> <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> <![endif]--> </head> <body> <?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php $query="SELECT * FROM service_info ORDER BY id"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<b><center>Database Output</center></b><br><br>"; // process form when posted if(isset($_POST['value'])) { if($_POST['value'] == 'Engine') { // query to get all Engine records $query = "SELECT * FROM servifce_info WHERE issues_reported='Engine'"; }elseif($_POST['value'] == 'Transmission') { // query to get all Transmission records $query = "SELECT * FROM servifce_info WHERE issues_reported='Transmission'"; }elseif($_POST['value'] == 'Differential') { // query to get all Differential records $query = "SELECT * FROM servifce_info WHERE issues_reported='Differential'"; }elseif($_POST['value'] == 'Electrical') { // query to get all Electrical records $query = "SELECT * FROM servifce_info WHERE issues_reported='Electrical'"; }elseif($_POST['value'] == 'Tires') { // query to get all Tires records $query = "SELECT * FROM servifce_info WHERE issues_reported='Tires'"; }elseif($_POST['value'] == 'Brakes') { // query to get all Brakes records $query = "SELECT * FROM servifce_info WHERE issues_reported='Brakes'"; }elseif($_POST['value'] == 'HVAC') { // query to get all HVAC records $query = "SELECT * FROM servifce_info WHERE issues_reported='HVAC'"; }elseif($_POST['value'] == 'Lighting') { // query to get all Lighting records $query = "SELECT * FROM servifce_info WHERE issues_reported='Lighting'"; }elseif($_POST['value'] == 'Accident Damage') { // query to get all Accident Damage records $query = "SELECT * FROM servifce_info WHERE issues_reported='Accident Damage'"; } else { // query to get all records $query = "SELECT * FROM servifce_info "; } mysql_close(); } ?> <html> <head></head> <body> <form action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post' name='form_filter' > <select name="value"> <option value="all">All</option> <option value="Engine">Engine</option> <option value="Transmission">Transmission</option> <option value="Differential">Differential</option> <option value="Electrical">Electrical</option> <option value="Tires">Tires</option> <option value="Brakes">Brakes</option> <option value="HVAC">HVAC</option> <option value="Lighting">Lighting</option> <option value="Accident">Accident</option> </select> <br /> <input type='submit' value = 'Filter'> </form> <div id="nav"> <ul> <li><a href="order_vehicle_name.php" title=""> ORDER BY VEHICLE NAME</a></li> <li><a href="order_vehicle_number.php" title=""> ORDER BY VEHICLE NUMBER</a></li> <li><a href="order_location.php" title=""> ORDER BY LOCATION</a></li> <li><a href="order_status.php" title=""> ORDER BY STATUS</a></li> <li><a href="order_issues_reported.php" title=""> ORDER REPORTED ISSUES</a></li> <li><a href="order_id.php" title=""> ORDER BY ID</a></li> <li><a href="index.php">LOG OUT</a></li> </ul> </div> <table border="1" cellspacing="5" cellpadding="5"> <tr> <th><font face="Arial, Helvetica, sans-serif">ID</font></th> <th><font face="Arial, Helvetica, sans-serif">Vehicle Name</font></th> <th><font face="Arial, Helvetica, sans-serif">Vehicle Number</font></th> <th><font face="Arial, Helvetica, sans-serif">Location</font></th> <th><font face="Arial, Helvetica, sans-serif">Status</font></th> <th><font face="Arial, Helvetica, sans-serif">RTS</font></th> <th><font face="Arial, Helvetica, sans-serif">Odometer Date</font></th> <th><font face="Arial, Helvetica, sans-serif">Odometer Reading Date</font></th> <th><font face="Arial, Helvetica, sans-serif">Date of next scheduled maintenance</font></th> <th><font face="Arial, Helvetica, sans-serif">Maintenance/Repair Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Scheduled Service Date Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Repair Service Performed W/Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Service Performed</font></th> <th><font face="Arial, Helvetica, sans-serif">Date OF Follow-up</font></th> <th><font face="Arial, Helvetica, sans-serif">Service In Progress 0=NO 1=YES</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Return To Use</font></th> <th><font face="Arial, Helvetica, sans-serif">Time Return Use</font></th> <th><font face="Arial, Helvetica, sans-serif">Nonrepaiable Issues Found W/Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Issues Found</font></th> <th><font face="Arial, Helvetica, sans-serif">Parts Cost</font></th> <th><font face="Arial, Helvetica, sans-serif">Hours Worked</font></th> <th><font face="Arial, Helvetica, sans-serif">Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Update</font></th> </tr> <?php while($row = mysql_fetch_array($result)) { ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['id']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['name']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['number']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['location']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['status']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['rts']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['odomread']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['odomdate']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_next_maint']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['issues_reported']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_reported']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['scheduled_service_date']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['service_performed']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_service_performed']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_of_followup']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['service_in_progress']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_return_use']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['time_return_use']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['issues_nonrepairable']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_nonrepairable_issues']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['parts_cost']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['hours']; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['comments']; ?></font></td> <td><a href="maint_update.php?id=<?php echo $row['id']; ?>">update</a></td> </tr> <?php } ?> <?php error_reporting(E_ALL); ?> </body> </html>Here is update page maint_update
<?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php // get value of id that sent from address bar $id=$_GET['id']; $_SESSION['id'] = $id; // Retrieve data from database $sql="SELECT * FROM service_info WHERE id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); ?> <html> <body> <h1>Maintenace Report </h1> <section> <section> <form method="post" name="form1" action="updated_maint.php"> <table align="center"> <tr valign="baseline"> <th nowrap align="right">Date of next scheduled maintenance:</th> <td> <input type="text" name="date_next_maint" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Date That Maintenace/Repair Issues Reported:</th> <td> <input type="text" name="date_reported" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Scheduled Service Date That Maintenace/Repair Issues Reported:</th> <td> <input type="text" name="scheduled_service_date" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Maintenace/Repair Service Performed W/Comments:</th> <td> <textarea name="service_performed" rows="3" cols="27"></textarea> </tr> <tr valign="baseline"> <th nowrap align="right">Date Maintenace/Repair Service Performed:</th> <td><input type="text" name="date_service_performed" value="" size="32"></td> </tr> <tr valign="baseline"> <th nowrap align="right">Date OF Follow-up Work / If Needed:</th> <td> <input type="text" name="date_of_followup" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Service In Progress:</th> <td> <input type="radio" name="service_in_progress" value="0" /> No <input type="radio" name="service_in_progress" value="1" /> Yes </tr> <tr valign="baseline"> <th nowrap align="right">Date Return To Use:</th> <td> <input type="text" name="date_return_use" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Time Return Use:</th> <td> <input type="text" name="time_return_use" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Nonrepaiable Issues Found W/Comments:</th> <td> <textarea name="issues_nonrepairable" rows="3" cols="27"></textarea> </tr> <tr valign="baseline"> <th nowrap align="right">Date Nonrepaiable Issues Found:</th> <td> <input type="text" name="date_nonrepairable_issues" value="" size="32"> </tr> <tr valign="baseline"> <th nowrap align="right">Comments:</th> <td> <textarea name="comments" rows="3" cols="27"></textarea> </tr> <input type="hidden" name="id" value = "$id" /> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert record"></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"> </form> <a href="service_list_update.php">Cancel</a> <p> </p> </section> <!-- end .content --></h2> </section> </body> </html>Here is update file updated_maint
<?php session_start();?> <?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php $id = $_SESSION['id']; $date_next_maint = mysql_prep($_POST['date_next_maint']); $date_reported = mysql_prep($_POST['date_reported']); $scheduled_service_date = mysql_prep($_POST['scheduled_service_date']); $service_performed = mysql_prep($_POST['service_performed']); $date_service_performed = mysql_prep($_POST['date_service_performed']); $date_of_followup = mysql_prep($_POST['date_of_followup']); $service_in_progress = mysql_prep($_POST['service_in_progress']); $date_return_use = mysql_prep($_POST['date_return_use']); $time_return_use = mysql_prep($_POST['time_return_use']); $issues_nonrepairable = mysql_prep($_POST['issues_nonrepairable']); $date_nonrepairable_issues = mysql_prep($_POST['date_nonrepairable_issues']); $comments = mysql_prep($_POST['comments']); ?> <?php $query = "INSERT INTO service_info `date_next_maint`='$date_next_maint', `date_reported`='$date_reported', `scheduled_service_date`='$scheduled_service_date', `service_performed`='$service_performed', `date_service_performed`='$date_service_performed', `date_of_followup`='$date_of_followup',`service_in_progress`='$service_in_progress', `date_return_use`='$date_return_use', `time_return_use`='$time_return_use', `issues_nonrepairable`='$issues_nonrepairable', `date_nonrepairable_issues`='$date_nonrepairable_issues', `comments` ='$comments' WHERE id=$id"; $result = mysql_query($query, $connection); if ($result) { // Success! redirect_to("service_list_update.php"); } else { // Display error message. echo "<p>Maintenance Info Creation Failed.</p>"; echo "<p>" . mysql_error() . "</p>"; } echo "<p>Error: " . mysql_error() . " SQL: $query</p>"; ?> <?php ini_set('display_errors',1); error_reporting(E_ALL); ?> -
Thank you, I will add this to my coding arsenal.
-
That was the problem yes, Thank you all very much for the help. It is greatly appreciated and I learned a lot on where I made mistakes.
-
Its a typing error I made I just have to find it.
-
Thank you that did help, I am now getting the correct ID, I am looking further into the new error I am getting now.
Error -
Maintenance Info Creation Failed.
Unknown column 'comments' in 'field list'
Error: Unknown column 'comments' in 'field list' SQL: UPDATE service_info SET `date_next_maint`='testing', `issues_reported`='', `date_reported`='', `scheduled_service_date`='', `service_performed`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=15
-
I have added this
error_reporting(E_ALL);
to show errors. Is that the wrong code to add? It's not showing anything.
I expected the first line
<td><font face="Arial, Helvetica, sans-serif"><?php echo $field1; ?></font></td>
to display the ID in the display table (which is what it is doing)
I expected the second line
<td><a href="maint_update.php?id=<?php echo $field1['id']; ?>">update</a></td>
to tell the maint_update page which record to update. I thought they would have to be the same in order to do that.
-
Yes that outputs the IDs as they are in the database like I expect it should.
-
URL is now showing maint_update.php?id=1 regardless of what record I click to update. Did I do this right, replacing $row with $field1?
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Service Order Database</title> <link href="nav.css" rel="stylesheet" type="text/css"><!--[if lt IE 9]> <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> <![endif]--> </head> <body> <?php require_once("dbcon.php"); ?> <?php require_once("functions.php"); ?> <?php $query="SELECT * FROM service_info ORDER BY id"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<b><center>Database Output</center></b><br><br>"; // process form when posted if(isset($_POST['value'])) { if($_POST['value'] == 'Engine') { // query to get all Engine records $query = "SELECT * FROM servifce_info WHERE issues_reported='Engine'"; }elseif($_POST['value'] == 'Transmission') { // query to get all Transmission records $query = "SELECT * FROM servifce_info WHERE issues_reported='Transmission'"; }elseif($_POST['value'] == 'Differential') { // query to get all Differential records $query = "SELECT * FROM servifce_info WHERE issues_reported='Differential'"; }elseif($_POST['value'] == 'Electrical') { // query to get all Electrical records $query = "SELECT * FROM servifce_info WHERE issues_reported='Electrical'"; }elseif($_POST['value'] == 'Tires') { // query to get all Tires records $query = "SELECT * FROM servifce_info WHERE issues_reported='Tires'"; }elseif($_POST['value'] == 'Brakes') { // query to get all Brakes records $query = "SELECT * FROM servifce_info WHERE issues_reported='Brakes'"; }elseif($_POST['value'] == 'HVAC') { // query to get all HVAC records $query = "SELECT * FROM servifce_info WHERE issues_reported='HVAC'"; }elseif($_POST['value'] == 'Lighting') { // query to get all Lighting records $query = "SELECT * FROM servifce_info WHERE issues_reported='Lighting'"; }elseif($_POST['value'] == 'Accident Damage') { // query to get all Accident Damage records $query = "SELECT * FROM servifce_info WHERE issues_reported='Accident Damage'"; } else { // query to get all records $query = "SELECT * FROM servifce_info "; } mysql_close(); } ?> <html> <head></head> <body> <form action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post' name='form_filter' > <select name="value"> <option value="all">All</option> <option value="Engine">Engine</option> <option value="Transmission">Transmission</option> <option value="Differential">Differential</option> <option value="Electrical">Electrical</option> <option value="Tires">Tires</option> <option value="Brakes">Brakes</option> <option value="HVAC">HVAC</option> <option value="Lighting">Lighting</option> <option value="Accident">Accident</option> </select> <br /> <input type='submit' value = 'Filter'> </form> <div id="nav"> <ul> <li><a href="order_vehicle_name.php" title=""> ORDER BY VEHICLE NAME</a></li> <li><a href="order_vehicle_number.php" title=""> ORDER BY VEHICLE NUMBER</a></li> <li><a href="order_location.php" title=""> ORDER BY LOCATION</a></li> <li><a href="order_status.php" title=""> ORDER BY STATUS</a></li> <li><a href="order_issues_reported.php" title=""> ORDER REPORTED ISSUES</a></li> <li><a href="order_id.php" title=""> ORDER BY ID</a></li> <li><a href="index.php">LOG OUT</a></li> </ul> </div> <table border="1" cellspacing="5" cellpadding="5"> <tr> <th><font face="Arial, Helvetica, sans-serif">ID</font></th> <th><font face="Arial, Helvetica, sans-serif">Vehicle Name</font></th> <th><font face="Arial, Helvetica, sans-serif">Vehicle Number</font></th> <th><font face="Arial, Helvetica, sans-serif">Location</font></th> <th><font face="Arial, Helvetica, sans-serif">Status</font></th> <th><font face="Arial, Helvetica, sans-serif">RTS</font></th> <th><font face="Arial, Helvetica, sans-serif">Odometer Date</font></th> <th><font face="Arial, Helvetica, sans-serif">Odometer Reading Date</font></th> <th><font face="Arial, Helvetica, sans-serif">Date of next scheduled maintenance</font></th> <th><font face="Arial, Helvetica, sans-serif">Maintenace/Repair Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Scheduled Service Date Issues Reported</font></th> <th><font face="Arial, Helvetica, sans-serif">Repair Service Performed W/Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Service Performed</font></th> <th><font face="Arial, Helvetica, sans-serif">Date OF Follow-up</font></th> <th><font face="Arial, Helvetica, sans-serif">Service In Progress 0=NO 1=YES</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Return To Use</font></th> <th><font face="Arial, Helvetica, sans-serif">Time Return Use</font></th> <th><font face="Arial, Helvetica, sans-serif">Nonrepaiable Issues Found W/Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Date Issues Found</font></th> <th><font face="Arial, Helvetica, sans-serif">Parts Cost</font></th> <th><font face="Arial, Helvetica, sans-serif">Hours Worked</font></th> <th><font face="Arial, Helvetica, sans-serif">Comments</font></th> <th><font face="Arial, Helvetica, sans-serif">Update</font></th> </tr> <?php $i=0; while ($i < $num) { $field1=mysql_result($result,$i,"id"); $field2=mysql_result($result,$i,"name"); $field3=mysql_result($result,$i,"number"); $field4=mysql_result($result,$i,"location"); $field5=mysql_result($result,$i,"status"); $field6=mysql_result($result,$i,"rts"); $field7=mysql_result($result,$i,"odomread"); $field8=mysql_result($result,$i,"odomdate"); $field9=mysql_result($result,$i,"date_next_maint"); $field10=mysql_result($result,$i,"issues_reported"); $field11=mysql_result($result,$i,"date_reported"); $field12=mysql_result($result,$i,"scheduled_service_date"); $field13=mysql_result($result,$i,"service_performed"); $field14=mysql_result($result,$i,"date_service_performed"); $field15=mysql_result($result,$i,"date_of_followup"); $field16=mysql_result($result,$i,"service_in_progress"); $field17=mysql_result($result,$i,"date_return_use"); $field18=mysql_result($result,$i,"time_return_use"); $field19=mysql_result($result,$i,"issues_nonrepairable"); $field20=mysql_result($result,$i,"date_nonrepairable_issues"); $field21=mysql_result($result,$i,"parts_cost"); $field22=mysql_result($result,$i,"hours"); $field23=mysql_result($result,$i,"comments"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field1; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field2; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field3; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field4; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field5; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field6; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field7; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field8; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field9; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field10; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field11; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field12; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field13; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field14; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field15; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field16; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field17; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field18; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field19; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field20; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field21; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field22; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $field23; ?></font></td> <td><a href="maint_update.php?id=<?php echo $field1['id']; ?>">update</a></td> </tr> <?php $i++; } ?> </body> </html> -
Thank you I will work on it more and post and updates!!
SQL Server statement to MySQL statement
in MySQL Help
Posted
I am needing to translate a SQL Server statement to MySQL and I was hoping to find an easy opensource translator that I can paste in the SQL Server statement and it translate it to what the MySQL statement should be or something of that effect.
Thank you all in advance.