sample login register script php

<?php

    /**
    * Sample login and register
    * @author Ariff Azmi (ariff.azmi16@gmail.com)
    */

    /**
    * Initialize mysqli connection
    * @var String   serverlocation,username,password,databasename
    */
    $mysqli = new mysqli('localhost','root','','register');

    /**
    * For login script
    *
    * @var String   $_POST
    */

    // Trigger if submit button was clicked on login form
    if (isset($_POST['submit'])) {

        $email = $mysqli->real_escape_string($_POST['email']);
        $password = $mysqli->real_escape_string($_POST['password']);


        /**
        * Check if user exist and auth the user
        *
        * @var String   $email,$password
        */

        $auth = $mysqli->query("
            SELECT
                *,
                COUNT(*) as TOTAL
            FROM
                register
            WHERE
                email='".$email."'
                AND
                password='".$password."'
            LIMIT 1
        ");

        $auth_result = $auth->fetch_object();

        if ($auth_result->TOTAL==1) {

            // Do your code for redirect if user exist here
        }
        else{

            // Do your code for redirect if user not exist here
        }
    }



    /**
    * For register script
    *
    * @var String   $_POST
    */

    // Trigger if submit button was clicked on register form
    if (isset($_POST['submit'])) {

        $username = $mysqli->real_escape_string($_POST['username']);
        $email = $mysqli->real_escape_string($_POST['email']);
        $password = $mysqli->real_escape_string($_POST['password']);


        /**
        * Create new record in database
        *
        * @var String   $username,$email,$password
        */

        $create_record = $mysqli->query("
            INSERT INTO
                register
            VALUES('".$username."','".$email."','".$password."')
        ");

        if ($create_record) {

            // Do your code for redirect if user successfully registered
        }
        else{

            // Do your code for redirect if user was not successfully registered
        }
    }

?>