Hey Bedul,
I dropped the table and recreated it with VARCHAR (50) for both. (The reason
I like BLOB is when you edit the table all you see is BLOB until you have
the permission to open it to binary or text.
Here is the log message:
070512 16:36:07 35 Connect root@localhost on
35 Init DB aims site
35 Query INSERT INTO docproedit (username,password)VALUES
('61d46e51e01c5c77ffb9a60f00a842a1'),('2ccd89b67324dd915dd2d286f613332e')
35 Query INSERT INTO docproedit
(username,password)VALUES(md5('mata's'),md5('blessing'))
35 Query 1
35 Quit
Now neither INSERT works. Do you know what the '1' is by the way?
With BLOB at least one worked with inserting $var's in the values.
This seems like a silly problem.
There must be some way to do this proper. I'm just a baby at this.
Blessings,
Chetan
Bedul says:
bedul wrote:
>
> username BLOB NOT NULL default '',
> password BLOB NOT NULL default '',
>
> do you try
> username varchar 50,
> password varchar 50??
>
> i'm just ask..
> sry, hope that's can solve your problem
>
> ----- Original Message -----
> From: "Chetan Graham" <chetan_graham@xxxxxxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Saturday, May 12, 2007 4:28 PM
> Subject: PHP to md5 the $var before it reaches MySQL's gen query
> log
>
>
>> Greetings to All,
>> I am having difficulty in 'md5'ing a $var in a function before it is
>> placed into the ("INSERT INTO table...
>>
>> The whole point is I don't want the MySQL DB logs showing my $var's
>> password and username 'before' it is encrypted by MySQL's md5.
>>
>> When MySQL receives PHP's encrypted $var the log shows query INSERT with
>> the 32 bits but it is not inserted into the DB.
>>
>> MySQL will not accept the $var's in the code that is commented out.
>> It shows no errors by the way.
>> MySQL accepts what is shown, but this is not as I explained what I want.
>> Thanks In Advance,
>> Chetan
>>
>> mysql_query("CREATE TABLE IF NOT EXISTS docproedit (
>> id int(11) NOT NULL auto_increment,
>> username BLOB NOT NULL default '',
>> password BLOB NOT NULL default '',
>> TimeEnter timestamp,
>> PRIMARY KEY (id)
>> )
>> ENGINE=MyISAM;")or die('Create Died' . mysql_error());
>>
>>
>> <?php
>> $db_server='localhost';
>> $db_user='root';
>> $db_pass='somepassword';
>> $db_name='aims site';
>> $tbl_name='docproedit';
>> $con = mysql_connect($db_server,$db_user,$db_pass) or die(mysql_error());
>> $q=mysql_select_db($db_name, $con) or die(mysql_error());
>>
>> function addNewUser($username,$password){
>> global $q;
>> global $tbl_name;
>> global $con;
>> //$user=md5($username);
>> //$pass=md5($password);
>> //mysql_query("INSERT INTO $tbl_name
>> (username,password)VALUES('$user'),('$pass')");
>> $user=$username;
>> $pass=$password;
>> mysql_query("INSERT INTO $tbl_name
>> (username,password)VALUES(md5('$user'),md5('$pass'))");
>> return mysql_query($q,$con);
>> }
>> ?>
>> <?php
>> $username="somename";
>> $password="somepassword";
>>
>> addNewUser($username,$password);
>> echo "<h2>New User Added!</h2>";
>> ?>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
View this message in context: http://www.nabble.com/PHP-to-md5-the-%24var-before-it-reaches-MySQL%27s-gen-query-log-tf3731340.html#a10444916
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
