Reza Nurfachmi AaEzha

Query:

SELECT "member_id", "member_username", "member_ipl", "member_photo", "member_nm", "member_phone", "member_right", "kategori_id", "member_project", "member_network", "member_addr", "member_token_push", "member_email", "dana_access_token", "member_password", "member_status", "member_password_token", "bank_id", "member_account_no", "member_account_nm", "member_downline", "member_tipe_id", "city_id", "member_pin", "member_ticket", "member_level", "member_cro", "member_type", "member_unique_number", "country_id", "member_ref", "subdistrict_id", "member_alamat", "member_dob", "member_gender", "member_hobi", "member_created", "member_ktp", "member_longitude", "member_latitude" FROM "member" AS "member" WHERE "member"."member_authkey" = 'S6TKrGxa2Fe1-MEpiV2ickzTa__j4vYF' LIMIT 1;

Result:

member_id|member_username|member_ipl|member_photo                   |member_nm    |member_phone |member_right|kategori_id|member_project|member_network|member_addr|member_token_push

remove `public` from url

create .htaccess at root folder

RewriteEngine on
RewriteCond %{REQUEST_URI} !^public
RewriteRule ^(.*)$ public/$1 [L]

Step 1 - Create a New SSH Key

We need to generate a unique SSH key for our second GitHub account.

ssh-keygen -t rsa -C "your-email-address"

Be careful that you don't over-write your existing key for your personal account. Instead, when prompted, save the file as id_rsa_COMPANY. In my case, I've saved the file to ~/.ssh/id_rsa_work.

Step 2 - Attach the New Key

Sudah biasa kalau kita memiliki satu field dengan tipe data “date” untuk menyimpan tanggal lahir. Namun, bagaimana jika kita ingin mengambil usianya dari kolom tanggal lahir tersebut? Ini adalah caraku dari dulu sampai sekarang digunakan.

Anggaplah kita memiliki struktur tabel seperti ini:

DESC biodata;

Field	Type	Null	Key	Default	Extra

	<?php

	// Fungsi untuk membuat gambar menggunakan FFMPEG
	function generateImage($text, $textColor, $backgroundColor, $outputImage)
	{
	// Konversi warna teks dan background menjadi format rgba yang bisa digunakan oleh FFMPEG
	$textColor = "0x" . ltrim($textColor, '#');
	$backgroundColor = "0x" . ltrim($backgroundColor, '#');

	// Ukuran gambar

	<IfModule mod_rewrite.c>
	<IfModule mod_negotiation.c>
	Options -MultiViews
	</IfModule>

	RewriteEngine On

	RewriteCond %{REQUEST_FILENAME} -d [OR]
	RewriteCond %{REQUEST_FILENAME} -f
	RewriteRule ^ ^$1 [N]

	<?php

	// Retrieve the webhook payload
	$payload = file_get_contents('php://input');

	// Process the webhook payload
	// ... Perform any necessary actions or data processing based on the received payload

	// Prepare the response data
	$responseData = [

	<?php

	use Illuminate\Support\Str;

	$url = parse_url(getenv("CLEARDB_DATABASE_URL"));
	$host = $url["host"] ?? null;
	$username = $url["user"] ?? null;
	$password = $url["pass"] ?? null;
	$database = substr($url["path"], 1);

	<?php
	// folder : app/Config
	// file : Email.php

	namespace Config;

	use CodeIgniter\Config\BaseConfig;

	class Email extends BaseConfig
	{