Add on for my life

The scenario;
I have a costumer database. And they are login my simple application. But i want to security to passwords.
[MYSQL]
UPDATE mycostumerdata SET password=MD5(SHA1(MD5(password)))
[/MYSQL]
If you want more, you add php code md5() or sha() to user id and mysql query add md5(userid). There is no chance to pass in with sql injection
Change it to yourself.
Çoğu [...]

Tags: cyrpto, md5, Mysql, simple

The scenario;
I have a lot of records on my test table. And costumer want to “Need a order by manualy”. So i want to update my table and set new order value. The new order value is old id value.
Here is code;
[MYSQL]
UPDATE Mytable SET ordervalue = oldid
[/MYSQL]
Bir Arkadaşım kendisine ait bir veritabanında yeni bir alan [...]

Tags: code, Mysql, simple, starter