Ok, I have a HTML form, where I can select a module type and a keyword. I
then submit this and want a table return with all the projects that fulfil
that criteria. However, instead of returning all the projects that fulfil
the criteria, it only returns the first one I entered. It doesn't seem to
be bringing back any details of projects I entered via the Web site, even
though they fill the criteria, and it is only returning those projects
entered directly into the database using SQL.
Advertising
Here's my PHP code:-
<! search1.php4>
<html>
<head>
<title>Project Database - Search Results</title>
</head>
<body bgcolor="#9966FF" link="lime" vlink="yellow">
<div align="center"><img src="compSciPageBanner.gif"/></div>
<?php
if ($submit == "Submit")
{
// The submit button was clicked!
// Get the input and use it to retrieve information from the database.
//make a connection to the database
PutEnv("ORACLE_HOME=/usr/local/applic/oracle/816");
$connection = OCILogon("geb97","f8s0g99","trdb");
//if a connection to the database is not made output a message
if (!$connection)
{
echo "I couldn't make a connection!";
exit;
}
//formulate the query
$query = "SELECT PROJECT.originator, PROJECT.title, PROJECT.projectID,
PROJECT.status, PROJECT.specialSkills, PROJECT.moduleID FROM PROJECT,
PROJKEY, KEYWORD WHERE PROJECT.projectID=PROJKEY.projectID AND
KEYWORD.keyID=PROJKEY.keyID AND PROJECT.moduleID='$moduleID' AND
KEYWORD.keyword='$keyword'";
//parse the statement
$qry_statement = OCIParse ($connection, $query); //or die ("Couldn't parse
statement");
//execute the query statement
OCIExecute($qry_statement); //or die ("Couldn't execute query");
//a paragraph break, so the table doesn't appear right at the top of the page
echo "<p>";
//create a table into which the results can be placed
echo "<table align=\"center\" border=\"1\" cellpadding=\"8\"
cellspacing=\"2\" bgcolor=\"silver\">";
echo "<tr valign=\"center\"><th>ORIGINATOR</th><th>TITLE</th><th>PROJECT
NUMBER</th><th>AVAILABILITY</th><th>SPECIAL SKILLS</th></tr>";
//retrieve the results of the query statement and present them in the
following way
while (ocifetch($qry_statement))
{
//insert the results into the table
echo "<tr align =\"center\">";
echo "<td>" .OCIresult($qry_statement, 'ORIGINATOR'). "</td>";
echo "<td>" .OCIresult($qry_statement, 'TITLE'). "</td>";
echo "<td>" .OCIresult($qry_statement, 'PROJECTID'). "</td>";
echo "<td>" .OCIresult($qry_statement, 'STATUS'). "</td>";
echo "<td>" .OCIresult($qry_statement, 'SPECIALSKILLS'). "</td>";
echo "</tr>";
//close table and close the paragraph
echo "</table>";
echo "</p>";
}
//commits the information added to the database
OCICommit ($connection);
//log off the database
OCILogoff ($connection);
}//end of if statement
//just a note
echo "<p><b><div align=\"center\">
If the table above appears empty, this means that no projects fulfil your
criteria and you will need to search again
</div></b></p>";
//provide a link back to the UWA home page
echo "<p><div align=\"center\">
<pre>
<a href = \"http://www.aber.ac.uk\";>Return to UWA Home Page</a>
</pre></div></p>";
//provide a link to the Computer Science Home Page
echo "<div align=\"center\">
<pre>
<a href = \"http://www.aber.ac.uk/compsci\";>Return to Computer Science Home
Page</a>
</pre></div>";
//provide a link back to the Project Database main menu
echo "<div align=\"center\">
<pre>
<a href = \"mainMenu.html\">Return to Project Database Main Menu</a>
</pre></div>";
?> <! end of PHP script>
</body>
</html>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
