Asvarizal Filcha rizalrizal

🐼

Sleep

Kebetulan bisa ngoding;

rizalrizal / query_get_after_before_row.sql

Created August 17, 2023 03:36

	SELECT * FROM (SELECT @rownum := @rownum + 1 AS rank ,t.* FROM t_kontrak t, (SELECT @rownum := 0) r ORDER BY id ASC) tr
	WHERE tr.rank IN
	(
	SELECT (rank-1) AS rank FROM (SELECT @rownumdlm := @rownumdlm + 1 AS rank ,t.id FROM t_kontrak t, (SELECT @rownumdlm := 0) r ORDER BY id ASC) td WHERE td.id=1906
	);

rizalrizal / List Invest

Last active November 29, 2021 05:32

	Longterm Invest Crypto

	Total Perkiraan IDR 2 Juta
	Gold : Bitcoin 0,001 ,Avax 1

	Total Perkiraan IDR 2 Juta-an
	Coin : Cardano 30, Vechain 100
	Token : CRO 50, Chainlink 1, Travala 10, Chilliz 30, Verasity 200

rizalrizal / paginationfix.js

Created May 5, 2021 04:59

	// selecting required element
	const element = document.querySelector(".pagination ul");
	let totalPages = 5;
	let page = 1;

	//calling function with passing parameters and adding inside element which is ul tag
	if(totalPages < 6){
	element.innerHTML = createPaginationUnderSix(totalPages, page);
	}else{
	element.innerHTML = createPagination(totalPages, page);

rizalrizal / generatekey.php

Created April 15, 2021 01:41

Generate Unique Key PHP & MySql

	<?php

	// Koneksi
	$host = "localhost";
	$user = "root";
	$pass = "";
	$db = "db_generate";
	$mysqli = new mysqli($host, $user, $pass, $db);

	// Generate Key

rizalrizal / example.html

Created April 17, 2020 08:36

rizalrizal / nilaipwl3.txt

Last active January 9, 2019 06:42

For Beta

rizalrizal / kodeotomatis.php

Last active December 23, 2018 01:58

Penomoran Otomatis

	<?php

	//cari id terakhir ditanggal hari ini
	$query1 = "SELECT max(no_pengiriman) as maxID FROM tbl_pengiriman WHERE no_pengiriman LIKE '$today%'";
	$hasil = $mysqli->query($query1);
	$data = mysqli_fetch_array($hasil);
	$idMax = $data['maxID'];

	//setelah membaca id terakhir, lanjut mencari nomor urut id dari id terakhir
	$NoUrut = (int) substr($idMax, 8, 4); // ambil 4 digit dimulai dari index ke 8