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]
