<?php
error_reporting(E_ALL);
ini_set('display_errors', true);
?>
<?php
$connection = mysql_connect("","","");
if (!$connection) {
die('PHP Mysql database connection could not connect : ' . mysql_error());
}
else{
$db_name = "";
mysql_select_db($db_name, $connection);
if(isset($_POST['submit'])){
if($_POST['ref']!="" && $_POST['role']!="" && $_POST['contract']!="" && $_POST['location']!=""
&& $_POST['salary']!="" && $_POST['description']!="" && $_POST['addedby']!=""
&& $_POST['status']!=""){
$update_sql = "UPDATE sgrjobs SET ref='".$_POST['ref']."',
role='".$_POST['role']."',
contract='".$_POST['contract']."',
location='".$_POST['location']."',
salary='".$_POST['salary']."',
description'".$_POST['description']."',
addedby'".$_POST['addedby']."',
status'".$_POST['status']."' WHERE id = '" . $_GET['id'] . "'";
}
}
}
?>
<?php
$title = "Admin Edit Page";
include ( 'includes/header.php' );
$q= mysql_query("SELECT ref, role FROM sgrjobs WHERE id='" . $_GET['id'] . "'") or die(mysql_error());
$r = mysql_fetch_array($q);
?>
</head>
<body>
<div id="container">
<a href="index.php">Back to Jobs</a>
<br><br>
<form action="<?php echo $_SERVER['PHP_SELF'] . '?id=' . $_GET['id']; ?>" method="post">
<table>
<tr>
<td>Job Ref : </td>
<td><input type="text" name="ref" value="<?php echo $r['ref']; ?>" /></td>
<td></td>
</tr>
<tr>
<td>Job Role : </td>
<td><input type="text" name="role" value="<?php echo $r['role']; ?>" /></td>
<td></td>
</tr>
<tr>
<td>Contract : </td>
<td><select name="contract" />
<option value="Temporary">Temporary</option>
<option value="Permenant">Permenant</option>
</select>
</td>
<td></td>
</tr>
<tr>
<td>Location : </td>
<td><input type="text" name="location" /></td>
<td></td>
</tr>
<tr>
<td>Salary : </td>
<td><input type="text" name="salary" /></td>
<td></td>
</tr>
<tr>
<td>Description : </td>
<td><textarea name="description" cols="30" rows="6" /></textarea></td>
<td></td>
</tr>
<tr>
<td>Added By : </td>
<td><input type="text" name="addedby" /></td>
<td></td>
</tr>
<tr>
<td>Status : </td>
<td>Active<input type="radio" name="status" value="active" />
Inactive<input type="radio" name="status" value="inactive" /></td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name='submit' value="Submit"/></td>
<td></td>
</tr>
</table>
</form>
</div>
</body>
</html>