lindaonline15
چهارشنبه 30 مرداد 1387, 09:18 صبح
سلام
من این برنامه search engine رو نوشتم اما مشکل اینجاست که هیچ جوابی به من بر نمیگردونه، هیچ پیغام خطایی هم نمیده. 2 تا page ساختم یکی HTML که داده هارو میفرسته به دومی که PHP هستش. کد کاملش رو هم این زیر میبنین.
کسی میتونه به من کمکی بکنه؟ :ناراحت:
ممنونم.
<html>
<head>
<title>Search in Final exam papers</title>
</head>
<body>
<?php
mysql_connect("localhost", "admin", "admin") or die(mysql_error());
mysql_select_db("ueros_db") or die(mysql_error());
$subject_code = empty($_POST['subject_code'])? die ("ERROR: Incorrect subject code") : mysql_escape_string($_POST['subject_code']);
$subject_name = empty($_POST['subject_name'])? die ("ERROR: Incorrect subject name") : mysql_escape_string($_POST['dubject_name']);
$lecturer = empty($_POST['lecturer'])? die ("ERROR: Incorrect lecturer name") : mysql_escape_string($_POST['lecturer']);
$department = empty($_POST['department'])? die ("ERROR: Incorrect department") : mysql_escape_string($_POST['department']);
$semester = empty($_POST['semester'])? die ("ERROR: Incorrect semester") : mysql_escape_string($_POST['semester']);
$year = empty($_POST['year'])? die ("ERROR: Incorrect year of exam") : mysql_escape_string($_POST['year']);
?>
<?php
$query = "SELECT * FROM exam_papers WHERE
(subject_code = '$subject_code' OR
subject_name = 'subject_name' OR
lecturer = '$lecturer' OR
department = '$department' OR
semester = '$semester' OR
year_of_exam = '$year')"
or die (mysql_error());
$result = mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result);
?>
<table border="1">
<tr>
<td>Subject Code</td>
<td>Subject Name</td>
<td>Lecturer</td>
<td>Department</td>
<td>Semester</td>
<td>Year</td>
<td>File</td>
</tr>
<?php
$count = 0;
while ($row = mysql_fetch_row( $result ))
{
$sc = $row[subject_code];
$sn = $row[subject_name];
$lec = $row[lecturer];
$dep = $row[department];
$sem = $row [semester];
$y = $row[year_of_exam];
$link = $row[file_path];
print("<tr>");
print("<td>$sc</td>");
print("<td>$sn</td>");
print("<td>$lec</td>");
print("<td>$dep</td>");
print("<td>$sem</td>");
print("<td>$y</td>");
print("<td>$link</td>");
print("</tr>");
$count++;
}
?>
</table>
<br />Your search yielded <strong>
<?php print("$count") ?> results.</strong> <br/> <br />
<?php
mysql_close();
?>
</body>
</html>
من این برنامه search engine رو نوشتم اما مشکل اینجاست که هیچ جوابی به من بر نمیگردونه، هیچ پیغام خطایی هم نمیده. 2 تا page ساختم یکی HTML که داده هارو میفرسته به دومی که PHP هستش. کد کاملش رو هم این زیر میبنین.
کسی میتونه به من کمکی بکنه؟ :ناراحت:
ممنونم.
<html>
<head>
<title>Search in Final exam papers</title>
</head>
<body>
<?php
mysql_connect("localhost", "admin", "admin") or die(mysql_error());
mysql_select_db("ueros_db") or die(mysql_error());
$subject_code = empty($_POST['subject_code'])? die ("ERROR: Incorrect subject code") : mysql_escape_string($_POST['subject_code']);
$subject_name = empty($_POST['subject_name'])? die ("ERROR: Incorrect subject name") : mysql_escape_string($_POST['dubject_name']);
$lecturer = empty($_POST['lecturer'])? die ("ERROR: Incorrect lecturer name") : mysql_escape_string($_POST['lecturer']);
$department = empty($_POST['department'])? die ("ERROR: Incorrect department") : mysql_escape_string($_POST['department']);
$semester = empty($_POST['semester'])? die ("ERROR: Incorrect semester") : mysql_escape_string($_POST['semester']);
$year = empty($_POST['year'])? die ("ERROR: Incorrect year of exam") : mysql_escape_string($_POST['year']);
?>
<?php
$query = "SELECT * FROM exam_papers WHERE
(subject_code = '$subject_code' OR
subject_name = 'subject_name' OR
lecturer = '$lecturer' OR
department = '$department' OR
semester = '$semester' OR
year_of_exam = '$year')"
or die (mysql_error());
$result = mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result);
?>
<table border="1">
<tr>
<td>Subject Code</td>
<td>Subject Name</td>
<td>Lecturer</td>
<td>Department</td>
<td>Semester</td>
<td>Year</td>
<td>File</td>
</tr>
<?php
$count = 0;
while ($row = mysql_fetch_row( $result ))
{
$sc = $row[subject_code];
$sn = $row[subject_name];
$lec = $row[lecturer];
$dep = $row[department];
$sem = $row [semester];
$y = $row[year_of_exam];
$link = $row[file_path];
print("<tr>");
print("<td>$sc</td>");
print("<td>$sn</td>");
print("<td>$lec</td>");
print("<td>$dep</td>");
print("<td>$sem</td>");
print("<td>$y</td>");
print("<td>$link</td>");
print("</tr>");
$count++;
}
?>
</table>
<br />Your search yielded <strong>
<?php print("$count") ?> results.</strong> <br/> <br />
<?php
mysql_close();
?>
</body>
</html>