fetch_all(MYSQLI_ASSOC);
// Get services
$sql = "SELECT id, name, type, billing FROM services";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$services = $result->fetch_all(MYSQLI_ASSOC);
// Get services
$sql = "SELECT id, service, name, client FROM orders";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$orders = $result->fetch_all(MYSQLI_ASSOC);
?>
ARFNET CSTIMS
ARFNET Client Service Ticket and Invoice Management System
panel
Users
user | type | status |
".$user['username']." | ".$user['type']." | ".$user['status']."\n";
}
?>
|
Service offerings
name | type | billing |
".$service['name']." | ".$service['type']." | ".$service['billing']."\n";
}
?>
|
Orders
service | instance | client |
".$order['service']." | ".$order['name']." | ".$order['client']."\n";
}
?>
|
Tickets
Invoices