php - MySQL statement seems to have an error. I get mysqli_num_rows() and mysqli_fetch_array() errors -

-

i've been working on password reset form. sql statement seems returning nothing. i've removed sections of code simplify it, can't seem pasted mysqli_num_rows(). think there wrong mysqli_query() statement on line proceeding it. i've try using mysql_num_rows , mysql_query alternative.

<?php if(isset($_post["u"])) { // connect database     include_once("includes/connect.php");  // gather posted data local variables , sanitize      $u = preg_replace('#[^a-z0-9_]#i', '', $_post['u']);              $e = mysql_real_escape_string($connect, $_post['e']);  $username = $_post['username']; $email = $_post['email'];  $query = mysqli_query($connect, "select username, email users username='$username'"); $numrows = mysqli_num_rows($query); if($numrows > 0)         {     while($row = mysqli_fetch_array($query, mysqli_assoc)){          $db_u = $row["username"];                     $db_e = $row["email"];     }                 if($e == $db_e && $u == $db_u)                 {         $code = rand(10000,9999999);          $sql = "update users set passreset='$code' username='$username'";         $query = mysqli_query($connect, $sql);                      $to = $db_email;         $subject = "password reset";         $body = "this automated email           ";           mail($to,$subject,$body);          echo "success";              }  else {  echo"no_exist";  exit();   } } } ?>    <script> function forgotpass(){     var u = _("username").value; var e = _("email").value; if(e == "" || u == ""){     _("status").innerhtml = "this form requires enter both username , email."; } else {     _("forgotpassbtn").style.display = "none";     _("status").innerhtml = 'please wait ...';     var ajax = ajaxobj("post", "forgot.php");     ajax.onreadystatechange = function() {         if(ajaxreturn(ajax) == true) {             var response = ajax.responsetext;             if(response == "success"){                 _("forgotpassform").innerhtml = '<h3>check email inbox </h3>';             } else if (response == "no_exist"){                 _("status").innerhtml = "email address not found";             } else if(response == "email_send_failed"){                 _("status").innerhtml = "mail function failed execute";             } else {                 _("status").innerhtml = "an unknown error occurred";             }         }     }     ajax.send("e="+e+"&u="+u); } } </script> </head> <body>     <h3>reset password</h3>  <form id="forgotpassform" onsubmit="return false;">  <div>enter username</div> <input id="username" type="text" onfocus="_('status').innerhtml='';" maxlength="88">   <br /><br />  <div>enter email address</div> <input id="email" type="text" onfocus="_('status').innerhtml='';" maxlength="88"> <br /><br />  <button id="forgotpassbtn" onclick="forgotpass()">submit</button>  <p id="status"></p>  </form>   </div>      </body>     </html>

value variable $e might problem using mysql escape 2 variables , change mysqli escape


Comments

Post a Comment

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook.
Read more

customize file_field button ruby on rails -

-
i'm trying rid of ugly button rails has default file upload. want add glyphicon <%= f.file_field :image_url, class:"glyphicon glyphicon-camera" %> this didn't work , have tried other things in different post saw on page, don't attach file. as suggested here bootstrap filestyle , can use bootstrap's filestyle style file upload buttons. step-1: add layout application.html.erb i have added bootstrap filestyle library cdn. should make sure have both jquery , boostrap loaded. <script type="text/javascript" src="https://cdn.jsdelivr.net/bootstrap.filestyle/1.1.0/js/bootstrap-filestyle.min.js"> </script> step-2: add corresponding js file: $(":file").filestyle({input: false}); step-3: image_url file field follows: <%= f.file_field :image_url,class: "filestyle", "data-input" => false %>
Read more

SoapUI on windows 10 - high DPI/4K scaling issue -

-
Image
soapui doesn't seem dpi-aware , displays small on high dpi screen (tiny text , buttons). other applications running fine (screen resolution 3840 x 2160). version : soapui 5.1.2 os : windows 10 i have tried: configure soapui run "disable display scaling on high dpi settings" - parts of soapui looking bigger , don't display (image) changing resolution changing font size (preferences > editor settings > select font...) therefore assume, soapui pretends dpi-aware, not scale itself. have same issue? this workaround until developers round making version dpi-aware. step 1: add registry key hkey_local_machine\software\microsoft\windows\currentversion\sidebyside\preferexternalmanifest (dword) 1 step 2: add manifest file 'soapui-5.2.1.exe.manifest' in same directory 'soapui-5.2.1.exe' content of manifest file: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <assembly xml
Read more