Untitled

<?php
   ini_set('display_errors', 'On');
error_reporting(E_ALL);
    $DBHOST = "localhost";
    $DBUSER = "test";
    $DBPASSWORD = "test";
    $DBNAME = "test";

$mysqli = new mysqli($DBHOST, $DBUSER,  $DBPASSWORD , $DBNAME);
if (mysqli_connect_errno()) {
   printf("Conecnt in server MySQL in not. Code error: %s\n",
   mysqli_connect_error());
   exit;
}
else{
    echo '<pre>';
     printf("Conected is good. \n");
     echo '</pre>';
}
    $mysqli->set_charset("utf8");
    if (isset($_POST['restore_pass'])) {
    $user_mail = $mysqli->real_escape_string($_POST['mail']);

    $query = ("SELECT * FROM  wp_users
WHERE user_mail = '$user_mail' ");

 $sql = $mysqli->query($query) or
  printf("Zapros ne udalsa': %s\n", mysqli_connect_error());


$simv = array ("92", "83", "7", "66", "45", "4", "36", "22", "1", "0",
 "k", "l", "m", "n", "o", "p", "q", "1r", "3s", "a", "b", "c", "d", "5e", "f", "g",
 "h", "i", "j6", "t", "u", "v9", "w", "x5", "6y", "z5");
 for ($k = 0; $k < 8; $k++)
         {
         shuffle ($simv);
         $string = $string.$simv[1];
         }


$zapros = ("UPDATE wp_users` SET `user_pass`='$string'
WHERE user_mail = '$user_mail' ");

 $sql = mysqli_query($zapros) or
   printf("Zapros update ne udalsa': %s\n", die(mysqli_connect_error());


$to = $user_email;
$subject = "zapros-na-vosstanovlenie-parolya";
$message = '
                <html>
                    <head>
                   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
                        <title>Thema page</title>
                    </head>
                    <body>
                        <p>"Hello, $user_email. Your new password: $string"</p>
                    </body>
                </html>';
// устанавливаем тип сообщения Content-type, если хотим
                $headers  = 'MIME-Version: 1.0' . "\r\n";
                $headers .= "Content-type: text/html; charset=utf-8 \r\n";

                // дополнительные данные
                $headers .= "From: $fio <$user_email>\r\n"; // от кого
                mail($to, $subject, $message, $headers);

 echo "Na vash pochtovyj yashchik bylo otpravleno pis'mo s novyj parolem";
    $mysqli->close();
    }
    ?>
 <p><b>Restore password</b></p>
 <form name="form1" method="post" action="vosst_pass.php">
 <p><i>Your e-mail </i><input type="text" name="mail" size="30" /></p>
 <p>
 <input type="submit" name="restore_pass" value="restore_pass"  size="30">
 </p>
 </form>