This is default featured post 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Sabtu, 10 November 2018


JAMRUD LIDER
JAMAAH MAULID SIMTUDDUROR LINTAS DAERAH BANJARNEGARA PURBALINGGA PENGASUH HABIB ALI BIN UMAR AL QUTBAN BUKATEJA PURBALINGGA.

SHOLLU ALA NABI MUHAMMAD SAW.

Rabu, 11 Januari 2012

Hasil Praktek Database....

mysql> select * from siswa;

mysql> desc guru;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| no     | int(11)     | NO   | PRI | NULL    | auto_increment |
| nama   | varchar(15) | YES  |     | NULL    |                |
| alamat | text        | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

mysql> desc siswa;
+---------------+---------------+------+-----+---------+-------+
| Field         | Type          | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| nis           | int(4)        | NO   | PRI | NULL    |       |
| nama          | varchar(15)   | YES  |     | NULL    |       |
| alamat        | text          | YES  |     | NULL    |       |
| no_telp       | varchar(12)   | YES  |     | NULL    |       |
| jenis_kelamin | enum('P','L') | YES  |     | NULL    |       |
+---------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> create table mapel (
    -> id_mapel int auto_increment primary key,
    -> kode_mapel varchar(5),
    -> mapel varchar(30);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 4
mysql> create table mapel (
    -> id_mapel int auto_increment primary key,
    -> kode_mapel varchar(5),
    -> mapel varchar(30));
Query OK, 0 rows affected (0.03 sec)

mysql> alter table mapel engine=innodb;
Query OK, 0 rows affected (0.19 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> insert into mapel (kode_mapel,mapel)
    -> values('BD','bhsindo');
Query OK, 1 row affected (0.03 sec)

mysql> select * from mapel;
+----------+------------+---------+
| id_mapel | kode_mapel | mapel   |
+----------+------------+---------+
|        1 | BD         | bhsindo |
+----------+------------+---------+
1 row in set (0.00 sec)

mysql> create table mengajar(
    -> id_mengajar int auto_increment primary key,
    -> no varchar(20),
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 3
mysql> select * from siswa;
+------+------+-------------+--------------+---------------+
| nis  | nama | alamat      | no_telp      | jenis_kelamin |
+------+------+-------------+--------------+---------------+
| 1111 | aan  | gemuruh     | 089765456342 | L             |
| 1112 | afif | tapen       | NULL         | L             |
| 1113 | andi | purwonegoro | NULL         | L             |
+------+------+-------------+--------------+---------------+
3 rows in set (0.00 sec)

mysql> create table guwru(
    -> nip int(10) primary key,
    -> nama varchar(20),
    -> jenis_kelamin enum('L','P'),
    -> alamat text);
Query OK, 0 rows affected (0.05 sec)

mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip varchar(20),
    -> id_matapelajaran int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_matapelajaran) references matapelajaran(id_matapelajaran)
    -> on delete cascade on update cascade)
    -> type=innodb;
ERROR 1005 (HY000): Can't create table 'tkj.mengajar' (errno: 150)
mysql> on delete cascade on update cascade)desc mapel;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'on de
lete cascade on update cascade)desc mapel' at line 1
mysql> show tables;
+---------------+
| Tables_in_tkj |
+---------------+
| guru          |
| guwru         |
| mapel         |
| siswa         |
+---------------+
4 rows in set (0.00 sec)

mysql> desc mapel;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id_mapel   | int(11)     | NO   | PRI | NULL    | auto_increment |
| kode_mapel | varchar(5)  | YES  |     | NULL    |                |
| mapel      | varchar(30) | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip varchar(20),
    -> id_matapelajaran int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_matapelajaran) references matapelajaran(id_matapelajaran)
    -> on delete cascade on update cascade);
Query OK, 0 rows affected (0.03 sec)

mysql> show tables;
+---------------+
| Tables_in_tkj |
+---------------+
| guru          |
| guwru         |
| mapel         |
| mengajar      |
| siswa         |
+---------------+
5 rows in set (0.00 sec)

mysql> drop table mengajar;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+---------------+
| Tables_in_tkj |
+---------------+
| guru          |
| guwru         |
| mapel         |
| siswa         |
+---------------+
4 rows in set (0.02 sec)

mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip varchar(20),
    -> id_matapelajaran int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_mapel) references mapel(id_mapel)
    -> on delete cascade on update cascade)
    -> type=innodb;
ERROR 1072 (42000): Key column 'id_mapel' doesn't exist in table
mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip varchar(20),
    -> id_matapelajaran int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_matapelajaran) references matapelajaran(id_matapelajaran)
    -> on delete cascade on update cascade)
    -> type=innodb;
ERROR 1005 (HY000): Can't create table 'tkj.mengajar' (errno: 150)
mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip varchar(20),
    -> id_matapelajaran int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_matapelajaran) references matapelajaran(id_matapelajaran);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 7
mysql> show table guwru;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'guwru
' at line 1
mysql> desc guwru;
+---------------+---------------+------+-----+---------+-------+
| Field         | Type          | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| nip           | int(10)       | NO   | PRI | NULL    |       |
| nama          | varchar(20)   | YES  |     | NULL    |       |
| jenis_kelamin | enum('L','P') | YES  |     | NULL    |       |
| alamat        | text          | YES  |     | NULL    |       |
+---------------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc mapel;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id_mapel   | int(11)     | NO   | PRI | NULL    | auto_increment |
| kode_mapel | varchar(5)  | YES  |     | NULL    |                |
| mapel      | varchar(30) | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> create table mengajar (
    -> id_mengajar int auto_increment primary key,
    -> nip int(10),
    -> id_mapel int,
    -> foreign key(nip) references guwru(nip)
    -> on delete cascade on update cascade,
    -> foreign key(id_mapel) references mapel(id_mapel)
    -> on delete caccade on update cascade)
    -> type=innodb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'cacca
de on update cascade)
type=innodb' at line 8
mysql> create table mengajar (;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql>
mysql>  create table mengajar (
    ->  id_mengajar int auto_increment primary key,
    ->  nip int(10),
    ->  id_mapel int,
    ->  foreign key(nip) references guwru(nip)
    ->  on delete cascade on update cascade,
    ->  foreign key(id_mapel) references mapel(id_mapel)
    ->  on delete cascade on update cascade)
    ->  type=innodb;
ERROR 1005 (HY000): Can't create table 'tkj.mengajar' (errno: 150)
mysql> create table mengajar
    ->  id_mengajar int auto_increment primary key,
    ->  nip int(10),
    ->  id_mapel int,
    ->  foreign key(nip) references guwru(nip)
    ->  on delete cascade on update cascade,
    ->  foreign key(id_mapel) references mapel(id_mapel)
    ->  on delete cascade on update cascade
    ->  type=innodb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'id_me
ngajar int auto_increment primary key,
 nip int(10),
 id_mapel int,
 foreig' at line 2
mysql>  create table mengajar(
    ->  id_mengajar int auto_increment primary key,
    ->  nip int(10),
    ->  id_mapel int(11),
    ->  foreign key(nip) references guwru(nip)
    ->  on delete cascade on update cascade,
    ->  foreign key(id_mapel) references mapel(id_mapel)
    ->  on delete cascade on update cascade)
    ->  type=innodb;
ERROR 1005 (HY000): Can't create table 'tkj.mengajar' (errno: 150)
mysql> alter table mapel ENGINE=innodb;
Query OK, 1 row affected (0.13 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>  create table mengajar(
    ->  id_mengajar int auto_increment primary key,
    ->  nip int(10),
    ->  id_mapel int(11),
    ->  foreign key(nip) references guwru(nip)
    ->  on delete cascade on update cascade,
    ->  foreign key(id_mapel) references mapel(id_mapel)
    ->  on delete cascade on update cascade)
    ->  type=innodb;
ERROR 1005 (HY000): Can't create table 'tkj.mengajar' (errno: 150)
mysql> alter table guwru ENGINE=innodb;
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>  create table mengajar(
    ->  id_mengajar int auto_increment primary key,
    ->  nip int(10),
    ->  id_mapel int(11),
    ->  foreign key(nip) references guwru(nip)
    ->  on delete cascade on update cascade,
    ->  foreign key(id_mapel) references mapel(id_mapel)
    ->  on delete cascade on update cascade)
    ->  type=innodb;
Query OK, 0 rows affected, 1 warning (0.13 sec)

mysql>

Darah Haid

Darah Haid

Definisi Haid
Arti Lughowi  : mengalir
Arti Syar’i       : darah alami yang keluar dari ujung rahim pada sehat.
Keterangan      :
Darah yang keluar secara alami bukan darah haid seperti darah yang keluar sebelum dan ketika melahirkan.
Usia Minimal
Usia wanita haid         : Dimulai dari umur 9 tahun qamariyah taqribiyah.
Keterangan                  :
Darah yang keluar adalah darah haid
 
            Tahun qamariyah adalah tahun Hijriyah, sedangkan taqribiyah artinya untuk dapat mengalami haid tidak harus berumus 9 tahun persis, jadi jika darah keluar pada umur 9tahun kurang 15 hari misalnya ( masa yang tidak cukup untuk haid dan suci ), maka darah tersebut sudah dihukumi haid.


 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Ulang tahun ke-9
 
Darah yang keluar bukan darah haid
 


Masa Haid
Minimal           Sehari semalam atau 24 jam.
Kebanyakan    : 6 – 7 hari.
Keterangan      :
·         Darah yang keluar kurang dari 24 jam adalah darah istihadloh.


Melihat darah setiap hari 1 jam selama 15 hari, maka semuanya istihadloh.
 
 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

·         Darah yang keluar lebih dari 15 hari adalah darah haid yang bercampur dengan darah istihadloh, maka harus diteliti lagi dengan mempelajari tujuh gambaran perempuan mustahadloh yang akan dijelaskan.
10 hari darah hitam dan 10 hari darah merah.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Darah istihadloh
 
Darah haid
 


Masa Suci antara Dua Haid
Minimal           : 15 hari
Kebanyakan    : Sisa hari-hari haid dalam sebulan.
Maksimal         : Tidak terbatas.
Keterangan      :
            Jika haid kedua datang sebelum masa suci sempurna 15 hari, maka darah itu bukanlah darah haid, wanita tersebut tetap dihukumi suci sampai sempurnanya masa suci 15 hari. Jika setelah masa suci sempurna darah tetap keluar, maka darah yang terakhir ini adalah haid.
7 hari darah, 8 hari bersih dan 7 hari darah
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Darah istihadloh
 
Suci
 
Darah haid
 
                                                                                                                    


Tanda Berhentinya Haid
Suci dapat diketahui dengan memasukkan kapas ke Mrs.V. Jika tidak nampak bercak pada kapas berupa darah maupun warna kuning atau keruh maka haid telah usai.