[PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread John Lim
Michael, After rereading your post again, i realise you mentioned it's happening with non-persistent connections also. That puzzles me. Perhaps we are talking about multiple bugs here. In general, I have not found PHP5 and oci8 to be very stable, and would not recommend moving anything

RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread Michael Caplan
Hi John, Just saw your blog today on Andi's PHP5 / Oracle article. One of the two bugs you sited in your previous email was one that I opened (http://bugs.php.net/bug.php?id=30808) I'm not sure what the case is with the 4.3.x line, but my hunch this issue is 'bigger' than PHP5. More

[PHP-DB] timestamp problem

2004-11-18 Thread Doug Parker
I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see that the idea is to convert the Timestamp type to Unix format using the strtotime() function, then using the date() function to format that result. However, this only appears to work

[PHP-DB] Re: timestamp problem

2004-11-18 Thread Sebastian Mendel
Doug Parker wrote: I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see that the idea is to convert the Timestamp type to Unix format using the strtotime() function, then using the date() function to format that result. However, this

[PHP-DB] Problem compiling PHP 5 with MySQLi (64bit)

2004-11-18 Thread Sascha Noethen
Hi, I am trying to compile PHP 5 with mysqli support: ./configure --with-mysqli The result is an error message and I cannot find out how to avoid this error message: checking for MySQLi support... yes checking whether to enable embedded MySQLi support... no checking for mysql_set_server_option

[PHP-DB] Re: Problem compiling PHP 5 with MySQLi (64bit)

2004-11-18 Thread Sebastian Mendel
Sascha Noethen wrote: Hi, I am trying to compile PHP 5 with mysqli support: ./configure --with-mysqli The result is an error message and I cannot find out how to avoid this error message: checking for MySQLi support... yes checking whether to enable embedded MySQLi support... no checking for

[PHP-DB] password encryption

2004-11-18 Thread Han
Hello, I'm having a real problem and wondering if anyone can help. I need to set up htaccess ans htpasswd files to authenticate users on my system. I need to do it with PHP, but can't find a way of encrypting the password so it works. I've used an online encrypter for testing the system, and

RE: [PHP-DB] timestamp problem

2004-11-18 Thread Bastien Koert
this is a common mysql timestamp problem, you can try using DATE_FORMAT(datefield, FORMAT) sql function to define the date, or store the timestamp as a unix timestamp (an integer) from the get go bastien From: Doug Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] timestamp

RE: [PHP-DB] timestamp problem

2004-11-18 Thread Rodrigo Cabeceiras
Hi Does it help? function time_stp(){ $curdate=getdate(time()); echo $curdate[weekday]. .$curdate[mday]. .$curdate[month]. .$curdate[year]; echo BR; echo $curdate[hours].:.$curdate[minutes].:.$curdate[seconds]; } function quiet_time_stp_data(){

RE: [PHP-DB] password encryption

2004-11-18 Thread Gryffyn, Trevor
You can use PHP to handle the auth headers and all: http://www.php.net/manual/en/features.http-auth.php That might give you more flexibility than trying to dynamically set it on the .htpassword and such. There are a couple of ways to encrypt something. You can do it in a way that can be

Re: [PHP-DB] timestamp problem

2004-11-18 Thread John Holmes
Doug Parker wrote: I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see that the idea is to convert the Timestamp type to Unix format using the strtotime() function, then using the date() function to format that result. However, this

RE: [PHP-DB] password encryption

2004-11-18 Thread peter
Quoting Gryffyn, Trevor [EMAIL PROTECTED]: If you want to be cheesy, you can also use something like an MD5 has on dog and get whatever it gets Then every time someone enters dog it always ends up with the same MD5 hash. How is using MD5 cheesy? I've implemented exactly that solution a

Re: [PHP-DB] timestamp problem

2004-11-18 Thread Doug Parker
Ok, thanks for the input. I knew that was an option as well, the problem is that I have about eight different dates in the query, and I'd rather do a query like SELECT projects.* FROM projects... and then format those results, rather than do SELECT DATE_FORMAT('%m %d %Y', projects.Date1) AS

RE: [PHP-DB] password encryption

2004-11-18 Thread Gryffyn, Trevor
Hah.. Because I figured it wouldn't be an accepted solution by real security people. :) I've used it too. Also used the md5_file() function to create a duplicate file scanner for my home PC. The only problem with using MD5 or another one-way solution on a general site that doesn't require

[PHP-DB] I'm less experienced please be gentle :)

2004-11-18 Thread ed
Can anyone tell me whats wrong with the below code? it doesnt execute. $ip=$_SERVER[REMOTE_ADDR]; $banned=SELECT * FROM banned WHERE ip='$ip'; if(@mysql_num_rows(mysql_query($banned)) 0) { echo You have been Banned.; }else{ echo $ip; }

Re: RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread CHRISTOPHER . JONES
During my presentation at the PHP Conference in Frankfurt I put out a call for participation in creating a roadmap for Oracle connectivity in PHP. When I get back to work (I'm on a short vacation in Europe with intermittent email access) I'll be following up on this. While I'm away, feel free

Re: [PHP-DB] I'm less experienced please be gentle :)

2004-11-18 Thread Micah Stevens
What does it do? Does it give a specific error? I don't see anything wrong with it. If it's not giving an error, perhaps it's returning unexpected results? This change may give you some insight: change: if(@mysql_num_rows(mysql_query($banned)) 0) { to: $result = mysql_query($banned) or

RE: [PHP-DB] I'm less experienced please be gentle :)

2004-11-18 Thread Norland, Martin
Remove the @ in front of the mysql_num_rows function call. The @ symbol supresses errors, so that's likely where your error would be printed. Cheers - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent

RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread Andreas Karajannis
On Thu, 2004-11-18 at 11:41 -0700, [EMAIL PROTECTED] wrote: During my presentation at the PHP Conference in Frankfurt I put out a call for participation in creating a roadmap for Oracle connectivity in PHP. When I get back to work (I'm on a short vacation in Europe with intermittent email

[PHP-DB] Frames mySQL

2004-11-18 Thread Ron Piggott
I have another challenge I am trying to over come. Frames. I have my screen set up in 3 frames. 2 for user input and the third is for data --- letting the user know what has just happened. IE RECORD UPDATED is what I want to be displayed there. The catch is this --- how do I display text in

Re: [PHP-DB] Frames mySQL

2004-11-18 Thread Ramil Sagum
On Thu, 18 Nov 2004 21:16:51 -0500, Ron Piggott [EMAIL PROTECTED] wrote: I have another challenge I am trying to over come. Frames. I have my screen set up in 3 frames. 2 for user input and the third is for data --- letting the user know what has just happened. IE RECORD UPDATED is what I

Re: [PHP-DB] Frames mySQL

2004-11-18 Thread Micah Stevens
I would use Javascript to update the page content. You can use the DOM to access the content in other frames as long as it's the same base URL I think. So when you output the form after storing the record, output a script that changes the bottom frame. Look up javascript InnerHTML in google..

[PHP-DB] Firebird and PHP

2004-11-18 Thread Mario Lacunza
Hello, Is possible work with Firebird ? and how? Thanks and advance!! Mario Lacunza Lima-Peru -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php