Salam,
Saya nak tanya... saya buat sistem menggunakan xampp.. saya dah siapkan form utk customer keyin data menggunakan dreamweaver(seperti dalam gambar), dah wat database mysql dan sekarang masalah nak connect ke database... xmasuk pon dlm database... ni coding config :
<?php
$username="";
$password="";
$database="kemasukan";
$server="localhost";
echo "connected";
?>ni coding proses mohon :
<HTML>
<HEAD>
<TITLE>New Document</TITLE>
</HEAD>
<BODY>
<?
include ("config.php");
//mysql_connect($server,$username,$password);
//mysql_select_db($database) or die("Unable to select database");
$h=$_POST['hantar'];
if ($h) {
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14'];
echo "$pilihan1,$pilihan2,$pilihan3,$nama,$alamat,$poskod,$negeri,$telrumah,$hp,$email,$ic,$spm,$percubaanspm,$bm,$bi,$math,$addmath,$sejarah,$pi,$pm,$sains,$fizik,$kimia,$subjek11,$result11,$subjek12,$result12,$subjek13,$result13,$subjek14,$result14";
$q="Insert into dbmohon values ('','$pilihan1','$pilihan2','$pilihan3','$nama','$alamat','$poskod','$negeri','$telrumah','$hp','$email','$ic','$spm','$percubaanspm','$bm','$bi','$math','$addmath','$sejarah','$pi','$pm','$sains','$fizik','$kimia','$subjek11','$result11','$subjek12','$result12','$subjek13','$result13','$subjek14','$result14')";
mysql_query($q);
echo"<meta http-equiv=\"refresh\"content=\"0; url=papar.php\" a target=\"_self\">";
}
?>
</BODY>
ni coding papar :
<HTML>
<HEAD>
<TITLE>New Document</TITLE>
</HEAD>
<BODY>
<?
include ("config.php");
//mysql_connect($server,$username,$password);
//mysql_select_db($database) or die("Unable to select database");
$h=$_POST['hantar'];
if ($h) {
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14'];
echo "$pilihan1,$pilihan2,$pilihan3,$nama,$alamat,$poskod,$negeri,$telrumah,$hp,$email,$ic,$spm,$percubaanspm,$bm,$bi,$math,$addmath,$sejarah,$pi,$pm,$sains,$fizik,$kimia,$subjek11,$result11,$subjek12,$result12,$subjek13,$result13,$subjek14,$result14";
$q="Insert into dbmohon values ('','$pilihan1','$pilihan2','$pilihan3','$nama','$alamat','$poskod','$negeri','$telrumah','$hp','$email','$ic','$spm','$percubaanspm','$bm','$bi','$math','$addmath','$sejarah','$pi','$pm','$sains','$fizik','$kimia','$subjek11','$result11','$subjek12','$result12','$subjek13','$result13','$subjek14','$result14')";
mysql_query($q);
echo"<meta http-equiv=\"refresh\"content=\"0; url=papar.php\" a target=\"_self\">";
}
?>
</BODY>
kalo click button kat index tu, dia tulis connected... tp xleh masuk database .
connected
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\xampp\mohon\papar.php on line 14
dah ko echo connected. memang ah sampai kiamat pun connected.
first of all kenapa ko comment kan
//mysql_connect($server,$username,$password);
//mysql_select_db($database) or die("Unable to select database");so tiada connection berlaku ke database.
patut ponnn... thanks sgt3x... pastu nak tanya... camna nak publish xampp ni supaya suma org leh access form tu? sblm ini wat guna intranet jer.. org dalaman jer leh baca... sorila... blaja sendiri... byk sgt xtau....
kalau nak daripada network luar boleh access sistem, uploadlah kedalam hosting..
upload dalam hosting tu camner? maaf yer....
Salam,
1) beli domain
2) sewa hosting
3) setup database dalam hosting
4) upload files ke dalam hosting (FTP)
5) distribute URL kepada masyarakat
ko tak payah beli dulu pun xpe..
pegi google type "free php cpanel hosting"
register lepas tu boleh test coding php & mysql ko..
tapi benda asas ni pun ko tak tahu mmg payah ler.. sila explore lebih lagi 
ok dh leh setle pasal dns tu... then cmna nak wat borang yang terpapar tu bleh di print? ada coding utk print x?
Emm....nk print ada beberapa cara yg selalu digunakan...
1. Buat page html yg baru....(means kena query balik semua or guna session)
2. Buat guna pdf(yg ni kena study skit) tp better than yang html...
buat page html baru, then apa coding untuk print tu? ada x?
Kena guna javascript....
Contoh....
<script type="text/javascript" charset="utf-8">
function cetak()
{
window.print();
}
</script>
html...
- dekat button tu tmbah onClick="javascript:cetak()"
ok thanks...
ok thanks...
kalo session ni... camna nak buat if dia print dulu then baru dia g kat index.php? login tu xnak...
<?
session_start();
//if(!session_is_registered(“login”))
{
session_destroy();
header(“Location:index.php”);
echo"<meta http-equiv=\"refresh\" content=\"1;URL=index.php\" a target = \"_self\"> ";
}
?>
Nk print current page then redirect ke index.php ke?
x de kena mengena ngan login tu.. agak agak aku kat properties form yang mana button tu..
a'a... bila pengguna isi form, dia akan paparkan semula data yang telah diisi then boleh print data tersebut dan terus ke index.php semula...
coding paparan :
<?php
//include("cek_session.php");
?>
<html>
<style type="text/css">
<!--
.style2 {font-weight: bold; font-size: 12px;}
.style3 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.style4 {font-size: 14px}
.style5 {
color: #FFFFFF;
font-weight: bold;
font-size: 14px;
}
.style6 {
font-size: 9px;
color: #0000FF;
}
.style10 {color: #000000}
-->
</style>
<? include ("config.php");
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14']; ?>
<center>
<table WIDTH="100%" HEIGHT="100%">
<tr>
<td align="center" valign="middle">
<form action="prosesmohon.php" method="POST" ">
<table class="sort-table">
<thead>
<tr>
<td colspan="7"><p align="center"><img src="gambar/jtm.gif" alt="logo" width="110" height="89"></p>
</tr>
</thead>
<tbody>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">A. PILIHAN KURSUS </span></td>
</tr>
<tr>
<td colspan="2">Pilihan 1 </td>
<td width="10">:</td>
<td colspan="4"><label><?php echo "$pilihan1"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 2 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan2"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 3 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan3"; ?></label></td>
</tr>
<tr>
<td colspan="3"> </td>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">B. BUTIR-BUTIR PERIBADI </span></td>
</tr>
<tr>
<td colspan="2"><p>Nama</p> </td>
<td><div align="center">:</div></td>
<td colspan="4" rowspan="2"><p><?php echo "$nama"; ?> </p>
<p class="style6"> </p></td>
</tr>
<tr>
<td height="21" colspan="2" class="style6">(Mengikut Kad Pengenalan) </td>
<td><div align="center"></div></td>
</tr>
<tr>
<td height="12" colspan="2"><p>Alamat Surat Menyurat </p> </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$alamat"; ?></label></td>
</tr>
<tr>
<td colspan="2"><div align="left">Poskod</div></td>
<td><div align="center">:</div></td>
<td><?php echo "$poskod"; ?> </td>
<td width="51">Negeri</td>
<td width="6"><div align="center">:</div></td>
<td width="216"><label><?php echo "$negeri"; ?></label></td>
</tr>
<tr>
<td colspan="2">Tel. Rumah </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telrumah"; ?></label></td>
<td>Tel. HP </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telhp"; ?></label></td>
</tr>
<tr>
<td colspan="2">Alamat E-mail </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$email"; ?></label></td>
</tr>
<tr>
<td colspan="2">No Kad Pengenalan </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$noic"; ?></label></td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">C. KELAYAKAN </span></td>
</tr>
<tr>
<td colspan="3">Keputusan SPM </td>
<td><label>:
<?php echo "$spm"; ?>
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3">Keputusan Percubaan SPM 2011 </td>
<td colspan="4"><label>:<?php echo "$percubaan"; ?> <span class="style6">(Sila Tanda Bagi Yang Berkenaan)</span> </label></td>
</tr>
<tr>
<td colspan="7" class="style6"> </td>
</tr>
<tr>
<td width="36" bgcolor="#999999"><div align="center" class="style10">Bil</div></td>
<td colspan="2" bgcolor="#999999"><div align="center" class="style10">Subjek</div> <div align="center" class="style10"></div></td>
<td bgcolor="#999999"><div align="center"><span class="style10">Keputusan</span></div></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">1</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Melayu </td>
<td bgcolor="#FFFFCC"><label><?php echo "$bm"; ?></label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">2</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Inggeris </td>
<td bgcolor="#FFFFCC"><?php echo "$bi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">3</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik</td>
<td bgcolor="#FFFFCC"><?php echo "$math"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">4</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik Tambahan </td>
<td bgcolor="#FFFFCC"><?php echo "$addmath"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">5</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sejarah</td>
<td bgcolor="#FFFFCC"><?php echo "$sejarah"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">6</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Islam </td>
<td bgcolor="#FFFFCC"><?php echo "$pi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">7</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Moral </td>
<td bgcolor="#FFFFCC"><?php echo "$pm"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">8</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sains</td>
<td bgcolor="#FFFFCC"><?php echo "$sains"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">9</div></td>
<td colspan="2" bgcolor="#FFFFCC">Fizik</td>
<td bgcolor="#FFFFCC"><?php echo "$fizik"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">10</div></td>
<td colspan="2" bgcolor="#FFFFCC">Kimia</td>
<td bgcolor="#FFFFCC"><?php echo "$kimia"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">11</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek11"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result11"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">12</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek12"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result12"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">13</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek13"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result13"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">14</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek14"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result14"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td width="150" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7"><?php
$timezone = "Asia/Kuala_Lumpur";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
echo date('j M Y, l, H:i:s');
?> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td><div align="center"></div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" align="center">
<input class="sort-table" type="submit" value="Print" name="print" style="border-style: outset; border-width: 2; padding: 0; background-color: #C0C0C0"></td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</center>
//<SCRIPT LANGUAGE="JavaScript">
//<!--
//document.forms[0].entered_login.select();
//document.forms[0].entered_login.focus();
//-->
</SCRIPT>
</body>
</html>
a'a... bila pengguna isi form, dia akan paparkan semula data yang telah diisi then boleh print data tersebut dan terus ke index.php semula...
coding paparan :
<?php
include("cek_session.php");
?>
<html>
<style type="text/css">
<!--
.style2 {font-weight: bold; font-size: 12px;}
.style3 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.style4 {font-size: 14px}
.style5 {
color: #FFFFFF;
font-weight: bold;
font-size: 14px;
}
.style6 {
font-size: 9px;
color: #0000FF;
}
.style10 {color: #000000}
-->
</style>
<? include ("config.php");
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14']; ?>
<center>
<table WIDTH="100%" HEIGHT="100%">
<tr>
<td align="center" valign="middle">
<form action="prosesmohon.php" method="POST" ">
<table class="sort-table">
<thead>
<tr>
<td colspan="7"><p align="center"><img src="gambar/jtm.gif" alt="logo" width="110" height="89"></p>
</tr>
</thead>
<tbody>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">A. PILIHAN KURSUS </span></td>
</tr>
<tr>
<td colspan="2">Pilihan 1 </td>
<td width="10">:</td>
<td colspan="4"><label><?php echo "$pilihan1"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 2 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan2"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 3 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan3"; ?></label></td>
</tr>
<tr>
<td colspan="3"> </td>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">B. BUTIR-BUTIR PERIBADI </span></td>
</tr>
<tr>
<td colspan="2"><p>Nama</p> </td>
<td><div align="center">:</div></td>
<td colspan="4" rowspan="2"><p><?php echo "$nama"; ?> </p>
<p class="style6"> </p></td>
</tr>
<tr>
<td height="21" colspan="2" class="style6">(Mengikut Kad Pengenalan) </td>
<td><div align="center"></div></td>
</tr>
<tr>
<td height="12" colspan="2"><p>Alamat Surat Menyurat </p> </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$alamat"; ?></label></td>
</tr>
<tr>
<td colspan="2"><div align="left">Poskod</div></td>
<td><div align="center">:</div></td>
<td><?php echo "$poskod"; ?> </td>
<td width="51">Negeri</td>
<td width="6"><div align="center">:</div></td>
<td width="216"><label><?php echo "$negeri"; ?></label></td>
</tr>
<tr>
<td colspan="2">Tel. Rumah </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telrumah"; ?></label></td>
<td>Tel. HP </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telhp"; ?></label></td>
</tr>
<tr>
<td colspan="2">Alamat E-mail </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$email"; ?></label></td>
</tr>
<tr>
<td colspan="2">No Kad Pengenalan </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$noic"; ?></label></td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">C. KELAYAKAN </span></td>
</tr>
<tr>
<td colspan="3">Keputusan SPM </td>
<td><label>:
<?php echo "$spm"; ?>
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3">Keputusan Percubaan SPM 2011 </td>
<td colspan="4"><label>:<?php echo "$percubaan"; ?> <span class="style6">(Sila Tanda Bagi Yang Berkenaan)</span> </label></td>
</tr>
<tr>
<td colspan="7" class="style6"> </td>
</tr>
<tr>
<td width="36" bgcolor="#999999"><div align="center" class="style10">Bil</div></td>
<td colspan="2" bgcolor="#999999"><div align="center" class="style10">Subjek</div> <div align="center" class="style10"></div></td>
<td bgcolor="#999999"><div align="center"><span class="style10">Keputusan</span></div></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">1</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Melayu </td>
<td bgcolor="#FFFFCC"><label><?php echo "$bm"; ?></label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">2</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Inggeris </td>
<td bgcolor="#FFFFCC"><?php echo "$bi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">3</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik</td>
<td bgcolor="#FFFFCC"><?php echo "$math"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">4</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik Tambahan </td>
<td bgcolor="#FFFFCC"><?php echo "$addmath"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">5</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sejarah</td>
<td bgcolor="#FFFFCC"><?php echo "$sejarah"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">6</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Islam </td>
<td bgcolor="#FFFFCC"><?php echo "$pi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">7</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Moral </td>
<td bgcolor="#FFFFCC"><?php echo "$pm"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">8</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sains</td>
<td bgcolor="#FFFFCC"><?php echo "$sains"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">9</div></td>
<td colspan="2" bgcolor="#FFFFCC">Fizik</td>
<td bgcolor="#FFFFCC"><?php echo "$fizik"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">10</div></td>
<td colspan="2" bgcolor="#FFFFCC">Kimia</td>
<td bgcolor="#FFFFCC"><?php echo "$kimia"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">11</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek11"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result11"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">12</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek12"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result12"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">13</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek13"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result13"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">14</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek14"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result14"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td width="150" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7"><?php
$timezone = "Asia/Kuala_Lumpur";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
echo date('j M Y, l, H:i:s');
?> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td><div align="center"></div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" align="center">
<input class="sort-table" type="submit" value="Print" name="print" style="border-style: outset; border-width: 2; padding: 0; background-color: #C0C0C0"></td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</center>
//<SCRIPT LANGUAGE="JavaScript">
//<!--
//document.forms[0].entered_login.select();
//document.forms[0].entered_login.focus();
//-->
</SCRIPT>
</body>
</html>
paparan tu xkeluarla... cmna nak wat supaya paparan tu boleh keluar....
paparan tu xkeluarla... cmna nak wat supaya paparan tu boleh keluar.... betul xkoding kat atas tu?
benda ni masuk database x?
databse masuk... tp page tu jer xkeluar... jadi org xbleh print... cmne ye... minta tolong sgt....
server dah up? nampak cam okay je code tu.. nama dkt textbox sume sama?
xampp dah up... nama pun sama ngan index dan paparan tu... ke sbb panggilan database tu salah? ermmm pening ni... patutnya dah upkan kat website...
bleh mail page yg ada textbox dengan page ni x? saya junior lagi tapi maybe boleh check..
Mmg tk kluar la...sebab u nak retrieve data from dbase...bukan nk POST data...
$pilihan1=$_POST['pilihan1']; -> yg ni utk POST value masuk dbase....
Maksud saya, after user key in or POST data masuk dbase, awak kena query balik utk paparkan data tu...
ye ke nojhere? aku test kalau x de query pun boleh kuar.. database pun x dok masa aku test.. so dia just bawak info drpd page sebelum tu masuk the next one kan?
<?php
$no=$_POST['textfield'];
?>
<html>
<body>
<table width="213" border="1">
<tr>
<td width="168">nombor ayam</td>
<td width="29"><?php echo $no ; ?></td>
</tr>
</table>
</body>
</html>
hafzan, yang post tu datang dari mana? database or page input sebelumnya?
sql kata apa?
anda pasti ker nama $_POST[...] yang anda guna ada wujud???
sql xde masalah... saya key in and submit boleh jer masuk database... cuma page paparan.php tu xdapat nak papar data dari databse... ke dia confius samada nak ambil dari index.php or databse... ermm ker ada satu coding yang tertinggal? ni page index :
<html>
<style type="text/css">
<!--
.style2 {font-weight: bold; font-size: 12px;}
.style3 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.style4 {font-size: 14px}
.style5 {
color: #FFFFFF;
font-weight: bold;
font-size: 14px;
}
.style6 {
font-size: 9px;
color: #0000FF;
}
.style10 {color: #000000}
-->
</style>
<center>
<table WIDTH="100%" HEIGHT="100%">
<tr>
<td align="center" valign="middle">
<form action="prosesmohon.php" method="POST" ">
<table class="sort-table">
<thead>
</thead>
<tbody>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">A. PILIHAN KURSUS </span></td>
</tr>
<tr>
<td colspan="2">Pilihan 1 </td>
<td width="10">:</td>
<td colspan="4"><label>
<select name="pilihan1" id="pilihan1">
<option selected>-Sila Pilih-</option>
<option>Diploma Teknologi Pembuatan (Perkakasan)</option>
<option>Diploma Teknologi Pembuatan (Pemesinan)</option>
<option>Diploma Teknologi Mekatronik</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="2">Pilihan 2 </td>
<td>:</td>
<td colspan="4"><label>
<select name="pilihan2" id="pilihan2">
<option selected>-Sila Pilih-</option>
<option>Diploma Teknologi Pembuatan (Perkakasan)</option>
<option>Diploma Teknologi Pembuatan (Pemesinan)</option>
<option>Diploma Teknologi Mekatronik</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="2">Pilihan 3 </td>
<td>:</td>
<td colspan="4"><label>
<select name="pilihan3" id="pilihan3">
<option selected>-Sila Pilih-</option>
<option>Diploma Teknologi Pembuatan (Perkakasan)</option>
<option>Diploma Teknologi Pembuatan (Pemesinan)</option>
<option>Diploma Teknologi Mekatronik</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="3"> </td>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">B. BUTIR-BUTIR PERIBADI </span></td>
</tr>
<tr>
<td colspan="2"><p>Nama</p> </td>
<td><div align="center">:</div></td>
<td colspan="4" rowspan="2"><p>
<input name="nama" type="text" class="sort-table" id="nama" value="" size="48" maxlength="20">
</p>
<p class="style6"> </p></td>
</tr>
<tr>
<td height="21" colspan="2" class="style6">(Mengikut Kad Pengenalan) </td>
<td><div align="center"></div></td>
</tr>
<tr>
<td height="12" colspan="2"><p>Alamat Surat Menyurat </p> </td>
<td><div align="center">:</div></td>
<td colspan="4"><label>
<textarea name="alamat" cols="45" rows="5" id="alamat"></textarea>
</label></td>
</tr>
<tr>
<td colspan="2"><div align="left">Poskod</div></td>
<td><div align="center">:</div></td>
<td><input name="poskod" type="text" class="sort-table" id="poskod" size="14" maxlength="5"></td>
<td width="51">Negeri</td>
<td width="6"><div align="center">:</div></td>
<td width="216"><label>
<select name="negeri" id="negeri">
<option selected>-Sila Pilih-</option>
<option>Johor</option>
<option>Selangor</option>
<option>Melaka</option>
<option>Negeri Sembilan</option>
<option>Kuala Lumpur</option>
<option>Pahang</option>
<option>Terengganu</option>
<option>Kelantan</option>
<option>Perlis</option>
<option>Perak</option>
<option>Kedah</option>
<option>Pulau Pinang</option>
<option>Sabah</option>
<option>Sarawak</option>
<option>Labuan</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="2">Tel. Rumah </td>
<td><div align="center">:</div></td>
<td><label>
<input name="telrumah" type="text" id="telrumah" size="14" maxlength="10">
</label></td>
<td>Tel. HP </td>
<td><div align="center">:</div></td>
<td><label>
<input name="telhp" type="text" id="telhp" size="20" maxlength="10">
</label></td>
</tr>
<tr>
<td colspan="2">Alamat E-mail </td>
<td><div align="center">:</div></td>
<td colspan="4"><label>
<input name="email" type="text" id="email" size="45">
</label></td>
</tr>
<tr>
<td colspan="2">No Kad Pengenalan </td>
<td><div align="center">:</div></td>
<td colspan="4"><label>
<input name="noic" type="text" id="noic" size="25" maxlength="12">
</label></td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">C. KELAYAKAN </span></td>
</tr>
<tr>
<td colspan="3">Keputusan SPM </td>
<td><label>:
<input name="spm" type="checkbox" id="spm" value="checkbox">
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3">Keputusan Percubaan SPM 2011 </td>
<td colspan="4"><label>:
<input name="percubaan" type="checkbox" id="percubaan" value="checkbox">
<span class="style6">(Sila Tanda Bagi Yang Berkenaan)</span> </label></td>
</tr>
<tr>
<td colspan="7" class="style6"> </td>
</tr>
<tr>
<td width="36" bgcolor="#999999"><div align="center" class="style10">Bil</div></td>
<td colspan="2" bgcolor="#999999"><div align="center" class="style10">Subjek</div> <div align="center" class="style10"></div></td>
<td bgcolor="#999999"><div align="center"><span class="style10">Keputusan</span></div></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">1</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Melayu </td>
<td bgcolor="#FFFFCC"><label>
<input name="bm" type="text" id="bm">
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">2</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Inggeris </td>
<td bgcolor="#FFFFCC"><input name="bi" type="text" id="bi"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">3</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik</td>
<td bgcolor="#FFFFCC"><input name="math" type="text" id="math"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">4</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik Tambahan </td>
<td bgcolor="#FFFFCC"><input name="addmath" type="text" id="addmath"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">5</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sejarah</td>
<td bgcolor="#FFFFCC"><input name="sejarah" type="text" id="sejarah"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">6</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Islam </td>
<td bgcolor="#FFFFCC"><input name="pi" type="text" id="pi"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">7</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Moral </td>
<td bgcolor="#FFFFCC"><input name="pm" type="text" id="pm"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">8</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sains</td>
<td bgcolor="#FFFFCC"><input name="sains" type="text" id="sains"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">9</div></td>
<td colspan="2" bgcolor="#FFFFCC">Fizik</td>
<td bgcolor="#FFFFCC"><input name="fizik" type="text" id="fizik"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">10</div></td>
<td colspan="2" bgcolor="#FFFFCC">Kimia</td>
<td bgcolor="#FFFFCC"><input name="kimia" type="text" id="kimia"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">11</div></td>
<td colspan="2" bgcolor="#FFFFCC"><input name="subjek11" type="text" id="subjek11"></td>
<td bgcolor="#FFFFCC"><input name="result11" type="text" id="result11"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">12</div></td>
<td colspan="2" bgcolor="#FFFFCC"><input name="subjek12" type="text" id="subjek12"></td>
<td bgcolor="#FFFFCC"><input name="result12" type="text" id="result12"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">13</div></td>
<td colspan="2" bgcolor="#FFFFCC"><input name="subjek13" type="text" id="subjek13"></td>
<td bgcolor="#FFFFCC"><input name="result13" type="text" id="result13"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">14</div></td>
<td colspan="2" bgcolor="#FFFFCC"><input name="subjek14" type="text" id="subjek14"></td>
<td bgcolor="#FFFFCC"><input name="result14" type="text" id="result14"></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td width="150" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td><div align="center"></div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" align="center">
<input class="sort-table" type="submit" value="Hantar" name="hantar" style="border-style: outset; border-width: 2; padding: 0; background-color: #C0C0C0"></td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</center>
<SCRIPT LANGUAGE="JavaScript">
<!--
document.forms[0].entered_login.select();
document.forms[0].entered_login.focus();
//-->
</SCRIPT>
</body>
</html>yang ni page proses mohon :
<HTML>
<HEAD>
<TITLE>New Document</TITLE>
</HEAD>
<BODY>
<?
include ("config.php");
mysql_connect($server,$username,$password);
mysql_select_db($database) or die("Unable to select database");
$h=$_POST['hantar'];
if ($h) {
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14'];
echo "$pilihan1,$pilihan2,$pilihan3,$nama,$alamat,$poskod,$negeri,$telrumah,$hp,$email,$ic,$spm,$percubaanspm,$bm,$bi,$math,$addmath,$sejarah,$pi,$pm,$sains,$fizik,$kimia,$subjek11,$result11,$subjek12,$result12,$subjek13,$result13,$subjek14,$result14";
$q="Insert into dbmohon values ('','$pilihan1','$pilihan2','$pilihan3','$nama','$alamat','$poskod','$negeri','$telrumah','$hp','$email','$ic','$spm','$percubaanspm','$bm','$bi','$math','$addmath','$sejarah','$pi','$pm','$sains','$fizik','$kimia','$subjek11','$result11','$subjek12','$result12','$subjek13','$result13','$subjek14','$result14')";
mysql_query($q);
echo"<meta http-equiv=\"refresh\"content=\"0; url=paparan.php\" a target=\"_self\">";
}
?>
</BODY>yang ni page paparan :
<html>
<style type="text/css">
<!--
.style2 {font-weight: bold; font-size: 12px;}
.style3 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.style4 {font-size: 14px}
.style5 {
color: #FFFFFF;
font-weight: bold;
font-size: 14px;
}
.style6 {
font-size: 9px;
color: #0000FF;
}
.style10 {color: #000000}
-->
</style>
<? include ("config.php");
mysql_connect($server,$username,$password);
mysql_select_db($database) or die("Unable to select database");
"Select * from dbmohon ";
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14']; ?>
<center>
<table WIDTH="100%" HEIGHT="100%">
<tr>
<td align="center" valign="middle">
<form action="index.php" method="POST" ">
<table class="sort-table">
<thead>
</thead>
<tbody>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">A. PILIHAN KURSUS </span></td>
</tr>
<tr>
<td colspan="2">Pilihan 1 </td>
<td width="10">:</td>
<td colspan="4"><label><?php echo "$pilihan1"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 2 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan2"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 3 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan3"; ?></label></td>
</tr>
<tr>
<td colspan="3"> </td>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">B. BUTIR-BUTIR PERIBADI </span></td>
</tr>
<tr>
<td colspan="2"><p>Nama</p> </td>
<td><div align="center">:</div></td>
<td colspan="4" rowspan="2"><p><?php echo "$nama"; ?> </p>
<p class="style6"> </p></td>
</tr>
<tr>
<td height="21" colspan="2" class="style6">(Mengikut Kad Pengenalan) </td>
<td><div align="center"></div></td>
</tr>
<tr>
<td height="12" colspan="2"><p>Alamat Surat Menyurat </p> </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$alamat"; ?></label></td>
</tr>
<tr>
<td colspan="2"><div align="left">Poskod</div></td>
<td><div align="center">:</div></td>
<td><?php echo "$poskod"; ?> </td>
<td width="51">Negeri</td>
<td width="6"><div align="center">:</div></td>
<td width="216"><label><?php echo "$negeri"; ?></label></td>
</tr>
<tr>
<td colspan="2">Tel. Rumah </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telrumah"; ?></label></td>
<td>Tel. HP </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telhp"; ?></label></td>
</tr>
<tr>
<td colspan="2">Alamat E-mail </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$email"; ?></label></td>
</tr>
<tr>
<td colspan="2">No Kad Pengenalan </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$noic"; ?></label></td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">C. KELAYAKAN </span></td>
</tr>
<tr>
<td colspan="3">Keputusan SPM </td>
<td><label>:
<?php echo "$spm"; ?>
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3">Keputusan Percubaan SPM 2011 </td>
<td colspan="4"><label>:<?php echo "$percubaan"; ?> <span class="style6">(Sila Tanda Bagi Yang Berkenaan)</span> </label></td>
</tr>
<tr>
<td colspan="7" class="style6"> </td>
</tr>
<tr>
<td width="36" bgcolor="#999999"><div align="center" class="style10">Bil</div></td>
<td colspan="2" bgcolor="#999999"><div align="center" class="style10">Subjek</div> <div align="center" class="style10"></div></td>
<td bgcolor="#999999"><div align="center"><span class="style10">Keputusan</span></div></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">1</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Melayu </td>
<td bgcolor="#FFFFCC"><label><?php echo "$bm"; ?></label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">2</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Inggeris </td>
<td bgcolor="#FFFFCC"><?php echo "$bi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">3</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik</td>
<td bgcolor="#FFFFCC"><?php echo "$math"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">4</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik Tambahan </td>
<td bgcolor="#FFFFCC"><?php echo "$addmath"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">5</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sejarah</td>
<td bgcolor="#FFFFCC"><?php echo "$sejarah"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">6</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Islam </td>
<td bgcolor="#FFFFCC"><?php echo "$pi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">7</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Moral </td>
<td bgcolor="#FFFFCC"><?php echo "$pm"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">8</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sains</td>
<td bgcolor="#FFFFCC"><?php echo "$sains"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">9</div></td>
<td colspan="2" bgcolor="#FFFFCC">Fizik</td>
<td bgcolor="#FFFFCC"><?php echo "$fizik"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">10</div></td>
<td colspan="2" bgcolor="#FFFFCC">Kimia</td>
<td bgcolor="#FFFFCC"><?php echo "$kimia"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">11</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek11"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result11"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">12</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek12"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result12"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">13</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek13"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result13"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">14</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek14"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result14"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td width="150" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7"><?php
$timezone = "Asia/Kuala_Lumpur";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
echo date('j M Y, l, H:i:s');
?> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td><div align="center"></div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" align="center">
<input class="sort-table" type="submit" value="Print" name="print" style="border-style: outset; border-width: 2; padding: 0; background-color: #C0C0C0" onClick="javascript:cetak()"></td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</center>
<script type="text/javascript" charset="utf-8">
function cetak()
{
window.print();
}
</script>
</body>
</html>
"Select * from dbmohon ";untuk coding SQL ni.. camna nak wat supaya dia baca untuk id database(row) yang last sekali jer....
maksudnya select * from dbmohon WHERE id = bacaan last sekali...... camna nak wat yer? sbb saya rasa cam salahla sql kat paparan.php ni....
ada 2 cara..
1. buat 1 query lain: SELECT MAX(id) as id FROM dbmohon
2. buat order DESC: SELECT * FROM dbmohon ORDER BY id DESC LIMIT 1
yang 2 takperlu buat query lain..
jap.. ini input data ke fetch kat database? kalau paparan tu nak amek kat database.. try buat code ni as reference untuk kat paparan.php
<?php
$ISBN = $_GET['name']:
$result = mysql_query ("SELECT * FROM books1 WHERE ISBN = '$ISBN'")
or die (mysql_error());
$row =mysql_fetch_assoc ($result);
?>
<form id="form1" name="form1" method="post" action="edit2.php">
<p>ISBN :
<input name="txtISBN" type="text" id="txtISBN" value="<?php echo $ISBN ;?>" size="15" width="140"
onkeypress="return isNumberKey(event)" />
</p>
<p> </p>
<p>Title :
<label for="txtTitle2"></label>
<input name="txtTitle" type="text" id="txtTitle2" size="50" value="<?php echo $row['Title'] ;?>" />
</p>
ini prosesmohon.php yang aku godek
<?php
// semak dulu data $_POST, jangan percaya apa yang user hantar
echo '<pre>$_POST->', print_r($_POST) . '</pre>';
//include ("config.php");
$h=$_POST['hantar'];
if ($h=='Hantar')
{
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14'];
$q="Insert into dbmohon values
('','$pilihan1','$pilihan2','$pilihan3','$nama','$alamat','$poskod','$negeri','$telrumah','$hp','$email','$ic','$spm','$percubaanspm',
'$bm','$bi','$math','$addmath','$sejarah','$pi','$pm','$sains','$fizik','$kimia','$subjek11','$result11','$subjek12','$result12',
'$subjek13','$result13','$subjek14','$result14')";
// papar sql dulu sebelum masuk sql
echo '<pre>' . $q . '</pre>';
//mysql_query($q);
//header('Location:./paparan.php');
}
else
{
echo '<br>Ada masalah teknikal huhuhu';
}
?>output sepatutnya
$_POST->Array
(
[pilihan1] => Diploma Teknologi Mekatronik
[pilihan2] => Diploma Teknologi Pembuatan (Perkakasan)
[pilihan3] => Diploma Teknologi Pembuatan (Pemesinan)
[nama] => A
[alamat] => b
[poskod] => 84000
[negeri] => Johor
[telrumah] => 06
[telhp] => 012
[email] => a@b.c
[noic] => 123456789
[percubaan] => checkbox
[bm] => 1
[bi] => 2
[math] => 3
[addmath] => 4
[sejarah] => 5
[pi] => 6
[pm] => 7
[sains] => 8
[fizik] => 9
[kimia] => 10
[subjek11] =>
[result11] =>
[subjek12] =>
[result12] =>
[subjek13] =>
[result13] =>
[subjek14] =>
[result14] =>
[hantar] => Hantar
)
1
Insert into dbmohon values
('','Diploma Teknologi Mekatronik','Diploma Teknologi Pembuatan (Perkakasan)','Diploma Teknologi Pembuatan (Pemesinan)','A','b','84000','Johor','06','012','a@b.c','123456789','','checkbox',
'1','2','3','4','5','6','7','8','9','10','','','','',
'','','','')reka bentuk database kurang memuaskan.
tak praktikal untuk jangka masa panjang
sila rujuk buku database bab pernormalan...
untuk paparan.php
<?php
function papartajuk($fields,$result,$myTable)
{// function papartajuk() - mula
echo "\n" . '<tr>' . "\n" . '<td colspan=2>(Jadual:' . $myTable . ')</td>';
for ($f=1;$f < $fields;$f++)
{
echo '<td>' . mysql_field_name($result,$f) . '</td>' . "\n";
}
echo '</tr>';
}// function papartajuk() - tamat
function paparisi($myTable,$row,$result,$fields,$rows,$bil)
{// function paparisi() - mula
echo($bil%'2'=='0')?"\n<tr bgcolor='#ffffe0'>":"\n<tr bgcolor='#ffe4e1'>";
echo "\n<td>" . $bil . "</td>";
for($f=0;$f<$fields;$f++)
{
echo "\n<td>" . $row[$f] . "</td>";
}
echo "\n</tr>";
}// function paparisi() - tamat
function diehard4($bil,$sql)
{
$w0=' style="background-color: #fffaf0; color:black" ';
$w1='<span style="background-color: #fffaf0; color:black">';$w2='</span>';
echo $w1.mysql_error().$w2.'<hr><pre'.$w0.'>'.$bil."->\r".$sql.'</pre><hr>';
}
function bersih($papar)
{
# lepas lari aksara khas dalam SQL
//$papar = mysql_real_escape_string($papar);
# buang ruang kosong (atau aksara lain) dari mula & akhir
$papar = trim($papar);
return $papar;
}
$id=bersih($_GET['id']);
$_GET['id']=bersih($_GET['id']);
?>
<html>
<style type="text/css">
<!--
.style2 {font-weight: bold; font-size: 12px;}
.style3 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 10px;
}
.style4 {font-size: 14px}
.style5 {
color: #FFFFFF;
font-weight: bold;
font-size: 14px;
}
.style6 {
font-size: 9px;
color: #0000FF;
}
.style10 {color: #000000}
-->
</style>
<?php
include ("config.php");
$myJadual=array('dbmohon');
$medanSemak[]='*';
//------------------------------------------------------------------------------
foreach ($myJadual as $key => $myTable)
{// mula ulang table
$sql="\tSELECT ".$medanSemak[$key]." FROM
".$myTable."
WHERE id = '" . $id . "' ";
//echo $s1.$hr.$sql.$s2;
$result = mysql_query($sql) or diehard4($myTable,$sql);
//die($s1.mysql_error().$hr.$sql.$s2);
$fields = mysql_num_fields($result);
$baris = mysql_num_rows($result);
// nak papar bil. brg
if ($baris=='0' or $_GET['id']==null): echo "<br>".
'<span style="background-color: black; color:white">'.
"Maaflah, ".$_GET['cari']." tak jumpalah pada jadual :".$myTable."|
<font face=Wingdings size=5>L</font></span>";
elseif($baris=='1'): // kalau jumpa
echo '<table border=0 class="excel" bgcolor="#ffffff">';
papartajuk($fields,$result,$myTable);
//$bil=1;while($row = mysql_fetch_array($result,MYSQL_NUM))
$bil=1;while($row = mysql_fetch_array($result))
{// mula papar
paparisi($myTable,$row,$result,$fields,$rows,$bil);
$bil++;
}// tutup papar
echo "\n</table>\n";
else :
echo '<span style="background-color: black; color:red">'.
'banyak pulak datanya. pilih satu sahaja</span>'."\n".
'<table border=0 class="excel" bgcolor="#ffffff">';
papartajuk($fields,$result,$myTable);
$bil=1;while($row = mysql_fetch_array($result,MYSQL_NUM))
{
paparisi($myTable,$row,$result,$fields,$rows,$bil);
$bil++;
}
echo "\n</table>\n";
endif; //tamat jika jumpa
}// tamat ulang table
//------------------------------------------------------------------------------
/*
$pilihan1=$_POST['pilihan1'];
$pilihan2=$_POST['pilihan2'];
$pilihan3=$_POST['pilihan3'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$poskod=$_POST['poskod'];
$negeri=$_POST['negeri'];
$telrumah=$_POST['telrumah'];
$hp=$_POST['telhp'];
$email=$_POST['email'];
$ic=$_POST['noic'];
$spm=$_POST['spm'];
$percubaanspm=$_POST['percubaan'];
$bm=$_POST['bm'];
$bi=$_POST['bi'];
$math=$_POST['math'];
$addmath=$_POST['addmath'];
$sejarah=$_POST['sejarah'];
$pi=$_POST['pi'];
$pm=$_POST['pm'];
$sains=$_POST['sains'];
$fizik=$_POST['fizik'];
$kimia=$_POST['kimia'];
$subjek11=$_POST['subjek11'];
$result11=$_POST['result11'];
$subjek12=$_POST['subjek12'];
$result12=$_POST['result12'];
$subjek13=$_POST['subjek13'];
$result13=$_POST['result13'];
$subjek14=$_POST['subjek14'];
$result14=$_POST['result14'];
*/
?>
<center>
<table WIDTH="100%" HEIGHT="100%">
<tr>
<td align="center" valign="middle">
<form action="index.php" method="POST" ">
<table class="sort-table">
<thead>
</thead>
<tbody>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">A. PILIHAN KURSUS </span></td>
</tr>
<tr>
<td colspan="2">Pilihan 1 </td>
<td width="10">:</td>
<td colspan="4"><label><?php echo "$pilihan1"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 2 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan2"; ?></label></td>
</tr>
<tr>
<td colspan="2">Pilihan 3 </td>
<td>:</td>
<td colspan="4"><label><?php echo "$pilihan3"; ?></label></td>
</tr>
<tr>
<td colspan="3"> </td>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">B. BUTIR-BUTIR PERIBADI </span></td>
</tr>
<tr>
<td colspan="2"><p>Nama</p> </td>
<td><div align="center">:</div></td>
<td colspan="4" rowspan="2"><p><?php echo "$nama"; ?> </p>
<p class="style6"> </p></td>
</tr>
<tr>
<td height="21" colspan="2" class="style6">(Mengikut Kad Pengenalan) </td>
<td><div align="center"></div></td>
</tr>
<tr>
<td height="12" colspan="2"><p>Alamat Surat Menyurat </p> </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$alamat"; ?></label></td>
</tr>
<tr>
<td colspan="2"><div align="left">Poskod</div></td>
<td><div align="center">:</div></td>
<td><?php echo "$poskod"; ?> </td>
<td width="51">Negeri</td>
<td width="6"><div align="center">:</div></td>
<td width="216"><label><?php echo "$negeri"; ?></label></td>
</tr>
<tr>
<td colspan="2">Tel. Rumah </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telrumah"; ?></label></td>
<td>Tel. HP </td>
<td><div align="center">:</div></td>
<td><label><?php echo "$telhp"; ?></label></td>
</tr>
<tr>
<td colspan="2">Alamat E-mail </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$email"; ?></label></td>
</tr>
<tr>
<td colspan="2">No Kad Pengenalan </td>
<td><div align="center">:</div></td>
<td colspan="4"><label><?php echo "$noic"; ?></label></td>
</tr>
<tr>
<td colspan="2"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#000000"><span class="style5">C. KELAYAKAN </span></td>
</tr>
<tr>
<td colspan="3">Keputusan SPM </td>
<td><label>:
<?php echo "$spm"; ?>
</label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3">Keputusan Percubaan SPM 2011 </td>
<td colspan="4"><label>:<?php echo "$percubaan"; ?> <span class="style6">(Sila Tanda Bagi Yang Berkenaan)</span> </label></td>
</tr>
<tr>
<td colspan="7" class="style6"> </td>
</tr>
<tr>
<td width="36" bgcolor="#999999"><div align="center" class="style10">Bil</div></td>
<td colspan="2" bgcolor="#999999"><div align="center" class="style10">Subjek</div> <div align="center" class="style10"></div></td>
<td bgcolor="#999999"><div align="center"><span class="style10">Keputusan</span></div></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">1</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Melayu </td>
<td bgcolor="#FFFFCC"><label><?php echo "$bm"; ?></label></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">2</div></td>
<td colspan="2" bgcolor="#FFFFCC">Bahasa Inggeris </td>
<td bgcolor="#FFFFCC"><?php echo "$bi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">3</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik</td>
<td bgcolor="#FFFFCC"><?php echo "$math"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">4</div></td>
<td colspan="2" bgcolor="#FFFFCC">Matematik Tambahan </td>
<td bgcolor="#FFFFCC"><?php echo "$addmath"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">5</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sejarah</td>
<td bgcolor="#FFFFCC"><?php echo "$sejarah"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">6</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Islam </td>
<td bgcolor="#FFFFCC"><?php echo "$pi"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">7</div></td>
<td colspan="2" bgcolor="#FFFFCC">Pendidikan Moral </td>
<td bgcolor="#FFFFCC"><?php echo "$pm"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">8</div></td>
<td colspan="2" bgcolor="#FFFFCC">Sains</td>
<td bgcolor="#FFFFCC"><?php echo "$sains"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">9</div></td>
<td colspan="2" bgcolor="#FFFFCC">Fizik</td>
<td bgcolor="#FFFFCC"><?php echo "$fizik"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">10</div></td>
<td colspan="2" bgcolor="#FFFFCC">Kimia</td>
<td bgcolor="#FFFFCC"><?php echo "$kimia"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">11</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek11"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result11"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">12</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek12"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result12"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">13</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek13"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result13"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFCC"><div align="center">14</div></td>
<td colspan="2" bgcolor="#FFFFCC"><?php echo "$subjek14"; ?> </td>
<td bgcolor="#FFFFCC"><?php echo "$result14"; ?> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td width="150" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7"><?php
$timezone = "Asia/Kuala_Lumpur";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
echo date('j M Y, l, H:i:s');
?> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td><div align="center"></div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7" align="center">
<input class="sort-table" type="submit" value="Print" name="print"
style="border-style: outset; border-width: 2; padding: 0; background-color: #C0C0C0" onClick="javascript:cetak()"></td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</center>
<script type="text/javascript" charset="utf-8">
function cetak()
{
window.print();
}
</script>
</body>
</html>cuba belajar $_POST guna untuk apa. ini main sebarang sahaja
copy paste
mana sumber kau dapat daa...
terima kasih en amin007 dan rakan2 yang lain... maafla saya baru blaja... tu pon blaja sendiri jer... tu yg copy paste jer tu... hehehe.... nanti saya try coding2 kat atas....
pada paparan.php jadual keluar tak???
kalau xampp username dia slalunye root