<?php

// Create a new status
function create_status($user_id, $name, $title, $color, $customCSS) {
global $db;
$sql = "INSERT INTO status (user_id, name, title, color, customCSS)
         VALUES ('$user_id', '$name', '$title', '$color', '$customCSS')";
$result = mysqli_query($db, $sql);
if($result) {
  return true;
} else {
  echo mysqli_error($db);
  return false;
}
}

// Get all statuses
function get_all_statuses() {
global $db;
$sql = "SELECT * FROM status";
$result = mysqli_query($db, $sql);
$statuses = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $statuses;
}

// Get status by user_id
function get_status_by_user_id($user_id) {
global $db;
$sql = "SELECT * FROM status WHERE user_id = '$user_id'";
$result = mysqli_query($db, $sql);
$status = mysqli_fetch_assoc($result);
return $status;
}

// Update status
function update_status($user_id, $name, $title, $color, $customCSS) {
global $db;
$sql = "UPDATE status SET name = '$name', title = '$title', color = '$color', customCSS = '$customCSS'
   WHERE user_id = '$user_id'";
$result = mysqli_query($db, $sql);
if($result) {
  return true;
} else {
  echo mysqli_error($db);
  return false;
}
}

// Delete status
function delete_status($user_id) {
global $db;
$sql = "DELETE FROM status WHERE user_id = '$user_id'";
$result = mysqli_query($db, $sql);
if($result) {
  return true;
} else {
  echo mysqli_error($db);
  return false;
}
}

?>