Hi, I’ve made a website where you can enter data into a database using a form. I’ve also made a page where you can view the data called listEmployees.php
I’ve echoed “update” buttons next to each entry in listEmployees where a page called editEmployees.php is supposed to change them but it’s not working.
When I press “update” it just comes up with “Error”
Any ideas what I’m doing wrong? Here is my code for editEmployees
[php]<?php
function valid($employeeID, $monthsWorked, $paidHoliday, $reasons)
{
?>
|
// Connect to server and select database.
mysql_connect("$host", “$username”, “$password”)or die(“cannot connect”);
mysql_select_db(“pay”)or die(“cannot select DB”);
if (isset($_POST[‘submit’]))
{
if (is_numeric($_POST[‘id’]))
{
$id = $_POST[‘id’];
$employeeID = mysql_real_escape_string(htmlspecialchars($_POST[‘employeeID’]));
$monthsWorked = mysql_real_escape_string(htmlspecialchars($_POST[‘monthsWorked’]));
$paidHoliday = mysql_real_escape_string(htmlspecialchars($_POST[‘paidHoliday’]));
$reasons = mysql_real_escape_string(htmlspecialchars($_POST[‘reasons’]));
if ($employeeID == ‘’ || $monthsWorked == ‘’ || $paidHoliday == ‘’)
{
$error = ‘You havent filled out the required fields!’;
valid($employeeID, $monthsWorked, $paidHoliday, $reasons)
}
else
{
mysql_query(“UPDATE sickdays SET employeeID=’$employeeID’, monthsWorked=’$monthsWorked’, paidHoliday=’$paidHoliday’, reasons=’$reasons’ WHERE id=’$id’”)
or die(mysql_error());
header(“Location: listEmployees.php”);
}
}
else
{
echo ‘Error1!’;
}
}
else
{
if (isset($_GET[‘id’]) && is_numeric($_GET[‘id’]) && $_GET[‘id’] > 0)
{
$id = $_GET[‘id’];
$result = mysql_query(“SELECT * FROM sickdays WHERE id=$id”)
or die(mysql_error());
$row = mysql_fetch_array($result);
if($row)
{
$employeeID = $row[‘employeeID’];
$monthsWorked = $row[‘monthsWorked’];
$paidHoliday = $row[‘paidHoliday’];
$reasons = $row[‘reasons’];
valid($employeeID, $monthsWorked, $paidHoliday, $reasons);
}
else
{
echo “No results!”;
}
}
else
{
echo ‘Error’;
}
}
?>[/php]