<?php 
 // if there are any errors, display them
 if ($error != '')
 {
 echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
 }
 ?> 
 
 <form action="" method="post">
 <input type="hidden" name="id" value="<?php echo $employee no; ?>"/>
 <div>
 <p><strong>ID:</strong> <?php echo $employee no; ?></p>
 <strong>Month: *</strong> <input type="text" name="firstname" value="<?php echo $month; ?>"/><br/>
 
 <strong>Employee Name: *</strong> <input type="text" name="firstname" value="<?php echo $employee name; ?>"/><br/>
 
 <strong>Salary: *</strong> <input type="text" name="firstname" value="<?php echo $salary; ?>"/><br/>
 
 <strong>Allottee Name: *</strong> <input type="text" name="firstname" value="<?php echo $allottee name; ?>"/><br/>
 
 <strong>Relation: *</strong> <input type="text" name="firstname" value="<?php echo $relation; ?>"/><br/> <br>
 
  <strong>Deduction of Employee</strong> <br> <br>
 
 <strong>SSS: *</strong> <input type="text" name="firstname" value="<?php echo $sss; ?>"/><br/>
 
 <strong>Philhealth: *</strong> <input type="text" name="firstname" value="<?php echo $philhealth; ?>"/><br/>
 
 <strong>Pagibig: *</strong> <input type="text" name="firstname" value="<?php echo $pagibig; ?>"/><br/>
 
 <strong>Tax: *</strong> <input type="text" name="firstname" value="<?php echo $tax; ?>"/><br/> <br>
 
 <strong>Deduction of Allottee</strong> <br> <br>
 
 <strong>SSS2: *</strong> <input type="text" name="firstname" value="<?php echo $sss2; ?>"/><br/>
 
 <strong>Philhealth2: *</strong> <input type="text" name="firstname" value="<?php echo $philhealth2; ?>"/><br/>
 
 <strong>Pagibig2: *</strong> <input type="text" name="firstname" value="<?php echo $pagibig2; ?>"/><br/>
 
 <strong>Tax2: *</strong> <input type="text" name="firstname" value="<?php echo $tax2; ?>"/><br/> <br>
 
 <strong>Total Deduction: *</strong> <input type="text" name="firstname" value="<?php echo $totaldeduction; ?>"/><br/>

 <strong>Total Salary: *</strong> <input type="text" name="firstname" value="<?php echo $totalsalry; ?>"/><br/>
  
 <strong>Allotment: *</strong> <input type="text" name="firstname" value="<?php echo $allotment; ?>"/><br/>

 <p>* Required</p>
 <input type="submit" name="submit" value="Submit">
 </div>
 </form> 
 </body>
 </html> 
 
 
 <?php
/* 
 EDIT.PHP
 Allows user to edit specific entry in database
*/

 // creates the edit record form
 // since this form is used multiple times in this file, I have made it a function that is easily reusable
 function renderForm($id, $firstname, $lastname, $error)
 {
 ?>
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
 <html>
 <head>
 <title>Edit Record</title>
 </head>
 <body>
 <?php 
 // if there are any errors, display them
 if ($error != '')
 {
 echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
 }
 ?> 
 
 <form action="" method="post">
 <input type="hidden" name="id" value="<?php echo $id; ?>"/>
 <div>
 <p><strong>ID:</strong> <?php echo $id; ?></p>
 <strong>First Name: *</strong> <input type="text" name="firstname" value="<?php echo $firstname; ?>"/><br/>
 <strong>Last Name: *</strong> <input type="text" name="lastname" value="<?php echo $lastname; ?>"/><br/>
 <p>* Required</p>
 <input type="submit" name="submit" value="Submit">
 </div>
 </form> 
 </body>
 </html> 
 <?php
 }



 // connect to the database
 include('connect-db.php');
 
 // check if the form has been submitted. If it has, process the form and save it to the database
 if (isset($_POST['submit']))
 { 
 // confirm that the 'id' value is a valid integer before getting the form data
 if (is_numeric($_POST['id']))
 {
 // get form data, making sure it is valid
 $id = $_POST['id'];
 $firstname = mysql_real_escape_string(htmlspecialchars($_POST['firstname']));
 $lastname = mysql_real_escape_string(htmlspecialchars($_POST['lastname']));
 
 // check that firstname/lastname fields are both filled in
 if ($firstname == '' || $lastname == '')
 {
 // generate error message
 $error = 'ERROR: Please fill in all required fields!';
 
 //error, display form
 renderForm($id, $firstname, $lastname, $error);
 }
 else
 {
 // save the data to the database
 mysql_query("UPDATE players SET firstname='$firstname', lastname='$lastname' WHERE id='$id'")
 or die(mysql_error()); 
 
 // once saved, redirect back to the view page
 header("Location: view.php"); 
 }
 }
 else
 {
 // if the 'id' isn't valid, display an error
 echo 'Error!';
 }
 }
 else
 // if the form hasn't been submitted, get the data from the db and display the form
 {
 
 // get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)
 if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
 {
 // query db
 $id = $_GET['id'];
 $result = mysql_query("SELECT * FROM players WHERE id=$id")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
 
 // check that the 'id' matches up with a row in the databse
 if($row)
 {
 
 // get data from db
 $firstname = $row['firstname'];
 $lastname = $row['lastname'];
 
 // show form
 renderForm($id, $firstname, $lastname, '');
 }
 else
 // if no match, display result
 {
 echo "No results!";
 }
 }
 else
 // if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
 {
 echo 'Error!';
 }
 }
?>

Im having an error in this

<form action="" method="post">
 <input type="hidden" name="id" value="<?php echo $employee no; ?>"/>

"Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' "
This is the Message error, thanks

Recommended Answers

All 2 Replies

Member Avatar for diafol
<input type="hidden" name="id" value="<?php echo $employee_no; ?>"/>

??

variable names can't have spaces.

<input type="hidden" name="id" value="<?php echo $employee_no; ?>"/>

??

variable names can't have spaces.

thanks ardav. it's working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.