Re: [PHP-DB] php and oracle
Dieter, Can you share some of your migration experiences? Why did you migrate to Oracle and what problems did you face? Miscellaneous thoughts follow: Regarding the error, search the bdump trace files for 3114 or other ORA-xyz errors. You may need to get Oracle Support involved if there are any. Your trace file dir seems huge. The Administrator's guide has some info about controlling the sizes: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/manproc.htm#sthref655 Effectively you delete what you don't need. Hopefully PHP5 will stabilize quickly. I recall a stern warning in the PHP manual about not using Apache 2. I can't find it currently - anyone know if it has been rescinded? The troubleshooting FAQ mentions restarting Apache occasionally to avoid connection problems. (See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt) I feel that the Oracle-PHP community needs to get together and work on through the various connection issues. Anyone want to participate? Chris D.Wilkening wrote: Hi, we are not really trained in analyzing Oracle-logs. I've been using Mysql and Mssql for years, but the migration was more difficult, than I thought. In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know, where to start... du -sch * 1.5Gbdump 166Mcdump 28K create 8.0Kpfile 282Kudump 1.7Gtotal well, for the apache-problem, I've found an "solution" (not the straight way, but it seems to work so far): using apache_child_terminate doesn't work (probably apache2 compiled against nptl (linux kernel 2.6), apache_child_terminate doesn't work in an multi-threaded env) so I cought the php-error using set_error_handler. Inside of this error-method, I did an "posix_kill(getmypid(),15);" I know, I won't win the programmers Nobel-Prize for that crap, but it works so far; dropped connections are reconnected. Dieter Christopher Jones sagte: D.Wilkening wrote: Hi everyone, i've a problem using php with oracle 10g. (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) One or two days, everything looks good. Then, by pressing (once a second) reload in your browser, you sometimes get an ERROR #: 2 ERROR DESC: oci_execute() [function.oci-execute]: OCIStmtExecute: ORA-03114: Nicht mit ORACLE verbunden restarting apache solves the problem, but is no real option. My first idea was the connection pooling, so i tried a ocilogon instead ociPlogon, but the problem dodn't solve. Any Ideas? Thank you in advance Are there any clues in the database trace files? Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php and oracle
Hi, we are not really trained in analyzing Oracle-logs. I've been using Mysql and Mssql for years, but the migration was more difficult, than I thought. In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know, where to start... du -sch * 1.5Gbdump 166Mcdump 28K create 8.0Kpfile 282Kudump 1.7Gtotal well, for the apache-problem, I've found an "solution" (not the straight way, but it seems to work so far): using apache_child_terminate doesn't work (probably apache2 compiled against nptl (linux kernel 2.6), apache_child_terminate doesn't work in an multi-threaded env) so I cought the php-error using set_error_handler. Inside of this error-method, I did an "posix_kill(getmypid(),15);" I know, I won't win the programmers Nobel-Prize for that crap, but it works so far; dropped connections are reconnected. Dieter Christopher Jones sagte: > > D.Wilkening wrote: > >> Hi everyone, >> >> i've a problem using php with oracle 10g. >> (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) >> One or two days, everything looks good. Then, by pressing (once a >> second) >> reload in your browser, you sometimes get an >> ERROR #: 2 >> ERROR DESC: oci_execute() [> href='function.oci-execute'>function.oci-execute]: OCIStmtExecute: >> ORA-03114: Nicht mit ORACLE verbunden >> >> restarting apache solves the problem, but is no real option. >> My first idea was the connection pooling, so i tried a ocilogon instead >> ociPlogon, but the problem dodn't solve. >> >> Any Ideas? >> >> Thank you in advance >> > > Are there any clues in the database trace files? > > Chris > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Antwort: [PHP-DB] php and oracle
This sounds interesting! We'll try this. Thanks and greetings from Essen :), Dieter -- Dieter Wilkening Software-Entwickler Baumann Technologie GmbH [EMAIL PROTECTED] [EMAIL PROTECTED] sagte: > > I tried to compile PHP 4.3.8 with OCI and oracle_LIB 32bit somewhere in > $ORACLE_HOME/../lib32 > ant it works. > ORACLE_HOME=/oracle/app/oracle/product/9.2.0 > TNS_ADMIN=/oracle/app/oracle/product/9.2.0/network/admin > LD_LIBRARY_PATH=$ORACLE_HOME/lib32 > NLS_LANG=german.germany.WE8895P1 > ORACLE_BASE=/oracle/app/oracle > > > after ./configure you have to edit Makefile to correct the PATH to LIB to > LIB32. > Try it. > > > > > Best Regards > Jahan Ketabchy > > > > > "D.Wilkening" > <[EMAIL PROTECTED] An: [EMAIL PROTECTED] > kening.de> Kopie: > Thema: Re: Antwort: [PHP-DB] > php and oracle > 07.09.2004 > 09:29 > Bitte antworten > an php > > > > > > > [EMAIL PROTECTED] sagte: >> >> Hi ! >> I have the same problem with oracle 9i. >> OCI doesn't work with Oracle_LIB 64bit kernel. > > Do you have any ideas? > I'd say, filing a bug @ php.net would be a possible solution. There has to > be a way for php to find out, which connection is gone and which is still > alive. > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php and oracle
Hi everyone, i've a problem using php with oracle 10g. (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) One or two days, everything looks good. Then, by pressing (once a second) reload in your browser, you sometimes get an ERROR #: 2 ERROR DESC: oci_execute() [function.oci-execute]: OCIStmtExecute: ORA-03114: Nicht mit ORACLE verbunden restarting apache solves the problem, but is no real option. My first idea was the connection pooling, so i tried a ocilogon instead ociPlogon, but the problem dodn't solve. Any Ideas? Thank you in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and Oracle
helloo Everyone... A new guest to the list needs your hlep!!. I am about to start working on a project in which im going to use Oralce with PHP4. I am new to PHP. I am looking for a good book about working with "PHP4 and Oracle" to help me pick up the basics as well as get the depth that i am looking for. To give you a better idea regaring depth, I'll be working on a Web-enabled college registration system. Students log into a web page to view, choose, and register courses. They should be able to view their time tables, grades, personal information ...etc. I need help as soon as possible. Please help. Thanks - Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day
Re: [PHP-DB] PHP and ORACLE conection error
"xxx " <[EMAIL PROTECTED]> wrote... : > hy, > i'm having a problem with my project > i have an oracle server on a computer named oracle and in apache htdocs files i have >a directory special for my project... > > 1 in that dir i have a html file named index.html > here i get the username and the password and post it to the validate.php file > > in the validate.php file: > the first i have is > header("Cache-control:private"); ?> > then > > 1. i get the variables > $name=$_POST['username']; > $password=$_POST['pass']; > > 2. i register the variables > session_register("name") and session_register("password"), > > 3. i verify if they can acces to the database > if( ociplogon($name,$password)) > $ok='true'; > else $ok='false'; oops... You are assigning $ok to a *string* of a readable values 'true' or 'false'. > 4. in the body of the validate.php i have a script in order to load a new page > > > var ok= > if(ok==true) > window.location.href="good_page.php"; > else > window.location.href="error.php" > window.reload(); > The string $ok is not empty, and thus will always evaluate as TRUE. You need to assign it the boolean value a few lines above. Not a string. > well > that's it > it works but not finei know it isn't the best way but it worked > till some days i have any problems but since today i don't know what is happening... > > sometimes it works loading the good_page but sometimes it loads the error page > i think it is something with authentification and session but i need a solution >quickly...i have no time to rethink all... > > if you have a solution or another type of making all i have made send me a reply > thanks a lot... > cybercop78 > > http://www.idilis.ro - Stiri, e-mail gratuit, download, > SMS, server de counter-strike, hosting gratuit, servicii internet... > Fii cu un pas inaintea celorlati! -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and ORACLE conection error
hy, i'm having a problem with my project i have an oracle server on a computer named oracle and in apache htdocs files i have a directory special for my project... 1 in that dir i have a html file named index.html here i get the username and the password and post it to the validate.php file in the validate.php file: the first i have is then 1. i get the variables $name=$_POST['username']; $password=$_POST['pass']; 2. i register the variables session_register("name") and session_register("password"), 3. i verify if they can acces to the database if( ociplogon($name,$password)) $ok='true'; else $ok='false'; 4. in the body of the validate.php i have a script in order to load a new page var ok= if(ok==true) window.location.href="good_page.php"; else window.location.href="error.php" window.reload(); well that's it it works but not finei know it isn't the best way but it worked till some days i have any problems but since today i don't know what is happening... sometimes it works loading the good_page but sometimes it loads the error page i think it is something with authentification and session but i need a solution quickly...i have no time to rethink all... if you have a solution or another type of making all i have made send me a reply thanks a lot... cybercop78 http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and Oracle
Hi Everybody Does anyone have a sample code that read each page of data from Oracle like OLEDB in windows? I don't want to read the whole table into my webpage, each time i only want to read 20 rows. And list all of the remaining pages for choosing How can I do that. If someone has done it or has a sample code, please show me Thanks in advance Thien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and Oracle 7.0
Greetings, Has anyone gotten oracle 7.0 to work with the latest php? I'm having trouble reliably getting anything back. Thanks in advance, Chip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and Oracle 9i Application Server
Hi Does anybody knows of a way to access an Oracle Database by the Oracle Application Server ? Thanks in advance. Carlos Alberto Fraga Leite [EMAIL PROTECTED] http://www.desenvolvedor.eti.br Porque programar nem sempre é fácil (grátis: [EMAIL PROTECTED]) -- 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]
[PHP-DB] PHP and Oracle
Can anybody help me! I've been getting a error message like this for the last few days. Warning: OCIStmtExecute: ORA-01722: invalid number on line 49 Array Every time I try to enter a project using a HTML form Line 49 in apparently the line that says: $result = OCIExecute(ins_statement); Below is the code I am trying to use: //insert relevant values into the project table $insert = "insert into PROJECT values ('$projectID', '$moduleID', $keyID, '$title', '$originator', '$softwareHardware', '$specialSkills', '$status', '$externalAgreement', '$background', '$tasks', '$steps', '$references')"; //formulate the query $query = "select projectID, moduleID, title, originator, softwareHardware, specialSkills, status, externalAgreement, background, tasks, steps, references from PROJECT WHERE projectID='$projectID'"; //parse the two statements $ins_statement = OCIParse ($connection, $insert); $qry_statement = OCIParse ($connection, $query); //execute the first insert statement and print error message if there is an error $result = OCIExecute($ins_statement); if (!$result) { echo OCIError($ins_statement).""; exit; } //execute the query statement OCIExecute($qry_statement); //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { etc.etc.
[PHP-DB] php and oracle
Hallo, I have problems installing php in Linux Mandrake 7.2. Php work, but I can't see the oracle funcions. I guessed I had to recompile the source. I have downloaded the latest version of php from php.net. I unzipped the file in /tmp but when I write "./configure" the program go in abend with this message: creating cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing Updated php_version.h checking whether to enable maintainer-specific portions of Makefiles... no checking host system type... i586-pc-linux-gnu checking for gawk... gawk checking for bison... no checking for byacc... no configure: warning: You will need bison if you want to regenerate the PHP parsers. checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking how to run the C preprocessor... gcc -E checking for AIX... no checking for gcc option to accept ANSI C... none needed checking for ranlib... ranlib checking whether gcc and cc understand -c and -o together... yes checking whether ln -s works... yes checking for flex... lex checking for yywrap in -ll... no checking lex output file root... ./configure: lex: command not found configure: error: cannot find output from lex; giving up what is lex??? and where I did wrong? thank you very much. Bye Marco R. -- 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]
Re: [PHP-DB] PHP and Oracle
You use // to comment, that is quite fine, but it could be that I can't see the layout of the file rightly, but when I opened the file it looked like this: // echo (" "; // echo ... etc... that won't work if you want to comment a block out you can much better use this kind of commenting out: /* echo (" "); echo ("blah"); */ check out if that works... Met vriendelijke groet, Michiel Lange ActuEra B.V. GEORGINA ELAINE BAILEYTo: [EMAIL PROTECTED] <[EMAIL PROTECTED] cc: .uk> Fax to: Subject: [PHP-DB] PHP and Oracle 19-10-2001 19:26 Can anyone tell me why my results will display when I just use text, but won't display when I try to put them into a table. I keep getting a message saying there is a parse error on line 50 of my script, but as far as I acn see, line 50 is commented out. Georgina(See attached file: search1.php4)(See attached file: search1.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] -- 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]
Re: [PHP-DB] PHP and Oracle
> Just a cosmetic question really. Why are the three links I have put in at > the bottom of the script appearing at the top on the WEb page, just beneath > the comp sci banner. How do I get them to appear beneath the table? Georgina, It may look "cosmetic" but a browser's job is to display mark-up logic! If things 'jump' outside/above a table, it is because the table is incomplete. You close off the db stuff neatly, where's the ? =dn -- 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]
[PHP-DB] PHP and Oracle
I want to keep my project number unique. So how would I say (in PHP) that script should do insert if project number is unique, but should print out a message if not, and where abouts in the script would I put it? Georgina Project Database - Project Details "; exit; } //execute the query statement OCIExecute($qry_statement); //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { //line to tell the user the project has been entered into the database echo "The following project has been entered into the Project Database: -"; //display the project title echo "". OCIresult($qry_statement,'TITLE') .""; //display the project number echo "Project Number: ". OCIresult($qry_statement, 'PROJECTID').""; //display the originator echo "Principal Originator: ". OCIresult($qry_statement, 'ORIGINATOR') .""; // no supervisor will be shown because these are not added at the time and a project can have many supervisors //display the software/hardware requirements echo "Software/Hardware Requirements: ". OCIresult($qry_statement, 'SOFTWAREHARDWARE') .""; //display the special skills needed to be used echo "Special Skills: ". OCIresult($qry_statement, 'SPECIALSKILLS') .""; //display which module the project is suitable for echo "Suitability: ". OCIresult($qry_statement, 'MODULEID') .""; //display the status echo "Status: ". OCIresult($qry_statement, 'STATUS') .""; //line to break up text echo ""; //a heading for the new section echo "Description"; //display the project background echo "Background: "; echo "" . OCIresult($qry_statement, 'BACKGROUND') .""; //display the project task/s echo "Project Task/s: "; echo "" . OCIresult($qry_statement, 'TASKS'). ""; //display the specific steps echo "Specific Steps: "; echo "" . OCIresult($qry_statement, 'STEPS'). ""; //display the references echo "References: "; echo "" . OCIresult($qry_statement, 'REFERENCES'). ""; //a line to break up the text echo ""; //contact email address - couldn't make this into a link because too difficult echo "For further information please contact: " . OCIresult($qry_statement, 'ORIGINATOR')."@aber.ac.uk "; //a final line echo ""; //the 1st link allows you to register an interest in the project, the 2nd allows you to withdraw the project echo " "; }//end of while statement //log off the database OCILogoff ($connection); }//end of if statement ?> http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu -- 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]
[PHP-DB] PHP and Oracle
Just a cosmetic question really. Why are the three links I have put in at the bottom of the script appearing at the top on the WEb page, just beneath the comp sci banner. How do I get them to appear beneath the table? Georgina Project Database - Search Results "; echo "ORIGINATORTITLEPROJECT NUMBERAVAILABILITYSPECIAL SKILLS"; //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { //insert the results into teh table echo ""; echo "" .OCIresult($qry_statement, 'ORIGINATOR'). ""; echo "" .OCIresult($qry_statement, 'TITLE'). ""; echo "" .OCIresult($qry_statement, 'PROJECTID'). ""; echo "" .OCIresult($qry_statement, 'STATUS'). ""; echo "" .OCIresult($qry_statement, 'SPECIALSKILLS'). ""; echo ""; }//end of while statement //log off the database OCILogoff ($connection); }//end of if statement //provide a link back to teh UWA home page echo " http://www.aber.ac.uk\";>Return to UWA Home Page "; //provide a link to the Computer Science Home Page echo " http://www.aber.ac.uk/compsci\";>Return to Computer Science Home Page "; //provide a link back to the Project Database main menu echo " Return to Project Database Main Menu "; ?> -- 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]
Re: [PHP-DB] PHP and Oracle
Imbalance of double-quotes on line 43! Thus // comments have all been included in quoted string and hence strange text output. =dn - Original Message - From: "GEORGINA ELAINE BAILEY" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 19 October 2001 18:26 Subject: [PHP-DB] PHP and Oracle > Can anyone tell me why my results will display when I just use text, but > won't display when I try to put them into a table. I keep getting a message > saying there is a parse error on line 50 of my script, but as far as I acn > see, line 50 is commented out. > > Georgina > > > > -- > 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] -- 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]
[PHP-DB] PHP and Oracle
Can anyone tell me why my results will display when I just use text, but won't display when I try to put them into a table. I keep getting a message saying there is a parse error on line 50 of my script, but as far as I acn see, line 50 is commented out. Georgina Project Database - Search Results "; echo " ORIGINATORTITLEPROJECT NUMBERAVAILABILITYSPECIAL SKILLS //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { //echo ""; //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 ""; echo ""; echo "" .OCIresult($qry_statement, 'ORIGINATOR'). ""; echo "" .OCIresult($qry_statement, 'TITLE'). ""; echo "" .OCIresult($qry_statement, 'PROJECTID'). ""; echo "" .OCIresult($qry_statement, 'AVAILABILITY'). ""; echo "" .OCIresult($qry_statement, 'SPECIALSKILLS'). ""; echo ""; } //log off the database OCILogoff ($connection); } ?> http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu Project Database - Project Search Project Search http://users.aber.ac.uk/geb97/search1.php4"; method="POST"> Please select the relevant module and then check the area(s) that may interest you 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 CS39030 CS39110 CS49060 CSM9060 CSM9260 Java Telematics Artificial Intelligence Databases 68HC11 Assembly Language Web Development Other Programming Languages http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu -- 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]
Re: [PHP-DB] php and Oracle database
Georgina: Based on your 2 enclosures, it appears that you have an html file called search1.html. When the user hits the submit button, it calls search1.php4. My question, therefore, is do you have output from search1.php4? Do you see any error messages? Thanks, Anthony Carlos > From: GEORGINA ELAINE BAILEY <[EMAIL PROTECTED]> > Date: Thu, 27 Sep 2001 12:20:17 +0100 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] php and Oracle database > > 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 > > > > > -- > 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] -- 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]
[PHP-DB] php and Oracle database
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 Project Database - Project Search Project Search http://users.aber.ac.uk/geb97/search1.php4"; method="POST"> Please select the relevant module and then check the area(s) that may interest you 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 CS39030 CS39110 CS49060 CSM9060 CSM9260 Java Telematics Artificial Intelligence Databases 68HC11 Assembly Language Web Development Other Programming Languages http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu Project Database - Search Results "; //echo " ORIGINATORTITLEPROJECT NUMBERAVAILABILITYSPECIAL //SKILLS //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 "" .OCIresult($qry_statement, 'ORIGINATOR'). ""; //echo "" .OCIresult($qry_statement, 'TITLE'). ""; //echo "" .OCIresult($qry_statement, 'PROJECTID'). ""; //echo "" .OCIresult($qry_statement, 'AVAILABILITY'). ""; //echo "" .OCIresult($qry_statement, 'SPECIALSKILLS'). ""; } //log off the database OCILogoff ($connection); } ?> http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu -- 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]
[PHP-DB] PHP and Oracle Stored Functions
Hi, I can call stored procedures no problem, but when it comes to functions, I've hit a brick wall. Can anyone help? Am I binding correctly? Is it right to declare the PL/SQL variable first? All help appreciated greatly. Code is included below PHP Code: // logon $conn = OCILogon ($usr, $pwd, $sid); $strSQL = "DECLARE " . "result NUMBER; " . "BEGIN " . ":result :=package_name_pkg.function1(" . "1, '10-JUN-2001', '23-JUL-2001');" . " END;"; // parse $stmt = OCIParse($conn, $strSQL); // bind OCIBindByName($stmt, ":result", &$answer, 22); // execute OCIExecute($stmt); // result OCIResult($stmt,$answer); echo "Value returned:" . $answer; PL/SQL declaration of function (within package_name_pkg): FUNCTION function1 (myval IN NUMBER ,P_STARTDATE IN DATE ,P_ENDDATE IN DATE) RETURN NUMBER; The error I get back on screen is: Warning: OCIStmtExecute: ORA-06550: line 1, column 69: PLS-00201: identifier 'CALC.package_name_pkg' must be declared ORA-06550: line 1, column 44: PL/SQL: Statement ignored in /home/isadlve/public_html/phptesting/file.php on line 28 Laurence Veale Regards, Laurence Veale Tel: 9689 6172 Email: [EMAIL PROTECTED] -- This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Office of State Revenue. -- -- 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]
[PHP-DB] PHP and Oracle 8 Stored Functions
Hi, I can call stored procedures no problem, but when it comes to functions, I've hit a brick wall. Can anyone help? Am I binding correctly? Is it right to declare the PL/SQL variable first? All help appreciated greatly. Code is included below PHP Code: // logon $conn = OCILogon ($usr, $pwd, $sid); $strSQL = "DECLARE " . "result NUMBER; " . "BEGIN " . ":result :=package_name_pkg.function1(" . "1, '10-JUN-2001', '23-JUL-2001');" . " END;"; // parse $stmt = OCIParse($conn, $strSQL); // bind OCIBindByName($stmt, ":result", &$answer, 22); // execute OCIExecute($stmt); // result OCIResult($stmt,$answer); echo "Value returned:" . $answer; PL/SQL declaration of function (within package_name_pkg): FUNCTION function1 (myval IN NUMBER ,P_STARTDATE IN DATE ,P_ENDDATE IN DATE) RETURN NUMBER; The error I get back on screen is: Warning: OCIStmtExecute: ORA-06550: line 1, column 69: PLS-00201: identifier 'CALC.package_name_pkg' must be declared ORA-06550: line 1, column 44: PL/SQL: Statement ignored in /home/isadlve/public_html/phptesting/file.php on line 28 Laurence Veale -- This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Office of State Revenue. -- -- 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]
[PHP-DB] PHP and Oracle
Hi, I just wanted to know if there are any known issues with PHP working with Oracle database. We are currently configuring Oracle to make PHP work with Oracle. Let me know. Thanks Lokesh -- 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]
Re: [PHP-DB] PHP and Oracle
At 03:43 PM 4/18/01 +0800, Lester June Cabrera wrote: >How would I install PHP with Oracle support if Oracle is on another >machine, not in the web server machine? 1. Install the Oracle Net8 client on your web server... 2. Configure the Oracle Net8 client on your web server... 3. Compile PHP with OCI8 support... Now, the next thing that usually happens is that I'll get an email asking me "where do I get the Oracle Net8 client?" then, "how do I install the Net8 client?" still later, I'll get another email asking "how do I configure the Net8 client?" then... So, to avoid all that... The Oracle Net8 client is available from Oracle Corporation. There is a client available for just about every platform imaginable. Call Oracle support with your CSI number and they'll gladly ship whichever client platform software you need for free. Sometimes, the client software isn't available as a stand-alone disk, and they'll send you an entire Oracle 8i installation set - fear not, it contains the Net8 client for that architecture. To configure the Net8 client, follow the directions provided with the installation. Basically, you need to set up your tnsnames.ora file to locate the oracle server. There are utilities installed with the client to help you configure and test it. It probably wouldn't be a bad idea for you to *also* install the SQL*Plus software, which operates through the Net8 interface as well... - Brian - Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 <[EMAIL PROTECTED]> - -- 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]
[PHP-DB] PHP and Oracle
Hi, How would I install PHP with Oracle support if Oracle is on another machine, not in the web server machine? Thanks, Lester - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8460 local 32 Fax: (63 2) 867 8077 E-mail: [EMAIL PROTECTED] Visit the most comprehensive on-line business travel resource at http://www.worldroom.com Successful events start here. Visit http://www.worldroomevents.com . The one-stop online exchange for event planners and suppliers to the MICE industry. -- 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]