[PHP-DB] Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
I am building a security script and am wondering what should I do to enable a user to recover his/her password if they forget it. I currently use PASSWORD() when inserting the password into the database so I don't know how to send them a unhashed string. Can someone direct me to an example or

Re: [PHP-DB] Passwords in MySQL for a PHP site

2004-10-03 Thread John Holmes
Dylan Barber wrote: I am building a security script and am wondering what should I do to enable a user to recover his/her password if they forget it. I currently use PASSWORD() when inserting the password into the database so I don't know how to send them a unhashed string. Can someone direct me t

RE: [PHP-DB] Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
Yeah I read that after I had posted this -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, October 03, 2004 7:04 AM To: Dylan Barber Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Passwords in MySQL for a PHP site Dylan Barber wrote: > I am building a security scr

[PHP-DB] Apology: Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
I apologize to everyone on the list - I did not realize I had read receipt set to be on. Dylan Barber

[PHP-DB] Multiple Selections from List Box

2004-10-03 Thread Stuart Felenstein
I'm creating some multiple selection list boxes. I believe this would be close to the correct code to pull the selections: >New York >San Francisco >Los Angeles >Washington D.C. The values from the table are stores by valueID and Label. Not sure if I need some kind

[PHP-DB] Safe / Secure Login Script

2004-10-03 Thread Wendell Frohwein
I have been writing php code for about 2 years now. I have a login script that I have written for my clients. I just would like to know if there is a better / safer way of logging people into websites. This is my current method. 1.) Username and Password are entered in an html / php form usin

[PHP-DB] Arabic characters displayed as garbage !!

2004-10-03 Thread Dre
Hi, I'm working on a website that needs to save and display Arabic characters. I'm using MySQL database and no matter how I insert the data either using phpMyAdmin or inserting it using a script of my own, when I try to show (display) the data I previously saved (which contains Arabic characters),

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-03 Thread martin73
Did you set a character encoding on your page to Arabic? (eg. ISO-8859-6) > Hi, > > I'm working on a website that needs to save and display Arabic characters. > I'm using MySQL database and no matter how I insert the data either using > phpMyAdmin or inserting it using a script of my own, when I t

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-03 Thread Dre
yes I did .. and the problem only happens for arabic text stored in database <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Did you set a character encoding on your page to Arabic? (eg. ISO-8859-6) > > > Hi, > > > > I'm working on a website that needs to save and display Arabic char

Re: [PHP-DB] Arabic characters displayed as garbage !!

2004-10-03 Thread martin73
By default, MySQL uses the ISO-8859-1 (Latin1) character set. I guess you need to set this parameter to something suitable for Arabic (if it is supported by MySQL). I suggest you read "The Character Set Used for Data and Sorting" part of MySQL manual. That's all I can help with. Cheers > yes I di

Re: [PHP-DB] Capturing a sql query

2004-10-03 Thread graeme
Just a thought, Could you use the set data type rather than a text to store your multiple selections? graeme. Stuart Felenstein wrote: It's more then keywords actually. There are 3 list boxes, one for states, one for industries and one for taxterm., so 50 states , industries, something like 20 i

[PHP-DB] Newbie needs help with multiple MySQL databases

2004-10-03 Thread Matthew
Hi, im fairly new to php and mysql and need a little help. im running a forum community and would like to have it run on multiple databases because of performance issues others have encountered using the same software on on database. My question is is it possible to have the software connect to 2 d

[PHP-DB] Re: Newbie needs help with multiple MySQL databases

2004-10-03 Thread Tim Van Wassenhove
In article <[EMAIL PROTECTED]>, Matthew wrote: > Hi, im fairly new to php and mysql and need a little help. im running a > forum community and would like to have it run on multiple databases because > of performance issues others have encountered using the same software on on > database. My questio

Re: [PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

2004-10-03 Thread Christopher Jones
[EMAIL PROTECTED] wrote: I'm trying to write text to a BLOB. I got a valid return code but it did not write the BLOB. > I was able to use similar code writing to a CLOB. Any examples I've seen for BLOBs are reading > from Binary files. Here's how I did the CLOB, but it would not work for BLO

Re: [PHP-DB] Multiple Oracle connections

2004-10-03 Thread Christopher Jones
Chris Back wrote: Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems begi