Home � � insert update delete using php and mysql | PHP beginers

insert update delete using php and mysql | PHP beginers

taabin | 04:20 | 0 comments

insert update delete using PHP | mysql PHP Insert Update Delete using PHP MySql

index.php

<!DOCTYPE html>
<html>
<head>
<title>phptaab.blogspot.in</title>

</head>

<body>
<form method="post">
<table>
<tr>
  <td>Title:</td>
  <td><input type="text" name="title" class="form-control"/></td>
 </tr>
<tr>
  <td>Author</td>
  <td><input type="text" name="author" class="form-control"/></td>
 </tr>
<tr>
  <td>Publisher Name</td>
  <td><input type="text" name="name" class="form-control"/></td>
 </tr>
<tr>
  <td>Copyright Year</td>
  <td><input type="text" name="copy" class="form-control"/></td>
 </tr>
<tr>
  <td> </td>
  <td><input type="submit" name="submit" value="add" class="btn btn-success btn-lg"/></td>
 </tr>
</table>
<?php
if (isset($_POST['submit']))
 {    
 include 'db.php';
 
      $title=$_POST['title'] ;
     $author= $_POST['author'] ;     
     $name=$_POST['name'] ;
     $copy=$_POST['copy'] ;
            
   mysql_query("INSERT INTO `example`(Title,Author,PublisherName,CopyrightYear) 
   VALUES ('$title','$author','$name','$copy')"); 
    
    
         }
?>
</form>
<table border="1">
 
   <?php
   include("db.php");
   
    
   $result=mysql_query("SELECT * FROM example");
   
   while($test = mysql_fetch_array($result))
   {
    $id = $test['BookID']; 
    echo "
<tr align='center'>"; 
    echo"<td><font color='black'>" .$test['BookID']."</font></td>";
    echo"<td><font color='black'>" .$test['Title']."</font></td>";
    echo"<td><font color='black'>". $test['Author']. "</font></td>";
    echo"<td><font color='black'>". $test['PublisherName']. "</font></td>";
    echo"<td><font color='black'>". $test['CopyrightYear']. "</font></td>"; 
    echo"<td> <a href ='view.php?BookID=$id'>Edit</a>";
    echo"<td> <a href ='del.php?BookID=$id'><center>
Delete</center>
</a>";
         
    echo "</tr>
";
   }
   mysql_close($conn);
   ?>
</table>
<script src="bootstrap/js/bootstrap.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>

view.php

<?php
require("db.php");
$id =$_REQUEST['BookID'];

$result = mysql_query("SELECT * FROM example WHERE BookID  = '$id'");
$test = mysql_fetch_array($result);
if (!$result) 
  {
  die("Error: Data not found..");
  }
    $Title=$test['Title'] ;
    $Author= $test['Author'] ;     
    $PublisherName=$test['PublisherName'] ;
    $CopyrightYear=$test['CopyrightYear'] ;

if(isset($_POST['save']))
{ 
 $title_save = $_POST['title'];
 $author_save = $_POST['author'];
 $name_save = $_POST['name'];
 $copy_save = $_POST['copy'];

 mysql_query("UPDATE example SET Title ='$title_save', Author ='$author_save',
   PublisherName ='$name_save',CopyrightYear ='$copy_save' WHERE BookID = '$id'")
    or die(mysql_error()); 
 echo "Saved!";
 
 header("Location: index.php");   
}
mysql_close($conn);
?>
<!DOCTYPE html>
<html>
<head>
<title>phptaab.blogspot.in</title>
</head>

<body>
<form method="post">
<table>
<tr>
  <td>Title:</td>
  <td><input type="text" name="title" value="<?php echo $Title ?>"/></td>
 </tr>
<tr>
  <td>Author</td>
  <td><input type="text" name="author" value="<?php echo $Author ?>"/></td>
 </tr>
<tr>
  <td>Publisher Name</td>
  <td><input type="text" name="name" value="<?php echo $PublisherName ?>"/></td>
 </tr>
<tr>
  <td>Copyright Year</td>
  <td><input type="text" name="copy" value="<?php echo $CopyrightYear ?>"/></td>
 </tr>
<tr>
  <td> </td>
  <td><input type="submit" name="save" value="save" /></td>
 </tr>
</table>
</body>
</html>

del.php

<?php
  include("db.php");  

 $id =$_REQUEST['BookID'];
 
 
 // sending query
 mysql_query("DELETE FROM example WHERE BookID = '$id'")
 or die(mysql_error());   
 
 header("Location: index.php");
?>

db.php

<?php  
 $conn = mysql_connect('localhost', 'root', '');
  if (!$conn)
    {
  die('Could not connect: ' . mysql_error());
 }
 mysql_select_db("jobs", $conn);
?>

example.sql

-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 25, 2014 at 01:38 PM
-- Server version: 5.6.16
-- PHP Version: 5.5.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `jobs`
--

-- --------------------------------------------------------

--
-- Table structure for table `example`
--

CREATE TABLE IF NOT EXISTS `example` (
  `BookID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(150) NOT NULL,
  `Author` varchar(150) NOT NULL,
  `PublisherName` varchar(150) NOT NULL,
  `CopyrightYear` year(4) NOT NULL,
  PRIMARY KEY (`BookID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

--
-- Dumping data for table `example`
--

INSERT INTO `example` (`BookID`, `Title`, `Author`, `PublisherName`, `CopyrightYear`) VALUES
(34, 'Java Developer', 'Aegis', 'Manoj', 2014),
(36, 'Java 1+', 'eee', 'ertret', 2010),
(37, 'Ab', 'hh', 'hhhn', 2014);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Thank You --> VISIT Again

Category:

About GalleryBloggerTemplates.com:
GalleryBloggerTemplates.com is Free Blogger Templates Gallery. We provide Blogger templates for free. You can find about tutorials, blogger hacks, SEO optimization, tips and tricks here!

Blogger news

insert update delete using php and mysql | PHP beginers

0 comments

Win Prize

Popular Posts

Followers

Blog Archive

Infolinks

Visitors