[PHP-DB] connection pooling
Hello List, is there anybody out there, who could help me in finding something I know from good old java: Connection Pooling. Is there a mechanism or project that provides that for PHP 5? Reason I create a 20 page pdf with data out of MySQL 4.1 (that means using the mysqli methods) where I require a couple of shots at my database. The whole process is realy slow and i think the bottleneck is the database connection. thx Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Offering alternatives in typing mistakes
Hello List, I'm currently doing a select like statement. No problem with that. But as no human being is perfect ;-) the input provided by the user is sometimes full of typing mistakes like informatoin, or informatin instead of information. I hope you know what I'm think about. Google offers you an alternative if google thinks you misspelled. Now my question, what is an algorithm for finding out which input was actually meant? I know I'll have to split the string like first letter than last letter, than second first etc. Is there a better solution, like taking the middle? I've already put some thought in it, but I see no reason to reinvent the wheel again. Has anybody any better ideas? I'm open to solutions. thx Jan Bro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] Performance in MySQL Result Question
thx folks, I pretty much thought version 1 to be the best. I' wouldn't have known how to carry the result to other pages anyway. Jan > > > Hi, > I've got a page with lot's of visitors every day and I sure hope to > get more, so I'm already thinking of performance. This is what I've > got. > > Users select one or more things out of a couple drop down menus, > no big deal. Their selection is than shown, with a limitation of > 20 results on the page. > > Now comes my question, what is better speaking of performance: > When users go on to the next page, is it better to > provide the select statement again with a different integer for > the limit? > > Or is better to do a full select without a limitation on first page. > But than I don't know how to provide the result set for the > next, next, ... page? > > What would be your choice? I'm open to suggestions, maybe somebody has > a totally different idea. The limitation of 20 is a wish of my customer. > I think, most vistors won't stay on page one, but will click thru > some pages further. The max. number of results shown should be around > 1000 hits. > > Jan > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Performance in MySQL Result Question
Hi, I've got a page with lot's of visitors every day and I sure hope to get more, so I'm already thinking of performance. This is what I've got. Users select one or more things out of a couple drop down menus, no big deal. Their selection is than shown, with a limitation of 20 results on the page. Now comes my question, what is better speaking of performance: When users go on to the next page, is it better to provide the select statement again with a different integer for the limit? Or is better to do a full select without a limitation on first page. But than I don't know how to provide the result set for the next, next, ... page? What would be your choice? I'm open to suggestions, maybe somebody has a totally different idea. The limitation of 20 is a wish of my customer. I think, most vistors won't stay on page one, but will click thru some pages further. The max. number of results shown should be around 1000 hits. Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with date solved
Hi, i managed it on my own, this is what I came up with, maybe it's usefull for one of you. It soure kept me busy. $datum_beginn="#$jahr/$monat_1/01#"; $datum_ende="#$jahr/$monat_1/$anzahl_tage_im_Monat#"; $datensatz_datum=odbc_exec($db_connection,"select * from Janbro_Termin where ((Datumsfeld >= $datum_beginn) and (Datumsfeld <= $datum_ende)) "); Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] receiving date elements from Access
oh, i've forgot to mention, I've already tried that, with the same result, sorry my mistake. Even 12.12.2002 brings back the same result. It doesn't make a difference if I use # or not. But thx anayway, i'm sure it is some dumb mistake i made. Jan on 3/9/03 4:42 PM, Jan Bro at [EMAIL PROTECTED] appended the following bits to my mbox: > $datum_beginn="2002-12-12"; > $datensatz=odbc_exec($db_connection,"select * from Termin where Datumsfeld>'#$datum_beginn#'"); > > I get an error message that data in criteria doesn't match. (free > translation) > The field Datumsfeld is a date field with the syntax DD.MM. (German way) Maybe you should try the date in the syntax the database uses, i.e., 12.12.2002? Sincerely, Paul Burney <http://paulburney.com/> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] receiving date elements from Access
Hi, i've posted this in the general list, but I've got no answer. Well I'm still hoping there is one ;-) I've got the following code: $datum_beginn="2002-12-12"; $datensatz=odbc_exec($db_connection,"select * from Termin where Datumsfeld >'#$datum_beginn#'"); I get an error message that data in criteria doesn't match. (free translation) The error def. lays in Datumsfeld >'#$datum_beginn#'. How do I get a list of all entries with a date that lay behind a certain date? I'd prefer to let the database do the job for me, rather than pulling everything out and get the relevant data with php. The field Datumsfeld is a date field with the syntax DD.MM. (German way) thx Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php