php - Why can't I use mysql_num_rows? -



php - Why can't I use mysql_num_rows? -

this question has reply here:

mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row() expects parameter 1 resource or mysqli_result, boolean given 32 answers

on line 25 in code, wrote this:

$check = mysql_num_rows($u_check);

and gave me error:

warning: mysql_num_rows() expects parameter 1 resource, boolean given in d:\download\htdocs\hoping.php on line 25

here entire code of file:

<?php include ("./header.inc.php"); ?> <?php $reg = @$_post['reg']; $fn = ""; $ln = ""; $un = ""; $em = ""; $em2 = ""; $pswd = ""; $pswd2 = ""; $d = ""; $u_check = ""; $fn = strip_tags(@$_post['fname']); $ln = strip_tags(@$_post['lname']); $un = strip_tags(@$_post['username']); $em = strip_tags(@$_post['email']); $em2 = strip_tags(@$_post['email2']); $pswd = strip_tags(@$_post['password']); $pswd2 = strip_tags(@$_post['password2']); $d = date("y-m-d"); if($reg){ if($em==$em2){ $u_check = mysql_query("select username test username='$un'"); $check = mysql_num_rows($u_check); if($check == 0){ if($fn&&$ln&&$un&&$em&&$em2&&$pswd&&$pswd2){ if($pswd==$pswd2){ if(strlen($un)>25||strlen($fn)>25||strlen($ln)>25){ echo "the maximum limit username/first name/last name 25 characters!"; } else { if(strlen($pswd)>30||strlen($pswd)<5){ echo "your password must between 5 , 30 characters long!"; } else { $pswd =md5($pswd); $pswd2 = md5($pswd2); $query = mysql_query("insert test values ('', '$un', '$fn', '$ln','$em', '$pswd', '$d','0')"); die("<h2>welcome communicate</h2>login business relationship started ..."); } } } else { echo "your passwords don't match!"; } } else { echo "please fill in of fields"; } } else { echo "username taken ..."; } } else { echo "your e-mails don't match!"; } } if(isset($_post["user_login"]) && isset($_post["password_login"])) { $user_login = preg_replace('#[^a-za-z0-9]#i', '', $_post["user_login"]); $password_login = preg_replace('#[^a-za-z0-9]#i', '', $_post["password _login"]); } ?> <td width="40%"> <h2>sign below!</h2> <form action="#" method="post"> <input type="text" name="fname" size="25" placeholder="first name" /><p /> <input type="text" name="lname" size="25" placeholder="last name"/><br /><br /> <input type="text" name="username" size="25" placeholder="username"/><br /><br /> <input type="text" name="email" size="25" placeholder="email address"/><br /><br /> <input type="text" name="email2" size="25" placeholder="email address (again)"/><br /><br /> <input type="text" name="password" size="25" placeholder="password"/><br /><br /> <input type="text" name="password2" size="25" placeholder="password (again)"/><br /><br /> <input type="submit" name="reg" value="sign up!"> </td> </tr> </table> <?php include ("./footer.inc.php"); ?>

why giving me error?

mysql_query returns false on error (a boolean), maybe happening. seek , print error if so? example:

$u_check = mysql_query("select username test username='$un'"); if(!$u_check) { die('invalid query: ' . mysql_error()); }

that may point in right direction. note mysql_query , related functions long deprecated. should larn how utilize mysqli* functions.

php mysql phpmyadmin

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more