as salam otai2..
sy ada pertanyaan tentang coding php..
sy ada develop satu database phpmysql untuk portal..pengguna daftar dekat form and bile data tu dah submit secara automatik ianya telah masuk ke dalam database..
Yang menjadi masalah nye kenape bile nk daftar untuk pengguna baru, field utk daftar tu die recall balik data yang ada dekat database..kenapa form tu die tk kosong "blank form" tekan reset button pon sama jugak..form tu dah brfunction utk recall data tu balik dari database..ada sapa yg terer pasal php programming la tlg jelaskan pada sy..a.s.a.p
coding spt dibawah:
<?php require_once('Connections/pendaftaran.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
**
return $theValue;
**
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
**
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO profil (nama, ic, kursus, jantina, umur, alamat, status) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['nama'], "text"),
GetSQLValueString($_POST['ic'], "text"),
GetSQLValueString($_POST['kursus'], "text"),
GetSQLValueString($_POST['jantina'], "text"),
GetSQLValueString($_POST['umur'], "text"),
GetSQLValueString($_POST['alamat'], "text"),
GetSQLValueString($_POST['status'], "text"));
mysql_select_db($database_pendaftaran, $pendaftaran);
$Result1 = mysql_query($insertSQL, $pendaftaran) or die(mysql_error());
$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
**
header(sprintf("Location: %s", $insertGoTo));
**
mysql_select_db($database_pendaftaran, $pendaftaran);
$query_rsdaftar = "SELECT profil.id_profil, profil.nama, profil.ic, profil.no_matriks, profil.kursus, profil.jantina, profil.umur, profil.email, profil.no_tel, profil.no_telefon, profil.alamat, profil.status FROM profil";
$rsdaftar = mysql_query($query_rsdaftar, $pendaftaran) or die(mysql_error());
$row_rsdaftar = mysql_fetch_assoc($rsdaftar);
$totalRows_rsdaftar = mysql_num_rows($rsdaftar);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>pendaftaran pelajar</title>
</head>
<body>
<p align="center">Pendaftaran Pelajar</p>
<form action="<?php echo $editFormAction; ?>" id="form1" name="form1" method="POST">
<p align="center">Maklumat Pelajar : </p>
<table width="760" border="1" align="center">
<tr>
<td width="147">Nama : </td>
<td width="597"><label>
<input name="nama" type="text" id="nama" value="<?php echo $row_rsdaftar['nama']; ?>" size="50" />
</label></td>
</tr>
<tr>
<td>No kad pengenalan : </td>
<td><label>
<input name="ic" type="text" id="ic" value="<?php echo $row_rsdaftar['ic']; ?>" size="30" />
eg :890328015183 </label></td>
</tr>
<tr>
<td>No kad matriks : </td>
<td><label>
<input name="matriks" type="text" id="matriks" value="<?php echo $row_rsdaftar['no_matriks']; ?>" />
</label></td>
</tr>
<tr>
<td>Kursus : </td>
<td><label>
<select name="kursus" size="1" id="kursus" title="<?php echo $row_rsdaftar['kursus']; ?>">
<option>IT</option>
<option>KM</option>
<option>KA</option>
<option>KE</option>
</select>
</label></td>
</tr>
<tr>
<td>Jantina : </td>
<td><label>
<select name="jantina" id="jantina" title="<?php echo $row_rsdaftar['jantina']; ?>">
<option>LELAKI</option>
<option>PEREMPUAN</option>
</select>
</label></td>
</tr>
<tr>
<td>Umur : </td>
<td><label>
<input name="umur" type="text" id="umur" value="<?php echo $row_rsdaftar['umur']; ?>" />
</label></td>
</tr>
<tr>
<td>Email : </td>
<td><label>
<input name="emai" type="text" id="emai" value="<?php echo $row_rsdaftar['email']; ?>" size="40" />
</label></td>
</tr>
<tr>
<td>No telefon (H) : </td>
<td><label>
<select name="notel" id="notel" title="<?php echo $row_rsdaftar['no_tel']; ?>">
<option>010</option>
<option>012</option>
<option>013</option>
<option>014</option>
<option>016</option>
<option>017</option>
<option>018</option>
<option>019</option>
</select>
<input name="notelefon" type="text" id="notelefon" value="<?php echo $row_rsdaftar['no_telefon']; ?>" />
</label></td>
</tr>
<tr>
<td>Alamat : </td>
<td><label>
<textarea name="alamat" cols="30" rows="3" id="alamat"><?php echo $row_rsdaftar['alamat']; ?></textarea>
</label></td>
</tr>
<tr>
<td>0Status : </td>
<td><label>
<select name="status" id="status" title="<?php echo $row_rsdaftar['status']; ?>">
<option>BUJANG</option>
<option>BERKAHWIN</option>
</select>
</label></td>
</tr>
</table>
<p align="center">Maklumat Sistem :</p>
<table width="758" border="1" align="center">
<tr>
<td width="157">ID pengguna : </td>
<td width="585"><label>
<input name="textfield7" type="text" />
</label></td>
</tr>
<tr>
<td height="25">Kata laluan : </td>
<td><label>
<input name="textfield8" type="password" />
</label></td>
</tr>
<tr>
<td>Confirm kata laluan : </td>
<td><label>
<input name="textfield9" type="password" />
</label></td>
</tr>
</table>
<p align="center">
<label>
<input type="submit" name="Submit" value="Submit" />
</label>
<label>
<input name="reset" type="reset" id="reset" value="Reset " />
</label>
</p>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p align="center"> </p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($rsdaftar);
?>
sapa otai PHP programer kat sini..mintak tolong..plz
. page kosong tu sekadar controller je untuk bro letakkan sql insert code 
