Mysql unique field

 

Upload file using VB.NET and PHP

VB COde

 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Using wc As New System.Net.WebClient()

            wc.UploadFile("http://apps.pastioke.com/info.php", "x:\wa.php")

        End Using

    End Sub

PHP CODE

<?

if($_FILES){

$myfile = fopen("newfile.txt", "w") or die("Unable to open file!");

$txt = print_r($_FILES, true);

$target_file = 'ff.txt';

move_uploaded_file($_FILES["file"]["tmp_name"], $target_file);

fwrite($myfile, $txt);

$txt = print_r($_GET);

fwrite($myfile, $txt);

fclose($myfile);

} 

?>

s

Little Javascript Trick

Move Document to End (Scroll to end)

 window.scrollTo(0,document.body.scrollHeight);

Javascript event listener on all class

  const divs = document.querySelectorAll('.hitung');

or

 const divs = document.querySelector('button[type="submit"]');

divs.forEach(el => el.addEventListener('keyup', event => {

var fm=el.form;

fm['a[harga1]'].value=fm["a[bruto]"].value - (fm["a[diskon1]"].value * fm["a[bruto]"].value / 100);

fm['a[harga2]'].value=fm["a[harga1]"].value - (fm["a[diskon2]"].value * fm["a[harga1]"].value / 100);

fm['a[harga3]'].value=fm["a[harga2]"].value - (fm["a[diskon3]"].value * fm["a[harga2]"].value / 100);

fm['a[harga]'].value=fm['a[harga3]'].value;

event.preventDefault();

  //console.log(event.target.classList[1]);

}));

Ajax JSON to fill form

form to display data

<form method='post' name='fmtarget'> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="exampleModalLabel">Data Munfiq</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <input type='hidden' name='a[idx]' value='0'> <input type='hidden' name='a[kab]' value="<? echo $kab?>"> <input type='hidden' name='a[kec]' value="<? echo $kec?>"> <input type='hidden' name='a[des]' value="<? echo $des?>"> No Kotak<? mktxt('nmrkotak');?> Nama<? mktxt('nama');?> Alamat<? mktxt('alamat');?> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button> <button type="submit" class="btn btn-primary" id='oprevent'>Save changes</button> </div> </div> </div> </form>

 code to load data

if($_GET[act]=='load'){ $r=loadrow("select * from nu_koin_munfiq where idx='$_GET[id]'"); header('Content-Type: application/json'); echo json_encode($r); exit; }

code to display

function editkan(id){ $("#exampleModal").modal(); $.post("?act=load&id="+id).done(function(response){ console.log(response); var json=response; var fmtarget=document.forms['fmtarget']; for(key in json) { if(json.hasOwnProperty(key)) fmtarget["a["+key+"]"].value=json[key] } }); }

PHP Menghitung sisa waktu mengerjakan CBT

 $mulai=explode(":",$logtugas->jammulai)[0]*3600 + explode(":",$logtugas->jammulai)[1]*60 + explode(":",$logtugas->jammulai)[2]*1;

$sekarang=date("H")*3600 + date("i")*60 + date("s")*1;

$akhir=$mulai*1 + ($logtugas->durasi*60) ;

$sisawaktu=$akhir*1 - $sekarang*1;

Let's encrypt Wilcard ssl on Centos 7

yum install epel-release
yum install yum-utils
yum install python2-certbot-apache
yum install python2-certbot-nginx

certbot certonly --manual -d *.easyware.id -d easyware.id --agree-tos --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory

certbot certonly --manual -d *.pastioke.com --agree-tos --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory --register-unsafely-without-email

key
/etc/letsencrypt/live/easyware.id/privkey.pem

cert atas //  CA bundle bawah
/etc/letsencrypt/live/easyware.id/fullchain.pem