Search the Community
Showing results for tags 'warning: mysql_num_rows() exp'.
Found 1 result
-
The below is my code.... it works from webserver, not works in local host <?php include "connect.php"; if(isset($_POST["signup"])) { $un=$_POST["uname"]; $pw=$_POST["pwd"]; $fn=$_POST["fname"]; $ln=$_POST["lname"]; $eml=$_POST["email"]; $ph=$_POST["phone"]; $gen=$_POST["radiobutton"]; $ad=$_POST["add"]; /*$phot=$_FILES["photo"]["name"]; move_uploaded_file($_FILES["photo"]["tmp_name"],'../photo/'.$phot);*/ $res=mysql_query("select * from users where uname='$un'"); /*or email='$eml'"*/ $row=mysql_num_rows($res); if($row==0) { mysql_query("insert into users(rdate,uname,pwd,fname,lname,email,phone,gender,address,sdate)values(CURDATE(),'$un','$pw','$fn','$ln','$eml','$ph','$gen','$ad',CURDATE())"); echo "<script language='javascript'>alert('Registration Successfull, An activation email will be send in 24 hours to your email account, Pleace check and confirm, Thanks')</script>"; } else { echo "<script language='javascript'>alert('Username or email already registered before, Please use different username or email')</script>"; } } ?>