[PHP-DB] csv without line feed
Hi, I have text file with CSV like format (use # sign separate each field) but there did not have any end of line character. This file could open in m$ excel but if I opened it in any text editor it will display in 1 line. How could I handle this file in PHP code? let see the example it attach file. Sommai Fongnamthip. 28-03-2002# #TR DEP##794,299.09#6,288,278.76#043 28-03-2002# #CASH DEP# #34,107.00#6,322,385.76#076 28-03-2002# #CASH DEP##341,410.84#6,663,796.60#005 28-03-2002#6779642 #TR WTD CHQ#62,332.81# #6,601,463.79#047 28-03-2002# #CASH DEP##120,313.13#6,721,776.92#084 28-03-2002# #ELC TR-BOA# #33,464.98#6,755,241.90#127#REFER TO : ASIA1272053867#REFER TO : ASIA0911006286# # # # 28-03-2002# #CASH DEP##260,695.50#7,015,937.40#067 28-03-2002# #CASH DEP# #253,175.44#7,269,112.84#067 28-03-2002# #TR DEP##45,431.00#7,314,543.84#091 28-03-2002#6779645 #TR WTD CHQ#6,664.81# #7,307,879.03#091 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] csv without line feed
I have hex text editor which could display hex value for each character. I fould that this text file has only carriage-return (0D) in end of record but other text file had carriage-return with line feed (0D 0A). So, when I open this file with fget or fgetcsv; PHP treat for 1 record or 1 line. If someone known how to handle only carriage-return character, please tell me. Sommai At 09:06 28/3/2002 +, George Pitcher wrote: Something I used to do about 17-18 years ago to analyse typeseting code was to use DOS's 'Debug'. It gave a hex value for each character in one panel while scrolling thru the file. Compare this against the Excel printout and you should find what code is being used for lf. Hoping that debug is still available from the C: prompt? George - Original Message - From: Sommai Fongnamthip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 8:53 AM Subject: [PHP-DB] csv without line feed Hi, I have text file with CSV like format (use # sign separate each field) but there did not have any end of line character. This file could open in m$ excel but if I opened it in any text editor it will display in 1 line. How could I handle this file in PHP code? let see the example it attach file. Sommai Fongnamthip. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question about advanced SQL
Hi, I assumed that you was used MySQL for database. With MySQL you can used this SQL to find different row select tblcd.* from tblcd left join tblorder on tblcd.cdid=tblorder.cdid where tblorder.cdid is null sommai At 12:37 28/2/2002 +1000, Adam Royle wrote: Hi. I need some guidance for writing an effective query (instead of processing through PHP). I lets says I have two tables, tblCDs and tblOrders. tblCD cdID| cdTitle | cdArtist -- 1 | Great Hits | Bon Jovi 2 | Forever Young| The Youngsters 3 | Now and Then | Beach Boys 4 | Cheesy Name | Two Tones tblOrders orderID | cdID_FK | ordererID -- 1 | 1| 442 2 | 3| 233 3 | 1| 233 Now, I want to select all the records from tblCD where the cdID does not appear in any row of tblOrders.cdID_FK This means that it selects all the CDs that have not been ordered. The results of the query should be cdID| cdTitle | cdArtist -- 2 | Forever Young| The Youngsters 4 | Cheesy Name | Two Tones I know how I can do this in PHP (two queries - put all cdID_FK in an array, and on displaying the other query, check if it is in the array, and display if not) but there HAS to be an easier way. Adam. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] query problem
Hi, I have problem with these mysql's query: select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no It take a long time (more than 1 minute) with thousand record. I have index within 2 table (name+surname, id). It did not have problem if I check only id or name+surname. SF -- 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] display text in screen
Hi, I have easy problem to ask someone. I wrote PHP to update data with many step and need to display comment or detail in each step. But I got all comment or detail display after it finished update all step. How could I display each step comment immediately?? Sommai Fongnamthip -- 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] load text file
Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF -- 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] version conflict
Dear List, I was installed mysql-3.23.47 in my Linux box with PHP. I could shown version correctly with mysql command line or any windows client tools. It still shown in phpinfo with version 3.23.37 (old version before upgrade). What wrong? Did somone know about Zend Optimizer for php 4.1.1? I have problem with latest Zend Optimizer (Zend say it could run with php-4.1.0) because it did not work (see in phpinfo page). SF -- 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] Unveilled Metabase OOP direct to driver object API
How to compare Metabase to ODBC or ADODB? SF At 06:20 24/12/2001 -0200, Manuel Lemos wrote: Hello, If you are reading this and do not know what is Metabase, be aware that it is PHP database abstraction package for developing truely portable database independent functions. Metabase development will complete 3 years next week. This is a lot of time in the software development world. More information available in the usual place: http://phpclasses.UpperDesign.com/browse.html/package/20 Despite my baby son is monopolizing almost all my free time (I am not complaining:-) ) I finally made time to clean up Metabase API and document a OOP API that is alternative to the Metabase* global functions API, so that now you can use Metabase functions using direct calls to driver class objects. This API has always been available but it was never documented because to enable it, I needed to use a syntax that would break under PHP 3. Finally I realized that I could use eval() to work around that problem and Metabase provides this OOP direct to driver function API preserving backwards compatibility to not affect the applications of those that for some reason still need to use PHP 3. I know that some people that use Metabase still have to use PHP 3 and I simpathize with their constraints. Anyway, finally OOP fans should have no more excuses for not adopting Metabase as their PHP database abstraction of choice. If you thought that typing MetabaseQuery($database,Select * from zbr); would make an hell of difference when compared to $db-Query(Select * from zbr); you should please now with Metabase with this symbolic Christmas gift. Also the performance fanatics should have one less excuse for not using Metabase for some so claimed significant overhead that Metabase global functions add to driver function calls. Soon I will also be adding functions for fetching row data in bulk contributed by Lukas Smith that is giving up his own database abstraction package for Metabase, contributing to make the best that PHP community deserve. More innovating developments will follow. Enjoy. :-) Merry X-mas, Manuel Lemos -- 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] pass variable
Hi, I was successful for use only 1 variable like www.hostname.com/path?variable=xx. How could pass more variable to other program? SF -- 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] variable check in 1 file
Hi, I'd like to create query form and display in 1 file. Do anyone guide me for this? SF -- 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] memory leak???
Hi, I have an error when try to query from 2 database (m$ sql). Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 29 bytes) when I check my server memory it have free for a lot total used free sharedbuffers cached Mem:126516 110996 15520 38864 38212 42192 -/+ buffers/cache: 30592 95924 Swap:96348 4848 91500 How could I fixed this problem?? SF
[PHP-DB] retrieve data from more db
HI, I have data on more than 1 db to separate in year name like these: cust2000-- contain customer infomation in year 2000 cust2001-- contain customer infomation in year 2001 all db have the same field name. I have put db name and table name in separate file (something like include.php). How I write php code to retrieve my interest value to display in one time? for more help pls describe how to layout compare table in the code. Thank you, SF -- 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] multi row handle
Dear, I would like to make a program which can display data in multi row to maintain it with update value, delete row or add new row. How could I handle multi row of data record in web page? SF -- 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] select data from more database
Hi, I have data on more than 1 database with same schema. How could I use SQL statement in PHP code to retrieve it for display in 1 time? thanks SF -- 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] attach file
Hi, How I retrieve data from DB and make it to mail attachment? I've been read PHP function about mailto but It did not contain any suggestion. SF -- 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] create data array
Hi, If I need to use data array like this $data_array = array ( array(text,1,2,3), array(text,4,5,6), array(text,7,8,9) ); all array element are contain in my database. How could I write PHP code to make this command on the fly? SF -- 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] crosstab for MS SQL
Hi, MySQL has a method to write Crosstab method but It can't use with MS SQL. Did someone know how to write SQL statement for make cross tab with MS SQL 6.5 (both ODBC and TDS connection)? Thank you SF -- 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] cross tab with mssql
Hi, I was used MS Access to make cross tab query with MS SQL. How could I do this with PHP? I was used syntax of MySQL but It did not work. Thank you, SF This is an example data: Customer#Bill date Bill amount --- A12345 21/9/20011000 B56789 21/9/20011000 A12345 22/9/20011000 A12345 23/9/20011000 B56789 23/9/20011000 This is the result I need. Customer#21/9/2001 22/9/2001 23/9/2001 --- A123451000 1000 1000 B567891000 1000 -- 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] join 2 db
Hello, I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to select data from 2 table with separate in 2 database name. How could I do this? here is some example. DB#1 DB#2 |-- Table#1-in-DB#1 |-- Table#1-in-DB#2 |--field#1-in-Table#1-in-DB#1 |--field#1-in-Table#1-in-DB#2 |--field#2-in-Table#1-in-DB#1 |--field#2-in-Table#1-in-DB#2 The result may contain data which the key of any field in Table of each DB. Thanks SF -- 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] db's war
hi I'd like to survey php commnunity about how do you think about merge between informix and ibm? Did there remain only 2 major dbms (oracle and db2)? do you think MySQL will be the leader with next version 4? SF -- 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] join 2 db
Hi, I'd like to retrieve data which contain in 2 db. How could I do? db1-table-in-db1-field-in-table-in-db1 db2-table-in-db2-field-in-table-in-db2 I'd not extract data to new table because I'd like to retrieve data only. thanks SF -- 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] text area handle
Hi, I know this group for PHP-DB, but I could not find any help from PHP-Manual about Text Area Handle. I'd like to accept input with multi-line text box (use textarea quote). How could I get each row value in text area. If someone have better idea to input multiple row in one time and retrieve into SQL Statement with PHP. Example: +---+ | ABC | | DEF | SearchFill value in text area and then press Search. (Put each value | GHI | into SQL statement; using in Where clause) +---+ Thanks SF -- 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] successful connect to MS SQL
Dear, I am very appreciate to let someone known. I have been successful connect PHP (on Linux) to MS SQL 6.5 (on NT). This is my configuration: - Linux Red Hat 6.2 - Apache 1.3.20 /w MOD_SSL - PHP 4.0.6 - FreeTDS 0.52 (It make PHP directly connect to M$ SQL.) - M$ SQL 6.2 on NT 4.0 Best Regards, Sommai Fongnamthip -- 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] odbc.ini
Hi, Could someone tell me how to write odbc.ini in Linux and related library to connect MS SQL on NT? Thanks Sommai Fongnamthip -- 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] best way connect MS SQL
Hi, I wonder which the best way to connect PHP from Linux to MS SQL on NT? - freeTDS - ODBC (iODBC, unixODBC, MyODBC) I was still can not connect with anyone! Regards, Sommai Fongnamthip -- 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] MS SQL connect by ODBC
Hi, Did someone ever connect PHP (on Linux box) to MS SQL (on NT box) via ODBC (iODBC or unixODBC)? How to config and writing code in PHP? thanks SF -- 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] MS SQL 6.5 connection
Hi, I've been setting PHP 4.0.6 with apache 1.3.20 in Linux Red Hat 6.2 to connect MS SQL 6.5 via TDS4.2 (freetds-0.51). Why I can't connect to MS SQL 6.5? here my code in php ? $conn = SQLSERVER; // host or connection name in /usr/local/freetds/interf$ $myuser = sa; $mypass = ; $dbc=mssql_connect($conn, $myuser, $mypass) or die (Unable to connect MS SQL); ? here is freetds config SQLSERVER query tcp tds4.2 203.144.255.71 1443 master tcp tds4.2 203.144.255.71 1443 Regards, Sommai Fongnamthip -- 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] ms sql connect
Hello, I'd like to use MS SQL 6.5 on NT from PHP-4.0.6 from Linux. I was config FreeTDS (use ver 4.2) and setup interfaces file already. I'm still cannot login to MS SQL 6.5. Here is my config. - Linux Red Hat 6.2 (use different IP with NT-Box) - Apache 1.3.20 - PHP 4.0.6 - FreeTDS 0.51 (config ver 4.2) - NT 4.0 (service pack 5) - MS SQL 6.5 interface file in /usr/local/freetds myserver query tcp tds4.2 127.0.0.1 1433 master tcp tds4.2 127.0.0.1 1433 php code ? $host = myserver; $myuser = sa; $mypass = ; $numero=mssql_connect($host, $myuser, $mypass) or die (Unable to connect to database.); echo (ConnectID: $numerobr\n); ? Regards, Sommai Fongnamthip
RE: [PHP-DB] PHP and Informix installation
Halo, How could I set up Informix driver in my Linux Server? SF At 13:26 27/7/2001 -0500, Muciño Zúñiga Marco Antonio wrote: OK, I set my LIBS environment variable to my esql -libs result and the confire shell is OK now, but now I get the next error when running the make command: # make === src make[1]: Entering directory `/tmp/apache_1.3.20' make[2]: Entering directory `/tmp/apache_1.3.20/src' === src/os/unix gcc -c -I../../os/unix -I../../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0 .6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp /php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../../lib/e xpat-lite -DNO_DL_NEEDED `../../apaci` os.c gcc -c -I../../os/unix -I../../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0 .6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp /php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../../lib/e xpat-lite -DNO_DL_NEEDED `../../apaci` os-inline.c rm -f libos.a ar cr libos.a os.o os-inline.o true libos.a === src/os/unix === src/ap gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_cpystrn.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_execve.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_fnmatch.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_getpass.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_md5c.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_signal.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_slack.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_snprintf.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_sha1.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_checkpass.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_base64.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED `../apaci` ap_ebcdic.c rm -f libap.a ar cr libap.a ap_cpystrn.o ap_execve.o ap_fnmatch.o ap_getpass.o ap_md5c.o ap_si gnal.o ap_slack.o ap_snprintf.o ap_sha1.o ap_checkpass.o ap_base64.o ap_ebcdic.o true libap.a === src/ap === src/main gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED
Re: [PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)
Hi, I have oracle 8i in Linux server. How could I connect it with PHP (on other server)? SF At 16:57 26/7/2001 -0500, Lee Whatley (System Admin) wrote: Here is a patch that will allow configure to properly detect oracle 9i If your mail server filters out attachments you can download it from http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch The patch should be applied from directly outside of the php source tree. I am not a coder by any means so I hope this doesn't break anything. -Lee Thies C. Arntzen wrote: On Thu, Jul 26, 2001 at 02:21:02PM -0500, Lee Whatley (System Admin) wrote: If I try to use ocilogon(scott,tiger); I get the following: Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12546 If its giving me an ORA-12546 error then I am assuming it is at least trying to talk to the database. I guess it must be a library incompatibility issue. no - 12546, 0, TNS:permission denied // *Cause: User has insufficient privileges to perform the // requested operation. // *Action: Acquire necessary privileges and try again. please make sure that the user that runs apache can actually access $ORACLE_HOME and all needed files withing! tc Thies C. Arntzen wrote: if phpinfo says oci8 is included than it _is_. the libraries used thing might (and probably is) broken. just try calling ocilogon($user,$pw); and see what it does! tc--- ./php-4.0.6/configure.orig Thu Jul 26 16:22:42 2001 +++ ./php-4.0.6/configure Thu Jul 26 16:30:31 2001 @@ -573,8 +573,8 @@ directory. If unspecified, the bundled MySQL library will be used. ac_help=$ac_help - --with-oci8[=DIR] Include Oracle-oci8 support. Default DIR is - ORACLE_HOME. + --with-oci8[=DIR] Include Oracle-oci8 (oracle 8i and 9i) support. + Default DIR is ORACLE_HOME. ac_help=$ac_help --with-adabas[=DIR] Include Adabas D support. DIR is the Adabas base install directory, defaults to /usr/local. @@ -31541,6 +31541,8 @@ test -z $OCI8_VERSION OCI8_VERSION=7.3 elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then OCI8_VERSION=8.1 + elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then + OCI8_VERSION=9.0 elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then OCI8_VERSION=8.0 elif test -f $OCI8_DIR/lib/libclntsh.a; then @@ -31934,7 +31936,7 @@ ;; - 8.1) + 9.0) case clntsh in c|c_r|pthread*) ;; --- ./php-4.0.6/ext/oci8/config.m4.orig Thu Jul 26 16:22:51 2001 +++ ./php-4.0.6/ext/oci8/config.m4 Thu Jul 26 16:24:34 2001 @@ -7,6 +7,8 @@ test -z $OCI8_VERSION OCI8_VERSION=7.3 elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then OCI8_VERSION=8.1 + elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then + OCI8_VERSION=9.0 elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then OCI8_VERSION=8.0 elif test -f $OCI8_DIR/lib/libclntsh.a; then @@ -72,6 +74,12 @@ ;; 8.1) + PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD) + PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD) + AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ]) + ;; + + 9.0) PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD) PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD) AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ]) -- 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] draw graph
Dear, How could I draw graph with gd by using PHP code with custom log scale? Sommai Fongnamthip -- 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 and informix interface
Hi, I've been known that PHP could connect to oracle or informix. But when I try to configure PHP, it tell me that there are some library required. How could I find oracle or informix support library for PHP? Sommai Fongnamthip -- 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] new data detect
Hi, I decide to make real time application (like stock market or online news). How could I know when new data arrive to table and retrieve them to display or update in web page? Sommai Fongnamthip -- 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] report style printing
Hi, When I retrieve data to display on web with PHP, it can print out from web in Browser Stlye. How could we have some PHP code to retrieve current display data into PC and print it with some Custom Report Style? Sommai Fongnamthip -- 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]