Learning Php

starting from the connection.

 mysql_connect(“namaserver”,”username”,”password”);
mysql_select_db(“namadatabase”);

Mysql login process

include(“koneksi.php”);
$username=$_POST[username];
$password=$_POST[password];
$md5=md5($password);
$sql=”select * from anggota where username=’$username’ and password=’$md5′ and aktivasi=’1′”;
$query=mysql_query($sql);
$jml=mysql_num_rows($query);
if($jml!=0){
session_start();
$_SESSION[username]=$username;
$_SESSION[password]=$password;
echo “window.location=’index.php’”;}
else {
echo “window.location=’index.php?link=login_gagal.php’”;}


Mysql register

include(“koneksi.php”);
$nama=$_POST[nama];
$alamat=$_POST[alamat];
$gender=$_POST[gender];
$username=$_POST[username];
$password=$_POST[password];
$md5=md5($password);
$email=$_POST[email];
$foto=$_FILES[foto];
$tanggal=$_POST[tanggal];
$bulan=$_POST[bulan];
$tahun=$_POST[tahun];
$fotoname=$foto['name'];
$folder=’images/’;
$filetujuan=$folder.$foto['name'];
move_uploaded_file($foto['tmp_name'],$filetujuan);
$sql=”insert into anggota(nama,alamat,gender,username,password,email,foto,tanggal,bulan,tahun,aktivasi)values(‘$nama’,'$alamat’,'$gender’,'$username’,'$md5′,’$email’,'$fotoname’,'$tanggal’,'$bulan’,'$tahun’,'1′)”;
$query=mysql_query($sql);
echo “window.location=’index.php?link=daftar_berhasil.php’”;

 Mysql search

include(“koneksi.php”);
$cari=$_POST[cari];
$sql=”select * from detail where uraian like ‘%$cari%’”;
$query=mysql_query($sql);
echo “ Hasil pencarian dari kata ‘$cari’
“;
while($row=mysql_fetch_row($query)){
include “hasil.php”;
}