@charset iso-8859-1; - engineering.upm.rotraian/web_curs/web_tech/lucr_stud/laslo_simion.pdf ·...
TRANSCRIPT
Proiect tehnologii web
Pagina principală
CSS-ul pentru toate paginile
@charset "iso-8859-1";
BODY {}A:hover {
COLOR: #343434; TEXT-DECORATION: none}A {
COLOR: #909090; TEXT-DECORATION: none}TABLE {
FONT: 8pt Verdana, Arial, Helvetica, sans-serif; COLOR: #464646; TEXT-DECORATION: none}
TEXTAREA {BORDER-RIGHT: #a0a0a0 1px groove; BORDER-TOP: #a0a0a0 1px groove;
OVERFLOW-Y: auto; FONT-SIZE: 8pt; OVERFLOW-X: hidden; BORDER-LEFT: #a0a0a0 1px groove; COLOR: #464646; BORDER-BOTTOM: #a0a0a0 1px groove; FONT-FAMILY: Verdana, Arial, Helvetica; BACKGROUND-COLOR: #e1e1e1}SELECT {
BORDER-RIGHT: #a0a0a0 1px solid; BORDER-TOP: #a0a0a0 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #a0a0a0 1px solid; COLOR: #464646; BORDER-BOTTOM: #a0a0a0 1px solid; FONT-FAMILY: Verdana, Arial, Helvetica; BACKGROUND-COLOR: #e1e1e1}A.menulink {
BORDER-RIGHT: 0px; PADDING-RIGHT: 0px; BORDER-TOP: 0px; DISPLAY: block; PADDING-LEFT: 8px; FONT-WEIGHT: normal; PADDING-BOTTOM: 0px; BORDER-LEFT: 0px; WIDTH: 100%; COLOR: #464646; PADDING-TOP: 0px; BORDER-BOTTOM: 0px; FONT: 8pt Verdana, Arial, Helvetica, sans-serif;}A.menulink:hover {
BORDER-RIGHT: 0px; WIDTH: 192px; HEIGHT: 34px; BORDER-TOP: 0px; BACKGROUND: #d6d6d6; BORDER-LEFT: 0px; CURSOR: hand; COLOR: #464646; BORDER-BOTTOM: 0px; TEXT-DECORATION: none ;}INPUT {
BORDER-RIGHT: #a0a0a0 1px solid; BORDER-TOP: #a0a0a0 1px solid; FONT-SIZE: 10pt; BORDER-LEFT: #a0a0a0 1px solid; COLOR: #464646; BORDER-BOTTOM: white 1px solid; FONT-FAMILY: Verdana, Arial, Helvetica; BACKGROUND-COLOR: #e1e1e1}
Cod sursă pentru index
<?php
ob_start();include 'include/page.php';include 'include/config.php'?><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link href="data/designSite.css" rel="stylesheet" type="text/css"><title>Colegiul Transilvania</title></head><body bgcolor="#ffd38b"><table cellspacing="0" cellpadding="0" width="100%"><tr> <td> </td> <td width="800"> <table cellspacing="0" cellpadding="0" width="800"> <tr>
<td background="data/head_banner.jpg" height="145" width="752"> </td>
<td> </td> </tr></table>
<table cellspacing="0" cellpadding="0" width="100%"> <tr>
<td width="136"><img width="136" height="44" src="data/left_title_picture.jpg"></td>
<td background="data/title_bg.jpg" width="648"> <font size="3"><b>Colegiul Economic Transilvania</b></font></td>
<td width="17"><img width="17" height="44" src="data/right_title_corner.jpg"></td>
</tr></table><table cellspacing="0" cellpadding="0" width="100%">
<tr> <td width="213"><img width="213" height="20"
src="data/menu_up.jpg"></td> <td background="data/linelien.jpg"> </td> <td width="17"><img width="17" height="20" src="data/line _right.jpg"></td></tr></table>
<table cellspacing="0" cellpadding="0" width="100%"> <tr>
<td width="213" background="data/sub_meniu_bg.jpg" valign="top">
<table cellspacing="0" cellpadding="0" width="100%" background="data/menu_bg.jpg">
<tr> <td>
<table cellspacing="3" cellpadding="0" width="207" align="right"> <tr>
<td align="center" bgcolor="#cdcdcd" valign="middle" height="35"><a href="index.php?page=istoric" class="menulink"><b>Istoria scolii</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=bazaMateriala" class="menulink"><b>Baza materiala</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=cadre" class="menulink"><b>Personal didactic</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=profile" class="menulink"><b>Profile</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=diriginti" class="menulink"><b> Profesori diriginti</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=ListaElevi" class="menulink"><b>Catalog online</b></a></td>
</tr> <tr> <td align="center" bgcolor="#cdcdcd" valign="middle"
height="35"><a href="index.php?page=contact" class="menulink"><b>Contact</b></a></td>
</tr> </table>
</td></tr>
</table> <img width="213" height="27" src="data/meniu_down.jpg">
<img width="213" height="20" src="data/menu_up.jpg"><br> <table cellspacing="3" cellpadding="0" width="100%"
background="data/menu_bg.jpg"> <tr> <td>
<table cellspacing="0" cellpadding="0" width="202" align="right" bgcolor="#cdcdcd">
<tr><td align="center"> <form action="index.php?page=login" method="post"> Utilizator
<input name="username"type="text"><br> Parola<br> <input name="password" type="password"> <div align="left"><br><center><input name="Submit" value="Ok" type="submit"></center> </div></form>
</td> </tr>
</table> </td></tr></table> <img width="213" height="27" src="data/meniu_down.jpg"> <br><br><br><br> </td> <td bgcolor="#d8d8d8" valign="top"><table cellpadding="8"
cellspacing="0"><tr><td> <!-- Conten Area --> <?php loadContent(); ?> <!-- Conten Area END --></td> </tr></table></td> <td width="17" background="data/right_line.jpg"> </td> </tr></table>
<table cellspacing="0" cellpadding="0" width="800" align="right"> <tr>
<td> </td><td width="17"><img width="17" height="18"
src="data/corner_down_left.jpg"></td><td width="647" background="data/down_bg.jpg" align="center"><font
size="1" color="#909090"></td><td width="17"><img width="17" height="18"
src="data/corner_down_right.jpg"></td></tr>
</table> </td> <td> </td><tr>
</table></body></html>
Codul php folosit pentru încărcarea dinamică a paginilor
<?php$_GET['page'] = ($_GET['page'] )?$_GET['page'] :'noutati';
function loadContent() {if ( !(@include('pages/' . $_GET['page'] . '.php')) )
include('pages/error.php');}?>
Scriptul pentru schimbarea pozei
<head><script type="text/javascript">var counter=0var sfunction photoGallery(){if (counter%6==0){document.getElementById('photo-gallery').src = "data/b1.jpg";}if (counter%6==1){document.getElementById('photo-gallery').src = "data/b2.jpg";}if (counter%6==2){document.getElementById('photo-gallery').src = "data/b3.jpg";}if (counter%6==3){document.getElementById('photo-gallery').src = "data/b4.jpg";}if (counter%6==4){document.getElementById('photo-gallery').src = "data/b5.jpg";}if (counter%6==5){document.getElementById('photo-gallery').src = "data/b6.jpg";}if (counter%6==6){document.getElementById('photo-gallery').src = "data/b7.jpg";}counter=counter+1s=setTimeout("photoGallery()",2000)}</script></head><body onLoad="photoGallery()"> <p><strong><em>Scoala dispune de un corp de cladire cu 16 sali de clasa dintre care 10 sunt sali specializate pentru studiul unor discipline de invatamant ca : economia, istoria, limba si literatura romana, matematica, contabilitate, merceologie, tehnologie turistica, dreptul, biologia, geografia. Scoala este dotata cu doua laboratoare pentru fizica si chimie, trei laboratoare de instruire practica in domeniul alimentatiei publice, doua cabinete de informatica, sase cabinete de instruire practica in domeniul comertului si dactilografiei, opt cabinete pentru studiul limbilor moderne. Biblioteca scolii are un numar de 40.000 volume. Baza materiala cuprinde deasemenea o sala de gimnastica, un
internat cu doua corpuri de cladire in care pot fi cazati peste 300 elevi si o cantina moderna in care servesc masa 180 elevi/serie</em></strong> <br> <strong><em> Cabinetul de informatica al scolii este dotat cu 14 computere,doua imprimante un scannar legate in retea si este conectat la Internet, elevii avand acces la el.</em></strong></p><center>
<img src="data/b1.jpg" id="photo-gallery"></center></body>
<center><table BORDER CELLPADDING=7 WIDTH="100%" > <tr>
<td VALIGN=TOP WIDTH="33%"><b><font face="Tahoma">Nume si prenume</font></b></td> <td VALIGN=TOP WIDTH="49%"><b><font face="Tahoma">Functia si specialitatea</font></b></td> <td VALIGN=TOP WIDTH="18%"><center> <b><font face="Tahoma">Gradul didactic</font></b> </center></td> </tr> <tr> <td VALIGN=TOP WIDTH="33%"><b><font face="Tahoma">Laslo Simion </font></b></td> <td VALIGN=TOP WIDTH="49%"><font face="Tahoma">Director </font></td> <td VALIGN=TOP WIDTH="18%"><center> <font face="Tahoma">I</font> </center></td> </tr>Etc...
Cod php pentru popularea tabelului cu elevi din baza de date<?php$dhb=mysql_connect ("localhost", "root", "") or die ( 'Conexiunea nu a fost realizata. Codul erorii este:' . mysql_error()) ;mysql_select_db ("eco");?>
<?phpecho '<table border="1" bordercolor="" width="500" bgcolor="">';echo'<tr><td width="50"> Numar<br> matricol </td><td><center> Nume</center> </td><td><center> Clasa<center></td><td><center>Media</center></td></tr>';$qry="SELECT `elev`.`nume` , `elev`.`Clasa` , `mg`.`mg` , `elev`.`nrmat`FROM elev, mg
WHERE `elev`.`nrmat` = `mg`.`nrmat`";$result = mysql_query($qry) or die(mysql_error());while ($row = mysql_fetch_array($result)){$nrmat=$row["nrmat"];$nume=$row["nume"];$class=$row["Clasa"];$mg=$row["mg"];echo"<tr><td> $nrmat </td><td> $nume </td><td> $class </td><td> $mg </td></tr>";}echo'</table>';?>
Cod php pentru preluarea adreselor persoanelor de contact
<?php echo 'Adrese de contact pentru calalogul virtual<br><br>'; $result = mysql_query("SELECT * FROM user ORDER BY `rank` DESC ") or die(mysql_error());
while ($row = mysql_fetch_array($result)){echo $row['nume'];if($row['rank']==1){
echo ' - Profesor/Profesoara';}if($row['rank']==2){
echo ' - Sef(a) de catedra';}if($row['rank']==3){
echo ' - Secretara';}if($row['rank']==4){
echo ' - Administrator Technic';}if($row['rank']==5){
echo ' - Director/Directoare';}echo ' - '.$row["mail"];echo '<br>';}
?>
Cod html pentru formularul de contact
<CENTER><table border="4" width="500" bordercolor="#0000CC" bordercolordark="#0000CC" bordercolorlight="#0000CC" bgcolor="#9999FF" background="img/blue.jpg"><TR><TH> <form method="post" action="index.php?page=sendmail"> <p><?php$ip = getenv("REMOTE_ADDR");?><input type="hidden" name="ip" value="<?php echo $ip ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" /><input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /><font color="black"> </font> <font size="3" color="black"> </font><font size="3" color="black">Nume si Prenume: </font><input type="text" name="visitor" size="50" /> </p> <p><br /><font size="3" color="black"> Email: </font><input type="text" name="visitormail" size="50" /></p> <p><br /><font size="3" color="black"> Subiect: </font><input type="text" name="subject" size="50" /></p> <p><br /><font size="3" color="black">Textul comentariului:</font><br /><textarea name="notes" rows="7" cols="70"></textarea><br /><input type="submit" value="Trimite" /><br /></p> </form></TH></TR></TABLE></CENTER>
Script php pentru login<?phpif (empty($_POST['username'])){die ('Nu ati introdus numele de utilizator');}if (empty($_POST['password'])){die ('Nu ati introdus parola');}$username = $_POST['username'];$password = $_POST['password'];$result = mysql_query("SELECT * FROM user WHERE userN='". $username."'") or die(mysql_error());while ($row = mysql_fetch_array($result)){$dbpassword= $row['pass'];
$rank=$row['rank'];}if(empty($dbpassword)){exit('Acest user nu exista');}if($password==$dbpassword){setcookie("UserName", $username,time()+1800);setcookie("Pass", $password,time()+1800);setcookie("RANK", ($rank*5)+1,time()+1800);echo 'Veti fi redirectionati<br><meta http-equiv="refresh" content="1; url=index.php?page=PaginaAdministrare">';}else {echo ('Parola gresita.');}?>
Script crearea câmpuri şi verificare dacă utilizatorul este valid
<?php$username=$_COOKIE["UserName"];$passsword=$_COOKIE["Pass"];$rank=($_COOKIE["RANK"]-1)/5;if (empty($passsword)){die('Va rugam logati-va din nou.');}if (empty($username)){die('Va rugam logati-va din nou.');}$result = mysql_query("SELECT * FROM user WHERE userN='". $username."'") or die(mysql_error());while ($row = mysql_fetch_array($result)){$password=$row["pass"];}if ($password==$passsword){echo '<form action="index.php?page=PaginaInregistrare" method="POST"><table border="0" cellpadding="5" cellspacing="0" width="100%">
<tr valign="top"> <td width="50%">Numar matricol*:<br> </td> <td> <input name="nr" type="text"></td> </tr> <tr valign="top"> <td width="50%">Nume*: </td> <td> <input name="name" type="text"></td> </tr> <tr valign="top"> <td width="50%">Clasa*: </td> <td> <input name="Class" type="text"></td> </tr> <tr valign="top"> <td width="50%">Media Generala: </td> <td> <input name="mg" type="text"></td> </tr> <tr valign="top"> </td> </td>
<td> <center><input type="submit" value="Inscriere"></center></td> </tr> </table></form>';}else{die('<meta http-equiv="refresh" content="0; url=index.php">');}?>
Script adăugare elev în baza de date
<?php$username=$_COOKIE["UserName"];$passsword=$_COOKIE["Pass"];$rank=($_COOKIE["RANK"]-1)/5;if (empty($passsword)){die('Va rugam logati-va din nou.');}if (empty($username)){die('Va rugam logati-va din nou.');}$result = mysql_query("SELECT * FROM user WHERE userN='". $username."'") or die(mysql_error());while ($row = mysql_fetch_array($result)){$password=$row["pass"];}if ($password==$passsword){$nr=$_POST["nr"];$nume=$_POST["name"];$clasa=$_POST["Class"];$mg=$_POST["mg"];if(empty($nr)){echo'Nu ati introdus numarul matricol.';}if(empty($nume)){echo'Nu ati introdus numele.';}
if(empty($clasa)){echo'Nu ati introdus clasa.';}
$qry="INSERT INTO `eco`.`elev` (`nrmat` ,`nume` ,`clasa` ,`lastModif`)VALUES ($nr, '$nume', '$clasa', '$rank');";$result = mysql_query($qry) or die("Acest numar matricol probabil exista deja. Incercati din nou.".mysql_error());$qry="INSERT INTO `eco`.`mg` (`nrmat` ,`mg`)VALUES ('$nr', '$mg');";$result = mysql_query($qry) or die("Acest numar matricol probabil exista deja. Incercati din nou. Error:".mysql_error());echo 'Elev adaugat. ';echo '<meta http-equiv="refresh" content="1; url=index.php?page=PaginaAdministrare">';}else{die('<meta http-equiv="refresh" content="0; url=index.php">');}?>