get_category.php

<?php


global $connection;
$cat_to_delete =    mysqli_real_escape_string($connection, $_GET['get'] );

$sql = "SELECT category_name FROM categories WHERE category_id = ? ;";


$stmt = mysqli_stmt_init($connection);

if (!mysqli_stmt_prepare($stmt, $sql))
    $_SESSION['error'] = "Error at preaparing for deleting query. mysqli_stmt_error($stmt) ." & redirect('../error.php');

mysqli_stmt_bind_param($stmt, 's', $cat_to_delete);

if (!mysqli_stmt_execute($stmt))
    $_SESSION['error'] = "ERror at executing delete category ".mysqli_stmt_error($stmt) &
        redirect('../error.php');


mysqli_stmt_bind_result($stmt, $cat_name);

if (!mysqli_stmt_fetch($stmt)) {
    mysqli_stmt_error($stmt);
}



mysqli_stmt_free_result($stmt);
mysqli_stmt_close($stmt);