how to Insert Data Into Database Using PHP and MySQLi

Insert Data Into Database Using PHP and MySQLi

by

This time, I will teach you how to Insert Data Into Database Using PHP and MySQLi. In this tutorial it will demonstrate to you on how to Insert Data Into Database with the use of insert query statement in PHP and MySQLi.

Below are following step by step guide on how to Insert Data Into Database Using PHP and MySQLi.

Lets Begin:

First Step: Create a MySQL Database and name it “userdb“.

Second Step: Do the following code for creating a table in the database that you have created.

[mysql]

CREATE TABLE `userdb`.`tbluser` (
`UserID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Name` VARCHAR( 30 ) NOT NULL ,
`Username` VARCHAR( 30 ) NOT NULL ,
`Pass` VARCHAR( 90 ) NOT NULL
) ENGINE = INNODB;

[/mysql]

Third Step: Create a .php file and name it “index.php“.

Fourth Step: Do the following code for the html view of a form.

[php]

<html>
<title>Insert Data Into Database Using PHP and MySQLi</title>
<head>
<h1 align=”center”>Add New User</h1>
</head>
<body>
<div id=”box”>
<div class=”column”></div>
<div class=”column”><form id=”main” class=”form” action=”index.php ” method=”POST”><label class=”first-column “>Name:</label>
<div class=”second-column”></div>
<div class=”clear”></div>
<label class=”first-column “>Username:</label>
<div class=”second-column”></div>
<div class=”clear”></div>
<label class=”first-column “>Password:</label>
<div class=”second-column”></div>
<div class=”clear”></div>
<div class=”first-column “></div>
<div class=”second-column”><button class=”btn” name=”save” type=”submit”>Save</button></div>

</form>
</div>
<div class=”column”></div>
</div>
</body>
</html>

[/php]
Fifth Step: Create a CSS Style for the layout of the form.

[css]

#box{
width: 100%;
}
.column {
width: 33.33%;
display: inline-block;
}
.form{
padding: 2px;
width: 100%;
display: inline-block;
}
.first-column {
display: inline-block;
width: 100px;
height: 2px;
margin: 2px;
position: inherit;
}
.second-column{
display: inline-block;
width: 150px;
height: 25px;
margin: 1px;
padding: 0px;
position: inherit;
}
.btn{
width: 50px;
height: 40px;
margin: 2px;
float: left;
}
.c{
c: left;
height: 15px;
}

[/css]

Sixth Step: Create a script for inserting data into database.

[php]

<?php
$server=”localhost”;
$userid =”root”;
$Password = “”;
$myDB = “userdb”;
$con = mysqli_connect($server,$userid,$Password,$myDB);
if (mysqli_connect_errno()) {
# code…
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
if (isset($_POST[‘save’])) {
# code…
$name = $_POST[‘name’];
$username = $_POST[‘username’];
$pass = $_POST[‘pass’];
$sqli = “INSERT INTO `tbluser` (`UserID`, `Name`, `Username`, `Pass`) VALUES (null,'{$name}’,'{$username}’,'{$pass}’)”;
$res = mysqli_query($con,$sqli);
if ($res) {
# code…
echo “New Data has been save in the database.”;
}

mysqli_close($con);
}
?>

[/php]

If you have any questions or suggestion about how to Insert Data Into Database Using PHP and MySQLi, please feel free to contact us at our contact page.You can subscribe this site to see more of my tutorials.

You can also view these tutorials below:

Leave a Comment