Re: [PHP-DB] isset or ! isset what is my problem?

2006-01-02 Thread Micah Stevens
NULL != Not set. isset() tests to see if the variable exists. If your variable has a null value it is set, it DOES exist, it just has NULL for a value. You should test for a null value if that's what you want: if ($picture == null) Or perhaps the empty() function might be what you're looking

Re: [PHP-DB] isset or ! isset what is my problem?

2006-01-02 Thread John Meyer
On Monday 02 January 2006 8:54 pm, Ralph wrote: > I'm building a URL based on data extracted from mySQL and I want the > text space.gif used as my default value should the variable $picture > by NULL. > > The results of the code below kick back a value for $picture when it > is set in the database,

[PHP-DB] isset or ! isset what is my problem?

2006-01-02 Thread Ralph
I'm building a URL based on data extracted from mySQL and I want the text space.gif used as my default value should the variable $picture by NULL. The results of the code below kick back a value for $picture when it is set in the database, but ignores the space.gif if the database result

Re: [PHP-DB] newbie PHP/MySQL question

2006-01-02 Thread Micah Stevens
Maybe from a previous query? I mean, did you make sure the table was clear before starting the script? On Monday 02 January 2006 6:18 pm, toylet wrote: > A table with a column big5 char(2) not null primary key. > > $target->query("delete from canton"); > for ($ii=0; $ii<256; $ii++) { >

[PHP-DB] newbie PHP/MySQL question

2006-01-02 Thread toylet
A table with a column big5 char(2) not null primary key. $target->query("delete from canton"); for ($ii=0; $ii<256; $ii++) { for ($jj=0; $jj<256; $jj++) { echo $ii .".". $jj . "\n"; $query="insert into canton ( big5 ) values ( '" . mysql_real_escape_string(chr($ii).chr($j

[PHP-DB] Re: php mail and accentuated characters

2006-01-02 Thread Manuel Lemos
Hello, on 12/31/2005 03:11 PM Jean-Philippe BATTU said the following: I would like to send email from my php program. So I use the mail() function from php engine but I noticed that the accentuated characters were not well transmitted by php or the apache server (I use a linux box with FC4 and

RE: [PHP-DB] Encrypting DB content

2006-01-02 Thread Bastien Koert
yes, have a look at mcrypt(www.php.net/mcrypt) and decrypt(www.php.net/decrypt) Bastien From: "Kosala Atapattu" <[EMAIL PROTECTED]> To: "Micah Stevens" <[EMAIL PROTECTED]>, Subject: RE: [PHP-DB] Encrypting DB content Date: Mon, 2 Jan 2006 13:20:47 +0600 This is bit off the topic...but is th

Re: [PHP-DB] Encrypting DB content

2006-01-02 Thread Julien Bonastre
Easily... As some people have already pointed out, one of the interesting aspects of 2 way or reversible encryption systems is they provide some form of a key, that is a unique or variable input which is combined into the encryption process to create a truly unique encypted string. For exa

RE: [PHP-DB] Encrypting DB content

2006-01-02 Thread Kosala Atapattu
This is bit off the topic...but is there a way to encrypt with a key and decrypt it back to the same value I want to store. My requirement is something like I want to store salaries of the executives of the organization in a table, but not even the DBA should be able to see that except the person w