Re: [PHP-DB] cookie issue

2004-07-01 Thread Sukanto Kho
Hah?? cookie do not have any id ?? so how to identify user when same user login from 2 different PC?? I prefer Session too... and I'm used to build website using session but I found 1 problem is that ... session_id keep destroyed by my web hosting... I'm not sure what cause the problem( web hostin

Re: [PHP-DB] cookie issue

2004-07-01 Thread zareef ahmed
Hi Sukanto, Cookies do not have any id like sessions. Headers in php sent in reverse order to browser, means the last one will send first, cookies also set/sent by headers, so This statement can be true. So, try setcookie function after you write redirection line like :: header("location

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread Michael Gale
Hello, Have a look at mysqldump .. it is used for backing up tables and database. Example mysqldump --add-drop-table -c testdatabase -h 127.0.0.1 -u mysqlbk --password=mysqlbk > testdatabase.bk Michael On Thu, 1 Jul 2004 21:26:27 -0700 (PDT) Rinku <[EMAIL PROTECTED]> wrote: > I want

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread David Orlovich
Hi Rinku To dump (backup), I do the following: /usr/local/mysql/bin/mysqldump -uroot -pyourpassword --opt --all-databases > ~/backup.sql To restore, I do this: cat ~/backup.sql | /usr/local/mysql/bin/mysql -uroot -pyourpassword If you've dumped your databases in order to install a new version of

Re: [PHP-DB] cookie issue

2004-07-01 Thread Sukanto Kho
Hi Mr. Zareef, I got issue from others that : "With some browsers, setting a cookie and then redirecting with header() will not make the cookies available on the next page" I want to know how to solve that issue.. I set cookie like this : setcookie ("name",$user_name, $time+3600); but all I want

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread Cole S. Ashcraft
Try the mysqldump command zareef ahmed wrote: Hi, If you have phpmyadmin on your system you can export all your data in sql format which can be restore again by running that sql script. make sure to check complete insert checkbox at time of export operations. Revert Back with any comment or proble

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread zareef ahmed
Hi, If you have phpmyadmin on your system you can export all your data in sql format which can be restore again by running that sql script. make sure to check complete insert checkbox at time of export operations. Revert Back with any comment or problem. Zareef Ahmed --- Rinku <[EMAIL PROTECTED

[PHP-DB] How to take Backup ?

2004-07-01 Thread Rinku
I want to take backup for Mysql database. Can any of you tell me how to take Backup and how to Restore it ? Rinku __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [PHP-DB] cookie issue

2004-07-01 Thread zareef ahmed
--- Sukanto Kho <[EMAIL PROTECTED]> wrote: > Hi All, > > Do cookie variable has cookie_id and how to call it? How you set the cookie? It will be available as $_COOKIE['COOKIE_NAME']; > > Is Cookie_id same for 1 PC ?? or just in 1 browser?? It is vaid for the pc but expire time applicable. >

[PHP-DB] cookie issue

2004-07-01 Thread Sukanto Kho
Hi All, Do cookie variable has cookie_id and how to call it? Is Cookie_id same for 1 PC ?? or just in 1 browser?? How to avoid cookie not passed if using redirecting header(location:"")...sorry if I ask this before...but still havent get any suggestion. Thanx Flame

[PHP-DB] SELECT problem between MySQL 3.23 and MySQL 4

2004-07-01 Thread Chris Payne
Hi there everyone, I'm using Booleans in my searches (New to it) but it works perfectly on my local 3.23 version of MySQL, but on the main server which uses version 4 of MySQL I get an error so there's an error in my Syntax. Here's what I currently use: SELECT id, def, word, 0.2*( LENGTH

Re: [PHP-DB] Conditional explode?

2004-07-01 Thread Justin Patrin
On Thu, 1 Jul 2004 15:09:38 -0500, Matt M. <[EMAIL PROTECTED]> wrote: > > On Thu, 1 Jul 2004 14:05:49 -0500, Shiloh Madsen > <[EMAIL PROTECTED]> wrote: > > > > Can I use explode in a conditional manner? I.E., can i have it explode on a space, > > but only if the space is not encased in double quo

Re: [PHP-DB] Conditional explode?

2004-07-01 Thread Matt M.
On Thu, 1 Jul 2004 14:05:49 -0500, Shiloh Madsen <[EMAIL PROTECTED]> wrote: > > Can I use explode in a conditional manner? I.E., can i have it explode on a space, > but only if the space is not encased in double quotes? I would use http://www.php.net/preg_split -- PHP Database Mailing List (ht

[PHP-DB] Conditional explode?

2004-07-01 Thread Shiloh Madsen
Can I use explode in a conditional manner? I.E., can i have it explode on a space, but only if the space is not encased in double quotes?

RE: [PHP-DB] More problems with searching

2004-07-01 Thread Ford, Mike [LSS]
On 01 July 2004 18:36, Justin Patrin wrote: > On Thu, 1 Jul 2004 12:28:46 -0500, Shiloh Madsen > <[EMAIL PROTECTED]> wrote: > > > > After the very kind help i was given last night I have the query > > being built right, however the query does not work. Just to > > refresh, the gentlemen who had h

Re: [PHP-DB] More problems with searching

2004-07-01 Thread Pablo M. Rivas
Hello Shiloh, Ideas?... forget the " 1 " $query = "Select * from keyword where "; $words = explode(' ',$_GET['search_text']); foreach($words as $word) { $query .= " keyword = '$word' and "; } $query=substr($query,-4); or... $query = "Select * from keyword where "; $words = explode(' ',$_GET['

Re: [PHP-DB] More problems with searching

2004-07-01 Thread Justin Patrin
On Thu, 1 Jul 2004 12:28:46 -0500, Shiloh Madsen <[EMAIL PROTECTED]> wrote: > > After the very kind help i was given last night I have the query being built > right, however the query does not work. Just to refresh, the gentlemen who > had helped me suggested creation of a query that looks like: >

[PHP-DB] More problems with searching

2004-07-01 Thread Shiloh Madsen
After the very kind help i was given last night I have the query being built right, however the query does not work. Just to refresh, the gentlemen who had helped me suggested creation of a query that looks like: SELECT * FROM table1 where 1 or cat or dog...and so forth. Now, this query is buildin

RE: [PHP-DB] Turning off "Save Password"

2004-07-01 Thread dpgirago
I'd bet I'm in the minority here, but I don't mind at all the occasional, OT post. Hell, most of life seems OT, doesn't it? BTW, your solution provides me with very helpful information. Thanks much. dave > Fixed my own problem. > Within the tag, you can use "autocomplete=off" > To turn off th

RE: [PHP-DB] Turning off "Save Password"

2004-07-01 Thread Gary Every
Fixed my own problem. Within the tag, you can use "autocomplete=off" To turn off the prompting or the autocompletion of any field. Apologize for this off-topic post, but I was searching for a non-javascript server-side solution Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram

[PHP-DB] Turning off "Save Password"

2004-07-01 Thread Gary Every
I'm trying to turn off the save password function so that I can do an auth page that refuses to save passwords on the client side. I've tried some JS but it works only in IE, not Netscape. So, I'm looking for a server-side solution to this. Any ideas? Gary Every Sr. UNIX Administrator Ingram En