Desire Code

Android Tutorial , Programming Tutorial, Php Tutorial, Learn Android, HTML Tutorial, Coding , Java Tutorial, GTU Programs, Learning Programming

Showing posts with label Insert record using mysql in php. Show all posts
Showing posts with label Insert record using mysql in php. Show all posts

Sunday, 18 September 2016

Insert , Update , Delete in mysql using php

Author:  |   |  31 Comments | 

In this example, CRUD operation (Insert,update,delete,view Record) is describe here. As we enter data in textbox , that data will be stored in the database which is created in mysql. We can update record. If record is available in the database table then we can update otherwise we can't update record. We can delete record by adding first name in this example. To make attractive look of form, in this example materialize css is used in the example .Let's see the example :

File Name :- insert.php

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<?php
 $servername= "localhost";
 $username = "root";
 $password="";
 $dbname="dbmultiple";
 
 $conn = new mysqli($servername,$username,$password,$dbname);
 if($conn->connect_error)
 {
  die("Connection Failed".$conn->connect_error);
 }
 if(isset($_POST['cancel']))
 {
  $fn = $_POST["fname"];
  $ln = $_POST["lname"];
  $fn="";
  $ln="";
 }
 if(isset($_POST['insert']))
 {
  $fn = $_POST["fname"];
  $ln = $_POST["lname"];  
  $sql = "INSERT INTO users(first_name,last_name) VALUES ('".$fn."','".$ln."')";
  if($conn->query($sql)===TRUE)
  {
   echo "Record Insert Successfully";
  }
  else
  {
   echo "Error :".$sql."<br>".$conn->error;
  }
 }
 $conn->close();
?>
<html>
<head>
<link rel="stylesheet" href="css/materialize.css"/>
<link rel="stylesheet" href="css/materialize.min.css"/>
</head>
<body>
<center>
<form method="POST" >
<div class="row">
 <div class="input-field col s6">
  
  <input type="text" name="fname" placeholder="Enter First Name" required><br/>
  <input type="text" name="lname" placeholder="Enter Last Name" required><br/>


 <input type="submit" name="insert" value="Insert" class="waves-effect waves-light btn">
 <input type="submit" name="cancel" value="Cancel" class="waves-effect waves-light btn">

</div>
</form>
</center>
<script type="text/javascript" src="js/materialize.js"/>
<script type="text/javascript" src="js/materialize.min.js"/>

</body>

</html>

Output :



File Name : update.php



 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
 $servername= "localhost";
 $username = "root";
 $password="";
 $dbname="dbmultiple";
 
 $conn = new mysqli($servername,$username,$password,$dbname);
 if($conn->connect_error)
 {
  die("Connection Failed".$conn->connect_error);
 }
 if(isset($_POST['cancel']))
 {
  $fn = $_POST["fname"];
  $ln = $_POST["lname"];
  $fn="";
  $ln="";
 }
 if(isset($_POST['update']))
 {
  $fn = $_POST["fname"];
  $ln = $_POST["lname"];  
  $sql = "UPDATE users SET last_name='$ln' WHERE first_name='$fn'";
  if($conn->query($sql)===TRUE)
  {
   echo "Record UPDATE Successfully";
  }
  else
  {
   echo "Error :".$sql."<br>".$conn->error;
  }
 }
 $conn->close();
?>
<html>
<head>
<link rel="stylesheet" href="css/materialize.css"/>
<link rel="stylesheet" href="css/materialize.min.css"/>
</head>
<body>
<center>
<form method="POST" >
<div class="row">
 <div class="input-field col s6">
  
  <input type="text" name="fname" placeholder="Enter First Name" required><br/>
  <input type="text" name="lname" placeholder="Enter Last Name" required><br/>


 <input type="submit" name="update" value="Update" class="waves-effect waves-light btn">
 <input type="submit" name="cancel" value="Cancel" class="waves-effect waves-light btn">

</div>
</form>
</center>
<script type="text/javascript" src="js/materialize.js"/>
<script type="text/javascript" src="js/materialize.min.js"/>
</body>
</html>
Output :


File Name : delete.php


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php
 $servername= "localhost";
 $username = "root";
 $password="";
 $dbname="dbmultiple";
 
 $conn = new mysqli($servername,$username,$password,$dbname);
 if($conn->connect_error)
 {
  die("Connection Failed".$conn->connect_error);
 }
 if(isset($_POST['cancel']))
 {
  $fn = $_POST["fname"];
  $ln = $_POST["lname"];
  $fn="";
  $ln="";
 }
 if(isset($_POST['delete']))
 {
  $fn = $_POST["fname"];
  $sql = "DELETE FROM users WHERE first_name='$fn'";
  if($conn->query($sql)===TRUE)
  {
   echo "Record DELETE Successfully";
  }
  else
  {
   echo "Error :".$sql."<br>".$conn->error;
  }
 }
 $conn->close();
?>
<html>
<head>
<link rel="stylesheet" href="css/materialize.css"/>
<link rel="stylesheet" href="css/materialize.min.css"/>
</head>
<body>
<center>
<form method="POST" >
<div class="row">
 <div class="input-field col s6">
  
 <input type="text" name="fname" placeholder="Enter First Name" required><br/>
 
 <input type="submit" name="delete" value="Delete" class="waves-effect waves-light btn">
 <input type="submit" name="cancel" value="Cancel" class="waves-effect waves-light btn">

</div>
</form>
</center>
<script type="text/javascript" src="js/materialize.js"/>
<script type="text/javascript" src="js/materialize.min.js"/>
</body>
Output :


Note :

Database Name : dbmultiple
Table Name : users
Field Name : first_name,last_name

 CSS Download link : Click Here

, , , , ,

Like us on Facebook

Site Visitor

Powered by Blogger.