Untitled

 <?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbphp";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname) or die(mysql_error());
// Check connection


$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>';

$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>';
echo $head;
if(isset($_POST['start']))
{
$now = time();
    $sql = "CREATE TABLE IF NOT EXISTS `siswa` (
`mais_id` int(11) NOT NULL AUTO_INCREMENT,
`nis` int(20) NOT NULL,
`nama` varchar(50) NOT NULL,
`kelas` varchar(10) NOT NULL,
`jurusan` varchar(30) NOT NULL,
PRIMARY KEY (`mais_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;";

if($conn->query($sql) === TRUE) {
$nis = $_POST['nis'];
$nama = $_POST['nama'];
$kelas = $_POST['kelas'];
$jurusan = $_POST['jurusan'];

    $dq = "INSERT INTO siswa (nis, nama, kelas, jurusan) VALUES ('$nis', '$nama', '$kelas', '$jurusan');";
    if($conn->query($dq) === true ) {
rename('./index.php', 'sukses-install.php');
header ('Location: man.png');
    }else{
        echo"insert data gagal";
    }
    } else {
    echo"Pembuatan tabel gagal";
}
}

else
{
echo '
<p>Selamat datang</p><br />
<form action ="index.php" method="POST">
<h4>Nama Pengguna</h4>
<table cellpadding="3" cellspacing="0">
<tr>
<td>NIS</td>
<td>:</td>
<td><input type="text" name="nis" required></td>
</tr>
<tr>
<td>Nama Lengkap</td>
<td>:</td>
<td><input type="text" name="nama" size="30" required></td>
</tr>
<tr>
<td>Kelas</td>
<td>:</td>
<td>
<select name="kelas" required>
<option value="">Pilih Kelas</option>
<option value="X">X</option>
<option value="XI">XI</option>
<option value="XII">XII</option>
</select>
</td>
</tr>
<tr>
<td>Jurusan</td>
<td>:</td>
<td>
<select name="jurusan" required>
<option value="">Pilih Jurusan</option>
<option value="Tes">Tes</option>
<option value="percobaan">percobaan</option>
<option value="coba">cobs</option>
<option value="cobacoba">cobacoba</option>
<option value="mencoba">mencoba</option>
</select>
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td></td>
<td><input type="submit" name="start" value="Tambah">
';
}