āĻিāĻĄিāĻ āĻ˛āĻāĻāĻ¨ + āĻিāĻĄিāĻ āĻŦāĻ্āĻ¸
āĻ˛āĻāĻāĻ¨ āĻāĻ°ুāĻ¨
đŦ āĻিāĻĄিāĻ āĻ°াāĻাāĻ° āĻŦāĻ্āĻ¸
YouTube āĻিāĻĄিāĻ
ā§§ā§Ŧ×ā§¯ āĻ°েāĻ¸āĻĒāĻ¨্āĻ¸িāĻ āĻŦāĻ্āĻ¸
āĻ˛োāĻাāĻ˛ MP4 āĻিāĻĄিāĻ
āĻāĻĒāĻ¨াāĻ° MP4 āĻĢাāĻāĻ˛ path āĻĻিāĻ¨
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Input data
$fullname = isset($_POST['fullname']) ? trim($_POST['fullname']) : '';
$phone = isset($_POST['phone']) ? trim($_POST['phone']) : '';
if ($fullname == '' || $phone == '') {
echo "error: missing fields";
exit;
}
// Prevent SQL injection
$fullname = $conn->real_escape_string($fullname);
$phone = $conn->real_escape_string($phone);
// Insert into table
$sql = "INSERT INTO users (fullname, phone) VALUES ('$fullname', '$phone')";
if ($conn->query($sql) === TRUE) {
echo "success";
} else {
echo "error: " . $conn->error;
}
$conn->close();
?>
CREATE DATABASE video_portal;
USE video_portal;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
fullname VARCHAR(100) NOT NULL,
phone VARCHAR(20) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetch users
$sql = "SELECT id, fullname, phone, created_at FROM users ORDER BY created_at DESC";
$result = $conn->query($sql);
?>
Admin Panel - Users List
Registered Users
| ID |
Full Name |
Phone |
Registered At |
num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "
| {$row['id']} |
{$row['fullname']} |
{$row['phone']} |
{$row['created_at']} |
";
}
} else {
echo "| No users found |
";
}
$conn->close();
?>
Subscribe by Email
Follow Updates Articles from This Blog via Email
.jpg)
No Comments