luckyaxl/dumbways

Test Technical Bootcamp DumbWays Batch 15 Kloter 2

Test Technical Bootcamp DumbWays Batch 15 Kloter 2

Nomer 4. CRUD

Package

• Language: PHP 7.2.10
• css: Bootstrap
• javascript: jQuery
• Database MySQL 14.14 Distrib 5.7.24
• Editor: Visual Studio Code
• OS: Ubuntu 18.04 LTS KDE

Referensi

• codepolitan
• stackoverflow 1
• stackoverflow 2
• stackoverflow 3
• w3school

Step

Buat Database dan table

mysql> create database testcrud;

Membuat table provinsi_tb

mysql> create table provinsi_tb(
    -> id int NOT NULL AUTO_INCREMENT,
    -> nama varchar (50) NOT NULL,
    -> diresmikan varchar (50) NOT NULL,
    -> photo varchar (10000) NOT NULL,
    -> pulau varchar (100) NOT NULL,
    -> PRIMARY KEY (id)
    -> );

Membuat table kabupaten_tb

mysql> create table kabupaten_tb(
    -> id int NOT NULL AUTO_INCREMENT,
    -> nama varchar (100) NOT NULL,
    -> provinsi_id int (100) NOT NULL,
    -> diresmikan varchar (100) NOT NULL,
    -> photo varchar (1000) NOT NULL,
    -> PRIMARY KEY (id)
    -> );

Screenshot

Menjalankan server localhost

php -S localhost:8080

Menjalankan Program

Sample Data hasil query POST