hi guys, i need help in making this scrip work.. i want individual registered user on the portal to be able to view their information anytime they want. am having issue fetching the data from the data base.
The script is like this;
<?php
session_start();
if(!isset($_SESSION['user'])){
header("Location: index.php");
exit;
}
if(!file_exists("confunc.inc.php")){
die("No such include file. Check filename properly");
}
include("confunc.inc.php");
$message = array();
// check if message array is empty then open database
@$conn = db_connect(HOST, USER, PWD, DB);
if(!$conn){
die("<h2><font color='red'>can't connect to server. try again or ask administrator</font></h2>");
}
else{
// connection successful
$sql = "select * from ef_tb where ";
$sql .= "email='" . $_SESSION['e'] . "' and phone='" .$_SESSION['p'] . "'";
@$result = mysql_query($sql, $conn);
if(!$result){
die("<h2><font color='red'>can't perform database operation. try again or ask administrator</font></h2>");
}
else{
$status = 1;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dth">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/style.css" media="screen" type="text/css" />
<style type="text/css">
<!--
.style1 {
color: #006600
}
.wid{
position: 50%;
size: 50%;
}
body {
margin: 0;
padding: 0;
}
.style2 {font-size: 36px}
-->
</style>
<title>View Information</title>
<script type="text/javascript">
function sname(musc){
if(musc=="all")
{
location.href="view_page.php";
}else{
location.href="view_page.php?name="+musc;
}
}
</script>
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#00FF33">
<tr>
<td bgcolor="#FFFFFF"><div align="center"><img alt="" class="form-image" border="0" src="http://www.jotform.com/uploads/Duncanjo/form_files/Students_bursary_butt.jpg" height="81.9" width="630"></div>
</div></td>
</tr>
</table>
<span>
<center>
<a href="logout.php">Logout</a> | <a href="form.php">Register Member</a>
</center>
</span>
<table width="70%" border="0" align="center" cellpadding="0" cellspacing="4" bgcolor="#FFFFFF">
<caption>
<strong>Member Information</strong>
</caption>
<tr>
<th colspan="2"><table width="100%" border="0" align="center">
<tr>
<td width="488" bgcolor="#FFFFCC"><div align="center"> <div align="center">Overall Info.
</div></td>
<td width="122" height="90" bgcolor="#FFFFFF">
<?php
if(isset($stat)){
$count = 1;
while($row = mysql_fetch_array($result)){
?>
<?php
$directory = '../upload/thumbs/';
$imagePix = $row["images"];
$sepPix = explode(".", $imagePix);
$imagePix = $sepPix[0] . "_thb" . "." . $sepPix[1];
$imageP = $directory . $imagePix;
?>
<p>
<?php
if(isset($imageP)) {
echo "<img src='" . $imageP. "' /> </br>";
}
?>
</p></td>
</tr>
</table>
</tr>
<tr><?php echo $count; ?>
<td bgcolor="#FFFFFF"><strong>Name</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(ucfirst($row["name"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Contact Address</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(ucfirst($row["caddress"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>City Address</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(ucfirst($row["cityaddress"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Village of Origin</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(ucfirst($row["viladdress"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Ward</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(ucfirst($row["wdaddress"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>LGA</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(ucfirst($row["lga"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>GSM Number</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["phone"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Email</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(strtolower($row["email"])); ?></td>
</tr>
<tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Name of Institution</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["n_school"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Telophone Number</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(strtoupper($row["tphone"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Gender</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtolower($row["sex"])); ?> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Marital Status</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(strtolower($row["marital"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Father/Guardian Name</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["father"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Date of Birth</strong></td>
<td bgcolor="#FFFFCC">month:<?php echo htmlspecialchars(strtolower($row["month"])); ?> | Day:
<?php echo htmlspecialchars(strtolower($row["day"])); ?> | Year:
<?php echo htmlspecialchars(strtolower($row["year"])); ?> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Parent/Guardian Occupation</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["parent"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Department</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(strtoupper($row["dept"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Level</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["level"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Registration Number</strong></td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["r_num"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><strong>Bank Name</strong></td>
<td bgcolor="#FFFFFF"><?php echo htmlspecialchars(strtoupper($row["bank_name"])); ?></td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><strong>Account Number</strong></td>
<td bgcolor="#FFFFCC"><?php echo htmlspecialchars(strtoupper($row["bank_acc"])); ?></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2" align="center" bgcolor="#FFCC99"> <input type='button' value='Print' onclick='window.print();return false;' /></td>
</tr>
<?php
$count++;
}
}
?>
<tr bgcolor="#FFFFCC">
<td colspan="25" align="center"> <input type='button' value='Print' onclick='window.print();return false;' /></td>
</tr>
</table>
</tr>
</table>
<table width="180%" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#00FF33">
<tr><td colspan="2" align="center" bgcolor="#FFFFFF"><?php include("includes/footer.php"); ?></td>
</tr>
</table>
</body>
</html>
thanks
