install dlib

 buka cmd di directory dlib 

pip install "dlib-19.22.99-cp310-cp310-win_amd64.whl"

catatan : sesuaikan versi python

membuat exe python

 pyinstaller --onefile hello.py

membuat virtual host pada xampp

 buka apache http.conf 

Listen 8080

buka apache httpd-vhost.conf 

<VirtualHost *:8080>

    DocumentRoot "D:/htdocs_extend"

    ServerName localhost:8080

    <Directory "D:/htdocs_extend">

        Options All

AllowOverride All

Require all granted  

    </Directory>

</VirtualHost>

setting xampp port dan htdocs location

 httpd.conf 

Listen 8012

ServerName localhost:8012

http-ssl.conf

Listen 443

<VirtualHost _default_:443>

ServerName localhost:443

xampp->config

https://stackoverflow.com/questions/11294812/how-to-change-xampp-apache-server-port

httpd.conf 

https://stackoverflow.com/questions/18902887/how-to-configuring-a-xampp-web-server-for-different-root-directory

cara import data csv ke mysql via sqlyog

 1. save as file exel dengan ext [csv msdos]

2. sqlyog pilih import -> import csv

3. terminated by ganti ;