Forum PHP.pl

Co robię nie tak skrypt ma za zadanie usuwać wpis z bazy danych po ID

Warning: Undefined variable $connect in C:\xampp\htdocs\dashboard\deleteTypes.php on line 5

Fatal error: Uncaught Error: Call to a member function query() on null in C:\xampp\htdocs\dashboard\deleteTypes.php:5 Stack trace: #0 {main} thrown in C:\xampp\htdocs\dashboard\deleteTypes.php on line 5

[PHP] pobierz, plaintext 
<?php 
$id= $_GET['id'];
$conn = new mysqli("127.0.0.1", "root", "", "zajaca");
$sql1= "SELECT * FROM meals WHERE type_id=$id";
$conn1 = $connect->query($sql);
$meals= $conn1->num_rows;
if($meals==0){
$sql = "DELETE FROM types WHERE id=$id";
$conn = $connect->query($sql);
}
header('location:types.php');
?>
[PHP] pobierz, plaintext 

Ten post edytował Yankesowsky 27.12.2022, 16:26:55

[PHP] pobierz, plaintext 
<?php 
$id= $_GET['id'];
$conn = new mysqli("127.0.0.1", "root", "", "zajaca");
$sql1= "SELECT * FROM meals WHERE type_id=$id";
$conn1 = $conn->query($sql1);
$meals= $conn1->num_rows;
if($meals==0){
$sql = "DELETE FROM types WHERE id=$id";
$conn = $conn->query($sql);
}
header('location:types.php');
?>
[PHP] pobierz, plaintext 

dobra zmieniłem to ale skrypt nadal nie usuwa pozycji z bazy