blog`e bagus

Home
Tugas Kuliah
- Alpro
- SDATA
Download
Contact
- Facebook
- Twitter

simpan script di bawah dengan nama index.php

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form action="seacrh.php" method="POST">
<input type="text" name="data_cari"><br/>
<select name="kategori">
<option value="nim">Nim</option>
<option value="nama_mhs">Nama</option>
<option value="alamat">Alamat</option>
</select>
<input type="submit" value="cari">
</form>
</body>
</html>

simpan script di bawah dengan nama search.php
<?php
$kata_kunci = $_POST['data_cari'];
$cari = $_POST['kategori'];
$MyDb = new mysqli("localhost","root","","akademik");
$query= "SELECT * FROM mhs where $cari LIKE'%$kata_kunci%'";
$hasilCari = $MyDb->query($query);
if($hasilCari->num_rows == 0){
echo "DATA TIDAK DITEMUKAN";
}else{
while($data = mysqli_fetch_array($hasilCari)){
echo "Nim :".$data['nim']."<br/>";
echo "Nama : ".$data['nama_mhs']."<br/>";
echo "Alamat : ".$data['alamat']."<br/>";
}
}

?>

NOTE: Jangan lupa di buatkan terlebih dahulu database nya

<!DOCTYPE html>
<html>
<head>
<title></title>
<script src="js/jquery-1.7.2.js"></script>
<script src="ui/jquery.ui.core.js"></script>
<script src="ui/jquery.ui.widget.js"></script>
<script src="ui/jquery.ui.datepicker.js"></script>
<script type="text/javascript">

function klik(){
var user = document.getElementById('username').value;
if(user.length<5){
document.getElementById('tag-u').innerHTML='Inputan kurang dari 5 karakter';
}else if( user.length>20 ){
document.getElementById('tag-u').innerHTML='Inputan lebih dari 20 karakter';
}else{
document.getElementById('tag-u').innerHTML='';
}

var emaill = document.getElementById('email').value;
var atpos = emaill.indexOf("@");
var dotpos = emaill.lastIndexOf(".");

if(emaill.length<4){
document.getElementById('tag-e').innerHTML='karakter kurang dari 4 karakter';
}else if (atpos<1 || dotpos<atpos+2 || dotpos+2>=x.length) {
document.getElementById("tag-e").innerHTML='email tidak valid';
return false;
}else{
document.getElementById('tag-e').innerHTML='';
}

}

function key(){
var user = document.getElementById('username').value;
var pass = document.getElementById('password').value;
if(pass.length<5){
document.getElementById('tag-p').innerHTML='Inputan kurang dari 5 karakter';
}else if(pass.length>20){
document.getElementById('tag-p').innerHTML='Inputan lebih dari 20 karakter';
}else{
document.getElementById('tag-p').innerHTML='';
}
if(user==pass){
document.getElementById('tag-p').innerHTML='Username dan password tidak boleh sama';
}else{
document.getElementById('tag-p').innerHTML='';
}

}
/*function check_radio(radio){

for (i = 0; i < radio.length; i++){
if (radio[i].checked === true){
return radio[i].value;
}
}
return false;
}*/

</script>

</head>

<body>

<p>Form pendaftaran</p>
<table>
<tr>
<td>
Username<br/><input type="text" id="username" onkeyup="klik()"><br/>
</td>
<td>
<p id="tag-u"></p>
</td>
</tr><br/>
<tr>
<td>
Password<br/><input type="password" id="password" onkeyup="key()"><br/>
</td>
<td>
<p id="tag-p"></p>
</td>
</tr><br/>
<tr>
<td>
Email<br/><input type="email" id="email" onkeyup="klik()"><br/>
</td>
<td>
<p id="tag-e"></p>
</td>
</tr><br/>
<tr>
<td>
Tanggal lahir<br/><input type="date" id="tanggal"><br/>
</td>
<td>
<p id="tag-e"></p>
</td>
</tr><br/>
<tr>
<td>
Jenis Kelamin<br/><input type="radio" name="jk" value="L" >laki-laki<br/>
<input type="radio" name="jk" value="P">perempuan<br/>
</td>
<td>
<p id="tag-e"></p>
</td>
</tr><br/>
<tr>
<td>
<input type="button" value="submit" onkeyup="klik()">
</td>
</tr>

</table>

</body>
</html>

simpan script di bawah ini dengan file database.php dan buatkan database dengan nama mhs

<?php
/**
*
*/
class Database
{
private $host;
private $username;
private $password;
private $db_c;

function __construct ($a,$b,$c,$d){
$this->host = $a;
$this->username = $b;
$this->password = $c;
$this->db_c=$d;
}

public function sambungan(){
mysql_connect($this->host,$this->username,$this->password);
mysql_select_db($this->db_c);
}

public function tambahdata($nim,$nama,$alamat){

$query = "insert into mhs (nim,nama,alamat) values ('$nim','$nama',
'$alamat')";
$sql = mysql_query($query);
if ($sql) {
echo "Berhasil";
}
else{
echo "Gagal";
}

}

public function getData($nim){

$query = "select * from mhs where nim=$nim";
$getData = mysql_query($query);

while($data = mysql_fetch_row($getData)){
$hasil['nim'] = $data[0];
$hasil['nama'] = $data[1];
$hasil['alamat'] = $data[2];

}
return $hasil;
}

public function tampildata(){
$query = "select * from mhs";
$sql = mysql_query($query);
$i = 0;
while($data = mysql_fetch_array($sql)){
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$data['0']."</td>";
echo "<td>".$data['1']."</td>";
echo "<td>".$data['2']."</td>";
echo "<td> <a href='simpan.php?aksi=hapus&nim=".$data['0']."'>Hapus</a>

</td>";
echo "</tr>";
$i++;
}
}

public function hapus($nim){

$query = "delete from mhs where nim=".$nim;
$sql = mysql_query($query);

if($sql)
echo "Berhasil<br>";
else
echo "Gagal Hapus <br>";

}

}
?>

simpan script dibawah dengan nama index.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form action="simpan.php?aksi=tambah" method="POST">
nim:<input type="text" name="nim"/><br>
nama:<input type="text" name="nama"/><br>
alamat: <input type="textarea" name="alamat"/><br>
<input type="submit" value="simpan"/><br>
</form>
<a href="simpan.php?aksi=tampil"><button>Tampil</button></a>

</body>
</html>

simpan script dibawah dengan nama simpan.php

<?php
include "databases.php";

$host = 'localhost';
$username = 'root';
$password = '';
$db_c = 'prak4';
$db = new Database($host,$username,$password,$db_c);
$db->sambungan();

$aksi = $_GET['aksi'];

if ($aksi=='tambah') {
$db->tambahdata($_POST['nim'],$_POST['nama'],$_POST['alamat']);

}
elseif ($aksi =='tampil') {
include "tampil.php";
}
elseif ($aksi=='hapus') {
$db->hapus($_GET['nim']);
}
?>

simpan script di bawah dengan nama tampil.php

<html>
<head>

</head>
<body>

<table border="1">
<tr>
<th>No</th>
<th>NIM</th>
<th>NAMA</th>
<th>ALAMAT</th>
<th>AKSI</th>
</tr>
<?php
$db->tampildata();
?>
</table>

</body>
</html>

Langganan: Postingan ( Atom )

JAM DIBAWAH INI

mengenai saya

Unknown

Lihat profil lengkapku

Categories

alpro
lat individu
Refleksi
SDATA
Uji Kompetensi 1

coretan

Diberdayakan oleh Blogger.

Copyright 2014 blog`e bagus.

Distributed By My Blogger Themes | Designed By OddThemes