Skip to content

Instantly share code, notes, and snippets.

View rizkyramadhan21's full-sized avatar

Rizky WG rizkyramadhan21

2 followers · 1 following
View GitHub Profile
@rizkyramadhan21
rizkyramadhan21 / daftar_paket.sql
Created January 5, 2018 14:36
CREATE TABLE IF NOT EXISTS `daftar_paket` (
`id` int(5) NOT NULL,
`kode_paket` varchar(4) NOT NULL,
`nama_paket` varchar(20) NOT NULL,
`harga` int(10) NOT NULL,
`keterangan` varchar(40) NOT NULL,
`jadwal` varchar(20) NOT NULL,
`pengajar` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@rizkyramadhan21
rizkyramadhan21 / database.php
Last active January 5, 2018 15:10
Koneksi ke database | Blog: wadagizig.com
<?php
$base_url = 'http://localhost/modal_dinamis';
define('DBHOST', 'localhost');
define('DBUSER', 'myusername');
define('DBPASS', 'mypassword');
define('DBNAME', 'mydatabase');
$db = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);
@rizkyramadhan21
rizkyramadhan21 / index.php
Created January 5, 2018 15:22
Menampikan database ke dalam Tabel
<?php
require_once("./application/config/database.php");
$query = mysqli_query($db, "SELECT * FROM daftar_paket;");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Modal bootstrap dinamis | wadagizig.com</title>
@rizkyramadhan21
rizkyramadhan21 / detail.php
Created January 5, 2018 15:38
Menampilkan data pada Modal
<?php
require_once("./../../application/config/database.php");
if($_POST['getDetail']) {
$id = $_POST['getDetail'];
$sql = mysqli_query($db, "SELECT * from daftar_paket where id='$id'");
while ($row = mysqli_fetch_array($sql)){
?>
<!-- Modal -->
@rizkyramadhan21
rizkyramadhan21 / save.php
Created January 5, 2018 15:52
Custom alert "simpan berhasil"
<?php
/*-----------------
Just custom alert
-----------------*/
echo "<script>alert('Simpan data berhasil !'); window.location.href = '../../';</script>";
?>
@rizkyramadhan21
rizkyramadhan21 / sendMessage.php
Last active May 22, 2021 12:14
Simple php script for sending telegram bot message
<?php
/* -----------------------------------------------------
Simple PHP script for Sending Telegram Bot Message
~ Iky | https://www.wadagizig.com
------------------------------------------------------ */
function sendMessage($telegram_id, $message_text, $secret_token) {
$url = "https://api.telegram.org/bot" . $secret_token . "/sendMessage?parse_mode=markdown&chat_id=" . $telegram_id;
$url = $url . "&text=" . urlencode($message_text);
@rizkyramadhan21
rizkyramadhan21 / index.html
Created January 7, 2018 12:54
Simple Form HTML for Input Message
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<title>wadagizig Telegram bots</title>
<!--link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"-->
</head>
<body>
@rizkyramadhan21
rizkyramadhan21 / config.php
Created February 14, 2018 13:01
<?php
define('DBHOST', 'myhost');
define('DBUSER', 'myuser');
define('DBPASS', 'mypassword');
define('DBNAME', 'mydatabase');
$db = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);
if ($db->connect_error) {
@rizkyramadhan21
rizkyramadhan21 / login.php
Last active February 14, 2018 13:21
<?php
/* memasukan config.php, harap sesuaikan folder penyimpanan
untuk file-file assets dibawah, silahkan cari sendiri ya! :) */
require_once '../config/config.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
@rizkyramadhan21
rizkyramadhan21 / login-validasi.php
Created February 14, 2018 13:37
<?php
/*
------------------------------------------------------
login-validasi.php: menangkap variable yang dikirimkan
pada file login.php
------------------------------------------------------
*/
require_once '../config/config.php';