Post subject: trying to read data from mysql and publish it

[asfan]

Hi everyone

I am using php and mysql for my degree project. The problem is that I am allowing people to search for a student by typing in the name and then the students details, if found, are displayed in a table.

My data is not being displayed and I can't understand why. I have three files: first one is profile.php which contains the search form, then processlogin.php and then student.php.

On submitting the search, the student.php does get displayed minus the database results, so am I right to assume that the processlogin.php file is ok?

If anyone could please help, it would be greatly appreciated. Thanks

Code: profile.php

<form method=post action="processlogin.php">
<table cellspacing=0 cellpadding=4 style='border: 1px solid black; font-size: 9pt'>
<tr><td style='background-color: rgb(236,219,185)'>
<table style='font-size: 9pt'>
<tr>
<td valign=middle>Student's First Name:</td>
<td valign=middle><input type=text name=name></td>
<td valign=middle>(eg. Asfan)</td>
</tr>
</table>
</td></tr>
</table>
<p>
<input type=submit value="Search">
</form>

Code: processlogin.php

$post = $HTTP_POST_VARS;
if ($post) {
$name = $post["name"];
}
$conn = mysql_connect("") or die ("Could not connect to MySQL");
mysql_select_db("");

$query = "SELECT StudentID FROM students where Forename ='$name'";
$result = mysql_query($query) or die("Query failed");

if ($result)
{

setcookie("student", $name);
header("Location: student.php");

}
else
{

echo "Student details not found";

}

else {

echo "Error in filling form";

}

Code: student.php

$conn = mysql_connect("") or die ("Could not connect to MySQL");

mysql_select_db("");

if ($student){

// query the DB

$sql = "SELECT * FROM students WHERE StudentID='$student'";

$result = mysql_query($sql) or die("Query failed");

$line = mysql_fetch_array($result);

}

?>

<!-- #EndEditable -->
<table width="80%" border="1">
<tr>

<td width="22%">
<p><b>Name</b></p>
</td>
<td colspan="3"><!-- #BeginEditable "Name" --><?=$line["Forename"]?>&nbsp;<?=$line["Surname"]?><!-- #EndEditable --></td>
</tr>
<tr>
<td width="22%">
<p><b>PhD title</b></p>
</td> ---and so on

[sgoku01]

You do a header to student.php when you have a result from your DB. But you are not sending any variables with it.. So when you are proccessing student.php is has no var called $student, because you didn't gave it..
Change your header 🙂

[Frederick]

<?php
$dblink = mysql_connect("localhost","username","password")
or die(mysql_error());
mysql_select_db("dbname",$dblink)
or die(mysql_error());

if ($search) {
$sql = mysql_query("SELECT * FROM students WHERE name='$name' ",$dblink)
or die(mysql_error());
$student = "".$row["name"]."";

&nbsp&nbsp&nbsp&nbspif ($student == $name) {

&nbsp&nbsp&nbsp&nbspsetcookie('student', $student, time()+(606024*30), '/', '', 0);
&nbsp&nbsp&nbsp&nbspheader("Location: student.php");

&nbsp&nbsp&nbsp&nbsp} else {

&nbsp&nbsp&nbsp&nbspecho "No record found";

&nbsp&nbsp&nbsp&nbsp}
} else {
?>
<form action="$PHP_SELF"?>" method="post">
<input type="text" name="name" size="20">
<input type="submit" name="search" value="Get It">
</fom>
<?php
}
?>

[asfan]

Thank u for ur replies.

How do I sent the variable? I thought I was doing that? Also, tried the code given, but now the page doesnt go to the student.php page, it does not pass the processlogin.php page. 😕

Please help