<?php include "../../DAL/dbConfig.php"; try { $userName = htmlspecialchars($_POST["user"]); $password = htmlspecialchars($_POST["password"]); $sqli = dbConfig::connectDb(); $error = false; // Check connection if ($sqli->connect_error) { $sqli->exit(); $error = true; } //insert variables $Categorys = array(); $IDs = array(); $stmt = $sqli->prepare("CALL getCategorys();"); if ($stmt->execute() === TRUE) { $stmt->bind_result($idCategory, $category); while ($stmt->fetch()) { $IDs[] = $idCategory; $Categorys[] = $category; } } else { $error = true; } $stmt->close(); $sqli->close(); } catch (Exception $e) { $error = true; }