tmp_mp

ALTER TABLE masjid ADD `masjid_type` enum ( 'M', 'I' ) CHARACTER
SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'M' COMMENT 'M: Masjid, I: Instansi'

// UPDATE
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

// DELETE
DELETE FROM table_name WHERE condition;

Custom validasi form input html
<input type="text" id="username" required placeholder="Enter Name" oninvalid="this.setCustomValidity('Enter User Name Here')" oninput="this.setCustomValidity('')"  />

// format number javascript | 9.898.989
  let format_angka = (angka) => {
    var reverse = angka.toString().split('').reverse().join(''),
    ribuan = reverse.match(/\d{1,3}/g);
    ribuan = ribuan.join('.').split('').reverse().join('');
    return ribuan;
  }

    // function cek() {
    //     $d = "55,289,460,481,538,638,645,672,715,804,1007,3820,7236,7237,7262,7284,7336,7361,7368,7382,7397,26,7398";
    //     $dt = explode(',', $d);
    //     echo count($dt)."<br>";
    //     for($i=0; $i < count($dt); $i++) {
    //         $u = $this->User_m->get_by(array('user_id' => $dt[$i]));
    //         if($u) {
    //             echo $u[0]->user_id." - ".$u[0]->user_name."<br>";
    //         }
    //     }
    // }

// date now in db
date('Y-m-d H:i:s')

select2 value
var $option = $("<option selected></option>").val('1').text("Pick me");
$('#select_id').append($option).trigger('change');

// autofocus select2 in modal
$.fn.modal.Constructor.prototype.enforceFocus = function() {};
#https://stackoverflow.com/a/19574076/9446622


// check index value post/get
$name = isset($_POST['nama']) ? $_POST['nama'] : '';
$name = isset($_POST['umur']) ? $_POST['umur'] : '';
// contoh menggunakan $_GET
$name = isset($_GET['nama']) ? $_GET['nama'] : '';
$name = isset($_GET['umur']) ? $_GET['umur'] : '';
#https://www.jagoanhosting.com/tutorial/bantuan-hosting/error-undefined-index-variable