help to solve php and oracle command

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.


###################### 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,value
s)) {
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"> </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:
  Sponsored Links











Last Thread
Next Thread










Search this forum -> 
 









PHP SQL archive



 Show a Printable Version
 Email This Page to Someone!
 Receive updates to this thread


Computer Consultants
Programming Jobs
Visual Basic Controls
SQL Server Programming
Webservices
Java Security
Visual Studio
C# Programming
Visual J++
Software engineering
Open source Software
Perl Programming
PHP Programming
ASP Programming
ASP .NET Programming
Visual Basic Programming
Windows Scripting Host
Java Programming
Java Help
Java Beans
VBScript
Cobol
MAC Applications
Unix Programming








Forum Jump:


Please select one:
--------------------
Private Messages
User Control Panel
Who's Online
Search Forums
Forums Home
--------------------
 General Programming Topics-- Software Engineering-- Programming Jobs-- Compilers-- Computer Consultants-- Compression-- Software Testing-- Computer Consultants Ads-- Open Source Software-- Software Licensing-- Software Internationalization-- Extreme Programming-- Software Patterns-- Shareware Programming---- Shareware Announcements---- Shareware Authors---- Shareware Users---- Association of Shareware Professionals forum-- Freshmeat Open Source Projects announcements-- CodeWright-- Google Summer of Code Discussion PERL-- PERL Programming-- PERL Announcements-- PERL Advocacy-- PERL Beginners-- PERL CGI Beginners-- PERL Language-- PERL Language Moderated group-- PERL Modules-- PerlTk-- PERL Miscellaneous-- PERL CGI Freelance-- PERL 6 Language-- PERL DBI-- MacPerl-- Perl Quality Assurance-- PERL-News-- Modules---- PERL Javascript module---- PERL PHP module-- LibWWW-- PERL CPAN---- CPAN Testers-- LDAP-- Perl FormBuilder module-- PERL Documentation-- Perl 6 Compiler-- PERL Tricks-- PERL INLINE module-- IPC DirQueue-- ithreads-- PERL POE-- PERL on RISC OS-- Perl Modules Development-- Perl DBI 2 Microsoft-- ASP-- ASP .NET---- ASP .NET Announcements---- ASP .NET Building Controls---- ASP .NET Caching---- ASP .NET Datagrid Control---- ASP .NET Mobile---- ASP .NET Security---- ASP .NET Webcontrols---- ASP .NET Webservices-- C#---- C# .NET-- Visual Basic---- Visual Basic Forum---- Visual Basic Addins---- Visual Basic 6 Web development---- Visual Basic Bugs---- Visual Basic Controls---- Visual Basic Controls Creation---- VB Controls Databound---- Visual Basic Controls Internet---- Visual Basic Crystal Reports---- Visual Basic Database---- Visual Basic Database ADO---- Visual Basic Database DAO---- Visual Basic Database ODBC---- Visual Basic Deployment---- Visual Basic DirectX---- Visual Basic Enterprise---- Visual Basic Installation---- Visual Basic Syntax-- VC++---- VC Databases---- Debugger---- VC Language---- MFC---- VC STL---- VC Utilities-- Visual J++-- Visual J#-- Scripting---- .NET Scripting---- JScript---- VBScript---- WSH---- Remote Scripting---- Script Debugger---- Scriplets---- IE Scripting---- Windows Server Scripting-- MSDN---- MSDN Annotations---- Dr GUI DotNet Discussion---- MSDN Magazine---- MSDN SOAP Toolkit---- MSDN Webservices-- Smartphone Developer Forum-- Visual Studio---- Visual SourceSafe---- Visual Studio Development---- Visual Studio Extensibility---- Visual Studio Setup---- Help Authoring with Visual Studio-- XML---- MSXML Webrelease---- XML SOAP---- XML SOAP SDK---- Data XML Analysis---- Dot Net XML-- Visual FoxPro Programming-- SQL Server Programming---- SQL Server XML-- Microsoft Webservices-- Sharepoint Windows Services Development-- Microsoft Device Drivers Development---- Windows XP Device Drivers Development-- Windows CE Applications Development-- Tablet PC Applications development-- WinHTTP Java Forum-- Java Programmer-- Java Language Forum-- Java Beans-- Java Corba-- Java Databases-- Java API-- Java GUI-- Java Help-- Java Machine-- Java Security-- Java Software Tools-- Java Announcements-- JavaScript-- Java Miscelleneous-- Borland Jbuilder-- Daisy Content Management-- Java-- Java Games-- GridSphere-- Java GUI Testing-- Castor-- XStream-- Netbeans J2EE-- OFBiz PHP-- PHP Announcements-- PHP Mirrors-- PHP General-- PHP Documentation-- PHP Installation-- PHP Development-- PHP DB-- PHP PEAR Questions and Answers-- PHP Pear-- PHP Pear Developers-- PHP Soap-- PHP XML-- PHP on Windows-- PHP Smarty Templates-- PHP Zend Engine-- PHP Questions and Answers-- PHP Programming-- PHP Language-- PHP PECL-- PHP SQL-- PHP Development-- PHP Evangelism-- PHP with PostgreSQL Database-- PHP Eaccelerator MAC-- MAC Programmer-- AppleScript-- MAC Databases-- MAC Applications-- MAC Programmer Codewarrior-- MAC Programming help-- MAC Programming Tools-- MAC Programmer Miscelleneous-- Hypercard Programming Languages-- A86 Assembler-- Learn C and C Sharp-- ASM370-- AWK-- APL-- C-- Eiffel-- C++---- C Modurated group-- Clarion-- Clipper-- Cobol-- Kylix---- Kylix Linux API---- Kylix Components---- Kylix IDE---- Graphics with Kylix---- Kylix Deployment-- Dylan-- Delphi-- Ruby---- Ruby YARV-- Fortran-- Functional-- Matlab-- Mathematica-- LabVIEW-- Lisp-- MUMPS-- Pascal---- Turbo Pascal-- Objective C-- Oberon-- PostScript-- Prolog-- Logo-- Python-- PowerBuilder-- Tex-- Rexx-- Scheme-- Smalltalk-- Tcl-- Unix Shell Programming-- Unix Programming-- VHDL




All times are GMT. The time now is 04:45 PM.
 

 
 Free MCSE Braindumps | Real Estate Topics
 

 


  ms access course  


Programming forum archive 

Copyrights CodeComments.com 2004 - 2006
Powered by vBulletin
Copyright  2000-2006 Jelsoft Enterprises Limited.