<?php
session_start(); // Digunakan untuk memulai session
$host = "localhost"; // nama host anda
$user = "root"; // username dari host anda
$pass = ""; //password dari host anda
$db = "crud"; // nama database yang anda miliki
try {
$connect = new PDO("mysql:host={$host};dbname={$db}", $user, $pass);
$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e) {
echo $e->getMessage();
}
?> <?php
error_reporting(0);
include 'config.php';
if(!isset($_SESSION['username'] )== 0) { /* Halaman ini tidak dapat diakses jika belum ada yang login
header('Location: home.php'); */
}
$username = $_POST['username'];
$email = $_POST['email'];
$password = md5($_POST['password']."ALS52KAO09");
$confirmPassword = md5($_POST['confirmPassword']."ALS52KAO09");
if(isset($username, $email, $password, $confirmPassword)) {
if(strstr($email, "@")) {
if($password == $confirmPassword) {
try {
$sql = "SELECT * FROM users WHERE username = :username OR email = :email";
$stmt = $connect->prepare($sql);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':email', $email);
$stmt->execute();
}
catch(PDOException $e) {
echo $e->getMessage();
}
$count = $stmt->rowCount();
if($count == 0) {
try {
$sql = "INSERT INTO users SET username = :username, email = :email, password = :password";
$stmt = $connect->prepare($sql);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':password', $password);
$stmt->execute();
}
catch(PDOException $e) {
echo $e->getMessage();
}
if($stmt) {
echo "Selamat Anda berhasil Register, anda dapat Login";
}
}else{
echo "Username dan Email sudah pernah digunakan";
}
}else{
echo "Password tidak sama";
}
}else{
echo "Email Tidak Valid";
}
}
?>
<!-- FORM UNTUK REGISTRASI -->
<form action="" method="post">
<table>
<tr>
<td>Username</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input type="password" name="confirmPassword"></td>
</tr>
<tr>
<td>
<input type="submit" name="register" value="Register">
<input type="reset" name="reset" value="Reset">
</td>
</tr>
</table>
</form> <?php
//error_reporting(0);
include 'config.php';
if(!isset($_SESSION['username'] )== 0) {
header('Location: home.php');
}
if(isset($_POST['login'])) {
$username = $_POST['username'];
$password = md5($_POST['password']."ALS52KAO09");
try {
$sql = "SELECT * FROM users WHERE username = :username AND password = :password";
$stmt = $connect->prepare($sql);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':password', $password);
$stmt->execute();
$count = $stmt->rowCount();
if($count == 1) {
$_SESSION['username'] = $username;
header("Location: home.php");
return;
}else{
echo "Anda tidak dapat login";
}
}
catch(PDOException $e) {
echo $e->getMessage();
}
}
?>
<!-- FORM LOGIN -->
<form action="" method="post">
<table>
<tr>
<td>Username</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td>
<input type="submit" name="login" value="Login">
<input type="reset" name="reset" value="Reset">
</td>
</tr>
</table>
</form>
<br><a href="register.php">Register</a> <?php
include 'config.php';
if(isset($_SESSION['username'])== 0) { /* Halaman ini tidak dapat diakses jika belum ada yang login */
header('Location: index.php');
}
?>
<h1><p>Selamat Datang <?php echo $_SESSION['username']; ?></p></h1>
<br><a href="logout.php">Logout</a> <?php
session_start(); //digunakan untuk memulai session
session_destroy(); //digunakan untuk menghapus session
header('Location: index.php'); //jika berhasil maka akan dialihkan ke halaman index(login)
?> 
 |
| Cover buku Trik Mudah Menguasai OOP dengan PHP. |
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace ComplexChartVC4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
LoadData();
}
private void LoadData()
{
//chart1.DataSource = GetData();
//chart1.Series["Series1"].XValueMember = "Registration Type";
//chart1.Series["Series1"].YValueMembers = "Total";
chart1.DataBindCrossTable(GetData().DefaultView, "Registration Type", "Year", "Total", "Label=Total");
}
private DataTable GetData()
{
DataTable dtChartData = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbx"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_ChartData3", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
dtChartData.Load(reader);
}
}
return dtChartData;
}
}
}
CREATE PROCEDURE [dbo].[usp_ChartData3]
AS
BEGIN
SELECT COUNT(st.StudentId) AS 'Total'
,ld.Description AS 'Registration Type'
,DATEPART(yyyy, st.DateOfRegistration) AS 'Year'
FROM dbo.Students st
INNER JOIN dbo.ListData ld ON st.RegistrationType = ld.LisDataId
GROUP BY DATEPART(yyyy, st.DateOfRegistration), ld.Description
END
using System;
using System.Data;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;
namespace ChartDemoVC3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
FromComboBox.Text = "2012";
ToComboBox.Text = "2015";
LoadData();
}
private void LoadData()
{
SalesByYearChart.DataSource = GetData();
SalesByYearChart.Series["Series1"].Points.Clear();
SalesByYearChart.Series["Series1"].XValueMember = "Year";
SalesByYearChart.Series["Series1"].YValueMembers = "Total";
}
// DataSet, Objects, Array, Collection, Generics, DataTable
private DataTable GetData()
{
DataTable dtChartData = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbx"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_ChartData2", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.AddWithValue("@FromYear", FromComboBox.Text);
cmd.Parameters.AddWithValue("@ToYear", ToComboBox.Text);
SqlDataReader reader = cmd.ExecuteReader();
dtChartData.Load(reader);
}
}
return dtChartData;
}
private void GoButton_Click(object sender, EventArgs e)
{
LoadData();
}
}
}
CREATE PROCEDURE [dbo].[usp_ChartData2]
(
@FromYear NVARCHAR(50)
,@ToYear NVARCHAR(50)
)
AS
BEGIN
SELECT SUM([Total]) AS 'Total'
,DATEPART(yyyy, [DateOfOrder]) AS 'Year'
FROM [dbo].[Orders]
GROUP BY DATEPART(yyyy, [DateOfOrder])
HAVING DATEPART(yyyy, [DateOfOrder]) >= @FromYear AND DATEPART(yyyy, [DateOfOrder]) <= @ToYear
END
$cfg['UploadDir'] = 'upload';
$cfg['ExecTimeLimit'] = 0;
using System;
using System.Data;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;
namespace ChartDemoVC2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
SalesByYearChart.DataSource = GetData();
SalesByYearChart.Series["SalesByYear"].XValueMember = "Year";
SalesByYearChart.Series["SalesByYear"].YValueMembers = "Total";
}
private DataTable GetData()
{
DataTable dtData = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbx"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_ChartData", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
dtData.Load(reader);
}
}
return dtData;
}
}
}
CREATE PROCEDURE [dbo].[usp_ChartData]
AS
BEGIN
SELECT SUM(Total) AS 'Total'
,DATEPART(yyyy, [DateOfOrder]) AS 'Year'
FROM [dbo].[Orders]
GROUP BY DATEPART(yyyy, [DateOfOrder])
END
 |
| Gambar.1 |
 |
| Gambar.2 |
 |
| Gambar.3 |
Langkah.1 Membuat DatabaseBuatlah sebuah database dengan nama db_nisn, kemudian buatlah field-field seperti script berikut :
CREATE TABLE IF NOT EXISTS `siswa` (
`nisn` int(10) NOT NULL,
`nama` varchar(30) NOT NULL,
`jenis_kelamin` enum('Perempuan','Laki-laki') NOT NULL,
`tempat_lahir` varchar(30) NOT NULL,
`tgl_lahir` date NOT NULL,
PRIMARY KEY (`nisn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Langkah.2 Membuat file koneksi.phpPembuatan file ini bertujuan untuk memanggil database, sehingga sistem diberikan otorisasi menggunakan database tersebut.
<?php
$con=mysqli_connect("localhost","root","","db_nisn");
?>
Langkah 3 Membuat ilmudetil.cssPembuatan file css ini bertujuan untuk membangun interface yang menarik. Tapi file css ini bukan bagian yang terpenting dalam proses searching, hanya asesoris mempercantik tampilan. Script css dari ilmudetil adalah sebagai berikut :
.navbar-default .navbar-nav > li.clr1 a{
color:#ffffff;
}
.navbar-default .navbar-nav > li.clr2 a{
color: #FFEB3B;;
}
.navbar-default .navbar-nav > li.clr3 a{
color: #5EC64D;
}
.navbar-default .navbar-nav > li.clr4 a{
color: #29AAE2;
}
.navbar-default .navbar-nav > li.clr1 a:hover, .navbar-default .navbar-nav > li.clr1.active a{
color:#fff;
background: #F55;
}
.navbar-default .navbar-nav > li.clr2 a:hover, .navbar-default .navbar-nav > li.clr2.active a{
color: #fff;
background:#973CB6;
}
.navbar-default .navbar-nav > li.clr3 a:hover, .navbar-default .navbar-nav > li.clr3.active a{
color: #fff;
background:#5EC64D;
}
.navbar-default .navbar-nav > li.clr4 a:hover, .navbar-default .navbar-nav > li.clr4.active a{
color: #fff;
background: #29AAE2;
}
.navbar-default{
background-color: #3b5998;
font-size:18px;
}
.navbar-default .navbar-brand {
color: #ffffff;
font-weight:bold;
}
.navbar-default .navbar-text {
color:#ffffff;
}
a{color: #FFC107;text-decoration: none;}
img{width:120px; height:135px;padding-top: 10px;}Langkah.4 Membuat file index_nama.phpFile index_nama.php merupakan interface untuk inputan nama yang akan dicari pada database.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="author" content="ilmu-detil.blogspot.com">
<title>Tutorial implementasi search dengan php</title>
<!-- Bagian css -->
<link rel="stylesheet" href="assets/css/bootstrap.css">
<link rel="stylesheet" href="assets/css/ilmudetil.css">
<!--<link rel='stylesheet' href='assets/css/jquery-ui-custom.css'>-->
<link rel="stylesheet" href="assets/css/font-awesome.min.css">
<!-- Akhir dari Bagian css -->
<!-- Bagian js -->
<script src='assets/js/jquery-1.10.1.min.js'></script>
<script src="assets/js/bootstrap.min.js"></script>
<!-- akhir dari Bagian js -->
</head>
<body>
<div class="navbar navbar-default navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.html">
Pusat Ilmu Secara Detil</a>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav navbar-left">
<li class="clr1 active"><a href="index.html">Home</a></li>
<li class="clr2"><a href="">Programming</a></li>
<li class="clr3"><a href="">English</a></li>
</ul>
</div>
</div>
</div>
</br></br></br></br>
<!--- Bagian Judul-->
<div class ="container">
<div class="row">
<div class="col-md-12">
<h4>Pencarian Data Siswa </h4>
</div>
</div>
</div>
<!--- Akhir Bagian Judul-->
<!-- Bagian pencarian -->
<div class ="container">
<div class="row">
<div class="col-md-6">
<div class="panel panel-default">
<div class="panel-heading">Pencarian Data</div>
<div class="panel-body">
<div class="row">
<div class="col-md-8" style="padding-top:25px">
<form method="POST" action="getuser_nama.php">
<div class="form-group">
<label for="input_no_siswa">Masukkan Nama</label>
<input type="text" class="form-control" required="required" name="inputnama" placeholder="Nama">
<span class="help-block"></span>
</div>
<div class="form-actions" style="padding-bottom:25px">
<button type="submit" class="btn btn-primary" name="submit" >Search</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Akhir dari pencarian -->
</body>
</html>
Langkah.5 Membuat file getuser_nama.phpFile ini berfungsi untuk memproses pencarian nama yang sebelumnya diinput pada form inputan nama.
<?php include "koneksi.php"; ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="author" content="ilmu-detil.blogspot.com">
<title>Tutorial implementasi search dengan php ajax </title>
<!-- Bagian css -->
<link rel="stylesheet" href="assets/css/bootstrap.css">
<link rel="stylesheet" href="assets/css/ilmudetil.css">
<link rel="stylesheet" href="assets/css/font-awesome.min.css">
<!-- Akhir dari Bagian css -->
<!-- Bagian js -->
<script src='assets/js/jquery-1.10.1.min.js'></script>
<script src="assets/js/bootstrap.min.js"></script>
<!-- akhir dari Bagian js -->
</head>
<body>
<div class="navbar navbar-default navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.html">
Pusat Ilmu Secara Detil</a>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav navbar-left">
<li class="clr1 active"><a href="index.html">Home</a></li>
<li class="clr2"><a href="">Programming</a></li>
<li class="clr3"><a href="">English</a></li>
</ul>
</div>
</div>
</div>
</br></br></br></br>
<!--- Bagian Judul-->
<div class ="container">
<div class="row">
<div class="col-md-12">
<h4>Pencarian Data Siswa </h4>
</div>
</div>
</div>
<!--- Akhir Bagian Judul-->
<!-- Bagian Searching -->
<div class ="container">
<div class="row">
<div class="col-md-6" style="padding-top:25px">
<?php
$nama = $_POST['inputnama'];
$sql ="Select * from siswa WHERE nama like '%$nama%'";
$result = mysqli_query($con, $sql);
//$row=mysqli_fetch_array($result);
if (mysqli_num_rows($result) == 0)
{
echo "<h5>Data tidak ditemukan</h5>";
echo "<br>";
}
else
{
echo "
<table class='table table-bordered'>
<thead>
<tr style='background-color: rgba(0, 0, 0, 0.05);'>
<th>NISN</th>
<th>Nama</th>
<th>Jenis Kelamin</th>
<th>Tempat Lahir</th>
<th>Tanggal Lahir</th>
</tr>
</thead>";
while($row =mysqli_fetch_array($result))
{
echo "<tbody>";
echo"<tr>";
echo "<td>" . $row['nisn']. "</td>";
echo "<td>" . $row['nama']. "</td>";
echo "<td>" . $row['jenis_kelamin']. "</td>";
echo "<td>" . $row['tempat_lahir']. "</td>";
echo "<td>" . $row['tgl_lahir']. "</td>";
echo "</tr>";
echo "</tbody>";
}
}
echo "</table> ";
mysqli_close($con);
?>
</div>
</div>
</div>
<!-- Akhir dari Searching -->
</body>
</html>
