Data Insert Into MySQL Database – PHP

Pritty July 25, 2016 HTML, mySQL, PHP, Web Development Leave a comment 574 Views

Hi all,
In here, I will show you to how to insert data into mysql database from php page.

Table Of Content

Create Database
Create Table
HTML Form
HTML Style

Create Database

In here, the database is create for performing insert operation. Create database and name it whatever you want.

CREATE DATABASE prittytimes ;

In here ‘prittytimes’ is the database name for creating table. We create table in prittytimes database.

Create Table

Now create table and name it ‘tbl_users’

CREATE TABLE `prittytimes`.`tbl_users` (
`user_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`firstname` VARCHAR( 25 ) NOT NULL ,
`lastname` VARCHAR( 25 ) NOT NULL ,
`useremail` VARCHAR( 45 ) NOT NULL
) ENGINE = InnoDB;

CREATE TABLE `prittytimes`.`tbl_users` (

`user_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`firstname` VARCHAR( 25 ) NOT NULL ,

`lastname` VARCHAR( 25 ) NOT NULL ,

`useremail` VARCHAR( 45 ) NOT NULL

) ENGINE = InnoDB;

We create ‘tbl_users’ table in ‘prittytimes’ database. And the tbl_users’ fields are user_id,firstname,lastname,useremail.

HTML Form

html form that inserts user first name , last name and email

<center>
<div id="header">
 <div id="content">
    <label>PHP Data Insert Into MySql</label>
    </div>
</div>
<div id="maincontent">
 <div id="content">
    <form method="post">
    <table align="center">
    <tr>
    <td><input type="text" name="firstname" placeholder="First Name" required /></td>
    </tr>
    <tr>
    <td><input type="text" name="lastname" placeholder="Last Name" required /></td>
    </tr>
    <tr>
    <td><input type="text" name="useremail" placeholder="user_email" required /></td>
    </tr>
    <tr>
    <td><button type="submit" name="btnsave"><strong>SAVE</strong></button></td>
    </tr>
    </table>
    </form>
    </div>
</div>
</center>

<label>PHP Data Insert Into MySql</label>

</div>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</div>

</center>

HTML Style

HTMl page style is specified in style tag.

<style>

body
{
 background:#f9f9f9;
 font-family:"Courier New", Courier, monospace;
}
#header
{
 width:100%;
 height:50px;
 background:#00a2d1;
 color:#f9f9f9;
 font-family:"Lucida Sans Unicode", "Lucida Grande", sans-serif;
 font-size:35px;
 text-align:center;
}
#maincontent
{
 margin-top:80px;
}
table
{
 width:40%;
}
table,td
{
 border-collapse:collapse;
 border:solid #d0d0d0 1px;
 padding:25px;
}
table td input
{
 width:97%;
 height:35px;
 border:dashed #00a2d1 1px;
 padding-left:15px;
 font-family:Verdana, Geneva, sans-serif;
 box-shadow:0px 0px 0px rgba(1,0,0,0.2);
 outline:none;
}
table td input:focus
{
 box-shadow:inset 1px 1px 1px rgba(1,0,0,0.2);
 outline:none;
}
table td button
{
 border:solid #f9f9f9 0px;
 box-shadow:1px 1px 1px rgba(1,0,0,0.2);
 outline:none;
 background:#00a2d1;
 padding:15px;
 color:#f9f9f9;
 font-family:Arial, Helvetica, sans-serif;
 font-weight:bolder;
 border-radius:3px;
 width:100%;
}
table td button:active
{
 position:relative;
 top:1px;
}
</style>

<style>

body

{

background:#f9f9f9;

font-family:"Courier New", Courier, monospace;

}

#header

{

width:100%;

height:50px;

background:#00a2d1;

color:#f9f9f9;

font-family:"Lucida Sans Unicode", "Lucida Grande", sans-serif;

font-size:35px;

text-align:center;

}

#maincontent

{

margin-top:80px;

}

table

{

width:40%;

}

table,td

{

border-collapse:collapse;

border:solid #d0d0d0 1px;

padding:25px;

}

table td input

{

width:97%;

height:35px;

border:dashed #00a2d1 1px;

padding-left:15px;

font-family:Verdana, Geneva, sans-serif;

box-shadow:0px 0px 0px rgba(1,0,0,0.2);

outline:none;

}

table td input:focus

{

box-shadow:inset 1px 1px 1px rgba(1,0,0,0.2);

outline:none;

}

table td button

{

border:solid #f9f9f9 0px;

box-shadow:1px 1px 1px rgba(1,0,0,0.2);

outline:none;

background:#00a2d1;

padding:15px;

color:#f9f9f9;

font-family:Arial, Helvetica, sans-serif;

font-weight:bolder;

border-radius:3px;

width:100%;

}

table td button:active

{

position:relative;

top:1px;

}

</style>

Full Code

<?php
 $conn= mysqli_connect('localhost','root','','prittytimes') or die(mysqli_error($connection));
if(isset($_POST['btn-save']))
{
 $firstname = $_POST['firstname'];
 $lastname = $_POST['lastname'];
 $useremail = $_POST['useremail'];
 $sql_query = "INSERT INTO tbl_users(firstname,lastname,useremail) VALUES('$firstname','$lastname','$useremail')";
 if(mysqli_query($conn,$sql_query))
 {
  ?>
  <script type="text/javascript">
  alert('Data Are Inserted Successfully Checkout Your Database Table');
  </script>
  <?php
 }
 else
 {
  ?>
  <script type="text/javascript">
  alert('error occured while inserting your data');
  </script>
  <?php
 }
}

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP Data Insert Into MySql</title>
<style>
body
{
 background:#f9f9f9;
 font-family:"Courier New", Courier, monospace;
}
#header
{
 width:100%;
 height:50px;
 background:#00a2d1;
 color:#f9f9f9;
 font-family:"Lucida Sans Unicode", "Lucida Grande", sans-serif;
 font-size:35px;
 text-align:center;
}
#maincontent
{
 margin-top:80px;
}
table
{
 width:40%;
}
table,td
{
 border-collapse:collapse;
 border:solid #d0d0d0 1px;
 padding:25px;
}
table td input
{
 width:97%;
 height:35px;
 border:dashed #00a2d1 1px;
 padding-left:15px;
 font-family:Verdana, Geneva, sans-serif;
 box-shadow:0px 0px 0px rgba(1,0,0,0.2);
 outline:none;
}
table td input:focus
{
 box-shadow:inset 1px 1px 1px rgba(1,0,0,0.2);
 outline:none;
}
table td button
{
 border:solid #f9f9f9 0px;
 box-shadow:1px 1px 1px rgba(1,0,0,0.2);
 outline:none;
 background:#00a2d1;
 padding:15px;
 color:#f9f9f9;
 font-family:Arial, Helvetica, sans-serif;
 font-weight:bolder;
 border-radius:3px;
 width:100%;
}
table td button:active
{
 position:relative;
 top:1px;
}

</style>
</head>
<body>
<center>
<div id="header">
 <div id="content">
    <label>PHP Data Insert Into MySql</label>
    </div>
</div>
<div id="maincontent">
 <div id="content">
    <form method="post">
    <table align="center">
    <tr>
    <td><input type="text" name="firstname" placeholder="First Name" required /></td>
    </tr>
    <tr>
    <td><input type="text" name="lastname" placeholder="Last Name" required /></td>
    </tr>
    <tr>
    <td><input type="text" name="useremail" placeholder="user email" required /></td>
    </tr>
    <tr>
    <td><button type="submit" name="btn-save"><strong>SAVE</strong></button></td>
    </tr>
    </table>
    </form>
    </div>
</div>
</center>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

<?php

$conn= mysqli_connect('localhost','root','','prittytimes') or die(mysqli_error($connection));

if(isset($_POST['btn-save']))

{

$firstname = $_POST['firstname'];

$lastname = $_POST['lastname'];

$useremail = $_POST['useremail'];

$sql_query = "INSERT INTO tbl_users(firstname,lastname,useremail) VALUES('$firstname','$lastname','$useremail')";

if(mysqli_query($conn,$sql_query))

{

alert('Data Are Inserted Successfully Checkout Your Database Table');

</script>

<?php

}

else

{

alert('error occured while inserting your data');

</script>

<?php

}

<html>

<head>

<title>PHP Data Insert Into MySql</title>

<style>

body

{

background:#f9f9f9;

font-family:"Courier New", Courier, monospace;

}

#header

{

width:100%;

height:50px;

background:#00a2d1;

color:#f9f9f9;

font-family:"Lucida Sans Unicode", "Lucida Grande", sans-serif;

font-size:35px;

text-align:center;

}

#maincontent

{

margin-top:80px;

}

table

{

width:40%;

}

table,td

{

border-collapse:collapse;

border:solid #d0d0d0 1px;

padding:25px;

}

table td input

{

width:97%;

height:35px;

border:dashed #00a2d1 1px;

padding-left:15px;

font-family:Verdana, Geneva, sans-serif;

box-shadow:0px 0px 0px rgba(1,0,0,0.2);

outline:none;

}

table td input:focus

{

box-shadow:inset 1px 1px 1px rgba(1,0,0,0.2);

outline:none;

}

table td button

{

border:solid #f9f9f9 0px;

box-shadow:1px 1px 1px rgba(1,0,0,0.2);

outline:none;

background:#00a2d1;

padding:15px;

color:#f9f9f9;

font-family:Arial, Helvetica, sans-serif;

font-weight:bolder;

border-radius:3px;

width:100%;

}

table td button:active

{

position:relative;

top:1px;

}

</style>

</head>

<body>

<label>PHP Data Insert Into MySql</label>

</div>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</div>

</center>

</body>

</html>

From the above code we can clearly say that, first we specify the html part for input field like firstname, lastname,useremail. The fields are specified in input tag with name. Next is PHP part, in here first we specify database connection in php page for insert the value from form. Get the input values from form using $_POST[]method. and insert values to database from form field.

Happy coding

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.