[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

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.

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" > i

[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] 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

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 tho

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: 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 t

[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: [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 supe

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 Dat

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 so

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 onl

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 decry

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 ""; echo $curdate["hours"].":".$curdate["minutes"].":".$curdate["seconds"]; } function quiet_time_stp_data(){

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 pr

[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 I'v

[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 mysq

[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 in

[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 onl

[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 w

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 troubling

[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 producti