[PHP-DB] Re: question in ADODB

2003-02-21 Thread Philippe Saladin
> yes, but can you tell me how? I have read the manual, but they didn't tell > how to do so! > Look at testdatabases.inc.php in the adodb release. Basically, you would have to write something like : include("adodb.inc.php"); $conn = NewADOConnection('ado_access'); $conn->debug = TRUE; // useful f

[PHP-DB] Getting results from MySQL

2003-02-21 Thread Anders Mellström
I have a PHP<->MySQl-problem. I would be very greatful if anyone would help me. I am - with the following code - trying to get results from a database. The problem isn't recieving the results, it's where i get the results. All the information is placed far down on the site, not in top. If you're

[PHP-DB] Re: php/mysql query

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Julie Keywell) writes: > I am querying our database for 11,000 different zip codes and it seems > to be overloading MySQL. However, common sense says it shouldn't. > > My question is: > When needing to query 11,000 things, is it best to make 1 SQL statement > that has 11,000 or

[PHP-DB] Re: NotesSQL via ODBC in PHP

2003-02-21 Thread MH
Steve, I have used NotesSQL succesfully to MS Access and MS SQL, but not with PHP. The NotesSQL gives you a very basic SQL function set and to my opinion its not even worth trying it. This was with Notes 4.5.2. It could be better in later versions, I don't know. ODBC works fine, I have connect

[PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Anders mellström) writes: > I have a PHP<->MySQl-problem. I would be very greatful if anyone > would help me. I am - with the following code - trying to get > results from a database. The problem isn't recieving the results, > it's where i get the results. All the information is

[PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Snijders, Mark
hello, does anybody know if it's possible (without php) to export data from mysql to a cvs file, so i can import it in excel??? so is it possible, and if yes.. how? thanks kinds regards, Mark Snijders -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

[PHP-DB] Re: mysql to cvs file to excel

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Mark Snijders) writes: > does anybody know if it's possible (without php) to export data from > mysql to a cvs file, so i can import it in excel??? Not a cvs file, that's for sure, but I guess you mean csv. You can of course script this with other languages than php, but you can

Re: [PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Anders Mellström
Oops. Sorry about that. But I'm afraid that I don't really understand. Wouldn't I need a webserver on my local computer to view serverside-code? That I don't have. But that shouldn't be the problem since I have the same code on another page on the same ISP (as I mentioned). I'm confused ... //

Re: [PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Anders mellström) writes: > But I'm afraid that I don't really understand. Wouldn't I need a > webserver on my local computer to view serverside-code? That I don't > have. But that shouldn't be the problem since I have the same code > on another page on the same ISP (as I mention

[PHP-DB] Re: question in ADODB

2003-02-21 Thread pei_world
thank you very much -- Sincerely your; pei_world ( .::IT::. ) "Philippe Saladin" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > yes, but can you tell me how? I have read the manual, but they didn't tell > > how to do so! > > > > Look at testdatabases.inc.php

[PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
Has anyone found a way to import data through ssl into a php script? If I can pull xml formatted data through a secure socket it will save some major headaches with a problem I need to solve. $url = file("https://www.mydomain.com";); Would be ideal, but it does not work <>< Ryan Ryan James

Re: [PHP-DB] file and https

2003-02-21 Thread Jeffrey_N_Dyke
This works as of 4.3 with fopen(https://myserver.com). but i dont' think it works with file(https://myserver.com)...i may be wrong, of course. HTH Jeff "R

Re: [PHP-DB] file and https

2003-02-21 Thread Paul Burney
on 2/21/03 9:52 AM, Ryan Jameson (USA) at [EMAIL PROTECTED] appended the following bits to my mbox: > Has anyone found a way to import data through ssl into a php script? If I can > pull xml formatted data through a secure socket it will save some major > headaches with a problem I need to solve.

Re: [PHP-DB] file and https

2003-02-21 Thread 1LT John W. Holmes
> Has anyone found a way to import data through > ssl into a php script? If I can pull xml formatted > data through a secure socket it will save some > major headaches with a problem I need to solve. > > $url = file("https://www.mydomain.com";); Would > be ideal, but it does not work It does w

[PHP-DB] Firebird driver

2003-02-21 Thread Philippe Makowski
Is there a plan to have a Firebird driver ? Firebird is no longer the same as Interbase, it will have it's own libraries when the 1.5 version will be release (there is an 1.5 beta version now) Thanks -- Philippe Makowski Firebird serveur SQL open-source en français http://firebird-fr.eu.org Ma c

RE: [PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Bruno Pereira
I had the some problem and someone told me this "What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ?" And it realy helped. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Snijders, Mark [mailto:[E

Re: [PHP-DB] PHP4 on Windows & using MSSQL

2003-02-21 Thread Kevin Gordon
Hi Coolio Accessing the Windows NT server from Windows and Linux no longer causes session errors (which were like: can not find session file, header already sent and something about cookies). Trying to access Linux Server (which previously worked 100%). now gives errors (for example: Fatal error:

[PHP-DB] Re: NotesSQL via ODBC in PHP

2003-02-21 Thread Stefan Haas
Hi MH, thanks for your comment, but it seems the NotesSQL-driver is basically fine, as I vcan access the Notes-DB from QTODBC, Access and others, but NOT from php. Do you anybody involved in the ODBC development? Thanks Steve Mh schrieb: Steve, I have used NotesSQL succesfully to MS Access an

RE: [PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
Thanks all.. John - What do you mean have SSL installed? Does PHP have a SSL module? I'm already running 4.3.1 so I'm fine there. Also, this is quite database related as the intention is to access data on a remote server through a secure connection. XML is arguably a database protocol. :-) <>

[PHP-DB] testing the validity of a link

2003-02-21 Thread Matt
Does anyone know of a function, or a way for PHP to test to see if a given link is valid (meaning that the linked page actually exists). Please let me know if you know of a way. Thanks. Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

[PHP-DB] Re: testing the validity of a link

2003-02-21 Thread Peter Beckman
You could do an fopen on the URL and see if the results contain the string "404 not found" or something. Read these pages: http://www.php.net/manual/en/function.fopen.php http://www.php.net/manual/en/wrappers.php http://www.php.net/manual/en/function.stream-get-meta-data.php Looks li

[PHP-DB] How to find the autoincremented number?

2003-02-21 Thread David Chamberlin
Hey, Most of the tables I use identify things using an id which is auto-generated using autoincrement. However I can't seem to figure out a good way to find what value was generated for the ID. For example, let's say I generate a new entry and want to e-mail out a link to it and the link iden

Re: [PHP-DB] How to find the autoincremented number?

2003-02-21 Thread Leif K-Brooks
http://www.php.net/manual/en/function.mysql-insert-id.php David Chamberlin wrote: Hey, Most of the tables I use identify things using an id which is auto-generated using autoincrement. However I can't seem to figure out a good way to find what value was generated for the ID. For example, let

Re: [PHP-DB] How to find the autoincremented number?

2003-02-21 Thread David Chamberlin
Aha. I had seen that before, but disregarded it because I was trying to just use pearDB calls instead of the mysql calls. However what I noticed this time when looking through there is that there's a LAST_INSERT_ID() that I could use in a query. e.g., function addNewEntry( $stuffToPutIn ){