Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Hans Lellelid
Hi Gerard, Thanks for the reply. I'm writing a db abstraction layer driver for MySQLi. I'm glad to finally get a chance to play around with these new functions, but am completely stumped by this question: Is there no way to get back a standard resultset when using prepared statement queries?

Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Georg Richter
Am Di, den 26.10.2004 schrieb Hans Lellelid um 12:57: > Ooops, I guess I should have searched the list itself; I did some google > searches to no avail. This is really unfortunate. This API sucks! Prepared api calls use a binary protocol, which is totally different from the "old" protocol.

RE: [PHP-DB] gdbm locking problem

2004-10-26 Thread Norland, Martin
The point is it was a simple test case created to test if locking was working, the results of which show that for whatever reason - it is not. The point wasn't to make a meaningful script. He's obviously trying to call a single script simultaneously, or work on a single database from multiple scr

Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Hans Lellelid
Hi Georg, > Am Di, den 26.10.2004 schrieb Hans Lellelid um 12:57: > >> Ooops, I guess I should have searched the list itself; I did some google >> searches to no avail. This is really unfortunate. This API sucks! > > > Prepared api calls use a binary protocol, which is totally different > from t

RE: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Norland, Martin
The functions you want exist in php5, if that's an option: http://us2.php.net/manual/en/ref.mysqli.php -> http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not

Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Gerard Samuel
Hans Lellelid wrote: Hi Georg, Am Di, den 26.10.2004 schrieb Hans Lellelid um 12:57: Ooops, I guess I should have searched the list itself; I did some google searches to no avail. This is really unfortunate. This API sucks! Prepared api calls use a binary protocol, which is totally

Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Gerard Samuel
Norland, Martin wrote: The functions you want exist in php5, if that's an option: http://us2.php.net/manual/en/ref.mysqli.php -> http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php No this is not an option. mysqli_fetch_* needs a "result" resource id to work. mysqli statement functions

Re: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Hans Lellelid
Hi Gerard, > I believe he is talking about -> > http://dev.mysql.com/doc/mysql/en/SQLPS.html > But IMHO, I think emulating via php would be faster, as that is > alot of talking to a database to get the job done, especially if the > database is on a remote host. Ahh, ok. Yes, this is interesting,

RE: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Norland, Martin
Wishful thinking on my part, since it specified no version info because it was likely only in CVS - I thought maybe it was *really new* :). That is unfortunate then, definitely. Perhaps a mysqli_stmt_fetch_assoc() is forthcoming :( - Martin Norland, Database / Web Developer, International Outrea

[PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Vinayakam Murugan
Hi I have a PHP-mysql website in which I want to implement search functionality. Through the content management section, the user can enter data into the database. Here he can enter HTML tags and embedded CSS stylesheets also. Now the problem is while searching the table, I want to show couple o

Re: [PHP-DB] delete time related data inside a table within 1 hour

2004-10-26 Thread Mark-Walter
Hi Martin, > http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html says > that's the right format. Are you sure you're storing the time and not > just the date? I'd wager that it will delete immediately if you are > only storing the date. I agree as it is the right format but when I us

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Robby Russell
On Wed, 2004-10-27 at 00:33 +0530, Vinayakam Murugan wrote: > Hi > > I have a PHP-mysql website in which I want to implement search functionality. > > Through the content management section, the user can enter data into > the database. Here he can enter HTML tags and embedded CSS stylesheets > a

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Robby Russell
On Tue, 2004-10-26 at 16:57 -0700, Robby Russell wrote: > On Wed, 2004-10-27 at 00:33 +0530, Vinayakam Murugan wrote: > > Hi > > > > I have a PHP-mysql website in which I want to implement search functionality. > > > > Through the content management section, the user can enter data into > > the

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Bastien Koert
regex replace them all bastien From: Robby Russell <[EMAIL PROTECTED]> To: Vinayakam Murugan <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Implementing search in a database driven website Date: Tue, 26 Oct 2004 16:57:36 -0700 On Wed, 2004-10-27 at 00:33 +0530, Vinayakam Murugan w

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Vinayakam Murugan
Thanks, Robby. This worked. However I wasn't able to get any documentation on the siU parameters used in the command as in > $string= preg_replace("']*>.*'siU",'',$string); Any pointers. -- Warm Regards Vinayak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Jason Wong
On Wednesday 27 October 2004 03:11, Vinayakam Murugan wrote: > Thanks, Robby. This worked. However I wasn't able to get any > documentation on the siU parameters used in the command as in > > > $string= preg_replace("']*>.*'siU",'',$string); > > Any pointers. manual > Regular Expression Functions