SELAMAT DATANG DI WEBSITE SARJANA GAGAL

pertama yang harus anda lakukan adalah, instal xampp dan dreamwever..
searching aja d google banyak
setelah komputer/laptop anda terinstal xampp skarang saat ny kita buat sebuah database untuk website kita nanti

1. pastikan apache dan mysql anda sudah di start

2. buka mozzila anda
3. ketikan localhost/phpmyadmin
4. setelah anda masuk ke halaman phpmyadmin buat sebuat database baru kita beri nama "sma" lalu tekan create

5. sekarang anda sudah memiliki sebuah database dengan nama sma.

6. lanjut lagi kita buat tabel & field yang kita butuhkan seperti berikut ini

1. Tabel alumni;

+-----------+--------------+------+-----+---------+-------+

| Field       | Type| Null | Key | Default | Extra |

+-----------+--------------+------+-----+---------+-------+

nis            | varchar(10) | Primary key

nama       | varchar(30)

jurusan    | varchar(30) 

thn_lulus | varchar(4)

foto           | varchar(30)

kegiatan | varchar(100)

email       | varchar(30)

komentar | text|

 2. Tabel berita;

+---------+-------------+------+-----+-------------------+----------------+

| Field    | Type| Null | Key | Default| Extra|

+---------+-------------+------+-----+-------------------+----------------+

 id          | int(10)| NO| Primary Key | NULL| auto_increment |

judul    | varchar(50)

isi         | text

tanggal | timestamp| NO|| CURRENT_TIMESTAMP

author | varchar(50)

gambar | varchar(50) | YES

3. Tabel bukutamu;

+----------+-------------+------+-----+-------------------+----------------+

| Field      | Type| Null | Key | Default| Extra|

+----------+-------------+------+-----+-------------------+----------------+

id            | int(10)| NO| Primary Key | NULL| auto_increment |

nama     | varchar(30)

email     | varchar(30)

lokasi     | varchar(50)

komentar | text

tanggal | timestamp| NO|| CURRENT_TIMESTAMP ||

4. Tabel fasilitas;

+----------------+-------------+------+-----+---------+----------------+

| Field             | Type| Null | Key | Default | Extra|

+----------------+-------------+------+-----+---------+----------------+

id_fasilitas  | int(10)| NO| Primary Key | NULL| auto_increment |

nama_fasilitas | varchar(50)

keterangan  | text

gambar        | varchar(50)

 5. Tabel jurusan;

+------------+-------------+------+-----+---------+----------------+

| Field        | Type| Null | Key | Default | Extra|

+------------+-------------+------+-----+---------+----------------+

id             | int(2)| NO| Primary Key | NULL| auto_increment |

jurusan  | varchar(30)

kompetensi | text

6. Tabel pengajar;

+--------------+-------------+------+-----+---------+-------+

| Field           | Type| Null | Key | Default | Extra |

+--------------+-------------+------+-----+---------+-------+

nip              | varchar(10) | NO| Primary Key

nama         | varchar(30)

pendidikan| text

mt_pelajaran | varchar(50)

email| varchar(30)

web| varchar(30)

foto| varchar(30)

7. Tabel prestasi;

+-------------+-------------+------+-----+---------+----------------+

| Field          | Type| Null | Key | Default | Extra|

+-------------+-------------+------+-----+---------+----------------+

id_prestasi | int(10)| NO| Primary Key | NULL| auto_increment |

nm_prestasi | varchar(50)

tgl_raih       | datetime

keterangan | text

gambar    | varchar(50)

8. Tabel profil;

+-----------+--------------+------+-----+---------+----------------+

| Field       | Type| Null | Key | Default | Extra|

+-----------+--------------+------+-----+---------+----------------+

id            | int(11)| NO| Primary Key| NULL| auto_increment |

profil      | varchar(250)

sejarah | text

visi_misi | text

9. Tabel sambutan;

+---------+-------------+------+-----+-------------------+----------------+

| Field    | Type| Null | Key | Default| Extra|

+---------+-------------+------+-----+-------------------+----------------+

id         | int(11)| NO| Primary Key | NULL| auto_increment |

nama  | varchar(50)

jabatan | varchar(50)

isi        | text

tanggal | timestamp| NO|| CURRENT_TIMESTAMP ||

foto      | varchar(50)

11. Tabel user;

+----------+-------------+------+-----+---------+-------+

| Field      | Type| Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+-------+

username | varchar(15)

password | varchar(15)

Mungkin ini dulu buat hari ini, bsok kita lanjut lagi..