Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement