$query = "SELECT * FROM users WHERE id = 1";
$result = sql($query, $eo);
while ($row = db_fetch_assoc($result)) {
echo $row['username'];
}
$username = sqlValue("SELECT username FROM users WHERE id = 1");
echo $username ? $username : "Không tìm thấy";
$result = sql("SELECT * FROM users", $eo);
while ($row = db_fetch_assoc($result)) {
echo $row['username'] . " - " . $row['email'];
}
sql("INSERT INTO users (username) VALUES ('john')", $eo);
echo "ID mới: " . db_insert_id();
$memberInfo = getMemberInfo();
echo $memberInfo ? $memberInfo['username'] : "Chưa đăng nhập";
if (is_allowed("users", 1, "edit")) {
echo "Có quyền chỉnh sửa";
} else {
echo "Không có quyền";
}
$input = makeSafe($_POST['username']);
$query = "SELECT * FROM users WHERE username = '$input'";
$description = htmlSpecialChars($_POST['description']);
echo $description;
$tables = getTableList();
print_r($tables);
$options = [
'to' => 'user@example.com',
'subject' => 'Chào mừng',
'message' => 'Chào mừng bạn!'
];
sendmail($options);
require_once('../hooks/config.php');
header('Content-Type: application/json');
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$memberInfo = getMemberInfo();
if (!$memberInfo || !is_allowed("users", null, "view")) {
http_response_code(403);
echo json_encode(['error' => 'Access denied']);
exit;
}
$query = "SELECT id, username, email FROM users";
$result = sql($query, $eo);
$users = [];
while ($row = db_fetch_assoc($result)) {
$users[] = $row;
}
http_response_code(200);
echo json_encode($users);
}
display_errors = On
post_max_size = 100M
upload_max_filesize = 100M
date.timezone = "Asia/Ho_Chi_Minh"
<VirtualHost _default_:80>
ServerName localhost
DocumentRoot "${INSTALL_DIR}/www"
DirectoryIndex index.php index.html index.htm
<Directory />
Require all denied
Options None
AllowOverride None
</Directory>
<Directory "${INSTALL_DIR}/www/">
Options +FollowSymLinks +Indexes
AllowOverride All
Require all granted
</Directory>
<Directory "${INSTALL_DIR}/apps/phpmyadmin5.2.1/">
Require local
</Directory>
</VirtualHost>
ServerSignature Off
ServerTokens Prod
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourStrongPassword';
FLUSH PRIVILEGES;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
Username: ladmin
Password: appginivn2025
/var/www/htmlhttp://localhost:8080your-appgini-project/
├── admin/
├── images/
├── hooks/
├── api/v1/
│ ├── api.php
│ ├── auth.php
│ ├── config.php
│ ├── db_connection.php
│ ├── login.php
│ └── permissions.php
└── ... (các file AppGini khác)
extension=mysqli
extension=mbstring
extension=pdo_mysql