I have created a admin panel in which user registration but it always showing me something went wrong error message

Question

<?php
    if(isset($_POST['btn-signup'])) {
            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "test";
            $conn = new mysqli($servername, $username, $password, $dbname);
            if($conn->connect_error)
                {
                    die("Connection failed :" . $conn->connect_error);
                }   
        $uname = trim($_POST['uname']);
        $email = trim($_POST['email']);
        $upass = trim($_POST['pass']);
        $mobile = trim($_POST['mobile']);
        $fee = trim($_POST['fee']);

        $uname = strip_tags($uname);
        $email = strip_tags($email);
        $upass = strip_tags($upass);
        $mobile = strip_tags($mobile);
        $fee = strip_tags($fee);
        $role = "user";


// check email exist or not
        $query = "SELECT email FROM users WHERE email='$email'";
        $result = mysqli_query($query);

        $count = mysqli_num_rows($result); // if email not found then proceed

if ($count==0) {

        $query = "INSERT INTO users(username,email,password,mobile,fee,role) VALUES('$uname','$email','$upass','$mobile','$fee','$role')";
        $res = mysqli_query($query);

    if ($res) {
        $errTyp = "success";
        $errMSG = "successfully registered, you may login now";
    } else {
        $errTyp = "danger";
        $errMSG = "Something went wrong, try again later..." .mysql_error();    
    }   

} else {
    $errTyp = "warning";
    $errMSG = "Sorry Email already in use ...";
}
mysqli_close($conn);
}

?>

whenever i click on submit button it always give me "something went wrong error" even i check for the error that has to be "sorry email already in use" but it always showing "something went wrong". i use session also. i am newbie in php and creating a session based login system for different role such as admin and student. please give me solution as soon as possible thank you :)

Why don't you check for errors in your code? If you did you'd know what was wrong: [`mysql_error()`](http://php.net/manual/en/function.mysql-error.php) — John Conde, Aug 19 '16 at 13:14
bro it shwoing error " Something went wrong, try again later...No database selected" when i use mysql_error() but i olready mention the dbname . now what to do ? — Amit Chauhan, Aug 19 '16 at 13:19
Possible duplicate of [Can I mix MySQL APIs in PHP?](http://stackoverflow.com/questions/17498216/can-i-mix-mysql-apis-in-php) — Epodax, Aug 19 '16 at 13:25
**WARNING**: When using `mysqli` you should be using [parameterized queries](http://php.net/manual/en/mysqli.quickstart.prepared-statements.php) and [`bind_param`](http://php.net/manual/en/mysqli-stmt.bind-param.php) to add user data to your query. **DO NOT** use string interpolation or concatenation to accomplish this because you have created a severe [SQL injection bug](http://bobby-tables.com/). `strip_tags` is **not** a suitable escaping method. — tadman, Aug 19 '16 at 15:37

score 2 · Accepted Answer · edited May 23 '17 at 12:00

2

Use only "mysqli_" or "mysql_", recommended is "mysqli_"

You are connecting database with "mysqli_" and fetching the result set using "mysql_"

Learn the Difference MYSQL vs MYSQLi vs PDO

edited May 23 '17 at 12:00

Community

1
1

answered Aug 19 '16 at 13:21

PravinS

2,640
3
21
25

1

this. it can't be stressed enough that the old mysql_* functions aren't recommended any more for any php 5.* version and removed in php 7! – cypherabe Aug 19 '16 at 13:25
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\bank\student_register.php on line 37 – Amit Chauhan Aug 19 '16 at 13:25
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\bank\student_register.php on line 42 – Amit Chauhan Aug 19 '16 at 13:26
it giving me error on the line where i check if the email is already exist or not – Amit Chauhan Aug 19 '16 at 13:27
@AmitChauhan: update your latest code and check the records in "users" table – PravinS Aug 19 '16 at 13:28
i updated mysql to mysqli in every place. and the code is same above. – Amit Chauhan Aug 19 '16 at 13:30

score 0 · Answer 2 · answered Aug 19 '16 at 13:47

0

I have seen your code.

Please check the syntax of Insert query once , print the query and run in mysql db and see if it run fine or not.

I think this will resolve your issue.

answered Aug 19 '16 at 13:47

Shallini

1
1

I have created a admin panel in which user registration but it always showing me something went wrong error message

2 Answers2