Hey all, I'm currently working on a website/database system. What i'm trying to achieve atm is for a user to be able to edit current data in a database table, submit it, and for it to display the new data in the webpage. The table i'm reading from has 6 records and the fields ID(which is just auto_incremented) and courseName.
Ideally, I would like the user to be able to delete a record too. The code I have written displays the courseName's in a table along with textareas and a submit button for each row. It seems to be doing nothing at the minute, so I was hoping someone could enlighten me as to what I've done wrong and if someone could provide what code i'm missing if any, i would be ever so grateful I think I might have structured it all wrong, I hope this isn't the case! My current code is below, hope to hear some feedback soon, many thanks, Aaron
PS: feel free to ask any more question in case I've forgot to mention something
<?php
session_start();
$hostname_logon = "***.*.*.*" ;
$database_logon = "aal9" ;
$username_logon = "root" ;
$password_logon = "" ;
$coursenametext = '';
$id = '';
//error_reporting (E_ALL ^ E_NOTICE);
$connections = mysql_connect($hostname_logon, $username_logon, $password_logon) or die ( "Unable to connect to the database" );
mysql_select_db($database_logon) or die ( "Unable to select database!" );
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Courses</title>
<link href="Aaron.css" rel="stylesheet" type="text/css" />
</head>
<div class="container">
<h1><img src="logo.gif" alt="Logo" width="224" height="62" id="logo" align="left"/></a>Update Courses</h1>
</div>
<div class="sidebar1">
<ul class="nav">
<li><a href="homepage.php">Homepage</a></li>
<li><a href="modules.php">My Modules</a></li>
<li><a href="update.php">Update Database</a></li>
<li><a href="googles1.php">Sem 1 Google</a></li>
<li><a href="timetable2.php">Sem 2 Timetable</a></li>
<li><a href="googles2.php">Sem 2 Google</a></li>
<li><a href="logout.php">Logout</a></li>
</ul>
<p><a href="javascript:window.print()">Print This Page</a></p>
<p> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. </p>
<p>Welcome To Timetable Management. Please Find All Necessary Links Above.</p>
</div>
<div class="content">
<form action="editcourses.php" method="post">
<table border="1" cellspacing="1" align="center" bordercolor="#FFFFFF">
<tr>
<td>Course Name</td>
<td>Edit</td>
<td>Submit</td>
<td>Delete</td>
</tr>
<?php
$query = "SELECT * FROM Courses ";
$result = mysql_query ($query);
if(mysql_num_rows($result)>0){
while($row = mysql_fetch_array($result)) {
echo('<tr>' .
'<td>' . $row['CourseName'] . '</td>' .
'<td><input type="hidden" name="id" value="' . $row['ID'] . '"/><textarea name="coursenametext" rows="2"></textarea>' . '</td>' .
'<td>' . '<input type="Submit" name="Submit" value="Submit">' . '</td>' .
'</tr>');
}
}
if(isset($_POST['Submit']))
{
$query1 = "UPDATE courses SET courseName = '".$_POST['coursenametext']."' WHERE ID = '".$_POST['id']."'";
$result1 = mysql_query ($query1);
}
?>
</table>
</form>
<br>
</div>
<div class="footer">
<p><a href="mailto:***@**.**.**" class="Email">Click Here To Email For Help With Faults</a></p>
</div>
</div>
</body>
</html>