database - show by printf data encrypted in php with mysqli -


i have problem php, programming php file show printf data of data base related encrypted_password. want pick value , display on screen, not work, have done so:

$query = "select *  `users`  `email` =  '$email' order  `users`.`uid` asc limit 0 , 30";  $result = $con->query($query);  $row = $result->fetch_array(mysqli_assoc); printf ("consulta %s nombre: %s email:(%s) salt: %s y pass: $s\n", $query,$row['name'], $row['email'],$row['salt'],base64_encode($row['encrypted_password'])); 

and printf shows screen:

consulta select * users email = 'elvega3009@msn.com' order users.uid asc limit 0 , 30 nombre: xxxx email:(xxxxxxxx@msn.com ) salt: a3f7734b0e y pass:

the pass field doesn't show screen, data encode in base64_encode in data base, don't know if problem, need data shows screen. need help. thank in advance

try putting %s instead of $s @ end of line:

printf ("consulta %s nombre: %s email:(%s) salt: %s y pass: $s\n", `$query,$row['name'],` $row['email'],$row['salt'],base64_encode($row['encrypted_password'])); 

you should use md5 or sha1 function store passwords.


Comments