[PHP-DB] Adding a PDO driver to the standard release
Hi, Not sure if I'm asking in the right place. One of our engineers wrote a PDO driver for the IBM U2 databases. Info can be found at: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612xia/ http://www.ibm.com/developerworks/db2/library/techarticle/dm-0701xia/ and there was a article at PHP developer about this: http://www.phpdeveloper.org/news/7049 Just wondering what steps would be required to get this into the standard PHP release, so that when one installs the PDO capabilities that this PDO driver comes shipped. Regards Claude Masseron Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
RE: [PHP-DB] php maximum characters in text field
Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish _ Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122
RE: [PHP-DB] php maximum characters in text field
Yes, that is the HTML and the PHP code to check. What about the php code to go to the db? Bastien Date: Fri, 12 Oct 2007 11:42:25 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field The field on the form is as such: TEXTAREA name=Customer_Description cols=100 rows=10 tabindex=44/TEXTAREA The confirmation page is: ?php echo ($_POST['Customer_Description']); ? From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:26 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text fieldAnd how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text field Date: Fri, 12 Oct 2007 11:24:14 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created.From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text fieldUnless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger _ Send a smile, make someone laugh, have some fun! Start now! http://www.freemessengeremoticons.ca/?icid=EMENCA122
Re: [PHP-DB] Remote DB Connection: Pros and Cons?
Thank you all for the responses. I think we're going to try replicating the databases with Slony. Wish me luck! Tony On 10/11/07 6:23 PM, Chris [EMAIL PROTECTED] wrote: Tony Grimes wrote: Splitting the tables probably wouldn't work. Most of the tables are used by both sites and the ones that aren't are tied to the rest by foreign keys. Most of the updates are done from the admin site, so we're toying with the idea of creating a read-only data warehouse for the website. The sync would be one way from main office db to the warehouse (say, every 10 minutes). No need to create something that has already been done. Use slony or something to replicate the database. Any updates the website does (like an event registration or profile update) would be done remotely to the office db. In this scheme the website db would be 10 minutes behind. We can live with that. When you do a registration, get it to use a remote database connection instead of the 'local' one. $local_connection = pg_connect('localhost'); $remote_connection = pg_connect('remote_server_ip'); $remote_result = pg_query($remote_connection, $query); Doing everything by remote connection would be easier, but we're worried about the performance. The only way to find out would be to test it really. As long as you have a decent connection in to the office and a decent connection on the remote end and aren't pulling through a ridiculous amount of data in queries (eg pulling through 50,000 records when you only really need 10), you should be fine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] FW: Kesalahan posting: Don Komo
Date: Fri, 12 Oct 2007 11:29:27 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] FW: Kesalahan posting: Don Komo Why do I get this everytime I post? I think Don Komo registered to this PHP list with the private email address [EMAIL PROTECTED] So since we are not a member of the googlegroup, we get these notices. The same kind of notice that anyone would get if they posted to a list for which they had not yet registered. I think he should be forced to unregister this email address. And/or be advised that it has been dropped for this reason. _ Peek-a-boo FREE Tricks Treats for You! http://www.reallivemoms.com?ocid=TXT_TAGHMloc=us
RE: [PHP-DB] php maximum characters in text field
And how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text fieldDate: Fri, 12 Oct 2007 11:24:14 -0400From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with “Undefined variable” errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AMTo: VanBuskirk, Patricia; [EMAIL PROTECTED]: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish Express yourself with free Messenger emoticons. Get them today! _ R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger
RE: [PHP-DB] php maximum characters in text field
The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122
[PHP-DB] php maximum characters in text field
Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish
Re: [PHP-DB] Adding a PDO driver to the standard release
On 10/12/07, Claude Masseron [EMAIL PROTECTED] wrote: Hi, Not sure if I'm asking in the right place. One of our engineers wrote a PDO driver for the IBM U2 databases. Info can be found at: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612xia/ http://www.ibm.com/developerworks/db2/library/techarticle/dm-0701xia/ and there was a article at PHP developer about this: http://www.phpdeveloper.org/news/7049 Just wondering what steps would be required to get this into the standard PHP release, so that when one installs the PDO capabilities that this PDO driver comes shipped. Join the -internals list and put your suggestion forward. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
The field on the form is as such: TEXTAREA name=Customer_Description cols=100 rows=10 tabindex=44/TEXTAREA The confirmation page is: ?php echo ($_POST['Customer_Description']); ? From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:26 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field And how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text field Date: Fri, 12 Oct 2007 11:24:14 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger
[PHP-DB] FW: Kesalahan posting: Don Komo
Why do I get this everytime I post? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:26 AM To: VanBuskirk, Patricia Subject: Kesalahan posting: Don Komo Anda tidak memiliki izin untuk memposting ke grup donkomo. Anda mungkin harus bergabung ke grup agar dibolehkan memposting atau grup ini mungkin tidak dapat terbuka untuk memposting. Kunjungi http://groups.google.com/group/donkomo/about?hl=id untuk bergabung atau mempelajari lebih lanjut tentang siapa yang dibolehkan memposting ke grup. Bantuan untuk menggunakan Google Groups juga tersedia di: http://groups.google.com/support?hl=id ---BeginMessage--- The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 ---End Message--- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] What is the most efficient way to store SELECT results
Robert Palmer wrote: I'm not I was clear in my question. A query returns 1,000 rows from the table. I want to store the entire result of that query in order to be able to create separate pages to return the results rather than all on one page e.g. Page 1 2 3 4 ... . Not sure if it's important but I'm using persistent connections. test out your server. create a test script to load the results into an array. keep track of memory usage. then calculate that to how much traffic that script will be seeing. so taking that into consideration, if you run separate boxes for your web server/php and db, you can balance out: lots of hits on memory on the web server or lots of disc access on the db server if you decide to go with the re-call the db server paging methods... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php