PHP insert update, delete using PDO part-3
Part-3: Insert record using prepared statement in PDO.
In part three, I am creating two file one is the HTML file (insert.html) to define form to get the information and second one (insert.php) is the code behind file to retrieve the values from HTML and insert those values in database using prepared statement with the help of PDO.
insert.html
<!DOCTYPE html>
<html>
<body>
<form method="GET" action="insert.php">
Name :<input type="text" name="txtName" required><br/>
Email :<input type="email" name="txtEmail" required><br/>
Phone :<input type="number" name="txtPhone" required><br/>
<input type="submit" value="Insert"><input type="reset" value="Clear"><br/>
</form>
</body>
</html>
insert.php
<?php
require("conn.php");
try
{
$tbl="tbl";
$name = $_GET["txtName"];
$email = $_GET["txtEmail"];
$phone = $_GET["txtPhone"];
/*
// prepare sql and bind parameters
$stmt = $conn->prepare("INSERT INTO $tbl (name, email, phone)
VALUES (:name, :email, :phone, :message)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':phone', $phone);
$stmt->execute();
*/
$stmt = $conn->prepare("INSERT INTO $tbl (name, email, phone) VALUES (?, ?, ?)");
$stmt->execute(array($name,$email,$phone));
$last_id = $conn->lastInsertId();
echo "<br> Record [ $last_id ] inserted" ;
}
catch(PDOException $e)
{
echo "Error: " . $e->getMessage();
}
$conn = null;
?>
This example is divided in multiple part.
Part-1: Configure and Setup the MySQL database connection using PDO.
Part-2: Create a MySQL Database and a table using PDO.
Part-3: Insert record using prepared statement in PDO.
Part-4: Display Records using prepared statement.
Part-5: Search records using AJAX and PDO in PHP.
Part-6: Update Record using prepared statement in PDO.
Part-7: Delete Record using prepared statement in PDO.
Subscribe to:
Post Comments (Atom)
Subjects
- WordPress
- Mobile Computing-4649303 Practical Solution
- Android Programming New Syllabus Theory
- PHP LAMP Question Bank
- PHP LAMP Theory
- Step by Step Android Example
- Android Practical
- Android Theory
- Android Question Bank
- Networking FON Practical
- Networking FON Theory
- OS Practical
- OS Theory
- HTML
- JavaScript
- J2EE WTAD Theory
- J2EE WTAD Question Bank
- J2EE WTAD Quick Guide
- J2EE WTAD GTU Papers
- J2EE WTAD Practical
- Python
- JAVA Theory
- JAVA Practical
- MIS
Categories
- Android (55)
- CSS (3)
- Configure Tomcat7 (2)
- Decryption (16)
- Difference (1)
- Encryption (16)
- Error Detection and Correction Techniques (3)
- FON (27)
- Framing Technic (2)
- J2EE (29)
- JAVA (13)
- JavaScript (19)
- OS (17)
- PHP (11)
- Protocol (3)
- SERVER SOCKET PROGRAMING (7)
- Servlet (13)
- WTAD (34)
- c (11)
- install Tomcat (2)
- linux (8)
- shell script (33)
- unix (22)
Blog Archive
-
▼
2015
(13)
-
▼
July
(8)
- PHP-Delete Record using prepared statement in PDO
- PHP - Update Record using prepared statement in PDO
- PHP - Search records using AJAX and PDO
- Part-4: Display Records using prepared statement
- PHP insert update, delete using PDO part-3
- PHP insert update, delete using PDO part-2
- PHP insert update, delete using PDO part-1
- PHP PDO : insert, update delete example for beginners
-
▼
July
(8)
Total Pageviews
© BipinRupadiya.com. Powered by Blogger.
1 comments:
Your explanation is so easy and interesting. The person information about ins It is a wonderful post with full of information. I enjoyed reading each and everything in this post. Thank you very much for sharing this excellent post.
Post a Comment