RE: [PHP-DB] PHP and Oracle
| From: | Rosser, Chris | Date: | Mon, 08 Oct 2001 10:03:09 +0000 |
| Subject: | RE: [PHP-DB] PHP and Oracle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13102@lists.php.net to get a copy of this message | ||
Georgina,
I think I've got a solution for you...
Your Oracle stuff is only run when $submit = 'Submit':
if ($submit == "Submit") {
//oracle stuff
}
The problem is, your form isn't passing the $search variable to your PHP
script. Your submit button HTML tag is:
<input type="submit" value="Submit">
The value's there, but not the variable name. You need to include 'name' in
the input tag, i.e.
<input type="submit" name="submit" value="submit">
Your PHP and SQL look fine. It should work if you do the above... :)
Chris
}:)
(also at cdr9@aber.ac.uk - good to see someone at Aber using PHP!)
> -----Original Message-----
> From: GEORGINA ELAINE BAILEY [SMTP:geb97@aber.ac.uk]
> Sent: Sunday, October 07, 2001 10:17 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] PHP and Oracle
>
> 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 the database that
> matches the criteria and I know that the query works when used directly in
> Oracle. The 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.Please don't tell me to change the file type to just php rather
> than php4 though, cos i have tried that and it just stopped the whole Web
> site working.
>
> Georgina Bailey
>
> -------------------- HTML ---------------------
>
> <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=3D"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>
>
>
> ------------------- 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=3D/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=3DPROJKEY.projectID AND=
> KEYWORD.keyID=3DPROJKEY.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");
>
>
> //echo "<table align=\"center\" border=\"1\"
> cellpadding=\"8\"=
> cellspacing=\"2\" bgcolor=\"silver\">";
> //echo " <tr
>
> valign=\"center\"><th>ORIGINATOR</th><th>TITLE</th><th>PROJE=
> CT 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net