Hi,
Sorry I'm a bit blurr on the complete code sinde my deadline is only one day left. Please can someone let me know the complete code.
Should I make a hyperlink text(to activate the save link etc/save button) that will point to another php file say save.php that will contain all the headers information of php?
I attached the code that display the database content
[PHP]
<?php
session_start();
if(!isset($_SESSION['user'])) {
header('Location: /Login.html');
die();
}
?>
<!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>
<SCRIPT LANGUAGE="JavaScript">
function varitext(text){
text=document
print(text)
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>See All My Notes</title>
<link rel="stylesheet" href="moviebrowser2.css" type="text/css" title="Default" media="screen"/>
<style type="text/css">
.style2 {color: #FFFFCC}
</style>
</head>
<span class="style2"></span>
<body bgcolor="#FFFFFF">
<table width="750" border="0">
<?php
include_once('../ez_sql.php');
?>
<tr>
<td width="100" align="left" valign="top" class="movieinfo_headtext">Movie Title </td>
<td width="300" align="left" valign="top" class="movieinfo_headtext">Notes </td>
<td width="100" align="left" valign="top" class="movieinfo_headtext">Date </td>
<td width="150" align="left" valign="top" class="movieinfo_headtext">Event Category </td>
<td width="100" align="center" valign="top" class="movieinfo_headtext">Event No. <br/></td>
</tr>
<?php
$notesDetails = $db->get_results("exec spShow_Movie_And_Events_Notes_By_User " . $_SESSION['user']->userID ." ");
foreach ($notesDetails as $notes)
{
?>
<tr>
<td width="100" align="left" valign="top" class="displayNotesBox1"><?php echo $notes->movieTitle;?></td>
<td width="300" align="left" class="displayNotesBox1" valign="top"><?php echo $notes->noteText;?></td>
<td width="100" align="left" valign="top" class="displayNotesBox1"><?php echo $notes->noteDate;?></td>
<td width="150" align="left" valign="top" class="displayNotesBox1"><?php echo $notes->EventCategory;?></td>
<td width="100" align="center" valign="top" class="displayNotesBox1"><?php echo $notes->eventNo;?><br/></td>
</tr>
<?php
}
?>
<tr>
<td></br></br></br></br></td>
</tr>
<tr>
<td>
<DIV ALIGN="CENTER">
<FORM>
<INPUT NAME="print" TYPE="button" VALUE="Print this Page"
ONCLICK="varitext()">
</FORM>
</DIV>
<!-- <form method="post">
<input name="save" type="submit" value="Save My Notes"></td>
</form> -->
</td>
</tr>
</table>
</body>
</html>
[/PHP]
93
