Skip to content

Instantly share code, notes, and snippets.

Andika Saputra andikasputra

Block or report user

Report or block andikasputra

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View preferences.sql
SELECT
MAX(CASE WHEN (pref_name = 'smtp_host') THEN pref_value ELSE NULL END) AS smtp_host,
MAX(CASE WHEN (pref_name = 'smtp_port') THEN pref_value ELSE NULL END) AS smtp_port,
MAX(CASE WHEN (pref_name = 'smtp_user') THEN pref_value ELSE NULL END) AS smtp_user,
MAX(CASE WHEN (pref_name = 'smtp_pass') THEN pref_value ELSE NULL END) AS smtp_pass
FROM preferences
WHERE pref_group = 'email';
View form-ajax.html
<!DOCTYPE html>
<html lang="id" dir="ltr">
<head>
<meta charset="utf-8">
<title>AJAX Submit Form</title>
</head>
<body>
<form action="kirim-proses.php" method="post" id="formulir">
<input type="text" name="nama" placeholder="Nama Lengkap"><br>
<input type="email" name="email" placeholder="Email"><br>
View query-1.sql
SELECT level, COUNT(id) AS jml
FROM soal
GROUP BY level;
You can’t perform that action at this time.