function deleterec(){
$server="127.0.0.1";
$username="root";
$password="";
$database="inventory";
$conn= new PDO("mysql:host=$server;dbname=$database",$username,$password);
$getstarteds = $conn->prepare("SELECT * FROM record");
$getstarteds->execute();
$displayrecs = $getstarteds->fetch();
if(count($displayrecs)>0){
$_SESSION['id']=$displayrecs['id'];
$checkrec = $conn->prepare("INSERT INTO archive SELECT * from record where id = '".$_SESSION['id']."'");
if( $checkrec->execute()){
$sql="DELETE FROM record WHERE id='".$displayrecs['id']."'";
$stmt = $conn->prepare($sql);
if($stmt->execute()){
echo '<script language="javascript">';
echo 'alert("Record is Deleted")';
echo '</script>';
echo"<script>setTimeout("location.href='main.php'",100);</script>";
}
}
}