MOHON MAAF SEMUA CONTOH MYSQL KAMI COPY LANGSUNG KE NOTEPAD++
JADI BANYAK TABEL YANG TIDAK ENAK DI LIHAT
MOHON MAAF ATAS NAMA KELOMPOK 4 KELAS 3 RPL 2
Jumat, 26 September 2014
MEMBUAT FILE KONEKSI
<?PHP
$Host="localhost";
$User="root";
$Pass="";
$dbName="absensi";
$Konek=mysql_connect($Host,$User,$Pass);
if($Konek){
$pilihDB=mysql_select_db($dbName);
}else{
echo"<script>alert('Tidak bisa konek ke database')</script>";
}
?>
$Host="localhost";
$User="root";
$Pass="";
$dbName="absensi";
$Konek=mysql_connect($Host,$User,$Pass);
if($Konek){
$pilihDB=mysql_select_db($dbName);
}else{
echo"<script>alert('Tidak bisa konek ke database')</script>";
}
?>
HAK AKSES
Menambah user baru dengan dengan hak akses yang hanya bisa melihat,dan mengedit database yang sudah kita buat dengan IP tertentu.
Contoh :
1.Tentukan persiapkan komputer yang akan di jadikan server,setelah itu catat IP komputer client yang akan menjadi user baru setelah itu ketikan perintah sesuai yang ada di bawah ini :
mysql> GRANT UPDATE ON absensi.* TO IMDADUN@192.168.60.51;
Query OK, 0 rows affected (0.00sec)
mysql> INSERT INTO guru VALUES ('12345','Hafizh Ghulam','Kedungwuni','Laki - Laki','Islam','08xxx');
Query OK, 1 row affected (0.11 sec)
mysql> select * from guru;
+-------+---------------+------------+---------------+-------+-------+
| NBM | nama_guru | alamat | jenis_kelamin | agama | no_hp |
+-------+---------------+------------+---------------+-------+-------+
| 12345 | Hafizh Ghulam | Kedungwuni | Laki - Laki | Islam | 08xxx |
+-------+---------------+------------+---------------+-------+-------+
1 row in set (0.03 sec)
mysql> GRANT UPDATE ON absensi.* TO IMDADUN@192.168.60.51;
Query OK, 0 rows affected (0.03sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00sec)
mysql> select * from guru;
+-------+---------------+------------+---------------+-------+-------+
| NBM | nama_guru | alamat | jenis_kelamin | agama | no_hp |
+-------+---------------+------------+---------------+-------+-------+
| 12344 | Lis Daryatun | Batang | Laki - Laki | Islam | 08xxx |
+-------+---------------+------------+---------------+-------+-------+
1 rows in set (0.00 sec)
FOR THE NEXT
2.Untuk komputer Client supaya bisa mengakses database komputer,ketikan perintah sesuai yang ada di bawah ini :
mysql> update guru set alamat='pasar_kedungwuni' where NBM='12345';
Query OK, 1 rows affected (0.04sec)
Rows matched: 1 Changed:1 Warnings: 0
Contoh :
1.Tentukan persiapkan komputer yang akan di jadikan server,setelah itu catat IP komputer client yang akan menjadi user baru setelah itu ketikan perintah sesuai yang ada di bawah ini :
mysql> GRANT UPDATE ON absensi.* TO IMDADUN@192.168.60.51;
Query OK, 0 rows affected (0.00sec)
mysql> INSERT INTO guru VALUES ('12345','Hafizh Ghulam','Kedungwuni','Laki - Laki','Islam','08xxx');
Query OK, 1 row affected (0.11 sec)
mysql> select * from guru;
+-------+---------------+------------+---------------+-------+-------+
| NBM | nama_guru | alamat | jenis_kelamin | agama | no_hp |
+-------+---------------+------------+---------------+-------+-------+
| 12345 | Hafizh Ghulam | Kedungwuni | Laki - Laki | Islam | 08xxx |
+-------+---------------+------------+---------------+-------+-------+
1 row in set (0.03 sec)
mysql> GRANT UPDATE ON absensi.* TO IMDADUN@192.168.60.51;
Query OK, 0 rows affected (0.03sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00sec)
mysql> select * from guru;
+-------+---------------+------------+---------------+-------+-------+
| NBM | nama_guru | alamat | jenis_kelamin | agama | no_hp |
+-------+---------------+------------+---------------+-------+-------+
| 12344 | Lis Daryatun | Batang | Laki - Laki | Islam | 08xxx |
+-------+---------------+------------+---------------+-------+-------+
1 rows in set (0.00 sec)
FOR THE NEXT
2.Untuk komputer Client supaya bisa mengakses database komputer,ketikan perintah sesuai yang ada di bawah ini :
mysql> update guru set alamat='pasar_kedungwuni' where NBM='12345';
Query OK, 1 rows affected (0.04sec)
Rows matched: 1 Changed:1 Warnings: 0
Jumat, 19 September 2014
PROCEDURE
SAMSUNG PC@SAMSUNG c:\xampp
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.5.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create procedure nambah (xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into guru values (xNBM,xnama_guru,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.03 sec)
mysql> create procedure hapus_guru(xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from guru where kondisi;
Query OK, 0 rows affected (0.01 sec)
create procedure ubah_guru (xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) xupdate guru set NBM=u_id_NBM,nama_guru=u_nmgr,alamat=u_almt,jenis_kelamin=u_jekel,agama=u_agama,xno_hp=u_nhp);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) insert into kehadiran values (xnis,xnama_siswa,xjenis_kelamin,xkel
as,xketerangan,xNBM,xnama_guru,xmapel,xsemester);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) delete from kehadiran where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) xupdate kehadiran set nis=u_nis,nama_siswa=u_nm_siswa,jenis_kelamin=u_jekel,keterangan=u_ket,NBM=u_NBM,nama_guru=nmgr,mapel=u_mpl,semester=u_smstr);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))insert into mapel values (xid_mapel,xmapel,xNBM,xnama_guru);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure hapus_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))delete from mapel where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_mapel (xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50)) xupdate mapel set id_mapel=u_id_mpl,mapel=u_mpl,NBM=u_NBM,nama_guru=u_nmgr);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))insert into semester values (xid_semester,xsemester,xtahun_semester);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))delete from semester where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10)) xupdate semester set id_semester=u_id_smstr,semester=u_smstr,tahun_semester=u_thn_semester);
Query OK, 0 rows affected (0.03 sec)
mysql> create procedure nambah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into siswa values(xnis,xnama,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from siswa where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) xupdate siswa set nis=u_nis,nama=u_nama,alamat=u_alamat,jenis_kelamin=u_jekel,agama=u_agama,no_hp=u_hp);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) insert into user values (xid,xusername,xfullname,xpassword,xemail,xmember_data,
xstatus,xlevel);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) delete from user where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_user (xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) xupdate user set id=u_id,username=u_usernme,fullname=u_fullnme,password=u_pass,email=u_mail,member_data=u_memberdata,lastup=u_lastup,status=u_stts,level=u_lvl);
Query OK, 0 rows affected (0.02 sec)
mysql> create procedure nambah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) insert into kelas values (xkelas,xjurusan,xjumlah_siswa,xwali_kelas);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) delete from kelas where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) update kelas set kelas=u_kls,jurusan=u_jrusan,jumlah_siswa=u_jml_siswa,wali_kelas=u_walikelas);
Query OK, 0 rows affected (0.00 sec)
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.5.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create procedure nambah (xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into guru values (xNBM,xnama_guru,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.03 sec)
mysql> create procedure hapus_guru(xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from guru where kondisi;
Query OK, 0 rows affected (0.01 sec)
create procedure ubah_guru (xNBM varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) xupdate guru set NBM=u_id_NBM,nama_guru=u_nmgr,alamat=u_almt,jenis_kelamin=u_jekel,agama=u_agama,xno_hp=u_nhp);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) insert into kehadiran values (xnis,xnama_siswa,xjenis_kelamin,xkel
as,xketerangan,xNBM,xnama_guru,xmapel,xsemester);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) delete from kehadiran where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) xupdate kehadiran set nis=u_nis,nama_siswa=u_nm_siswa,jenis_kelamin=u_jekel,keterangan=u_ket,NBM=u_NBM,nama_guru=nmgr,mapel=u_mpl,semester=u_smstr);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))insert into mapel values (xid_mapel,xmapel,xNBM,xnama_guru);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure hapus_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))delete from mapel where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_mapel (xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50)) xupdate mapel set id_mapel=u_id_mpl,mapel=u_mpl,NBM=u_NBM,nama_guru=u_nmgr);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))insert into semester values (xid_semester,xsemester,xtahun_semester);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))delete from semester where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10)) xupdate semester set id_semester=u_id_smstr,semester=u_smstr,tahun_semester=u_thn_semester);
Query OK, 0 rows affected (0.03 sec)
mysql> create procedure nambah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into siswa values(xnis,xnama,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from siswa where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) xupdate siswa set nis=u_nis,nama=u_nama,alamat=u_alamat,jenis_kelamin=u_jekel,agama=u_agama,no_hp=u_hp);
Query OK, 0 rows affected (0.01 sec)
mysql> create procedure nambah_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) insert into user values (xid,xusername,xfullname,xpassword,xemail,xmember_data,
xstatus,xlevel);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) delete from user where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_user (xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) xupdate user set id=u_id,username=u_usernme,fullname=u_fullnme,password=u_pass,email=u_mail,member_data=u_memberdata,lastup=u_lastup,status=u_stts,level=u_lvl);
Query OK, 0 rows affected (0.02 sec)
mysql> create procedure nambah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) insert into kelas values (xkelas,xjurusan,xjumlah_siswa,xwali_kelas);
Query OK, 0 rows affected (0.00 sec)
mysql> create procedure hapus_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) delete from kelas where kondisi;
Query OK, 0 rows affected (0.00 sec)
create procedure ubah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) update kelas set kelas=u_kls,jurusan=u_jrusan,jumlah_siswa=u_jml_siswa,wali_kelas=u_walikelas);
Query OK, 0 rows affected (0.00 sec)
Langganan:
Postingan (Atom)