WampServer

Apache, PHP, MySQL on Windows 

 
  • Accueil forum
  • Retour à WampServer
  • presentation
  • Download
  • Addons
  • Formations
  • Alter Way

 
Voir le sujet: Précédent•Suivant
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==""winking smiley{
alert("Sila Masukkan Maklumat Penting"winking smiley;
return false;
}
else if(fo.nama.value==""winking smiley{
alert("Sila Masukan Nama Pelajar"winking smiley;
return false;
}
else if(fo.pengkhususan.value==""winking smiley{
alert("Sila pilih Pengkhususan Pelajar"winking smiley;
return false;
}
else if(fo.no_kp.value==""winking smiley{
alert("Sila masukkan No Ic Pelajar"winking smiley;
return false;
}
else if(fo.noMatrik.value==""winking smiley{
alert("Sila masukkan No Matrik Pelajar"winking smiley;
return false;
}
else if(fo.tahun_khursus.value==""winking smiley{
alert("Sila pilih tahun kursus pelajar"winking smiley;
return false;
}
else if(fo.jantina.value==""winking smiley{
alert("Sila pilih jantina pelajar"winking smiley;
return false;
}
else if(fo.alamat_tetap.value==""winking smiley{
alert("Sila masukkan alamat tetap Pelajar"winking smiley;
return false;
}
else if(fo.alamat_sem.value==""winking smiley{
alert("Sila masukkan alamat Semasa Pelajar"winking smiley;
return false;
}
else if(fo.penasihat_akedemik.value==""winking smiley{
alert("Sila masukkan PA Pelajar"winking smiley;
return false;
}
else if(fo.CPA.value==""winking smiley{
alert("Sila masukkan CPA Pelajar"winking smiley;
return false;
}
else if(isNaN(parseInt(fo.CPA.value))){
alert("CPA mesti dalam bentuk interger"winking smiley;
return false;
}
else if(fo.jum_kredit_dapat.value==""winking smiley{
alert("Sila masukkan Jumlah Kredit Pelajar"winking smiley;
return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger"winking smiley;
return false;
}
else if(fo.jum_kredit_ambil.value==""winking smiley{
alert("Sila masukkan Jumlah Kredit Ambil Pelajar"winking smiley;
return false;
}
else if(isNaN(parseInt(fo.jum_kredit_ambil.value))){
alert("Jumlah Kredit Ambil mesti dalam bentuk interger"winking smiley;
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"winking smiley.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,"progidgrinning smileyXImageTransform.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 smiling smiley"]);
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"winking smiley
{
$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($sqlcool smiley;

if(!$rstcool smiley
{
echo("Problem : " . mysql_error());
exit();
}
}

?>

</html>
</div>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////

thanks alot ......

joe


Options: Répondre•Citer ce Message
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]

Options: Répondre•Citer ce Message
Re: generate database
Envoyé par: joe (210.195.78.---)
Date: 18 November 2004 à 07:32

sorry....

which should i try....

thanks

Options: Répondre•Citer ce Message


Aller à : Liste des Forums•Liste des messages•Recherche•Connexion
Désolé, seuls les utilisateurs connectés peuvent envoyer des messages dans ce forum.
Cliquer ici pour se connecter

design by jidePowered by Alter Way get firefoxget PHP