because I have this query
Code: Select all
$query = mysql_query("UPDATE `$Table1` SET `textTotalDays`='$textTotalDays' -$Days FROM $Table2 WHERE `employeeID`='$employeeID'"); but its not working.
thank you.
Moderator: General Moderators
Code: Select all
$query = mysql_query("UPDATE `$Table1` SET `textTotalDays`='$textTotalDays' -$Days FROM $Table2 WHERE `employeeID`='$employeeID'"); but its not working.
Code: Select all
<?php
mysql_connect("", "", "") or die(mysql_error());
//Now connected to DB Server.
mysql_select_db("db_name") or die(mysql_error());
//Now connected to Database.
$query=mysql_real_escape_string('SELECT ID, fname, sname FROM employees');
$result = mysql_query($query);
//We now have an array of all employees in the $result variable.
?>
<form action="/selectEmployee.php" method="POST">
<select name="employeeID">
<?php
foreach ($result as $option) {
echo "<option value='".$option['ID']."'>".$option['fname']." ".$option['sname'];
}
?>
</select>
<input type="submit" value="View Employee">
</form>Code: Select all
<?php
if (isset($_POST['employeeID'])) {
$ID=$_POST['employeeID'];
mysql_connect("", "", "") or die(mysql_error());
//Now connected to DB Server.
mysql_select_db("db_name") or die(mysql_error());
//Now connected to Database.
$query=mysql_real_escape_string("SELECT fname, sname, holsAllowance FROM employees WHERE ID = '$ID'");
$queryAvail=mysql_real_escape_string("SELECT daysHoliday FROM approvedHolidays WHERE employeeID = '$ID'")
$result = mysql_query($query);
//We now have our employees details in the result array.
$resultAvail = mysql_query($queryAvail);
//This variable holds all taken holidays for the selected employee.
$totalHols;
foreach ($resultAvail as $hols) {
$totalHols = $totalHols + $hols;
}
//Adds all the holidays already taken together and stores it as $totalHols.
$holsAvailable=$result['holsAllowance']-$totalHols;
echo "Employee ".$result['fname']." ".$result['sname']." has ".$holsAvailable."holidays that they can still take.<br><br>";
//Prints the number of holidays the employee has available.
echo " <form action='/addHoliday.php' method='POST'>
<input type='text' name='daysHoliday'><br>
<input type='submit' value='Add Holiday'>
<input type='hidden' name='employeeID' value='".$ID."'>
</form>
";
else {
echo "An error occured. Please try again.";
}
}
?> Code: Select all
<?php
if (isset($_POST['daysHoliday'])) {
$daysHoliday=$_POST['daysHoliday'];
$employeeID=$_POST['employeeID'];
mysql_connect("", "", "") or die(mysql_error());
//Now connected to DB Server.
mysql_select_db("db_name") or die(mysql_error());
//Now connected to Database.
$query=mysql_real_escape_string("INSERT INTO approvedHolidays (employeeID, daysHoliday) VALUES ('$employeeID','$daysHoliday')");
mysql_query($query);
//Execute the Query.
echo "Holiday added sucessfully.";
else {
echo "Adding holiday failed. Please try again.";
}
}
?>Code: Select all
-- ---
-- Globals
-- ---
-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;
-- ---
-- Table 'employees'
--
-- ---
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
`ID` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
`fname` VARCHAR(40) NOT NULL,
`sname` VARCHAR(40) NOT NULL,
`holsAllowance` DECIMAL NOT NULL,
PRIMARY KEY (`ID`)
);
-- ---
-- Table 'approvedHolidays'
--
-- ---
DROP TABLE IF EXISTS `approvedHolidays`;
CREATE TABLE `approvedHolidays` (
`ID` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
`employeeID` INTEGER NOT NULL,
`daysHoliday` DECIMAL NOT NULL,
PRIMARY KEY (`ID`)
);
-- ---
-- Foreign Keys
-- ---
ALTER TABLE `approvedHolidays` ADD FOREIGN KEY (employeeID) REFERENCES `employees` (`ID`);
-- ---
-- Table Properties
-- ---
-- ALTER TABLE `employees` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `approvedHolidays` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;