<?php
include_once 'connection.php';
$con = getConnection();

$idfruta = $_GET['frutaid'];


$sql = "select * from frutas_vitaminas
where frutaid = '".$idfruta."';";

$stmt = $con->prepare($sql);
$stmt->execute();

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($result as $key => $value) {
    // var_dump($value);
    $deletesql  = "delete from vitaminas_desc where id = '".$value['id']."' ";
    $stmt = $con->prepare($deletesql);
    $stmt->execute();

    $deletesql2 = "delete from frutas_vitaminas where id = '".$value['id']."' ";
    $stmt2 = $con->prepare($deletesql2);
    $stmt2->execute();
}

$deletesql3 = "delete from frutas where id = '".$idfruta."'";
$stmt3 = $con->prepare($deletesql3);
$stmt3->execute();


header('Location: listagem.php');
exit();



?>