Thursday, March 15, 2018

Saving data in database using PDO

Instructions

Sample database: demo
Sample table: persons
Columns:
id - int
first_name - vc-50
last_name - vc - 50
email - vc - 50

PHP code and HTML code : addperson.php

<?php
$message="";
if(isset($_POST['id']))
{
try
{
extract($_POST); //To automatically create the variables with field name
$sql="INSERT INTO persons VALUES($id,'$first_name','$last_name','$email')";
$pdo = new PDO("mysql:host=localhost;dbname=demo", "root", "");
$pdo->query($sql);
unset($pdo);
$message="Record Saved";
}
catch(PDOException $ex)
{
$message="Error : ".$ex->getMessage();
}
}
?>
<form action="addperson.php" method="post">
Person ID <input name="id" type="text" required="required"/><br />
First Name <input name="first_name" type="text" required="required"/><br />
Last Name <input name="last_name" type="text" required="required"/><br />
Email <input name="email" type="text" required="required"/><br />
<input name="submit" type="submit" value="Save Person" />
</form>
<div><?php echo $message; ?></div>



No comments:

Post a Comment