25 lines
563 B
PHP
25 lines
563 B
PHP
<?php
|
|
require "db.php";
|
|
|
|
function get_category_items()
|
|
{
|
|
$conn = get_db_connection();
|
|
$items = mysqli_query($conn, "SELECT * FROM `category`");
|
|
$conn->close();
|
|
|
|
return $items;
|
|
}
|
|
|
|
function create_category($name)
|
|
{
|
|
$conn = get_db_connection();
|
|
$statement = $conn->prepare("INSERT INTO `category` (category_name) VALUES (?)");
|
|
$statement->bind_param("s", $name);
|
|
if($statement->execute() == true){
|
|
|
|
}
|
|
|
|
$statement->close();
|
|
$conn->close();
|
|
}
|
|
?>
|