I am very new to PHP and databases and have not really had very much
programming practice. However, I am trying to create a Web page that
retrieves data from an Oracle database and uses php to display the content
in a HTML format. For some reason though my script just doesn't seem to
work, despite the fact that I know there is data in teh database that
matches the criteria, and only prints the final three HTML links at the
bottom of the script.
Any ideas? But please make them easy enough for a 3 year old to understand.
Georgina Bailey
<html>
<head>
<title>Project Database - Project Search</title>
</head>
<body bgcolor="#9966FF" link="lime" vlink="yellow">
<div align="center"><img src="compSciPageBanner.gif"/></div>
<h1 align="center">Project Search</h1>
<form action="http://users.aber.ac.uk/geb97/search1.php4"; method="POST">
<h2 align="center">Please select the relevant module and then check the area(s) that
may interest you</h2>
<h4 align="center"> If, for example, you would like to see all projects that involve
Java,
check the Java box. If you would like only those that involve both Java and databases,
check both boxes.
You must check at least one box</h4>
<p>
<input type="radio" name="moduleID" value="CS39030"
checked="checked"><big>CS39030</big><br/>
<input type="radio" name="moduleID" value="CS39110"><big>CS39110</big><br/>
<input type="radio" name="moduleID" value="CS49060"><big>CS49060</big><br/>
<input type="radio" name="moduleID" value="CSM9060"><big>CSM9060</big><br/>
<input type="radio" name="moduleID" value="CSM9260"><big>CSM9260</big><br/>
</p>
<p>
<input type="radio" name="keyword" value="java" checked="checked"><big>Java</big><br/>
<input type="radio" name="keyword" value="telematics"><big>Telematics</big><br/>
<input type="radio" name="keyword" value="artificialIntelligence"><big>Artificial
Intelligence</big><br/>
<input type="radio" name="keyword" value="databases"><big>Databases</big><br/>
<input type="radio" name="keyword" value="68HC11"><big>68HC11 Assembly
Language</big><br/>
<input type="radio" name="keyword" value="web"><big>Web Development</big><br/>
<input type="radio" name="keyword" value="others"><big>Other Programming
Languages</big><br/>
</p>
<p>
<div align="center"><input type="submit" value="Submit"/>
<input type="reset" value="Reset"/></div>
</p>
</form>
<div align="center">
<pre>
<a href = "http://www.aber.ac.uk";>Return to UWA Home Page</a>
</pre></div>
<div align="center">
<pre>
<a href = "http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page</a>
</pre></div>
<div align="center">
<pre>
<a href = "mainMenu.html">Return to Project Database Main Menu</a>
</pre></div>
</body>
</html>
<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, MODULE WHERE PROJECT.projectID=PROJKEY.projectID AND
KEYWORD.keyID=PROJKEY.keyID AND PROJECT.moduleID='CS39030' AND KEYWORD.keyword='java'";
//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");
//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))
{
echo "The Originator is:" .OCIresult($qry_statement, 'ORIGINATOR');
echo "The title is:" .OCIresult($qry_statement, 'TITLE');
echo "The projectID is: ". OCIresult($qry_statement, 'PROJECTID');
echo "The availabilty is: ". OCIresult($qry_statement, 'AVAILABILITY');
echo "The special skills are: ". OCIresult($qry_statement,
'SPECIALSKILLS');
//echo "<tr align =\"center\"><td>" .OCIresult($qry_statement,
'ORIGINATOR'). "</td></tr>";
//echo "<tr align=\"center\"><td>" .OCIresult($qry_statement,
'TITLE'). "</td></tr>";
//echo "<tr align=\"center\"><td>" .OCIresult($qry_statement,
'PROJECTID'). "</td></tr>";
//echo "<tr align=\"center\"><td>" .OCIresult($qry_statement,
'AVAILABILITY'). "</td></tr>";
//echo "<tr align=\"center\"><td>" .OCIresult($qry_statement,
'SPECIALSKILLS'). "</td></tr>";
}
//log off the database
OCILogoff ($connection);
}
?>
<div align="center">
<pre>
<a href = "http://www.aber.ac.uk";>Return to UWA Home Page</a>
</div>
<div align="center">
<pre>
<a href = "http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page</a>
</pre></div>
<div align="center">
<pre>
<a href = "mainMenu.html">Return to Project Database Main Menu</a>
</pre></div>
</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]
