Using MySQL database with PHP to Store Sign Up Information tutorial

Check out part one of creating sign up form.
In the previous class we created a signup form and stored the data in variable and displayed it using echo. Now instead of displaying the data directly, we will store the data in a Mysql database so that we can use the data whenever we need it. Even if you don’t have understanding of sql queries, you can easily get along as i will show you just basic operation and if you have any doubts, just comment ’em up.


MySQL + PHP

  To store the sign up data of users in a database, first of all you need a database. You can see how I create local database using XAMPP here.
After creating your database you need to connect to the database just created and then simply modify the signup function that we created in the user class. 
Connet to your database like this-

function __construct() {

        $this->mysqli = new mysqli($this->host, $this->user, $this->pass, $this->db);
        if ($this->mysqli->error) {
            echo $this->mysqli->error;
        } else
            echo”connection successful<br>”;
    }

    private $host = “localhost”;  // default localhost

    private $db = “kathford_db”; //name of the database
    private $user = “root”;  // default root
    private $pass = “”; // default password

    private $mysqli;

And then modify the signup function of part 1 like this-


function signup() {

        //echo “hi i am test<br>”;
        $user = $_POST[‘username’];
        $email = $_POST[’email’];
        $phone = $_POST[‘phone’];
        $address = $_POST[‘address’];
        $pass = $_POST[‘password’];
        echo ‘<br>’ . $user;
        echo ‘<br>’ . $pass;
        echo ‘<bt>’ . $phone;
        echo ‘<br>’ . $address;
        echo ‘<br>’ . $email;
        $sql = “insert into tbl_user(name,email,address,phone,password) values(‘$user’,’$email’,’$address’,’$phone’,’$pass’)”;
        $this->mysqli->query($sql);
        if ($this->mysqli->error) {
            echo $this->mysqli->error;
        } else {
            echo “insertion successful”;
        }

    }
We are done, very simple, wasn’t it? Next we will learn how to sign in a user by checking his email and password, till then, happy coding and if any problems, just comment or connect to me.

Don’t miss these tips!

We don’t spam! Read our privacy policy for more info.

You’ve been successfully subscribed to our newsletter! See you on the other side!

Sharing is caring!

Leave a Comment

Your email address will not be published.

Exit mobile version