WampServer
Apache, PHP, MySQL
on Windows
Aller à : Liste des Forums•Liste des messages•Nouvelle discussion•Recherche•Connexion•Imprimer la vue
generate database
Envoyé par:
joe
(210.195.78.---)
Date: 17 November 2004 à 08:47
dear Rom....
now i am doing my final project for my school.....
can i auto generate the dB after one semester, because the database is the sem ..... but need to create database after one semester to store the difference data
(the database still with the same field)...
HOw.......
AND......can u teach me how to write programming in class.....
previous i did it in structure.....but now i face problem when need to change all the coding to Object oriented (OO).....
pls help...
this is one of my coding (registration)
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?
session_start();
include 'kerani/checkLogin.php';
checkLogin();
$cmdAdd = $_POST['cmdAdd'];
$nama = $_POST['nama'];
$pengkhususan = $_POST['pengkhususan'];
$no_kp = $_POST['no_kp'];
$noMatrik = $_POST['noMatrik'];
$tahun_khursus = $_POST['tahun_khursus'];
$jantina = $_POST['jantina'];
$notelefon = $_POST['notelefon'];
$no_handphone = $_POST['no_handphone'];
$email = $_POST['email'];
$alamat_tetap = $_POST['alamat_tetap'];
$alamat_sem = $_POST['alamat_sem'];
$nama_organisasi = $_POST['nama_organisasi'];
$alamat_organisasi = $_POST['alamat_organisasi'];
$poskod_organisasi = $_POST['poskod_organisasi'];
$kawasan_organisasi = $_POST['kawasan_organisasi'];
$negeri_organisasi = $_POST['negeri_organisasi'];
$no_tel_organisasi = $_POST['no_tel_organisasi'];
$fax_organisasi = $_POST['fax_organisasi'];
$penasihat_akedemik = $_POST['penasihat_akedemik'];
$CPA = $_POST['CPA'];
$jum_kredit_dapat = $_POST['jum_kredit_dapat'];
$jum_kredit_ambil = $_POST['jum_kredit_ambil'];
?>
<html>
<head>
<title>Pendaftaran Pelajar LP</title>
<script language="JavaScript">
<!--
function convertToUppercase(fieldObject) {
fieldObject.value = fieldObject.value.toUpperCase()
}
function validate(fo){
if(fo.nama.value=="" && fo.pengkhususan.value=="" && fo.no_kp.value=="" && fo.noMatrik.value=="" && fo.tahun_khursus.value=="" && fo.jantina.value==""&& fo.alamat_tetap.value=="" && fo.alamat_sem.value==""&& fo.penasihat_akedemik.value=="" && fo.CPA.value=="" && fo.jum_kredit_dapat.value=="" && fo.jum_kredit_ambil.value==""
{
alert("Sila Masukkan Maklumat Penting";
return false;
}
else if(fo.nama.value==""{
alert("Sila Masukan Nama Pelajar";
return false;
}
else if(fo.pengkhususan.value==""{
alert("Sila pilih Pengkhususan Pelajar";
return false;
}
else if(fo.no_kp.value==""{
alert("Sila masukkan No Ic Pelajar";
return false;
}
else if(fo.noMatrik.value==""{
alert("Sila masukkan No Matrik Pelajar";
return false;
}
else if(fo.tahun_khursus.value==""{
alert("Sila pilih tahun kursus pelajar";
return false;
}
else if(fo.jantina.value==""{
alert("Sila pilih jantina pelajar";
return false;
}
else if(fo.alamat_tetap.value==""{
alert("Sila masukkan alamat tetap Pelajar";
return false;
}
else if(fo.alamat_sem.value==""{
alert("Sila masukkan alamat Semasa Pelajar";
return false;
}
else if(fo.penasihat_akedemik.value==""{
alert("Sila masukkan PA Pelajar";
return false;
}
else if(fo.CPA.value==""{
alert("Sila masukkan CPA Pelajar";
return false;
}
else if(isNaN(parseInt(fo.CPA.value))){
alert("CPA mesti dalam bentuk interger";
return false;
}
else if(fo.jum_kredit_dapat.value==""{
alert("Sila masukkan Jumlah Kredit Pelajar";
return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger";
return false;
}
else if(fo.jum_kredit_ambil.value==""{
alert("Sila masukkan Jumlah Kredit Ambil Pelajar";
return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger";
return false;
}
else{ return true; }
}
-->
</script>
</head>
<span id="liveclock" style="position:absolute;right:0;top:0;">
</span>
<script language="JavaScript">
<!--
function show5(){
if (!document.layers&&!document.all&&!document.getElementById)
return
var Digital=new Date()
var hours=Digital.getHours()
var minutes=Digital.getMinutes()
var seconds=Digital.getSeconds()
var dn="PM"
if (hours<12)
dn="AM"
if (hours>12)
hours=hours-12
if (hours==0)
hours=12
if (minutes<=9)
minutes="0"+minutes
if (seconds<=9)
seconds="0"+seconds
//change font size here to your desire
myclock="<font size='3' face='Arial' color='#000000'><b>"+hours+":"+minutes+":" +seconds+" "+dn+"</b></font>"
if (document.layers){
document.layers.liveclock.document.write(myclock)
document.layers.liveclock.document.close()
}
else if (document.all)
liveclock.innerHTML=myclock
else if (document.getElementById)
document.getElementById("liveclock".innerHTML=myclock
setTimeout("show5()",1000)
}
window.onload=show5
//-->
</script>
<script type="text/javascript" language="JavaScript1.2" src="stm31.js"></script>
<div style="width:154px; height:348px; position:absolute; left:50px; top:226px; z-index:1;" id="layer1">
<p align="center"><a href="reg_pel.php">Daftar Pelajar</a>
<p align="center"><a href="update_pel.php">Kemaskini Pelajar</a>
<p align="center"><a href="reg_org.php">Daftar Organisasi</a>
<p align="center"><a href="update_Org.php">Kemaskini Organisasi</a>
<p align="center"><a href="search_pelK.php">Carian Pelajar</a>
<p align="center"><a href="search_penyeliaK.php">Carian Penyelia</a>
<p align="center"><a href="surat_pengesahan.php">Surat Pengesahan</a>
<p align="center"><a href="surat_lantik.php">Surat Pelantikan</a>
<p align="center"><a href="surat_tempat.php">Surat Penempatan</a>
</div>
<p align="center"><img src="banner.jpg" width="650" height="130">
<p align="center"><font face=arial size=1 color=blue>Status</font><font size=3><b><? echo' : '. $_SESSION['Kerani']; ?></b></font>
<script type="text/javascript" language="JavaScript">
<!--
stm_bm(["ivvnair",400,"","blank.gif",0,"","",0,0,0,0,50,1,0,0,"","",0],this);
stm_bp("p0",[0,4,0,0,0,3,0,7,100,"",-2,"",-2,90,0,0,"#006699","transparent","",3,0,0,"#ffffff"]);
stm_ai("p0i0",[0,"Home ","","",-1,-1,0,"index.php","","","Home","","",0,0,0,"","",0,0,0,0,1,"#ffffff",1,"#ffffff",1,"xp1.gif","xp2.gif",3,3,0,0,"#ffffff","#ffffff","#666666","#000066","bold 8pt Arial","bold 8pt Arial",0,0]);
stm_aix("p0i1","p0i0",[0,"Penyelaras ","","",-1,-1,0,"penyelaras_login.php","_self","","Untuk Penyelaras Sahaja"]);
stm_aix("p0i2","p0i0",[0,"AJK ","","",-1,-1,0,"ajk_login","_self","","Untuk AJK Sahaja"]);
stm_aix("p0i3","p0i0",[0,"Penyelia Seliaan ","","",-1,-1,0,"penyelia_login.php","_self","","Untuk Penyelia Sahaja"]);
stm_aix("p0i4","p0i0",[0,"Penyelia Organisasi","","",-1,-1,0,"penOrg_login.php","_self","","Untuk Penyelia Org Sahaja"]);
stm_aix("p0i5","p0i0",[0,"Kerani ","","",-1,-1,0,"","_self","","Here :>"]);stm_aix("p0i2","p0i0",[0,"Links ","","",-1,-1,0,"","_self","","","","",0,0,0,"arrow_r.gif","arrow_r.gif",7,7]);
stm_bp("p1",[1,4,0,0,0,3,0,0,100,"progid
XImageTransform.Microsoft.Fade(overlap=.5,enabled=0,Duration=0.45)",-2,"",-2,65,2,4,"#000066","transparent","",3,0,0,"#000000"]);
stm_aix("p1i0","p0i0",[0,"Homepage UTM ","","",-1,-1,0,"[www.utm.my","_blank","","All] About UTM","","",0,0,0,"","",0,0,0,0,1,"#ffffff",1,"#ffffff",1,"xp1.gif","xp2.gif",3,3,0,0,"#ffffff","#ffffff","#666666","#000066","8pt Arial","8pt Arial"]);
stm_aix("p1i1","p1i0",[0,"AIMS2000 ","","",-1,-1,0,"[aimswebxs.utm.my","_blank","","Academic] Information Management System."]);
stm_aix("p1i2","p1i0",[0,"PSZ ","","",-1,-1,0,"[www.psz.utm.my","_blank","","Perpustakaan] Sultan Zakariah"]);
stm_ep();
stm_aix("p0i6","p0i0",[0,"Keluar ","","",-1,-1,0,"kerani_logout.php","_self","","Terima Kasih
"]);
stm_ep();
stm_ep();
stm_em();
//-->
</script>
<p>
<STYLE type=text/css>
A:link {
COLOR: #383848; TEXT-DECORATION: none
}
A:visited {
COLOR: #505870; TEXT-DECORATION: none
}
A:hover {
CURSOR: e-resize; COLOR: #505870; TEXT-DECORATION: underline overline
}
</STYLE>
<p>
<p>
<STYLE type=text/css>
BODY {
SCROLLBAR-FACE-COLOR: #505870; SCROLLBAR-HIGHLIGHT-COLOR: #ffffff; SCROLLBAR-SHADOW-COLOR: #505870; SCROLLBAR-ARROW-COLOR: #ffffff; SCROLLBAR-TRACK-COLOR: #c8c8d8; SCROLLBAR-BASE-COLOR: #505870; scrollbar-dark-shadow-color: #FFFFFF; scrollbar-3d-light-color: #FFFFFF
}
</STYLE>
</p>
<? print "<link rel='stylesheet' href='style.css' type='text/css'>"; ?>
<div id="layer2" style="width:543px; height:338px; position:absolute; left:288px; top:224px; z-index:1;">
<script language=javascript >
function insRecord()
{
document.pel.cmdAdd.value="Add1";
}
</script>
<?
include "connect.php";
?>
<body>
<p align="center"><strong>Borang Pendaftaran Latihan Praktikal</strong></p>
<form name="pel" method="POST" action="<?=$PHP_SELF?>" onSubmit="return validate(document.pel)">
<table width="100%" border="0" align="center">
<input type='hidden' name='act' value='cmdAdd'>
<tr>
<td width="29%"><div align="right">Nama Pelajar<font color='red'>*</font> :</div></td>
<td width="71%"><input type="text" size="50" name="nama" onChange="convertToUppercase(this)"></td>
</tr>
<tr>
<td><div align="right">Jabatan<font color='red'>*</font> :</div></td>
<td><select name="pengkhususan">
<option selected>Pilih</option>
<option value="MIS">MIS</option>
<option value="SKK">SKK</option>
<option value="PPI">PPI</option>
<option value="KP">KP</option>
<option value="GMM">GMM</option>
</select></td>
</tr>
<tr>
<td><div align="right">No Kad Pengenalan<font color='red'>*</font> :</div></td>
<td><input type="text" name="no_kp"> (810420145172)</td>
</tr>
<tr>
<td><div align="right">No Matriks<font color='red'>*</font> :</div></td>
<td><input type="text" name="noMatrik" onChange="convertToUppercase(this)"></td>
</tr>
<tr>
<td><div align="right">Tahun Pengajian Semasa<font color='red'>*</font> :</div></td>
<td> <select name="tahun_khursus">
<option selected>Pilih</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select></td>
</tr>
<tr>
<td height="26"><div align="right">Jantina<font color='red'>*</font> :</div></td>
<td><select name="jantina">
<option selected>Pilih</option>
<option value="Lelaki">Lelaki</option>
<option value="Perempuan">Perempuan</option>
</td>
<tr>
<td height="27"><div align="right">No Telefon :</div></td>
<td> <input type="text" size="12" name="notelefon"> (Rumah)
<input type="text" size="12" name="no_handphone">
(HP) </td>
</tr>
<tr>
<td><div align="right">Email :</div></td>
<td><input type="text" size="30" name="email"></td>
</tr>
<tr>
<td><div align="right">Alamat Tetap<font color='red'>*</font> :</div></td>
<td><textarea name="alamat_tetap" rows="4" cols="35"></textarea></textarea>
</td>
</tr>
<tr>
<td><div align="right">Alamat Semasa<font color='red'>*</font> :</div></td>
<td><textarea name="alamat_sem" rows="4" cols="35"></textarea></td>
</tr>
<tr>
<td><div align="right">Nama Organisasi :</div></td>
<td><input type="text" size="50" name="nama_organisasi"></td>
</tr>
<tr>
<td><div align="right">Alamat Organisasi :</div></td>
<td><input type="text" size="40" name="alamat_organisasi"></td>
</tr>
<tr>
<td><div align="right">Poskod :</div></td>
<td><input type="text" size="6" name="poskod_organisasi"></td>
</tr>
<tr>
<td><div align="right">Kawasan :</div></td>
<td><input type="text" size="20" name="kawasan_organisasi"></td>
</tr>
<tr>
<td><div align="right">Negeri :</div></td>
<td><select name="negeri_organisasi">
<option selected>Pilih</option>
<option value="PERLIS">PERLIS</option>
<option value="KEDAH">KEDAH</option>
<option value="PULAU PINANG">PULAU PINANG</option>
<option value="PERAK">PERAK</option>
<option value="KELANTAN">KELANTAN</option>
<option value="TERENGGANU">TERENGGANU</option>
<option value="PAHANG">PAHANG</option>
<option value="SELANGOR">SELANGOR</option>
<option value="NEGERI SEMBILAN">NEGERI SEMBILAN</option>
<option value="MELAKA">MELAKA</option>
<option value="JOHOR">JOHOR</option>
<option value="SABAH">SABAH</option>
<option value="SARAWAK">SARAWAK</option>
<option value="WILAYAH PERSEKUTUAN">WILAYAH PERSEKUTUAN</option>
<option value="LABUAN">LABUAN</option>
</td>
</tr>
<tr>
<td><div align="right">No telefon Organisasi :</div></td>
<td><input type="text" size="20" name="no_tel_organisasi"></td>
</tr>
<tr>
<td><div align="right">Fax Organisasi:</div></td>
<td><input type="text" size="20" name="fax_organisasi"></td>
</tr>
<tr>
<td><div align="right">Penasihat Akedemik<font color='red'>*</font> :</div></td>
<td><input type="text" size="20" name="penasihat_akedemik"></td>
</tr>
<tr>
<td><div align="right">CPA Terkini<font color='red'>*</font> :</div></td>
<td><input type="text" name="CPA"></td>
</tr>
<tr>
<td><div align="right">Jumlah Kredit Dapat<font color='red'>*</font> :</div></td>
<td><input type="text" name="jum_kredit_dapat"></td>
</tr>
<tr>
<td><div align="right">Jumlah Kredit Semester Ini<font color='red'>*</font> :</div></td>
<td><input type="text" name="jum_kredit_ambil"></td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="cmdAdd" value="Submit"> <input type="reset" name="reset" value="Reset"></td>
</tr>
</table>
<?
if ($cmdAdd=="Submit"
{
$sqlB="insert into lpraktikal(nama,pengkhususan,no_kp,noMatrik,tahun_khursus,jantina,notelefon,no_handphone,email,alamat_tetap,alamat_sem,nama_organisasi,alamat_organisasi,poskod_organisasi,kawasan_organisasi,negeri_organisasi,no_tel_organisasi,fax_organisasi,penasihat_akedemik,CPA,jum_kredit_dapat,jum_kredit_ambil) values('$nama','$pengkhususan','$no_kp','$noMatrik','$tahun_khursus','$jantina','$notelefon','$no_handphone','$email','$alamat_tetap','$alamat_sem','$nama_organisasi','$alamat_organisasi','$poskod_organisasi','$kawasan_organisasi','$negeri_organisasi','$no_tel_organisasi','$fax_organisasi','$penasihat_akedemik','$CPA','$jum_kredit_dapat','$jum_kredit_ambil')";
//print"$sqlB";
$rstB=mysql_query($sql
;
if(!$rst
{
echo("Problem : " . mysql_error());
exit();
}
}
?>
</html>
</div>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
thanks alot ......
joe
now i am doing my final project for my school.....
can i auto generate the dB after one semester, because the database is the sem ..... but need to create database after one semester to store the difference data
(the database still with the same field)...
HOw.......
AND......can u teach me how to write programming in class.....
previous i did it in structure.....but now i face problem when need to change all the coding to Object oriented (OO).....
pls help...
this is one of my coding (registration)
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?
session_start();
include 'kerani/checkLogin.php';
checkLogin();
$cmdAdd = $_POST['cmdAdd'];
$nama = $_POST['nama'];
$pengkhususan = $_POST['pengkhususan'];
$no_kp = $_POST['no_kp'];
$noMatrik = $_POST['noMatrik'];
$tahun_khursus = $_POST['tahun_khursus'];
$jantina = $_POST['jantina'];
$notelefon = $_POST['notelefon'];
$no_handphone = $_POST['no_handphone'];
$email = $_POST['email'];
$alamat_tetap = $_POST['alamat_tetap'];
$alamat_sem = $_POST['alamat_sem'];
$nama_organisasi = $_POST['nama_organisasi'];
$alamat_organisasi = $_POST['alamat_organisasi'];
$poskod_organisasi = $_POST['poskod_organisasi'];
$kawasan_organisasi = $_POST['kawasan_organisasi'];
$negeri_organisasi = $_POST['negeri_organisasi'];
$no_tel_organisasi = $_POST['no_tel_organisasi'];
$fax_organisasi = $_POST['fax_organisasi'];
$penasihat_akedemik = $_POST['penasihat_akedemik'];
$CPA = $_POST['CPA'];
$jum_kredit_dapat = $_POST['jum_kredit_dapat'];
$jum_kredit_ambil = $_POST['jum_kredit_ambil'];
?>
<html>
<head>
<title>Pendaftaran Pelajar LP</title>
<script language="JavaScript">
<!--
function convertToUppercase(fieldObject) {
fieldObject.value = fieldObject.value.toUpperCase()
}
function validate(fo){
if(fo.nama.value=="" && fo.pengkhususan.value=="" && fo.no_kp.value=="" && fo.noMatrik.value=="" && fo.tahun_khursus.value=="" && fo.jantina.value==""&& fo.alamat_tetap.value=="" && fo.alamat_sem.value==""&& fo.penasihat_akedemik.value=="" && fo.CPA.value=="" && fo.jum_kredit_dapat.value=="" && fo.jum_kredit_ambil.value==""
{alert("Sila Masukkan Maklumat Penting"
;return false;
}
else if(fo.nama.value==""
{alert("Sila Masukan Nama Pelajar"
;return false;
}
else if(fo.pengkhususan.value==""
{alert("Sila pilih Pengkhususan Pelajar"
;return false;
}
else if(fo.no_kp.value==""
{alert("Sila masukkan No Ic Pelajar"
;return false;
}
else if(fo.noMatrik.value==""
{alert("Sila masukkan No Matrik Pelajar"
;return false;
}
else if(fo.tahun_khursus.value==""
{alert("Sila pilih tahun kursus pelajar"
;return false;
}
else if(fo.jantina.value==""
{alert("Sila pilih jantina pelajar"
;return false;
}
else if(fo.alamat_tetap.value==""
{alert("Sila masukkan alamat tetap Pelajar"
;return false;
}
else if(fo.alamat_sem.value==""
{alert("Sila masukkan alamat Semasa Pelajar"
;return false;
}
else if(fo.penasihat_akedemik.value==""
{alert("Sila masukkan PA Pelajar"
;return false;
}
else if(fo.CPA.value==""
{alert("Sila masukkan CPA Pelajar"
;return false;
}
else if(isNaN(parseInt(fo.CPA.value))){
alert("CPA mesti dalam bentuk interger"
;return false;
}
else if(fo.jum_kredit_dapat.value==""
{alert("Sila masukkan Jumlah Kredit Pelajar"
;return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger"
;return false;
}
else if(fo.jum_kredit_ambil.value==""
{alert("Sila masukkan Jumlah Kredit Ambil Pelajar"
;return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger"
;return false;
}
else{ return true; }
}
-->
</script>
</head>
<span id="liveclock" style="position:absolute;right:0;top:0;">
</span>
<script language="JavaScript">
<!--
function show5(){
if (!document.layers&&!document.all&&!document.getElementById)
return
var Digital=new Date()
var hours=Digital.getHours()
var minutes=Digital.getMinutes()
var seconds=Digital.getSeconds()
var dn="PM"
if (hours<12)
dn="AM"
if (hours>12)
hours=hours-12
if (hours==0)
hours=12
if (minutes<=9)
minutes="0"+minutes
if (seconds<=9)
seconds="0"+seconds
//change font size here to your desire
myclock="<font size='3' face='Arial' color='#000000'><b>"+hours+":"+minutes+":" +seconds+" "+dn+"</b></font>"
if (document.layers){
document.layers.liveclock.document.write(myclock)
document.layers.liveclock.document.close()
}
else if (document.all)
liveclock.innerHTML=myclock
else if (document.getElementById)
document.getElementById("liveclock"
.innerHTML=myclocksetTimeout("show5()",1000)
}
window.onload=show5
//-->
</script>
<script type="text/javascript" language="JavaScript1.2" src="stm31.js"></script>
<div style="width:154px; height:348px; position:absolute; left:50px; top:226px; z-index:1;" id="layer1">
<p align="center"><a href="reg_pel.php">Daftar Pelajar</a>
<p align="center"><a href="update_pel.php">Kemaskini Pelajar</a>
<p align="center"><a href="reg_org.php">Daftar Organisasi</a>
<p align="center"><a href="update_Org.php">Kemaskini Organisasi</a>
<p align="center"><a href="search_pelK.php">Carian Pelajar</a>
<p align="center"><a href="search_penyeliaK.php">Carian Penyelia</a>
<p align="center"><a href="surat_pengesahan.php">Surat Pengesahan</a>
<p align="center"><a href="surat_lantik.php">Surat Pelantikan</a>
<p align="center"><a href="surat_tempat.php">Surat Penempatan</a>
</div>
<p align="center"><img src="banner.jpg" width="650" height="130">
<p align="center"><font face=arial size=1 color=blue>Status</font><font size=3><b><? echo' : '. $_SESSION['Kerani']; ?></b></font>
<script type="text/javascript" language="JavaScript">
<!--
stm_bm(["ivvnair",400,"","blank.gif",0,"","",0,0,0,0,50,1,0,0,"","",0],this);
stm_bp("p0",[0,4,0,0,0,3,0,7,100,"",-2,"",-2,90,0,0,"#006699","transparent","",3,0,0,"#ffffff"]);
stm_ai("p0i0",[0,"Home ","","",-1,-1,0,"index.php","","","Home","","",0,0,0,"","",0,0,0,0,1,"#ffffff",1,"#ffffff",1,"xp1.gif","xp2.gif",3,3,0,0,"#ffffff","#ffffff","#666666","#000066","bold 8pt Arial","bold 8pt Arial",0,0]);
stm_aix("p0i1","p0i0",[0,"Penyelaras ","","",-1,-1,0,"penyelaras_login.php","_self","","Untuk Penyelaras Sahaja"]);
stm_aix("p0i2","p0i0",[0,"AJK ","","",-1,-1,0,"ajk_login","_self","","Untuk AJK Sahaja"]);
stm_aix("p0i3","p0i0",[0,"Penyelia Seliaan ","","",-1,-1,0,"penyelia_login.php","_self","","Untuk Penyelia Sahaja"]);
stm_aix("p0i4","p0i0",[0,"Penyelia Organisasi","","",-1,-1,0,"penOrg_login.php","_self","","Untuk Penyelia Org Sahaja"]);
stm_aix("p0i5","p0i0",[0,"Kerani ","","",-1,-1,0,"","_self","","Here :>"]);stm_aix("p0i2","p0i0",[0,"Links ","","",-1,-1,0,"","_self","","","","",0,0,0,"arrow_r.gif","arrow_r.gif",7,7]);
stm_bp("p1",[1,4,0,0,0,3,0,0,100,"progid
XImageTransform.Microsoft.Fade(overlap=.5,enabled=0,Duration=0.45)",-2,"",-2,65,2,4,"#000066","transparent","",3,0,0,"#000000"]);stm_aix("p1i0","p0i0",[0,"Homepage UTM ","","",-1,-1,0,"[www.utm.my","_blank","","All] About UTM","","",0,0,0,"","",0,0,0,0,1,"#ffffff",1,"#ffffff",1,"xp1.gif","xp2.gif",3,3,0,0,"#ffffff","#ffffff","#666666","#000066","8pt Arial","8pt Arial"]);
stm_aix("p1i1","p1i0",[0,"AIMS2000 ","","",-1,-1,0,"[aimswebxs.utm.my","_blank","","Academic] Information Management System."]);
stm_aix("p1i2","p1i0",[0,"PSZ ","","",-1,-1,0,"[www.psz.utm.my","_blank","","Perpustakaan] Sultan Zakariah"]);
stm_ep();
stm_aix("p0i6","p0i0",[0,"Keluar ","","",-1,-1,0,"kerani_logout.php","_self","","Terima Kasih
"]);stm_ep();
stm_ep();
stm_em();
//-->
</script>
<p>
<STYLE type=text/css>
A:link {
COLOR: #383848; TEXT-DECORATION: none
}
A:visited {
COLOR: #505870; TEXT-DECORATION: none
}
A:hover {
CURSOR: e-resize; COLOR: #505870; TEXT-DECORATION: underline overline
}
</STYLE>
<p>
<p>
<STYLE type=text/css>
BODY {
SCROLLBAR-FACE-COLOR: #505870; SCROLLBAR-HIGHLIGHT-COLOR: #ffffff; SCROLLBAR-SHADOW-COLOR: #505870; SCROLLBAR-ARROW-COLOR: #ffffff; SCROLLBAR-TRACK-COLOR: #c8c8d8; SCROLLBAR-BASE-COLOR: #505870; scrollbar-dark-shadow-color: #FFFFFF; scrollbar-3d-light-color: #FFFFFF
}
</STYLE>
</p>
<? print "<link rel='stylesheet' href='style.css' type='text/css'>"; ?>
<div id="layer2" style="width:543px; height:338px; position:absolute; left:288px; top:224px; z-index:1;">
<script language=javascript >
function insRecord()
{
document.pel.cmdAdd.value="Add1";
}
</script>
<?
include "connect.php";
?>
<body>
<p align="center"><strong>Borang Pendaftaran Latihan Praktikal</strong></p>
<form name="pel" method="POST" action="<?=$PHP_SELF?>" onSubmit="return validate(document.pel)">
<table width="100%" border="0" align="center">
<input type='hidden' name='act' value='cmdAdd'>
<tr>
<td width="29%"><div align="right">Nama Pelajar<font color='red'>*</font> :</div></td>
<td width="71%"><input type="text" size="50" name="nama" onChange="convertToUppercase(this)"></td>
</tr>
<tr>
<td><div align="right">Jabatan<font color='red'>*</font> :</div></td>
<td><select name="pengkhususan">
<option selected>Pilih</option>
<option value="MIS">MIS</option>
<option value="SKK">SKK</option>
<option value="PPI">PPI</option>
<option value="KP">KP</option>
<option value="GMM">GMM</option>
</select></td>
</tr>
<tr>
<td><div align="right">No Kad Pengenalan<font color='red'>*</font> :</div></td>
<td><input type="text" name="no_kp"> (810420145172)</td>
</tr>
<tr>
<td><div align="right">No Matriks<font color='red'>*</font> :</div></td>
<td><input type="text" name="noMatrik" onChange="convertToUppercase(this)"></td>
</tr>
<tr>
<td><div align="right">Tahun Pengajian Semasa<font color='red'>*</font> :</div></td>
<td> <select name="tahun_khursus">
<option selected>Pilih</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select></td>
</tr>
<tr>
<td height="26"><div align="right">Jantina<font color='red'>*</font> :</div></td>
<td><select name="jantina">
<option selected>Pilih</option>
<option value="Lelaki">Lelaki</option>
<option value="Perempuan">Perempuan</option>
</td>
<tr>
<td height="27"><div align="right">No Telefon :</div></td>
<td> <input type="text" size="12" name="notelefon"> (Rumah)
<input type="text" size="12" name="no_handphone">
(HP) </td>
</tr>
<tr>
<td><div align="right">Email :</div></td>
<td><input type="text" size="30" name="email"></td>
</tr>
<tr>
<td><div align="right">Alamat Tetap<font color='red'>*</font> :</div></td>
<td><textarea name="alamat_tetap" rows="4" cols="35"></textarea></textarea>
</td>
</tr>
<tr>
<td><div align="right">Alamat Semasa<font color='red'>*</font> :</div></td>
<td><textarea name="alamat_sem" rows="4" cols="35"></textarea></td>
</tr>
<tr>
<td><div align="right">Nama Organisasi :</div></td>
<td><input type="text" size="50" name="nama_organisasi"></td>
</tr>
<tr>
<td><div align="right">Alamat Organisasi :</div></td>
<td><input type="text" size="40" name="alamat_organisasi"></td>
</tr>
<tr>
<td><div align="right">Poskod :</div></td>
<td><input type="text" size="6" name="poskod_organisasi"></td>
</tr>
<tr>
<td><div align="right">Kawasan :</div></td>
<td><input type="text" size="20" name="kawasan_organisasi"></td>
</tr>
<tr>
<td><div align="right">Negeri :</div></td>
<td><select name="negeri_organisasi">
<option selected>Pilih</option>
<option value="PERLIS">PERLIS</option>
<option value="KEDAH">KEDAH</option>
<option value="PULAU PINANG">PULAU PINANG</option>
<option value="PERAK">PERAK</option>
<option value="KELANTAN">KELANTAN</option>
<option value="TERENGGANU">TERENGGANU</option>
<option value="PAHANG">PAHANG</option>
<option value="SELANGOR">SELANGOR</option>
<option value="NEGERI SEMBILAN">NEGERI SEMBILAN</option>
<option value="MELAKA">MELAKA</option>
<option value="JOHOR">JOHOR</option>
<option value="SABAH">SABAH</option>
<option value="SARAWAK">SARAWAK</option>
<option value="WILAYAH PERSEKUTUAN">WILAYAH PERSEKUTUAN</option>
<option value="LABUAN">LABUAN</option>
</td>
</tr>
<tr>
<td><div align="right">No telefon Organisasi :</div></td>
<td><input type="text" size="20" name="no_tel_organisasi"></td>
</tr>
<tr>
<td><div align="right">Fax Organisasi:</div></td>
<td><input type="text" size="20" name="fax_organisasi"></td>
</tr>
<tr>
<td><div align="right">Penasihat Akedemik<font color='red'>*</font> :</div></td>
<td><input type="text" size="20" name="penasihat_akedemik"></td>
</tr>
<tr>
<td><div align="right">CPA Terkini<font color='red'>*</font> :</div></td>
<td><input type="text" name="CPA"></td>
</tr>
<tr>
<td><div align="right">Jumlah Kredit Dapat<font color='red'>*</font> :</div></td>
<td><input type="text" name="jum_kredit_dapat"></td>
</tr>
<tr>
<td><div align="right">Jumlah Kredit Semester Ini<font color='red'>*</font> :</div></td>
<td><input type="text" name="jum_kredit_ambil"></td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="cmdAdd" value="Submit"> <input type="reset" name="reset" value="Reset"></td>
</tr>
</table>
<?
if ($cmdAdd=="Submit"
{
$sqlB="insert into lpraktikal(nama,pengkhususan,no_kp,noMatrik,tahun_khursus,jantina,notelefon,no_handphone,email,alamat_tetap,alamat_sem,nama_organisasi,alamat_organisasi,poskod_organisasi,kawasan_organisasi,negeri_organisasi,no_tel_organisasi,fax_organisasi,penasihat_akedemik,CPA,jum_kredit_dapat,jum_kredit_ambil) values('$nama','$pengkhususan','$no_kp','$noMatrik','$tahun_khursus','$jantina','$notelefon','$no_handphone','$email','$alamat_tetap','$alamat_sem','$nama_organisasi','$alamat_organisasi','$poskod_organisasi','$kawasan_organisasi','$negeri_organisasi','$no_tel_organisasi','$fax_organisasi','$penasihat_akedemik','$CPA','$jum_kredit_dapat','$jum_kredit_ambil')";
//print"$sqlB";
$rstB=mysql_query($sql
;if(!$rst
{
echo("Problem : " . mysql_error());
exit();
}
}
?>
</html>
</div>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
thanks alot ......
joe
Re: generate database
Envoyé par:
bistory
(---.45-136-217.adsl.skynet.be)
Date: 17 November 2004 à 14:38
Wow ! Did you try phpLib classes ? See [phplib.sourceforge.net]
Re: generate database
Envoyé par:
joe
(210.195.78.---)
Date: 18 November 2004 à 07:32
sorry....
which should i try....
thanks
which should i try....
thanks
Désolé, seuls les utilisateurs connectés peuvent envoyer des messages dans ce forum.
