- Beranda
- Komunitas
- Tech
- Programmer Forum
KOneksi ke My Sql
TS
ruslysetiawan
KOneksi ke My Sql
file index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title>Form Pendaftaran Multi-Step</title>
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
[removed][removed]
[removed][removed]
[removed][removed]
[removed][removed]
</head>
<body>
<div id="container">
<form action="submit.php" method="post">
<div id="langkah_pertama">
<h1>FORM<span>PENDAFTARAN MEMBER BARU</span></h1>
<div class="form">
<input type="text" name="username" id="username" value="username" />
<label for="username">Minimal 4 karakter. Huruf kapital, huruf kecil dan angka</label>
<input type="password" name="password" id="password" value="password" />
<label for="password">Minimal 5 karakter. Gunakan kombinasi huruf kapital dan huruf kecil untuk password yang lebih kuat</label>
<input type="password" name="ulangpassword" id="ulangpassword" value="password" />
<label for="ulangpassword">Ketik ulang password</label>
</div>
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
<input class="submit" type="submit" name="submit_pertama" id="submit_pertama" value="Submit" />
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
</div>
<div id="langkah_kedua">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<input type="text" name="firstname" id="firstname" value="first name" />
<label for="firstname">Nama Depan </label>
<input type="text" name="lastname" id="lastname" value="last name" />
<label for="lastname">Nama Belakang </label>
<input type="text" name="email" id="email" value="email address" />
<label for="email">Alamat email Anda. Detail pendaftaran akan dikirim melalui alamat email yang anda tuliskan.</label>
</div>
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
<input class="submit" type="submit" name="submit_kedua" id="submit_kedua" value="Submit" />
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
</div>
<div id="langkah_ketiga">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<div class="clear"></div><!-- /clearfix -->
<select id="gender" name="gender">
<option>Laki-laki</option>
<option>Perempuan</option>
</select>
<label for="gender">Jenis kelamin </label> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<select id="region" name="region">
<option>Jawa</option>
<option>Sumatra</option>
<option>Kalimantan</option>
<option>Sulawesi</option>
<option>Papua</option>
</select>
<label for="region">Daerah regional </label> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<input class="submit" type="submit" name="submit_ketiga" id="submit_ketiga" value="Submit" />
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<div id="langkah_keempat">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<h2>Ringkasan</h2>
<table>
<tr><td>Username</td><td></td></tr>
<tr><td>Password</td><td></td></tr>
<tr><td>Email</td><td></td></tr>
<tr><td>Nama</td><td></td></tr>
<tr><td>Jenis Kelamin</td><td></td></tr>
<tr><td>Regional</td><td></td></tr>
</table>
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<input class="send submit" type="submit" name="submit_keempat" id="submit_keempat" value="Kirim" />
</div>
</form>
</div>
<div id="progress_bar">
<div id="progress"></div>
<div id="progress_text">LANGKAH 0/3</div>
</div>
</body>
</html>
Gan kenapa koq ga bisa tersimpan di database....minta solusinya. padahal database dan
file submit.phpnya dah dibuat tapi ga mau kirim
<?php
$usermame = $_POST['username'];
$password = $_POST['password'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$region = $_POST['region'];
//koneksi database
$conn = mysql_connect("localhost","root","");
mysql_select_db("pendaftaran");
$query = "insert into member set username='$username',password='$password', firstname='$firstname', email='$email', gender='$gender',region='$region'";
$hasil = mysql_query($query);
if($hasil){
echo "Data siswa telah disimpan";
}else{
echo "Error! gagal menyimpan data siswa:".mysql_error();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title>Form Pendaftaran Multi-Step</title>
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
[removed][removed]
[removed][removed]
[removed][removed]
[removed][removed]
</head>
<body>
<div id="container">
<form action="submit.php" method="post">
<div id="langkah_pertama">
<h1>FORM<span>PENDAFTARAN MEMBER BARU</span></h1>
<div class="form">
<input type="text" name="username" id="username" value="username" />
<label for="username">Minimal 4 karakter. Huruf kapital, huruf kecil dan angka</label>
<input type="password" name="password" id="password" value="password" />
<label for="password">Minimal 5 karakter. Gunakan kombinasi huruf kapital dan huruf kecil untuk password yang lebih kuat</label>
<input type="password" name="ulangpassword" id="ulangpassword" value="password" />
<label for="ulangpassword">Ketik ulang password</label>
</div>
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
<input class="submit" type="submit" name="submit_pertama" id="submit_pertama" value="Submit" />
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
</div>
<div id="langkah_kedua">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<input type="text" name="firstname" id="firstname" value="first name" />
<label for="firstname">Nama Depan </label>
<input type="text" name="lastname" id="lastname" value="last name" />
<label for="lastname">Nama Belakang </label>
<input type="text" name="email" id="email" value="email address" />
<label for="email">Alamat email Anda. Detail pendaftaran akan dikirim melalui alamat email yang anda tuliskan.</label>
</div>
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
<input class="submit" type="submit" name="submit_kedua" id="submit_kedua" value="Submit" />
<!-- clearfix -->
<div class="clear"></div>
<!-- /clearfix -->
</div>
<div id="langkah_ketiga">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<div class="clear"></div><!-- /clearfix -->
<select id="gender" name="gender">
<option>Laki-laki</option>
<option>Perempuan</option>
</select>
<label for="gender">Jenis kelamin </label> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<select id="region" name="region">
<option>Jawa</option>
<option>Sumatra</option>
<option>Kalimantan</option>
<option>Sulawesi</option>
<option>Papua</option>
</select>
<label for="region">Daerah regional </label> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<input class="submit" type="submit" name="submit_ketiga" id="submit_ketiga" value="Submit" />
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<div id="langkah_keempat">
<h1>FORM<span>PENDAFTARAN</span></h1>
<div class="form">
<h2>Ringkasan</h2>
<table>
<tr><td>Username</td><td></td></tr>
<tr><td>Password</td><td></td></tr>
<tr><td>Email</td><td></td></tr>
<tr><td>Nama</td><td></td></tr>
<tr><td>Jenis Kelamin</td><td></td></tr>
<tr><td>Regional</td><td></td></tr>
</table>
</div> <!-- clearfix --><div class="clear"></div><!-- /clearfix -->
<input class="send submit" type="submit" name="submit_keempat" id="submit_keempat" value="Kirim" />
</div>
</form>
</div>
<div id="progress_bar">
<div id="progress"></div>
<div id="progress_text">LANGKAH 0/3</div>
</div>
</body>
</html>
Gan kenapa koq ga bisa tersimpan di database....minta solusinya. padahal database dan
file submit.phpnya dah dibuat tapi ga mau kirim
<?php
$usermame = $_POST['username'];
$password = $_POST['password'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$region = $_POST['region'];
//koneksi database
$conn = mysql_connect("localhost","root","");
mysql_select_db("pendaftaran");
$query = "insert into member set username='$username',password='$password', firstname='$firstname', email='$email', gender='$gender',region='$region'";
$hasil = mysql_query($query);
if($hasil){
echo "Data siswa telah disimpan";
}else{
echo "Error! gagal menyimpan data siswa:".mysql_error();
}
?>
Diubah oleh ruslysetiawan 09-07-2013 06:44
0
803
3
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan