Threaded Mode | Linear Mode

Raz! · 2015-07-06, 18:36

Hello, I have created a system so that when this page is viewed, it updates the password in the database.
This is the code:

Code:

<html>

<head>

<title>Password Generator</title>

</head>

<body>

<?php

function generatePassword($length = 19) {

    $chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';

    $count = mb_strlen($chars);

    for ($i = 0, $result = ''; $i < $length; $i++) {

        $index = rand(0, $count - 1);

        $result .= mb_substr($chars, $index, 1);

    }

    return $result;

}

echo generatePassword();

$dbhost = '*********';

$dbuser = '*********';

$dbpass = '*********';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if(! $conn )

{

  die('Could not connect: ' . mysql_error());

}

$sql = "UPDATE mst_user

   SET pass = '$result'

   WHERE user_id = 2";

mysql_select_db('a2097679_quiz');

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

  die('Could not update data: ' . mysql_error());

}

echo "<br>Password Changed\n";

mysql_close($conn);

?>

</body>

</html>

When this is ran, in the database the password (pass) value shows empty. If I change the 'SET' Value to 'TEST' it will show up.

Possibly Related Threads...
Thread:		Author	Replies:	Views:	Last Post
	Advice needed:	Charlie	7	6,182	2017-07-31 18:19 Last Post: dyzio2206
	New PC Advice(s) - HELP NEEDED!	KooKoo	28	22,440	2015-08-02 01:18 Last Post: Jerkkka
	Joystick help needed !	Chill .	3	3,336	2013-01-12 17:22 Last Post: Chill .