Baik sobat.,mungkin sobat pasti sudah pernah menanyakan CARA MEMBUAT FORMULIR PENDAFTARAN dengan mudah dan cepat.,Ya.. memang sudah banyak kita lihat formulir pendaftaran seperti di forum-forum atau situs-situs Bisnis online dan lain-lain...
lalu,bagaimana cara membuat formulirnya?
Nah,ini dia nih yang sekarang ingin kita bahas........,
Langsung aja ya?
Langkah Pertama yang harus kita buat adalah,pertama mari kita buat dulu database seperti format tabel dibawah ini:
===============================
CREATE TABLE 'member' (
'id' INT NOT NULL AUTO_INCREMENT ,
'username' VARCHAR( 128 ) NOT NULL ,
'email' VARCHAR( 64 ) NOT NULL ,
'password' VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY ( 'id' )
)==============================Kemudian,buat file dengan nama 'dbconfiq.php' kemudian copy script dibawah
=============================
<?php
function open_connection() {
$host = "localhost";
$user = "root";
$pass = "";
$database = "project";
$namatable = "member";
$connect = mysql_connect($host,$user,$pass) or die("Koneksi gagal");
$pilih_db = mysql_select_db($database) or die("Database tidak ada");
}
?>
function open_connection() {
$host = "localhost";
$user = "root";
$pass = "";
$database = "project";
$namatable = "member";
$connect = mysql_connect($host,$user,$pass) or die("Koneksi gagal");
$pilih_db = mysql_select_db($database) or die("Database tidak ada");
}
?>
=============================
Angggap sudah selesai,sekarang mari kita buat formulir PENDAFTARAN nya..,beri nama " Sigup.php":
=============================
<?php
<html> <head> <title>Sign up</title></head><body> <div align="middle" valign="middle"> <h3>Sign Up..!!</h3><p> <form method="post"> <table> <tr> <td>Username</td> <td><input name="username" id="username" type="text" size="20"></td> </tr><tr> <td>Email</td> <td><input name="email" id="email" type="email" size="20"></td> </tr><tr> <td>Password</td> <td><input name="password" id="password" type="password" size="20"></td> </tr><tr> <td height="10"> </td> <td><input type ="submit" id="submit" name="submit" value ="Sign up"></td> </tr></table></form></div></p> <?php if ('POST' == $_SERVER['REQUEST_METHOD']) { $username = $_POST['username']; $email = $_POST['email']; $password = $_POST['password']; $submit = $_POST['submit']; if (isset($_POST['submit'])) { require_once "register.php";} } ?> </body></html>
<html> <head> <title>Sign up</title></head><body> <div align="middle" valign="middle"> <h3>Sign Up..!!</h3><p> <form method="post"> <table> <tr> <td>Username</td> <td><input name="username" id="username" type="text" size="20"></td> </tr><tr> <td>Email</td> <td><input name="email" id="email" type="email" size="20"></td> </tr><tr> <td>Password</td> <td><input name="password" id="password" type="password" size="20"></td> </tr><tr> <td height="10"> </td> <td><input type ="submit" id="submit" name="submit" value ="Sign up"></td> </tr></table></form></div></p> <?php if ('POST' == $_SERVER['REQUEST_METHOD']) { $username = $_POST['username']; $email = $_POST['email']; $password = $_POST['password']; $submit = $_POST['submit']; if (isset($_POST['submit'])) { require_once "register.php";} } ?> </body></html>
=================================
lalu buat script untuk mengolah data,inputan formulir dan berinama "register.php":
=================================
<?php
if (empty($username) || empty($email) || empty($password)){
echo "Data yang kamu masukkan belum lengkap cuy..";
echo "<meta content=1;url=signup.php>";
}
else {
require_once("dbconfig.php");
open_connection();
$namatabel = "member";
$sql = "insert into $namatabel values ('$id','$username','$email','$password')";
mysql_query ($sql) or die ("<h2>Error coy..!!</h2>");
echo "<div align='middle'><b>You now registered";
echo "<meta http-equiv=refresh content=2;url=index.php>"; }
?>
if (empty($username) || empty($email) || empty($password)){
echo "Data yang kamu masukkan belum lengkap cuy..";
echo "<meta content=1;url=signup.php>";
}
else {
require_once("dbconfig.php");
open_connection();
$namatabel = "member";
$sql = "insert into $namatabel values ('$id','$username','$email','$password')";
mysql_query ($sql) or die ("<h2>Error coy..!!</h2>");
echo "<div align='middle'><b>You now registered";
echo "<meta http-equiv=refresh content=2;url=index.php>"; }
?>
===================================
Dan yang terakhir buat script untuk menampilkan data member nya sobat beri nama dengan "basing.php":
===================================
<?php
require_once "dbconfig.php";
open_connection();
$query = "SELECT * FROM member";
$runquery = mysql_query($query);
while($result = mysql_fetch_array($runquery)) {
$id = $result['id'];
$member = $result['username'];
}
?>
require_once "dbconfig.php";
open_connection();
$query = "SELECT * FROM member";
$runquery = mysql_query($query);
while($result = mysql_fetch_array($runquery)) {
$id = $result['id'];
$member = $result['username'];
}
?>
===================================
Selesai membuat formulir pendaftaran....,
semoga bermanfaat......
oh iya...,jangan lupa ya komentarnya...ditunggu.
0 Komentar:
Post a Comment