phptaab: August 2014

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

php tutorial pdf free download | PHP tutorial pdf free download for beginners with examples | beginners tutorial examples free download | php examples | insert update delete example

If You want to learn the basics of PHP, then you have to come to the right place.

PHP TUTORIAL EXAMPLES

Content :
1 what is PHP
2 what's it do
3 what you should know
4 tutorial overview

PHP TUTORIAL BEGINNERS

And Download

Blogger news

Win Prize

Popular Posts

Followers

Blog Archive

Infolinks

Visitors