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 users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(100),
age INT
);
INSERT INTO users (name, email, age) VALUES
('Аружан', 'aruzhan@mail.com', 22),
('Данияр', 'daniyar@mail.com', 30),
('Нұрболат', 'nurbollat@mail.com', 27);
<?php
// Laravel Query Builder қолдану
$results = $db->table('users')->where('age', '>', 25)->get();
if (count($results) > 0) {
echo "<h3>Тізім:</h3>";
// Кестені ашу
echo "<table style='border-collapse: collapse; width: 60%; font-family: Arial, sans-serif;'>";
echo "<thead>";
echo "<tr style='border-bottom: 1px solid #ddd;'>";
echo "<th align='left'>ID</th>";
echo "<th align='left'>Аты</th>";
echo "<th align='left'>Email</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>";
foreach ($results as $row) {
echo "<tr style='border-bottom: 1px solid #ddd;'>";
echo "<td>" . intval($row->id) . "</td>"; // ID (int типі)
echo "<td>" . htmlspecialchars($row->name) . "</td>"; // Аты (varchar)
echo "<td><a href='mailto:" . htmlspecialchars($row->email) . "'>" . htmlspecialchars($row->email) . "</a></td>"; // Email (varchar)
echo "</tr>";
}
echo "</tbody>";
echo "</table>";
} else {
echo "Мәлімет табылмады.";
}
?>