php-general Digest 24 Nov 2009 14:56:37 -0000 Issue 6458

2009-11-24 Thread php-general-digest-help
php-general Digest 24 Nov 2009 14:56:37 - Issue 6458 Topics (messages 300044 through 300060): Re: function not returning query 300044 by: Philip Thompson 300046 by: Allen McCabe 300047 by: Ashley Sheridan 300048 by: Ashley Sheridan Re: Query based on Server

Re: [PHP] function not returning query

2009-11-24 Thread Ashley Sheridan
On Mon, 2009-11-23 at 21:53 -0800, Allen McCabe wrote: Okay, suddenly I got it to filter the results, but I still can't figure out where this part of the query is coming from, at the end of the query string in the URL, I have this filter.x=0filter.y=0. No where in my form do I have a field

Re: [PHP] function not returning query

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 02:11 -0800, Allen McCabe wrote: I am! Will these extra query variables cause any problems or should I use standard submit inputs? Thanks Ashley! On Tue, Nov 24, 2009 at 1:10 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Mon,

[PHP] Metadata - mysqli

2009-11-24 Thread keyser soze
hi mysqli_fetch_field provide result metadata like 'column name', 'max length', 'datatype' etc but i need the comment of each column is this possible? (i guess it does't because i do a query, and that query brings to me columns and its values but not the comment metadata... but it would be very

Re: [PHP] Metadata - mysqli

2009-11-24 Thread David Otton
2009/11/24 keyser soze bajopala...@yahoo.com.ar: mysqli_fetch_field provide result metadata like 'column name', 'max length', 'datatype' etc but i need the comment of each column is this possible? The table that stores data about columns is information_schema.COLUMNS. You're looking for the

Re: [PHP] Re: My experience with the Forms Generation and Validation class

2009-11-24 Thread Martin Scotta
Guys! Here you both have a really good oportunity. You have contacted each other and say a lot, try to make something of this! Think on what you have done, design your idea, diagram a new set of classes, propose an implementation, work together and write the best form generation tool for all the

[PHP] Re: Metadata - mysqli

2009-11-24 Thread keyser soze
yes, David, thanks i know that this query, for example: select now(), item_count+10 as itemplus10, name from mytable i do not pretend that columns 1 and 2 bring to me the column_comment metadata because don't exist but it would be helpful if i can get the column_comment metadata of the column

[PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean it's taking minutes. When the dbase had 10,000 records ... search

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 08:40 -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean it's

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
On Nov 24, 2009, at 8:59 AM, Ashley Sheridan wrote: On Tue, 2009-11-24 at 08:40 -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is

[PHP] Re: PHP and XML

2009-11-24 Thread Juan
El día 23 de noviembre de 2009 13:25, Nathan Rixham nrix...@gmail.com escribió: Juan Marcelo Rodríguez Monti wrote: Hi people, I have some doubts about this topic that I'm gonna explain. I have a few sites in flash, and I was requested to write a PHP frontend to send news. I have this

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
even though the dbf has 10K records Fox can't spend minutes to found a match by the way, its very strange to have 35 columns in a table/dbf or whatever pay attention to the comment of Ashley in Fox, you should: SELECT directory INDEX on phone_number to idx_directory_phone - or - INDEX on

[PHP] Question about includes

2009-11-24 Thread Al
I'm having an include problem on a shared host and need the answer to the following to cover a key point. I'm getting this error: Warning: include_once() [function.include]: Failed opening 'Net/SMTP.php' for inclusion include_path='.:/usr/lib/php:/usr/local/lib/php:/home1/youstart/php/') in

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Your post definitely gives me hope. It's possible I'm doing something wrong! I definitely have the foxpro database indexed. I use this FoxPro command ... INDEX ON PHONE TAG PHONE I do have a .CDX file present for the Database and if I MODIFY STRUCTURE and I can see the INDEX present on

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
i will try to help you but think i'm old in Fox but new in php and sadly never used php+fox so, reading your code i see you are scanning the whole dbf file from php Fox cant help you in this way if there is not another option for scan a dbf the row by row method is very slow Rahul S. Johari

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
Rahul, my friend i found this in a first search perhaps it be helpful http://www.yinfor.com/blog/archives/2008/01/php_connect_dbf_file.html Rahul S. Johari escribió: I do believe that what I'm doing is scanning the foxpro dbase row by row to get the match ... which is why it's returning the

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
I do believe that what I'm doing is scanning the foxpro dbase row by row to get the match ... which is why it's returning the results very slow. But I don't know if there's any other way to do this. Basically the FoxPro DBF has 75,000 records and I have to search for the one row which

[PHP] Re: PHP and XML

2009-11-24 Thread Nathan Rixham
Juan wrote: El día 23 de noviembre de 2009 13:25, Nathan Rixham nrix...@gmail.com escribió: Juan Marcelo Rodríguez Monti wrote: Hi people, I have some doubts about this topic that I'm gonna explain. I have a few sites in flash, and I was requested to write a PHP frontend to send news. I

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Keyser, It gets better -- I'm on a Mac OS X (Leopard)!! As far as I know, there isn't a VisualFoxPro ODBC Driver for Mac OS X. On Nov 24, 2009, at 10:11 AM, keyser soze wrote: Rahul, my friend i found this in a first search perhaps it be helpful

[PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread keyser soze
uhh, i don't know (time ago Fox was multi-platform unix/mac/dos) did you found that on the web? Rahul S. Johari escribió: Keyser, It gets better -- I'm on a Mac OS X (Leopard)!! As far as I know, there isn't a VisualFoxPro ODBC Driver for Mac OS X. On Nov 24, 2009, at 10:11 AM, keyser

Re: [PHP] Re: dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Back in 1996 FoxPro was multi-platform. The last FoxPro version released for Mac was Visual FoxPro 3.0b (1996). After that Microsoft bought FoxPro and Mac Support/Development was cut off. As of now, there are NO known ODBC Drivers for FoxPro for the Mac Platform. So that aside ... back to

Re: [PHP] Question about includes

2009-11-24 Thread Brady Mitchell
On Tue, Nov 24, 2009 at 6:22 AM, Al n...@ridersite.org wrote: This bothers since the current working directory is effectively where my original script resides; is it not? If so, doesn't the include Net/SMTP.php on line 206 look for the path relative to it and not in /home1/youstart/php/? When

[PHP] processing html forms and keeping the values

2009-11-24 Thread Merlin Morgenstern
Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How could I do this while keeping all characters? Thank you for any hint, Merlin -- PHP

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Olav
Ashley Sheridan wrote: I would assume that any indexes created on any tables would be referenced automatically by the dbms and wouldn't need to be explicitly referenced from within PHP. This is dBase (.dbf) he is asking about. There is no such thing as a DBMS in dBase. The program / driver

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Quite right. Unfortunately there doesn't seem to be any available ODBC Drivers for FoxPro available for Mac OS X either!! I'm hitting a brick wall no matter what direction I take. On Nov 24, 2009, at 12:22 PM, Olav wrote: Ashley Sheridan wrote: I would assume that any indexes created

[PHP] Re: processing html forms and keeping the values

2009-11-24 Thread Shawn McKenzie
Merlin Morgenstern wrote: Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How could I do this while keeping all characters? Thank you

Re: [PHP] processing html forms and keeping the values

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 18:14 +0100, Merlin Morgenstern wrote: Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How could I do this

Re: [PHP] processing html forms and keeping the values

2009-11-24 Thread tedd
At 6:14 PM +0100 11/24/09, Merlin Morgenstern wrote: Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How could I do this while keeping all

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Paul M Foster
On Tue, Nov 24, 2009 at 08:40:09AM -0500, Rahul S. Johari wrote: Ave, I'm connecting to a foxpro database (dbase) and simply running a search to retrieve a record. It's a very simple code. The problem is, as the database is growing, the search is becoming ridiculously slow ... and I mean

Re: [PHP] Question about includes

2009-11-24 Thread Al
Brady Mitchell wrote: On Tue, Nov 24, 2009 at 6:22 AM, Al n...@ridersite.org wrote: This bothers since the current working directory is effectively where my original script resides; is it not? If so, doesn't the include Net/SMTP.php on line 206 look for the path relative to it and not in

Re: [PHP] processing html forms and keeping the values

2009-11-24 Thread Merlin Morgenstern
Ashley Sheridan wrote: On Tue, 2009-11-24 at 18:14 +0100, Merlin Morgenstern wrote: Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How

Re: [PHP] processing html forms and keeping the values

2009-11-24 Thread Paul M Foster
On Tue, Nov 24, 2009 at 06:14:01PM +0100, Merlin Morgenstern wrote: Hi there, I am trying to redirect a user back to a html form if a validation failes. The form shoult then hold all entered values. So far I did this over $_GET, but there is a 100 Character limitation. How could I do this

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Olav
Rahul S. Johari wrote: Quite right. Unfortunately there doesn't seem to be any available ODBC Drivers for FoxPro available for Mac OS X either!! I'm hitting a brick wall no matter what direction I take. Convert to SQLite and don't look back ;) Unless your DBF files are still in use in

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Rahul S. Johari
Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using PHP which is running on an Apache Web Server on Mac OS X. I

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Ashley Sheridan
On Tue, 2009-11-24 at 12:59 -0500, Rahul S. Johari wrote: Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using

Re: [PHP] dbase_get_record_with_names; Very slow search!!!

2009-11-24 Thread Paul M Foster
On Tue, Nov 24, 2009 at 12:59:35PM -0500, Rahul S. Johari wrote: Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using

[PHP] string concatenation with fgets

2009-11-24 Thread aurfalien
Hi all, I'm trying to append some text to what I read from a file. My code; $file = fopen(foo.txt, r); while (!feof($file)) { $line = fgets($file); print $line.sometext; } fclose($file); foo,txt; a b c d e f g And when I run the script, it looks like; a sometextb

Re: [PHP] string concatenation with fgets

2009-11-24 Thread ryan
Is this what you want $file = fopen(test.txt, r); while (!feof($file)) { $line = trim(fgets($file)); print $line.sometext\n; } fclose($file); outputs asometext bsometext csometext Ref to http://us3.php.net/manual/en/function.fgets.php. Reading ends when /length/ - 1 bytes have been

Re: [PHP] string concatenation with fgets

2009-11-24 Thread Nirmalya Lahiri
--- On Wed, 11/25/09, aurfal...@gmail.com aurfal...@gmail.com wrote: From: aurfal...@gmail.com aurfal...@gmail.com Subject: [PHP] string concatenation with fgets To: php-general@lists.php.net Date: Wednesday, November 25, 2009, 7:00 AM Hi all, I'm trying to append some text to what I read

Re: [PHP] string concatenation with fgets

2009-11-24 Thread aurfalien
On Nov 24, 2009, at 5:55 PM, Nirmalya Lahiri wrote: --- On Wed, 11/25/09, aurfal...@gmail.com aurfal...@gmail.com wrote: From: aurfal...@gmail.com aurfal...@gmail.com Subject: [PHP] string concatenation with fgets To: php-general@lists.php.net Date: Wednesday, November 25, 2009, 7:00 AM Hi

Re: [PHP] string concatenation with fgets

2009-11-24 Thread aurfalien
On Nov 24, 2009, at 5:52 PM, ryan wrote: Is this what you want $file = fopen(test.txt, r); while (!feof($file)) { $line = trim(fgets($file)); print $line.sometext\n; } fclose($file); outputs asometext bsometext csometext Ref to http://us3.php.net/manual/en/function.fgets.php. Reading

[PHP] Create client certificate with openssl

2009-11-24 Thread Tanveer Chowdhury
Hi all, I have an apache server and for that I created CA as the signing authority using openssl. Now I created a php page which will generate client certificates with key and will sign by CA. Now the output is in .pem . Now how to convert it in .p12 for exporting it in client browser.. Again,