RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread matt stewart
I would go for the generate new random password approach - email the new random password to the registered email address, then they can log in using it and reset it to whatever they want. probably easier than using lots of code encrypting and decrypting things? Let me know what you decide on, and

[PHP-DB] Function OCILogon().

2001-12-20 Thread Somsak RAKTHAI
Dear all, I used PHP 4.1.0 and Oracle 9i running on RedHat-7.2. I have question about Oracle function OCILogon(). I have problem about my source below. ?php $db = ; $c1 = ocilogon(scott,tiger,$db); $c2 = ocilogon(scott,tiger,$db); ? When run

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread rhelms
Hi, I need dbase.so I don`t have it. I download php`s .tgz to compile Is dbase actional supported and produced for it? I know this as an old database. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread pcastillo
Well, only i need open .dbf files from linux, .dbf files are Visual fox pro files [EMAIL PROTECTED] wrote: Hi, I need dbase.so I don`t have it. I download php`s .tgz to compile Is dbase actional supported and produced for it? I know this as an old database. Regards, Ruprecht -- PHP

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread Zach Curtis
This is how I'm going to work things. Store the password using PASSWORD() in the table. Allow user to request their forgotten username and/or password. If the password is requested, I will reset the password to a random value and store this in the table using PASSWORD(). The username and/or

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread Yasuo Ohgaki
[EMAIL PROTECTED] wrote: Thanks to reply my message. I need dbase.so I don`t have it. I download php`s .tgz to compile how i can to compile dbase module? i do next cd php-4.0.4 cd ext cd dbase phpize ./configure make make install and i have dbase.so, but in the momento to run

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread Ryan Marrs
Or what may be even better at that point (to keep someone from pestering another user and changing their password. Email them a randomly generated string based on their username, store that in a database, then send them to a page to enter the string (or pass it through the url.) IE. I'm Joe, I

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread matt stewart
good point well made. this system has pretty much everything we need - thanks! -Original Message- From: Ryan Marrs [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 16:17 To: 'Zach Curtis'; matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Decrypting PASSWORD() from MySQL Or

[PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread SpyProductions Support Team
I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. Here's what I am doing: I have a form with a few checkboxes. When the information as to whether the checkboxes are checked or not is 'saved' into the MySQL table, they are represented by a value of

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Paul DuBois
On Thu, Dec 20, 2001 at 11:40:14AM -0500, SpyProductions Support Team wrote: I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. On this question, you'd be better off just reading an HTML reference. It doesn't matter what the value of a checkbox is.

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
It's not the checkbox's VALUE attribute that determines whether it is checked or not. If you add the empty attribute CHECKED, then the checkbox will be checked. Example: INPUT TYPE='Checkbox' NAME='VarCheck1' VALUE='Good' CHECKED INPUT TYPE='Checkbox' NAME='VarCheck2' VALUE='Good' VarCheck1

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread matt stewart
the value doesn't determine whether it's checked or not - it determines the value passed WHEN it's checked. try the lines below: echoinput type=/checkbox/ name=/firstvalue/ value=/1/; if ($result[32] == 1){ echo checked; }else{ echo; } or something along these lines.

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jason Wong
On Friday 21 December 2001 00:40, SpyProductions Support Team wrote: I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. Here's what I am doing: I have a form with a few checkboxes. When the information as to whether the checkboxes are checked

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
Or a better, more-visual way might be: ? if($result[32] == 1) $Checked = CHECKED; else $Checked = ; print INPUT TYPE='Checkbox' NAME='firstvalue' VALUE='1' $Checked; ? - Jonathan -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 8:45

[PHP-DB] Multiple Image Display Problem

2001-12-20 Thread Christopher Martin
I am having problems displaying two different images on the same page. (stored as binary files in two different db tables) Instead of getting two different images, I am getting the first image twice, although the scripts are going to two different database tables to get the two images. Is there

Re: [PHP-DB] Mysql result resource error

2001-12-20 Thread Jim Lucas
which one was giving you the problem? the first or second mysql try. if it was the second, try wrapping the $cattyname with single quotes like this Minor_Category = '$cattyname'. if the $cattyname var has anything but numbers, the statement won't work. Jim - Original Message - From:

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jim Lucas
Try this input type=checkbox name=firstvalue ?=($result[32]?checked:)? Jim - Original Message - From: SpyProductions Support Team [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 8:40 AM Subject: [PHP-DB] Checkboxes, PHP, and MySQL I've looked around in a

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rosser, Chris
nautilis, Leave the date in the database in MySQL format (/MM/DD) and when you need to display the date on your page, just do this: ?php explode(/, $datearray); $date = $datearray[2].'/'.$datearray[1].'/'.$datearray[0]; ? That just splits up the three numbers, and rearranges them. Easy

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rosser, Chris
Sorry, correction: ?php $datearray = explode(/, $mysqldate); $date = $datearray[2].'/'.$datearray[1].'/'.$datearray[0]; echo $date; ? -Original Message- From: Rosser, Chris Sent: Thursday, December 20, 2001 5:37 PM To: [EMAIL PROTECTED]

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rick Emery
Try in PHP. This should take 12/25/2001 in $input_date and convert it to 20011225 in $db_date. Then write $db_date to mySQL database. Perform similar conversion when extracting from database. Or instruct your users to use MMDD. $thedate = explode(/,$input_date); //$thedate[0]=DD,

[PHP-DB] Re: Problem with PHP4 and dba_open

2001-12-20 Thread Juffe Ã…berg
If you are using PostgreSQL module, do not use PostgreSQL for now. I'll work on conflict issue later, but I don't think it will be fixed any time soon No, I don't use PostgreSQL module.. so what's wrong? Sometimes, when I reboot machine, it works for a while..? -- PHP Database Mailing

[PHP-DB] Run php page automatically

2001-12-20 Thread Harpreet
I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Marco Eyzaguirre
do this (crontab file) 35 23 * * * root lynx http://www.host.com/dir/file.php -accept_all_cookies it's work! marco -Mensaje original- De: Harpreet [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 02:21 p.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto:

[PHP-DB] mysql table layout help needed

2001-12-20 Thread Chris Payne
Hi there everyone, This is probably a really simple problem but for the life of me I can't figure out what i'm doing wrong. My problem is I am getting 20+ results from a DB to display without any problems with the images etc . but they display one ontop of another (Of course with spacing

[PHP-DB] RE: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
In my opinion, PHP works fine with small scripts like this. True, it could be more efficient with Perl, but when you don't know Perl, or don't have DB perl modules installed, PHP scriptlets are a nice way to take care of small tasks. And PHP can just as easily run a system command and append text

Re: [PHP-DB] mysql table layout help needed

2001-12-20 Thread Bogdan Stancescu
A sample of what you were trying would have been helpful... If I understood your problem right, the solution is a piece of code like this: ? echo(table\ntr\n); while ($myrow=mysql_fetch_row($result)) { $colcount++; if ($colcount==$desiredcolcount) { $colcount=0; }

[PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread George Loch
What if you are on win2K? - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 12:22 PM Subject: [mysql-support] RE: [PHP-DB] Run php page automatically I usually just create a cron

RE: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Marco Eyzaguirre
task manager -Mensaje original- De: George Loch [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 05:56 PM Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically What if you are on win2K? -

RE: [PHP-DB] Mysql result resource error

2001-12-20 Thread Shannon Doyle
Hi Jim, Ahh yes of courseI have corrected this. I am still getting the error on the first query...not sure why. And now I am getting a whole bunch of empty lines being output to the screen. Like there is supposed to be data in those lines, but nothing happening. Plus I am getting repeats of

[PHP-DB] New Object Oriented Programming (OOP) mailing list for PHP programmers

2001-12-20 Thread Manuel Lemos
Hello, Despite I already created this list a long time ago, only now I am announcing it as a general purpose forum for discussing matters related with Object Oriented Programming done in PHP. Everybody is invited and to join all you need to do is to send a message to [EMAIL PROTECTED] or go to

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Beau Lebens
it's better to do something like 0,10,20,30,40,50* * * * /usr/bin/php -q /home/you/yourscript.php /dev/null since crontab actually stores the result of it's operations in a file (/home/you/Mailbox?) so you will bloat your server if you don't clear the output.