PHP database connection using PDO

PHP data access using PDO

PDO(PHP Data Object) is the secure process to access the database(like ADO.NET in .NET).

The database connection file :-

dp.inc.php

<?php
try{
$db=new PDO("mysql:host=Your_Host_Name;dbname=db_name","Your_User_Name","Password");
}
catch(PDOException $exception)
{
    printf("Connection Error..");
}
?>


To Delete data :-

delete.php

<?php

include_once("db.inc.php");
echo $query="delete from table_name whereField_name='value'";
$i=$db->exec($query);
if($i > 0)
{
    echo "<script>alert('Value Deleted :".$i."')</script>";
}
else{
    echo "<script>alert('No Result found...')</script>";
}
?>

To insert to the database :-

insert.php

<?php
include_once("db.inc.php");
$pswd=uniqid(rand());
$query="insert into Table_Name values('value1','value2','value2')";
$affect=$db->exec($query);
if($affect > 0)
{
    echo "<script>alert('Value inserted')</script>";
}
else
{
    echo "<script>alert('Error')</script>";
}


?>

Select Query :-

select.php

<?php

include_once("db.inc.php");
$query="select * from table_name";

$stmt=$db->query($query);
while($row= $stmt->fetch(PDO::FETCH_ASSOC))
{
    echo $row['id'];
    echo "<br/>";
    echo $row['username'];
    echo "<br/>";
    echo $row['pswd'];
    echo "<br/>";
}

?>