problem searching and display using php with oracle

Dev Shed Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

June 9th, 2004, 12:17 AM

kanpp

Registered User

Join Date: Jun 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

problem searching and display using php with oracle

Problem

Currently i am creating a system using php that integreate with oracle database.I am
having a problem to display the result that retrieve the data from database When the
user try to search the details of the particular staff.
Below is the coding to retrieve and display the result.

Note: Connecting to the database using OCI8 is successfull.

PHP Code:


		
			
###################### Retrieve data from database ##################



<?php

    if(!empty($do)) {

            

            if($do == "staff_id") {                    

                    $search = "SELECT LIABILITIES.LIAB_ID FROM LIABILITIES,EMPLOYEE 

                           WHERE EMPLOYEE.STAFF_ID = LIABILITIES.STAFF_ID AND EMPLOYEE.STAFF_ID='$staff_id'";    

                                

            }

            

            

            if($do == "staff_name"){

                    //$search ="SELECT reservation.Resv_Id, reservation.No_PerChild, reservation.Resv_Arri, reservation.Resv_Dept, room.Ro_Type FROM reservation, room WHERE  reservation.Ro_Id=room.Ro_Id and reservation.Resv_Id ='$Resv_Id';";

            }





                                        

            $search_result = OCIParse($conn,$search);    

                

            $search_res = OCIExecute($search_result);

            



?>





#########################Display the result inside the table!##############################3





<?php

            while(OCIFetchInto($search_result,$values)) {

            $Liab_Id=$values[0];

            

?> 

   <tr>

     <td class="td3" ><font class="text"><?php echo $Liab_Id; ?></font></td>

     <td class="td3" ><font class="text"></font></td>

     <td class="td3" ><font class="text"></font></font></td>

     <td class="td3"><font class="text"></font></td>

     <td class="td3"><font class="text"></font></td>

     <td class="td3"><font class="text"></font></td>

     <td class="td3"><font class="text"></font></td>

     <td class="td3"><font class="text"></font></td>

     <td class="td3"><font class="text"></font></td>

   </tr>

  <tr>

      <td colspan="7" class="td3" ><font class="inlabelcell"><center></center></font><font class="inlabelcell">&nbsp;</font></td>       

      <td class="td3"><Center><div class="labelcell">Total Amount:</div></Center> </td>

      <td class="td3"><font class="inlabelcell"><center>

      </center></font></td>

  </tr>

  <?php

                }//close for while search_date

            }//close if statement

?>



</center>

</body>

</html>





#####################################################################

Bellow is the error messages that display when run this code!

Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in c:\program files\apache group\apache\htdocs\searc_only_view.php on line 71

Warning: ocifetchinto(): supplied argument is not a valid OCI8-Statement resource in c:\program files\apache group\apache\htdocs\searc_only_view.php on line 109

Notes: For the full coding --->URL,
If u cannot view, please right click and click view source.

Last edited by pabloj : June 9th, 2004 at 03:14 AM.

June 9th, 2004, 03:17 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,707

Time spent in forums: 2 Months 2 Weeks 6 Days 2 h 38 m 50 sec
Reputation Power: 259

I've done some development with Php and Oracle 9.2 using Oracle extension (not OCI) but I hope this code can help:

PHP Code:


		
			
<?

$conn = @ora_logon("scott@smcdbserver", "tiger") or die ('Could not connect.'.ora_error());

$oracur = ora_open ($conn);

$statement = "SELECT COUNT(*) FROM emp";

$bool = ora_parse($oracur, $statement, 0);

if (!$bool)

    {

        echo ora_error();

    }

else

    {

        echo "Successfully parsed statement";

        //after successfully parsed statement we execute the query

        ora_exec($oracur);

                         //get the number of columns in the resultset

        $numcols = ora_numcols($oracur);

              while(ora_fetch($oracur) ){ // while there is a row 

                     for($i=0;$i<$numcols;$i++){ // go through the columns

                       echo ora_getcolumn($oracur,$i);         //print the results

                     }

               }



    }

ora_close($oracur);

ora_logoff($conn);

?>

__________________
My blog about OpenSource Databases
PDF tutorials about OSS databases, DBMonster ...
Please contribute to Open Source Development, fill bug reports!!!
Developer Shed eSupport
Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins

June 9th, 2004, 09:38 PM

kanpp

Registered User

Join Date: Jun 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

problem with searching

tahnks for the respon.. FYI i'm using OCI because the there are a better than ORA. my problem is that searching command can be displayed only by static the searching not using the interface or $staff_id address reference

<?php
if(!empty($do)) {

if($do == "staff_id") {
$search = "SELECT LIABILITIES.LIAB_ID FROM LIABILITIES,EMPLOYEE
WHERE EMPLOYEE.STAFF_ID = LIABILITIES.STAFF_ID AND EMPLOYEE.STAFF_ID='$staff_id';

}

if($do == "staff_name"){
//$search ="SELECT reservation.Resv_Id, reservation.No_PerChild, reservation.Resv_Arri, reservation.Resv_Dept, room.Ro_Type FROM reservation, room WHERE reservation.Ro_Id=room.Ro_Id and reservation.Resv_Id ='$Resv_Id';";
}

$search_result = OCIParse($conn,$search);

$search_res = OCIExecute($search_result);

?>

the bold text refer to the problem..it only display when i'm state the

WHERE EMPLOYEE.STAFF_ID = LIABILITIES.STAFF_ID AND EMPLOYEE.STAFF_ID='12345'

hope that can somebody help me to solve the problem.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: