Create Db of Name "pdourdu"
After that you need to create table:
CREATE TABLE `users` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`email` VARCHAR( 25 ) NOT NULL ,
`pass` VARCHAR( 25 ) NOT NULL
)
Create connection file name write as "connect.php"
<?php
try{
$con = new PDO ("mysql:host=localhost;dbname=pdourdu","root","");
echo "connected";
}
catch(PDOException $e)
{
echo "error:".$e->getMessage();
}
?>
Create Insert.php file
<?php
try{
$con = new PDO ("mysql:host=localhost;dbname=pdourdu","root","");
if(isset($_POST['done']))
{
$email = $_POST['email'];
$pass = $_POST['pass'];
$insert = $con->prepare("INSERT INTO users (email,pass) VALUES(:email,:pass)");
$insert->bindParam(':email',$email);
$insert->bindParam(':pass',$pass);
$insert->execute();
echo "insert it";
}
}
catch(PDOException $e)
{
echo "error:".$e->getMessage();
}
?>
<form method="post">
<input type="text" name="email" placeholder="Email">
<input type="text" name="pass" placeholder="*****">
<input type="submit" name="done" >
</form>
Create select.php file
<table border="2">
<tr>
<th>ID</th>
<th>EMAIL</th>
<th>PASSWORD</th>
<th colspan="2">ACTION</th>
</tr>
<?php
try{
$con = new PDO ("mysql:host=localhost;dbname=pdourdu","root","");
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$select = $con->prepare("SELECT * FROM users ");
$select->setFetchMode(PDO::FETCH_ASSOC);
$select->execute();
while($data=$select->fetch()){
?>
<tr>
<td><?php echo $data['id']; ?></td>
<td><?php echo $data['email']; ?></td>
<td><?php echo $data['pass']; ?></td>
<td><a href="update.php?edit_id=<?php echo $data['id']; ?>">EDIT</a></td>
<td><a href="delete.php?del_id=<?php echo $data['id']; ?>">DELETE</a></td>
<?php
}
}
catch(PDOException $e)
{
echo "error:".$e->getMessage();
}
?>
</tr></table>
Create Update.php file
<?php
try{
$con = new PDO ("mysql:host=localhost;dbname=pdourdu","root","");
$edit_id = $_GET['edit_id'];
$select = $con->prepare("SELECT * FROM users where id='$edit_id' ");
$select->setFetchMode(PDO::FETCH_ASSOC);
$select->execute();
$data=$select->fetch();
if(isset($_POST['done']))
{
$email = $_POST['email'];
$pass = $_POST['pass'];
$update = $con->prepare("UPDATE users SET email=:email ,pass=:pass where id='$edit_id'");
$update->bindParam(':email',$email);
$update->bindParam(':pass',$pass);
$update->execute();
header("location:select.php");
}
}
catch(PDOException $e)
{
echo "error:".$e->getMessage();
}
?>
<form method="post">
<input type="text" name="email" placeholder="Email" value="<?php echo $data['email'] ?>">
<input type="text" name="pass" placeholder="*****" value="<?php echo $data['pass'] ?>">
<input type="submit" name="done" >
</form>
Create Delete.php file
<?php
try{
$con = new PDO ("mysql:host=localhost;dbname=pdourdu","root","");
$del_id = $_GET['del_id'];
$DELETE = $con->prepare("DELETE FROM users where id='$del_id'");
$DELETE->execute();
header("location:select.php");
}
catch(PDOException $e)
{
echo "error:".$e->getMessage();
}
?>
No comments:
Post a Comment