Re: [PHP-DB] configure PHP4 with sybase-ct
I am on a lan and i would like to know how to use PHP's get_meta_tags function though my proxy. Can someone write me some sample code. Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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] database synchronizing
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Benny K. Putera) wrote: I have 2 systems, local and internet. I want my Internet database is updated from local database. How can I make this through php script? See the manual for your DBMS for info on terms like replication, backup, mirroring, etc. -- CC -- 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] IMPORT DATA
hello all, did anyone know on how to import data from one database to another using Mysql? Thanks
Re: [PHP-DB] ora 12154 tns problems
Try to make listener.ora file by net8assistant jarry Laurent GARCIA wrote: ** Top Secret ** ** High Priority ** i have windows2000 server, iis5.0, oracle client 8.0.5 and php 4.0.3pl1 i have oci8 and oracle installed i can access to oracle by sqlplus and sqlnet tnsnames.ora is ok sqlnet.ora is ok when i do phpinfo() , coi8, oracle installed but i have this error Warning: _oci_open_server: ORA-12154: TNS:l'adresse symbolique n'a pas pu être résolue in includes/php-dbi.inc on line 50 Error connecting to database: Unknown error thanx for your help because i don't know why i may do now? salutations distinguees laurent Garcia -- 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] configure PHP4 with sybase-ct
[Lester June Cabrera [EMAIL PROTECTED]] Hi, When I run configure in my Solaris box ./configure --with-nsapi=path of iPlanet --enable-libgcc --with-mysql=path of my MySQL --enable-track-vars --enable-short-tags --enable-asp-tags --with-sybase-ct=path of freetds ... I got the following error: checking whether the C++ compiler (c++ -R/usr/ucblib -L/usr/ucblib -R/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2 -L/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2 -R/usr/local/mysql/lib -L/usr/local/mysql/lib -R/usr/local/freetds/lib -L/usr/local/freetds/lib) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. We have here GNUgcc 2.8.1 installed. Should I install other compiler? Take a look at the config.log file to see the error message from the compiler or wherever. It may be a simple fix. - Stig -- Stig Sæther Bakken [EMAIL PROTECTED] Fast Search Transfer ASA, Trondheim, Norway -- 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] PostgreSQL7.1: It's worth to upgrade.
You have forgotton to mention new SQL features such as outer joins. Postgres have been supporting many advanced sql features for a long time those were not supported by other databases. Anuradha On Tue, 24 Apr 2001, Yasuo Ohgaki wrote: Hello PostgreSQL users, I'm testing PostgreSQL 7.1 and PHP4.0.4pl1 on Linux. It's really worth to upgrade. Besides PostgreSQL 7.1 supports any size of text, WAL, many bug fixes, better pg_dump/restore, etc. PostgreSQL 7.1 can provide more backends on the same box. A box, which could set to max 70 or less backends, can set upto 3000+ backends. The box would not be able to handle 3000 db connections, but it is really nice to have more db connections for web applications. 7.1 also seems much faster than 7.0.3. Text type with large data can consume a lot of CPU time. BLOB is suitable to store really large data. If you are using Windows, you are better to stay with 7.0. You will see error message with pg_errormessage() even if there is no errors. Wait or compile php_pgsql.dll with 7.1 libpq. (I don't have environment to compile it. If anyone has php_pgsql.dll with 7.1 libpq for PHP4.0.4pl1, could you tell where to get or send it to me?) -- Yasuo Ohgaki -- 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] How to randomly select data in a field. Please help newbie.
Well the only way to do this properly is a cron job. have a look at http://forums.devshed.com/showthread.php?threadid=13642forumid=5 hope it helps MAX [EMAIL PROTECTED] schrieb im Newsbeitrag 002301c0d2c0$b49b3c00$0300a8c0@cv2">news:002301c0d2c0$b49b3c00$0300a8c0@cv2... Hi, I'm newbie from Indonesia. Your query has helped me to create random text using PHP and MySQL. Could you please give me an example script for random text, the text changes in every 24 hours/every 7 o'clock in the morning not after refresh/reload. Thanks for your help. Max Indonesia - Original Message - From: Johannes Janson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 30, 2001 6:56 PM Subject: Re: [PHP-DB] How to randomly select data in a field. Please help newbie. Hi, you could do the random selection in MysSQL if you use it using a query like this. SELECT FieldWithURL FROM YourTable ORDER BY RAND() LIMIT 0,1; This will give you a random field. If you want more fields you have to set different values for the limit. Like LIMIT 0,5 for the first 5 row. Just if you don't know the syntax of LIMIT: limit 'StartingPoint', 'NumberOfRows' hope it helps Johannes Greg K [EMAIL PROTECTED] schrieb im Newsbeitrag 9cfe9n$ggd$[EMAIL PROTECTED]">news:9cfe9n$ggd$[EMAIL PROTECTED]... Can someone explain to me the best way to randomly select data from field that consist of urls. The fields consist urls that are images of people. I believe I have to setup that field as a array and turn it into a interger. But I have no experience doing this can someone sort of give me a example on how I would do this . Thank you .. Your Help would be well appreciate it .. -- 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 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] mysql-php
hi, I'm a newbie from Italy I use php with mysql and I need to find a way to visualize the difference between two dates. For ex in a row I have column [A] and column [B] [A] 2001-05-02 10:00:00 [B] 2001-05-02 10:01:30 If I use SELECT TIME_FORMAT([B]-[A], '%H:%i:%s') result is 00:01:30 But it's the same if I use SELECT TIME_FORMAT([A]-[B], '%H:%i:%s') why? I need a - (minus)! Thanks -- 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] creating a downloadable file ...
hi, i have a table that is populated from a database. the only problem with it is that the table is quite large. i'd like to give the user to the option to download the file in csv format ... can anybody point me in the right direction ? Steve Brett Internal Development tel: 4251 EMIS Ltd. Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, please delete this message, and notify us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my firm or employer unless otherwise indicated by an authorised representative independently of this message. Egton Medical Information Systems Limited. Registered in England. No 2117205. Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth, Leeds, LS18 4RF -- 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] Sessions ???
Dave, What you need to do is make sure that the variable: $topidID is being set to a value first (before you register it you must get it from the table. Once it is set you need to register it as you did BUT WITHOUT the $. So it will say: ? session_start(); session_register(topidID); ? Make sure that session_start is ALWAYS before any headers in your html page, BUT register does NOT have to be. It can be declared anywhere in the page as long as you have set the value in it already. Also, on every page that will ever access topidID you must have session_start() at the top. But not session_register, as the value has already been registered. HINT: if you want to change the value of topidID just set it's value and then call a register right after you do that. Hope this helps! DC [EMAIL PROTECTED] 05/02/01 07:53AM Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. ? session_start(); session_register($topidID); ? $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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] Sessions ???
Thanks Steve; I now have this in a session file in my tmp dir topicID|s:1:8; Now how do i get the link to read http://localhost/forums/view.php?topicID=8 i think its along the lines of http://localhost/forums/view.php3?PHPSESSIONID?topicID I am banging away, the 4 books i have on Php are useless when it comes to session and there usage. Thanks for the help Dave C Steve Brett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... try session_register(topidID); without the $ Steve -Original Message- From: DC [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 13:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] Sessions ??? Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. ? session_start(); session_register($topidID); ? $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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 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] Sessions ???
Hola. Quiero saber que debo hacer para poder conectar a Informix a través de php4. De antemano, gracias por la ayuda. John Molano ---Original Message--- From: Angie Tollerson Date: Wednesday, May 02, 2001 08:26:28 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Sessions ??? Dave,What you need to do is make sure that the variable: $topidID is being set to a value first (before you register it you must get it from the table. Once it is set you need to register it as you did BUT WITHOUT the $. So it will say:?session_start();session_register("topidID");?Make sure that session_start is ALWAYS before any headers in your html page, BUT register does NOT have to be. It can be declared anywhere in the page as long as you have set the value in it already. Also, on every page that will ever access topidID you must have session_start() at the top. But not session_register, as the value has already been registered. HINT: if you want to change the value of topidID just set it's value and then call a register right after you do that. Hope this helps! "DC" [EMAIL PROTECTED] 05/02/01 07:53AM Hi AllI have a ? about setting a session.I have a functions.inc file and at the top have put my session statment thatlooks like this.?session_start();session_register("$topidID");?$topicID comes from my mysql db.What i am trying to do is set the $topicID of my message board so that whena sucessful post has been made the visitor can click on a link that show theright board by topicID.so the link will look like this...http://localhost/forums/view.php?topicID=3 I am banging away trying to make this workAny help in the meantime is as always appreciatedThank You In Advancedave C-- 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] _IncrediMail - Email has finally evolved - Click Here
Re: [PHP-DB] Sessions ???
Doh! I meant there is NO dire need Joe Brown [EMAIL PROTECTED] wrote in message 9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]... For this operation there is dire need for session management. And remember the default variable order EGPCS may cause you trouble if you're sending a put variable across with the same name as a session variable. Session vars take presidence in the global scope. http://localhost/forums/view.php?topicID=3 The session var $topicID will override this put variable. $topicID=session var value //your 3 may not be here. $HTTP_GET_VARS[topicID]=3 //you can still find your 3 here. Session variables are good for maintaining information from one page to the next, avoiding the need for the client to keep sending the same information over and over again. In either event, I recommend useing a different session variable name than the put variable's name, unless you use $HTTP_GET_VARS/$HTTP_SESSION_VARS accordingly. -Joe DC [EMAIL PROTECTED] wrote in message 9covu3$p6g$[EMAIL PROTECTED]">news:9covu3$p6g$[EMAIL PROTECTED]... Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. ? session_start(); session_register($topidID); ? $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- 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 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_tableprivileges help required
Could someone supply simple examples of how this command works. I am trying to use it like this - $conn=odbc_connect(poinv,,); $result=odbc_tableprivileges($conn,pt_mstr,%,%); odbc_result_all($result); but this returns Warning: SQL error: , SQL state 0 in SQLTablePrivileges in /opt/apache/lib/htdocs/poinv/test.php on line 9 Warning: Supplied argument is not a valid ODBC result resource in /opt/apache/lib/htdocs/poinv/test.php on line 11 So my understanding of this is obviously incorrect Thanks Mark # Mark Newnham Application Design Associates, Inc 6021 S.Syracuse Way #302 Englewood, CO 80111, USA http://www.adacorp.com # -- 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] pgsql 7.1 build
Hi there, I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and get the following build error: gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' /bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql -I/net/clear1/home/rpatters/php-4.0.5/main -I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include -I/net/clear1/home/rpatters/php-4.0.5/Zend -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse -I/net/clear1/home/rpatters/php-4.0.5/TSRM -I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -c pgsql.c pgsql.c: In function `_notice_handler': pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from pointer target type pgsql.c: In function `_rollback_transactions': pgsql.c:167: `pgsql_globals' undeclared (first use this function) pgsql.c:167: (Each undeclared identifier is reported only once pgsql.c:167: for each function it appears in.) gmake[3]: *** [pgsql.lo] Error 1 gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext' gmake: *** [all-recursive] Error 1 Worked ok with PostgreSQL 7.0.3 Any ideas? Thanks, Ron Patterson USA.NET Get free email and a permanent address at http://www.netaddress.com/?N=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-DB] pear db and pgsql
i'm having a hell of a time figuring out how to connect to a postgresql database using the pear db abstraction...here's some code snippets: with mysql (works fine): require_once('DB.php'); $db = DB::connect(mysql://username:password@localhost/audio); if (DB::isError($db)) { print $db-getMessage(); } $select_query = SELECT * FROM items; $result = $db-query($select_query); while ($row = $result-fetchRow()) { print $row[1]BR; } $db-disconnect(); with pgsql (dies with this error: DB Error: unknown error Fatal error: Call to undefined function: query() in /path/pg_test.php on line 8) require_once('DB.php'); $db = DB::connect(pgsql://username:password@localhost/audio); if (DB::isError($db)) { print $db-getMessage(); } $select_query = SELECT * FROM items; $result = $db-query($select_query); while ($row = $result-fetchRow()) { print $row[1]BR; } $db-disconnect(); both databases exist, along with the tables$10 says i'm being dumb, and need to put the port # someplace on the postgres connect, but i can't seem to put it in the right place. tia, 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]
[PHP-DB] Re: [PHP] MySQL fulltext indices and phrase search
Jens Kisters [EMAIL PROTECTED] wrote: Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to look for a string like foo bar ? if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or bar, but not both of them separated by a space. My guess is that the organization of the index doesn't allow this kind of search as it's based on single words , but maybe one of you has a better idea than to select the rows that contain both and hit those with LIKE '%foo bar%' Perhaps you should ask on the mysql list. List-Subscribe: mailto:[EMAIL PROTECTED] -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ -- 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] MySQL fulltext indices and phrase search
Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to look for a string like foo bar ? if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or bar, but not both of them separated by a space. My guess is that the organization of the index doesn't allow this kind of search as it's based on single words , but maybe one of you has a better idea than to select the rows that contain both and hit those with LIKE '%foo bar%' -- Grüße aus dem schönen Kleve Jens Kisters rosomm et partner Agentur für neue Medien GmbH Dienstleistungszentrum am Weißen Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau Telefon: 02821 - 97856-20 Telefax: 02821 - 97856-77 [EMAIL PROTECTED] http://www.rosomm-partner.de -- 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] Date Ranges
Hi, I'm working on a event calendar and some events span more than one day. I would like to store a date range like 2001-02-05 thru 2001-07-05 so when I do a query for the current day the event would appear for all the days in the range. I hoping someone can point me to some documentation or tutorials on this. Thanks in advance, Mike
[PHP-DB] updating database on internet server
I have 2 systems, local and internet. I want my Internet database is updated from local database. How can I make this? Regards; Benny. -- 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] open foxpro database
I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : ? if (dbase_open(/home/benny/test/employee.dbf,0)) { for ($i=1; $i=dbase_numrecords($open); $i++) { $rec = dbase_get_record($db, $i); $nf = dbase_numfields($db); for ($j=0; $j $nf; $j++) { print $rec[$j].br\n; } } } ? Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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: [PHP] RE: [PHP-DB] open foxpro database:solved
Thank's a lot. I make the employee.dbf free table. And it's work. Regards; Benny. -Original Message- From: Scott Bernard [mailto:[EMAIL PROTECTED]] Sent: 03 Mei 2001 8:44 To: Benny; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] RE: [PHP-DB] open foxpro database Try it again, but make the employee.dbf free table, or just making it foxplus. -Mensaje original- De: Benny [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 02 de Mayo de 2001 07:03 a.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] open foxpro database I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : ? if (dbase_open(/home/benny/test/employee.dbf,0)) { for ($i=1; $i=dbase_numrecords($open); $i++) { $rec = dbase_get_record($db, $i); $nf = dbase_numfields($db); for ($j=0; $j $nf; $j++) { print $rec[$j].br\n; } } } ? Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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 General 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] open foxpro database
Your problem is caused by file name writing (because filename is case-sensitive). PHP can read any FoxPro's Tables (free tables or databases tables). Regards, Abdul Kadir - Original Message - From: Benny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 9:12 AM Subject: [PHP-DB] open foxpro database I used function dbase_xxx to access foxpro database (.dbf) but it's not work. Here is my code : ? if (dbase_open(/home/benny/test/employee.dbf,0)) { for ($i=1; $i=dbase_numrecords($open); $i++) { $rec = dbase_get_record($db, $i); $nf = dbase_numfields($db); for ($j=0; $j $nf; $j++) { print $rec[$j].br\n; } } } ? Everytime I call this page there's a message : Warning: unable to open database /home/benny/test/employee.dbf in /home/benny/htdocs/foxpro.php on line 2 I used php 4.0.4 and Visual Fox Pro 5.0. Before that I have mounted my foxpro dbf file to my linux in the /home/benny/test directory. Is there anything wrong? Anyone could help me? Regards; Benny. -- 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] Uploading Images
Hi All I want to upload images to my server and name them as found in my local machine. I am able to upload them using the copy function but the name on the server is not the same on my local machine. How can I go about this Thanks -- 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] pgsql 7.1 build
I haven't built 4.0.5 with PostgreSQL7.1, but I built CVS source with V7.1. Last night, it compiles with warning message. It seems working, not tested. For the time being, how about use latest CVS snapshot? (And report problems, so that we can get stable postgresql module for 4.0.6?) Regards, -- Yasuo Ohgaki Ron Patterson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and get the following build error: gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' /bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql -I/net/clear1/home/rpatters/php-4.0.5/main -I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include -I/net/clear1/home/rpatters/php-4.0.5/Zend -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok -I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse -I/net/clear1/home/rpatters/php-4.0.5/TSRM -I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -c pgsql.c pgsql.c: In function `_notice_handler': pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from pointer target type pgsql.c: In function `_rollback_transactions': pgsql.c:167: `pgsql_globals' undeclared (first use this function) pgsql.c:167: (Each undeclared identifier is reported only once pgsql.c:167: for each function it appears in.) gmake[3]: *** [pgsql.lo] Error 1 gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext' gmake: *** [all-recursive] Error 1 Worked ok with PostgreSQL 7.0.3 Any ideas? Thanks, Ron Patterson USA.NET Get free email and a permanent address at http://www.netaddress.com/?N=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] Migrating from InterBase 4.0 to 6.0
Hi all, I need to migrate a database from InterBase 4.0 to 6.0 . Question is has anybody done this and what are the snafus !! The migration docs for 6.0 only seem to mention migration from 5.0 !! I would imagine a complete export from 4.0 and import into 6.0 would be the way to go. Any suggestions would be appreciated Regards Steve -- --- Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] Proxy
I am behind a LAN and i would like to know to use PHP's get_meta_tags function though a proxy. Can someone write me the help or write me the code thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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]