updating multiple queries in php

[Kevin Castro]

I want to update more than one column in php using mysql.

 

fr example:

$sql="update table_name set where username='$user';

 

$sql="update table_name set where password='$pass';

 

how to concatenate this querie?

 

could you tell anyone how to solve this?

 

Thanks in advance

[dauruk0512]

just more than one column but still one table right !

 

here is my query just give comma

UPDATE  `tabel_annual` SET  `tglmulai` =  '$tanggalmulai',`tglakhir` =  '$tanggalakhir',`acara` =  '$acara',`id_lokasi` =  '$lokasi',`tarip` =  '$tarif',`ket` =  '$keterangan',`cp` =  '$cp',`status` =  '$cek' WHERE  `tabel_annual`.`id_anual` ='$id'

Hope this make sense

 

sorry edited what do you mean multi query ! i saw your query trying update same table, please more detail what you want to

 

Freddy

Edited June 17, 2015 by dauruk0512

[Kevin Castro]

fr eg:) i created 4 input tags namely username,update username,password and update password.

 

i want to update old username into new username and old password into new password.

 

here is the code for updating single column in php

 

$sql="update students set where username='$user';

 

if i update password field how to combine with this same variable....

[dauruk0512]

sorry for late respond, you are write wrong query kevin !

 

if you want to update row in table, you need to post primary key too which show in your edit.php cause it need in your query clasue where,

 

so your query wrong, i guess this is not change at all you data in table cause you need set each table !

update students set where username='$user

here is my query suggest to you why there is id_user in my query because id_user is primary key, $usernmae, $password, $id is variabel came from your form, in this case you need show id_user in your form so you can update it,

UPDATE  `students ` SET  `username` =  '$username',`password` =  '$password' WHERE  `id_user` ='$id'

so here is simple table from me ->id_user, usernmae, password

 

 

oh ya almost forgot if you need encrypt your password you need md5 when you post password

 

 

 

Hope this make sense, please let me know if working, Thanks

 

 

Freddy

[Kevin Castro]

Thank you freddy,it was working

[Ingolme]

MD5 is not a secure way to encrypt passwords. From the PHP manual itself:

http://php.net/md5

Note: Secure password hashing It is not recommended to use this function to secure passwords, due to the fast nature of this hashing algorithm. See here for details.

[dauruk0512]

So to came this thread again ! so what the best way to make secure password !

 

i always use md5, do i old about this so what the best way to make secure password Foxy, Thanks !

[Ingolme]

The answer is right in the PHP manual: http://php.net/manual/en/faq.passwords.php#faq.passwords.fasthash