Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE role_actions (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO role_actions (name) VALUES ('view'), ('create'), ('update'), ('delete');
<?php
use Carbon\Carbon;
$role_id = 1;
$sql = "SELECT COUNT(*) AS total
FROM role_actions
WHERE id = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $role_id);
if ($stmt->execute()) {
$result = $stmt->get_result();
$stmt->close();
$permissionData = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$permissionData = $row;
}
}
}
$type = gettype($permissionData['total']);
if ($permissionData['total'] > 0) {
echo "Mayor"
} else {
echo "Error"
}
echo ' --- ';
echo $type;