[PHP-DB] really more of an oracle question
Hey everyone, please disregard this off-topic question. I think I may need some PHP knowledge too, but here goes. In all of the documentation I've found, a DBA can write stored procedures, functions and views. I know how to write a stored procedure to do INSERT, UPDATE or DELETE functions. I really want to be able to store queries in Oracle just as you would an INSERT. For example, I want to have a SP do this: SELECT FLGT_NUMBER, DPTR_ARPT, ARVL_ARPT FROMFLIGHT WHERE FLGT_NUM = $flgt_num ORDER BYFLGT_NUM; I need the entire recordset returned so that I can call the SP from PHP. This almost sounds like making a view, but I don't know how to send parameters to the view. I really don't know a lot about Oracle and quite frankly the Oracle documentation I've found sucks. Can anyone help me? Would anyone be so kind as to tell me what their favorite Oracle resource is? I've tried www.oracle.com and www.orafaq.com but neither has helped me find what I'm looking for. It's too bad Google took over Deja; I can't post there. My university's news server is far from being called "maintained" and I have no other decent news server at my disposal. Pleading for help, Brian Mauter [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] Re: installation blues with oracle 8i
On your configure script try this: ./configure --with-oci=/path/to/your/oracle/installation/home I think your PHP configure script still cannot find the Oracle home directory (have you set ORACLE_HOME in your environment?). Good luck, Brian Mauter [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] Oracle vs MS SQL vs MySQL
Hey, Has anyone tried out all three of these DBMS packages and evaluated them? I was wondering what everyone is having the best luck with when writing PHP scripts. I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) Thanks, Brian -- 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] Re: Connecting to Oracle
Hey, I'm using Oracle with PHP. I never could get the blasted thing to work right. What I ended up doing was something similar to this: $db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521))(CONNECT_DATA=(SID=TEST)))"; $conn = OCILogon("scott", "tiger", $db); From what I can tell, this completely lets PHP ignore your tnsnames.ora file. So if you're having some rather interesting trouble connecting with environment variables, give that a shot. The only things you'll have to replace are the SID and the IP address. :) -Brian -- 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]