Monday, August 26, 2019

script sederhana HTML #2


Format kaitan dan Format Formulir

Script hyperlink.
<!DOCTYPE html>
<html>
<head>
                <title>script link</title>
</head>
<body>
<a href="https://khusnimk.blogspot.com/#" target="tampil">https://khusnimk.blogspot.com/#</a>
<iframe name="tampil">
</iframe>
</body>
</html>



Script konsep formulir.
<!DOCTYPE html>
<html>
<head>
                <title>contoh membuat formulir</title>
</head>
<body>
----- IDENTITAS PESERTA DIDIK -----
<form>
                Nama lengkap : <input type="text"
                name="nama"><br>
                no . induk siswa : <input type="text" name="nis"
                maxlength="12"><br>
                <input type="reset" value="reset">
                <input type="submit" name="submit" value="submit">
</form>
</body>
</html>




Script form option.
<!DOCTYPE html>
<html>
<head>
                <title>FORMAT FORMULIR</title>
</head>
<body>
<form method="post">
<table border=0 width="75%"> <tr>
<td width="20%">NISN</td>
<td><input type="text" name="NISN" maxlength="10" size="11"> </td> </tr> <tr>
<td width="20%">Nama peserta didik</td>
<td><input type="text" name="nama peserta didik" maxlength="25" size="25"></td></tr><tr>
<td width="20%">Alamat</td>
<td><input type="text" name="Alamat" maxlength="50" size="40"></td></tr><tr>
<td width="20%">Jenis kelamin</td>
<td><input type="Radio" name="Jenkel" checked value="laki2">Laki-Laki
<input type="Radio" name="Jenkel" value="Perempuan">Perempuan </td> </tr> <tr> <tr>
<td width="20%">Program Keahlian</td>
<td><select name="Jurusan">
                <option value="RPL">Rekayasa Perangkat Lunak
                <option value="AP">Administrasi perkantoran
                <option value="TSM">Teknisi Sepeda Motor
</select> </td> </tr> <tr>
<td width="20%">Fisilitas</td>
<td><input type="Checkbox">Bebas Uang Gedung</td> </tr> <tr>
<td></td><td><input type="Checkbox">Baju Praktek</td> </tr> <tr>
<td></td><td><input type="Checkbox">Seragam Pramuka</td> </tr> <td></td>
<td><input type="Submit" value="Simpan">
<input type="Reset" value="Batal"> </td> </tr> </table> </form>
</body>
</html>

Contoh Membuat tabel di CMD(command promt) #2.


Tugas KD 4.6

Microsoft Windows [Version 10.0.14393]
(c) 2016 Microsoft Corporation. All rights reserved.

C:\Users\smkn1bangsri>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.30-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database pendaftaran;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> use pendaftaran;
Database changed
MariaDB [pendaftaran]> create table pendaftaran (
    -> no int(3),
    -> nama varchar(35),
    -> alamat varchar(60),
    -> email varchar(40),
    -> no_telepon varchar(15),
    -> sex char(1));
Query OK, 0 rows affected (0.14 sec)

MariaDB [pendaftaran]> insert into pendaftaran (no,nama,alamat,email,no_telepon)values(22,'muhammad khusni mubaroh','kepuk rt 2 rw 5','muhammadkhusni112@gmail.com','083456789098');
Query OK, 1 row affected (0.02 sec)

MariaDB [pendaftaran]> select * from pendaftaran;
+------+-------------------------+-----------------+-----------------------------+--------------+------+
| no   | nama                    | alamat          | email                       | no_telepon   | sex  |
+------+-------------------------+-----------------+-----------------------------+--------------+------+
|   22 | muhammad khusni mubaroh | kepuk rt 2 rw 5 | muhammadkhusni112@gmail.com | 083456789098 | NULL |
+------+-------------------------+-----------------+-----------------------------+--------------+------+
1 row in set (0.00 sec)

MariaDB [pendaftaran]> insert into pendaftaran (no,nama,alamat,email,no_telepon)values(04,'ahmad faizul umri','karanggondang rt 5 rw 7','fizulumrri38@gmail.com','087897456324');
Query OK, 1 row affected (0.08 sec)

MariaDB [pendaftaran]> select * from pendaftaran;
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
| no   | nama                    | alamat                  | email                       | no_telepon   | sex  |
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
|   22 | muhammad khusni mubaroh | kepuk rt 2 rw 5         | muhammadkhusni112@gmail.com | 083456789098 | NULL |
|    4 | ahmad faizul umri       | karanggondang rt 5 rw 7 | fizulumrri38@gmail.com      | 087897456324 | NULL |
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
2 rows in set (0.00 sec)

MariaDB [pendaftaran]> insert into pendaftaran (no,nama,alamat,email,no_telepon)values(18,'maulana nofa karisma','jambu timur rt 1 rw 7','maulananofawikwik@gmail.com','081234567098');
Query OK, 1 row affected (0.02 sec)

MariaDB [pendaftaran]> select * from pendaftaran;
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
| no   | nama                    | alamat                  | email                       | no_telepon   | sex  |
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
|   22 | muhammad khusni mubaroh | kepuk rt 2 rw 5         | muhammadkhusni112@gmail.com | 083456789098 | NULL |
|    4 | ahmad faizul umri       | karanggondang rt 5 rw 7 | fizulumrri38@gmail.com      | 087897456324 | NULL |
|   18 | maulana nofa karisma    | jambu timur rt 1 rw 7   | maulananofawikwik@gmail.com | 081234567098 | NULL |
+------+-------------------------+-------------------------+-----------------------------+--------------+------+
3 rows in set (0.00 sec)
MariaDB [pendaftaran]>
Hasilnya!!!!



Wednesday, August 21, 2019

Contoh Membuat tabel di CMD(command promt).


ASSALAMUALAIKUM WR WB

SELAMAT DATANG DI BLOG SAYA!!
KALI INI SAYA AKAN MEMBERIKAN CONTOH MEMBUAT TABEL SEDERHANA DI CMD(COMMAND PROMT)


Command promt 
YANG DI TULIS YANG BERWARNA YA !!!
Microsoft Windows [Version 10.0.16299.125]
(c) 2017 Microsoft Corporation. All rights reserved.

C:\Users\USER>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.3.16-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database siswa;
Query OK, 1 row affected (0.008 sec)

MariaDB [(none)]> use siswa;
Database changed
MariaDB [siswa]>  create table absen(
    -> NISN int,
    ->nama varchar (40) not null,
    ->tgl_lahirvarchar(12),
    ->tempat_lahirvarchar(20),
    -> primary key (NISN)
    -> );
Query OK, 0 rows affected (0.408 sec)

MariaDB [siswa]> insert into absen (NISN,nama,tgl_lahir,tempat_lahir)values(2468,'ahmad ansori','22/01/2003','jepara');
Query OK, 1 row affected (0.118 sec)

MariaDB [siswa]> select * from absen;
+------+--------------+------------+--------------+
| NISN | nama         | tgl_lahir  |tempat_lahir |
+------+--------------+------------+--------------+
| 2468 | ahmadansori | 22/01/2003 | jepara       |
+------+--------------+------------+--------------+
1 row in set (0.001 sec)

MariaDB [siswa]> insert into absen (NISN,nama,tgl_lahir,tempat_lahir)values(2319,'taufik umar','27/02/2002','jepara');
MariaDB [siswa]> insert into absen (NISN,nama,tgl_lahir,tempat_lahir)values(2286,'abellindo faustin','06/06/2003','jepara');
MariaDB [siswa]> insert into absen (NISN,nama,tgl_lahir,tempat_lahir)values(2236,'MUHAMMAD DAFFANIO WARDHANA','21/10/2002','jepara');
MariaDB [siswa]> insert into absen (NISN,nama,tgl_lahir,tempat_lahir)values(2237,'MUHAMMAD KHUSNI MUBAROH','01/10/2001','jepara');
Query OK, 1 row affected (0.082 sec)

MariaDB [siswa]> select * from absen;
+------+----------------------------+------------+--------------+
| NISN | nama                       | tgl_lahir  |tempat_lahir |
+------+----------------------------+------------+--------------+
| 2236 | MUHAMMAD DAFFANIO WARDHANA | 21/10/2002 | jepara       |
| 2237 | MUHAMMAD KHUSNI MUBAROH    | 01/10/2001 | jepara       |
| 2286 | abellindofaustin          | 06/06/2003 | jepara       |
| 2288 | ahmadansori               | 22/01/2003 | jepara       |
| 2319 | taufikumar                | 27/02/2002 | jepara       |
| 2468 | ahmadansori               | 22/01/2003 | jepara       |
+------+----------------------------+------------+--------------+
6 rows in set (0.001 sec)

MariaDB [siswa]>






DAN INI HASILNYA!!!






NOTE : Contoh Tulisan yg diisikan yg berwarna
JIKA ADA KESALAHAN MOHON DI MAAFKAN

SEKIAN DAN TERIMAKASIH

Jual Aksesoris Motor!!

Assalammualaikum WR WB

Terimakasih telah mengunjungi blog saya..

Kali ini saya akan menawarkan aksesoris motor 
Yang lumayan bagus lah😊😊dan harganya lumayan terjangkau pula.🏁🏁
Rp; 1xx.xxx,xx

Rp; 4x.xxx,xx

Rp; 8x.xxx,xx

Rp; 15x.xxx,xx

Rp; 2x.xxx,xx

Kalo memang anda minat/tertarik😀😀
Bisa hub:
Wa : 085747949xxx
Sekian dan Terimakasih😂😂

Desain Suka-Suka.




Desain suka-suka

Contoh desain t-shirt di coreldraw

Contoh Desain t shirt sederhana di coreldraw

script sederhana HTML






Tuesday, August 20, 2019

contoh formulir pendaftaran