· 10 years ago · Jul 23, 2016, 02:06 PM
1 <?php
2$servername = "localhost";
3$username = "root";
4$password = "";
5$dbname = "dbphp";
6
7// Create connection
8$conn = new mysqli($servername, $username, $password, $dbname) or die(mysql_error());
9// Check connection
10
11
12
13$head = '<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www,wapforum,org/DTD/xhtml-mobile10.dtd"><html xmlns="http://www.w3,org/1999/xhtml"><head><title>Pemasangan FSB</title><meta name="viewport" content="width=320" /><meta name="viewport" content="initial-scale=1.0" /><meta name="viewport" content="user-scalable=false" /><meta http-equiv="Cache-Control" content="max-age=1" /><meta name="HandheldFriendly" content="True" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><link rel="stylesheet" href="files/panel.css" type="text/css" media="all,handheld"/><head><div id="fs-header"><h1>TES AJA</h1></div><body>';
14
15$foot = '<div id="fs-footer">Copyright 2012 - '.date('Y',time()+60*60*8).'<br />Njajal<a href="www.FB.com">fb</a></div></body></html>';
16echo $head;
17if(isset($_POST['start']))
18{
19$now = time();
20 $sql = "CREATE TABLE IF NOT EXISTS `siswa` (
21`mais_id` int(11) NOT NULL AUTO_INCREMENT,
22`nis` int(20) NOT NULL,
23`nama` varchar(50) NOT NULL,
24`kelas` varchar(10) NOT NULL,
25`jurusan` varchar(30) NOT NULL,
26PRIMARY KEY (`mais_id`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;";
28
29if($conn->query($sql) === TRUE) {
30$nis = $_POST['nis'];
31$nama = $_POST['nama'];
32$kelas = $_POST['kelas'];
33$jurusan = $_POST['jurusan'];
34
35 $dq = "INSERT INTO siswa (nis, nama, kelas, jurusan) VALUES ('$nis', '$nama', '$kelas', '$jurusan');";
36 if($conn->query($dq) === true ) {
37rename('./index.php', 'sukses-install.php');
38header ('Location: man.png');
39 }else{
40 echo"insert data gagal";
41 }
42 } else {
43 echo"Pembuatan tabel gagal";
44}
45}
46
47else
48{
49echo '
50<p>Selamat datang</p><br />
51<form action ="index.php" method="POST">
52<h4>Nama Pengguna</h4>
53<table cellpadding="3" cellspacing="0">
54<tr>
55<td>NIS</td>
56<td>:</td>
57<td><input type="text" name="nis" required></td>
58</tr>
59<tr>
60<td>Nama Lengkap</td>
61<td>:</td>
62<td><input type="text" name="nama" size="30" required></td>
63</tr>
64<tr>
65<td>Kelas</td>
66<td>:</td>
67<td>
68<select name="kelas" required>
69<option value="">Pilih Kelas</option>
70<option value="X">X</option>
71<option value="XI">XI</option>
72<option value="XII">XII</option>
73</select>
74</td>
75</tr>
76<tr>
77<td>Jurusan</td>
78<td>:</td>
79<td>
80<select name="jurusan" required>
81<option value="">Pilih Jurusan</option>
82<option value="Tes">Tes</option>
83<option value="percobaan">percobaan</option>
84<option value="coba">cobs</option>
85<option value="cobacoba">cobacoba</option>
86<option value="mencoba">mencoba</option>
87</select>
88</td>
89</tr>
90<tr>
91<td> </td>
92<td></td>
93<td><input type="submit" name="start" value="Tambah">
94';
95}