Magazin Virtual Proiect

Proiectul consta in realizarea unui site web ce reprezinta un magazin electronic, mai bine spus un magazin virtual. Asta inseamna ca o firma isi prezinta produsele pe care le are in stoc, vizitatorul (in speta clientul) avand posibilitatea de a alege produsele dorite si de a face comanda on-line, completand un formular. Dupa ce isi introduce si datele de contact (datele personale), clientul va putea analiza factura proforma corespunzatoare comenzii facute si o va putea printa.

Limbajele folosite pentru realizarea site-ului sint HTML, PHP, JAVASCRIPT.

Toate produsele magazinului si caracteristicile acestora sint stocate intr-o baza de date, iar afisarea acestora pe pagina se face cu ajutorul unor scripturi PHP ce interogheaza aceasta baza de date. Serverul de baza de date folosit este MySQL.

=== dosar ===

Facultatea de Automatica si Calculatoare

Proiect CI

Magazin electronic

http://gimi.onlineservice.ro/laur/upload/index.php

Proiectul consta in realizarea unui site web ce reprezinta un magazin electronic, mai bine spus un magazin virtual. Asta inseamna ca o firma isi prezinta produsele pe care le are in stoc, vizitatorul (in speta clientul) avand posibilitatea de a alege produsele dorite si de a face comanda on-line, completand un formular. Dupa ce isi introduce si datele de contact (datele personale), clientul va putea analiza factura proforma corespunzatoare comenzii facute si o va putea printa.

Limbajele folosite pentru realizarea site-ului sint HTML, PHP, JAVASCRIPT.

Toate produsele magazinului si caracteristicile acestora sint stocate intr-o baza de date, iar afisarea acestora pe pagina se face cu ajutorul unor scripturi PHP ce interogheaza aceasta baza de date. Serverul de baza de date folosit este MySQL.

La inceput, partea de administrare a site-ului presupune rularea unui script (createtable.php) care creaza tabelele aferente categoriilor de produse. Odata create tabelele, trebuie introduse datele (produsele si caracteristicile acestora), acest lucru realizandu-se prin executia unui script de inserare: insert.php.

Site-ul contine o pagina de start in care se face o atentionare ca este vorba de un site pur didactic, paginile cu produsele “scoase la vanzare” (aceste obiecte fiind preluate direct din baza de date), o pagina cu cosul de cumparaturi in care apar produsele alese de client, o pagina in care se cer datele personale ale cumparatorului si ultima pagina reprezinta factura proforma cu datele despre furnizor, cumparator si produsele cumparate.

Principala problema a proiectului consta in realizarea cosului de cumparaturi, care trebuie sa fie tot timpul accesibil clientului, adica sa poata fi vizibil de pe orice pagina, in orice moment, indiferent daca s-au facut cumparaturi pana atunci sau nu.

Obiectele din cos nu trebuie stocate in baza de date, ceea ce inseamna ca ele trebuie sa fie inregistrate intr-un fel, pentru a putea ramane efectiv in cos, mai exact pentru a putea fi retinute (transportate) de la o pagina la alta. Pentru aceasta am folosit lucrul cu sesiuni. Astfel, inca de la inceput, din index.php, sint inregistrate sesiunile cu obiectele care vor alcatui cosul de cumparaturi:

session_register("prod"); – pentru PRODUS

session_register("marc"); – pentru MARCA

session_register("cant"); – pentru CANTITATE

session_register("pretu"); – pentru PRETUL UNITAR

session_register("prett"); – pentru PRETUL TOTAL

Odata intrat pe o pagina cu produse, clientul poate vedea o lista cu acestea, le poate selecta pentru cumparare, poate vedea cosul de cumparaturi sau poate adauga in acesta. Pentru a face o deosebire intre adaugare si vizualizare, mai exact pentru a nu se adauga un produs in cos daca se doreste doar vizualizarea acestuia, am folosit o variabila cos, care poate fi 0 sau !0, adaugarea in cos facandu-se doar cand aceasta ia o valoare diferita de 0.

Dupa ce s-a adaugat un produs in cos, clientul poate continua aceasta operatie sau poate termina “cumparaturile”, urmand sa-si introduca datele personale.

Dat fiind faptul ca acest proiect este realizat doar in scop didactic, datele cerute nu contin informatii despre banca, firma, cod fiscal, etc. ci doar date personale ce includ nume si prenume, adresa, telefon, etc.

Pentru a valida datele introduse am implementat niste functii JavaScript, in acest fel clientul fiind obligat sa introduca date in toate campurile.

Dupa ce si-a introdus si datele personale, utilizatorul ajunge la pagina finala, care reprezinta factura fiscala. In aceasta apar datele furnizorului, datele clientului (introduse ulterior), produsele cumparate, precum si suma totala de plata. Obiectele din factura proforma sint cele inregistrate in sesiuni, deci nu sint luate din baza de date. Tot de pe ultima pagina clientul poate sa printeze factura pentru a o folosi mai departe.

Tabelele din baza de date arata in felul urmator:

Tabela 1 – CD

Tabela 2 – Dischete

Tabela 3 – Tastaturi

In continuare voi prezenta sursele ce alcatuiesc site-ul web:

general.php – variabile folosite de MySQL

<?php

$mysql_host="localhost"; // serverul mySql

$mysql_user=""; // utilizatorul

$mysql_pass=""; // parola

$baza="magazin"; // baza de date

$tabela1="cd"; // tabela cd-uri

$tabela2="dischete"; // tabela dischete

$tabela3="tastaturi"; // tabela tastaturi

?>

createtable.php – creaza tabelele

<?php

include("general.php");

// conectarea la serverul mysql

$link=mysql_connect($mysql_host, $mysql_user, $mysql_pass) or

die("Nu s-a putut face conectarea la baza de date!");

// incerc sa creez baza de date

mysql_create_db("$baza");

// mysql_errno() intoarce 0 daca nu sunt erori si 1007 daca

// baza de date exista deja

if( mysql_errno()!=0 & mysql_errno()!=1007 ) die("Nu s-a putut

crea baza de date!");

// incerc sa selectez baza de date

mysql_select_db("$baza") or die("Nu s-a putut selecta baza de date!");

//creez tabelele

mysql_query("CREATE TABLE IF NOT EXISTS $tabela1(

numar int(100) not null auto_increment,

marca varchar(50), capacitatea int(100), pret int(100),

primary key(numar));")

or die("Nu s-a putut crea tabela CD!");

mysql_query("CREATE TABLE IF NOT EXISTS $tabela2(

numar int(100) not null auto_increment,

marca varchar(50), pret int(100),

primary key(numar));")

or die("Nu s-a putut crea tabela dischete!");

mysql_query("CREATE TABLE IF NOT EXISTS $tabela3(

numar int(100) not null auto_increment,

marca varchar(50), tip varchar(50), pret int(100),

primary key(numar));")

or die("Nu s-a putut crea tabela tastaturi!");

mysql_close($link);

?>

insert.php – insereaza datele in tabelele

<?php

include("general.php");

// conectarea la serverul mysql

$link=mysql_connect($mysql_host, $mysql_user, $mysql_pass) or

die("Nu s-a putut face conectarea la baza de date!");

// incerc sa selectez baza de date

mysql_select_db("$baza") or die("Nu s-a putut selecta baza de date!");

//inserez datele in tabele

mysql_query("INSERT into $tabela1 values('', 'PHILIPS', '650', '30000');");

mysql_query("INSERT into $tabela1 values('', 'PHILIPS', '700', '35000');");

mysql_query("INSERT into $tabela1 values('', 'TDK', '650', '25000');");

mysql_query("INSERT into $tabela1 values('', 'TDK', '700', '30000');");

mysql_query("INSERT into $tabela1 values('', 'TRAXDATA', '650', '20000');");

mysql_query("INSERT into $tabela1 values('', 'TRAXDATA', '700', '25000');");

mysql_query("INSERT into $tabela1 values('', 'SKY', '650', '15000');");

mysql_query("INSERT into $tabela1 values('', 'SKY', '700', '20000');");

mysql_query("INSERT into $tabela2 values('', 'SONY', '20000');");

mysql_query("INSERT into $tabela2 values('', 'IMATION', '15000');");

mysql_query("INSERT into $tabela2 values('', 'EMTEC', '10000');");

mysql_query("INSERT into $tabela3 values('', 'MICROSOFT', 'standard', '1000000');");

mysql_query("INSERT into $tabela3 values('', 'MICROSOFT', 'multimedia', '1200000');");

mysql_query("INSERT into $tabela3 values('', 'MICROSOFT', 'ergonomica', '1500000');");

mysql_query("INSERT into $tabela3 values('', 'LOGITECH', 'standard', '500000');");

mysql_query("INSERT into $tabela3 values('', 'LOGITECH', 'multimedia', '700000');");

mysql_query("INSERT into $tabela3 values('', 'LOGITECH', 'ergonomica', '900000');");

mysql_query("INSERT into $tabela3 values('', 'GENIUS', 'standard', '200000');");

mysql_query("INSERT into $tabela3 values('', 'GENIUS', 'multimedia', '350000');");

mysql_query("INSERT into $tabela3 values('', 'GENIUS', 'ergonomica', '500000');");

mysql_close($link);

?>

index.php – fisierul index

<?

session_register("nr");

$nr=0;

session_register("prod");

session_register("marc");

session_register("cant");

session_register("pretu");

session_register("prett");

?>

<HTML>

<!–

Lazar Radu

–>

<script>

function go()

{

window.location="cd.php"

}

</script>

<body bgcolor=black onLoad="alert('ATENTIE! Acest site este realizat numai in scop didactic!'); go()">

</HTML>

cd.php – pentru categoria CD

<?php

// preiau setarile referitoare la baza de date

include("general.php");

// incerc sa ma conectez la serverul mysql

mysql_connect($mysql_host, $mysql_user, $mysql_pass);

// incerc sa selectez baza de date

mysql_select_db("$baza")or die("Nu s-a putut selecta baza de date!");

$string="SELECT distinct marca from $tabela1";

$result=mysql_query($string);

$numar=mysql_numrows($result);

$string1="SELECT distinct capacitatea from $tabela1";

$result1=mysql_query($string1);

$numar1=mysql_numrows($result1);

?>

<HTML>

<!–

Lazar Radu – 354C3

–>

<style>

A:link {color:#000080; text-decoration="none"}

A:visited {color:#000080; text-decoration="none"}

A:hover {color:red; text-decoration="underline overline"}

BODY {

SCROLLBAR-HIGHLIGHT-COLOR: green;

SCROLLBAR-3DLIGHT-COLOR: green;

SCROLLBAR-TRACK-COLOR: #000000;

SCROLLBAR-DARKSHADOW-COLOR: green

}

</style>

<HEAD>

<TITLE>CD</TITLE>

<SCRIPT language="JavaScript">

//functia valideaza form-urile

function validare(){

if(document.formular.marca[0].selected)

{

alert('Alegeti marca de CD!')

document.formular.marca.focus()

return false

}

return true

}

</SCRIPT>

</HEAD>

<BODY onLoad=document.formular.reset()>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr>

<td width="65%"><IMG src="files/cd.jpg" width=60></td>

<td width="35%" bgcolor='green' align=center><font face="Verdana,Arial" size="2" color='white'><b>Comanda on-line CD Blank</b></font></td>

</tr>

</table>

<BR>

<BR>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr bgcolor="silver">

<td align="center"><a href="cd.php">| &nbsp;CD Blank&nbsp; |</td>

<td align="center"><a href="dischete.php">| &nbsp;Dischete&nbsp; |</td>

<td align="center"><a href="tastaturi.php">| &nbsp;Tastaturi&nbsp; |</td>

</tr>

</table>

<BR>

<BR>

<center><h1>Categoria CD Blank</h1></center>

<BR>

<BR>

<form name="formular" onSubmit="return validare()" method="post" action="cos.php">

<input type="hidden" name="categorie" value="CD">

<input type="hidden" name="cos" value="1">

<font face="Verdana,Arial" size='2' color='green'><b>Selectati marca de CD:</b>

<select name="marca">

<option selected>……

<?

for($i=0;$i<$numar;$i++){

$marca=mysql_result($result,$i,"marca");

print "<option>$marca";

}

?>

</select></font>

<BR>

<BR>

<font face="Verdana,Arial" size='2' color='green'><b>Selectati capacitatea:</b></font>

<br>

<?

for($i=0;$i<$numar1;$i++){

$capacitatea=mysql_result($result1,$i,"capacitatea");

if($i==0)

print "<input type='radio' name='capacitatea' value='$capacitatea' checked>$capacitatea MB<br>";

else

print "<input type='radio' name='capacitatea' value='$capacitatea'>$capacitatea MB<br>";

}

?>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Selectati cantitatea (buc):</b></font>

<br>

<input type="radio" name="cantitate" value="10" checked>10 buc<br>

<input type="radio" name="cantitate" value="20">20 buc<br>

<input type="radio" name="cantitate" value="50">50 buc<br>

<input type="radio" name="cantitate" value="100">100 buc<br>

</P>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Modalitatea de plata:</b></font>

<br>

<input type="radio" name="plata" value="card bancar">Card bancar

<br>

<input type="radio" name="plata" value="cash" checked>Cash

</P>

<HR color='green' width="60%"><br>

<center>

<input type="submit" name="ok" value="Adauga">

<input type="reset" value="Sterge"><BR>

<BR>

<IMG width=50 src="files/cos.jpg"><BR>

<font size="-1"><a href="cos.php?cos=0">Vizualizeaza cos </a></font>

</center>

</form>

<center><FONT face=courier size=1>&copy; 2003 <i>RaduL</i>

</BODY>

</HTML>

dischete.php – pentru categoria Dischete

<?php

// preiau setarile referitoare la baza de date

include("general.php");

// incerc sa ma conectez la serverul mysql

mysql_connect($mysql_host, $mysql_user, $mysql_pass);

// incerc sa selectez baza de date

mysql_select_db("$baza")or die("Nu s-a putut selecta baza de date!");

$string="SELECT distinct marca from $tabela2";

$result=mysql_query($string);

$numar=mysql_numrows($result);

?>

<HTML>

<!–

Lazar Radu – 354C3

–>

<style>

A:link {color:#000080; text-decoration="none"}

A:visited {color:#000080; text-decoration="none"}

A:hover {color:red; text-decoration="underline overline"}

BODY {

SCROLLBAR-HIGHLIGHT-COLOR: green;

SCROLLBAR-3DLIGHT-COLOR: green;

SCROLLBAR-TRACK-COLOR: #000000;

SCROLLBAR-DARKSHADOW-COLOR: green

}

</style>

<HEAD>

<TITLE>DISCHETE</TITLE>

<SCRIPT language="JavaScript">

//functia valideaza form-urile

function validare(){

if(document.formular.marca[0].selected)

{

alert('Alegeti marca de discheta!')

document.formular.marca.focus()

return false

}

return true

}

</SCRIPT>

</HEAD>

<BODY onLoad=document.formular.reset()>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr>

<td width="65%"><IMG src="files/disc.jpg" width=50></td>

<td width="35%" bgcolor='green' align=center><font face="Verdana,Arial" size="2" color='white'><b>Comanda on-line Dischete</b></font></td>

</tr>

</table>

<BR>

<BR>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr bgcolor="silver">

<td align="center"><a href="cd.php">| &nbsp;CD Blank&nbsp; |</td>

<td align="center"><a href="dischete.php">| &nbsp;Dischete&nbsp; |</td>

<td align="center"><a href="tastaturi.php">| &nbsp;Tastaturi&nbsp; |</td>

</tr>

</table>

<BR>

<BR>

<center><h1>Categoria Dischete</h1></center>

<BR>

<BR>

<form name="formular" onSubmit="return validare()" method="post" action="cos.php">

<input type="hidden" name="categorie" value="Discheta">

<input type="hidden" name="cos" value="1">

<font face="Verdana,Arial" size='2' color='green'><b>Selectati marca de discheta:</b>

<select name="marca">

<option selected>……

<?

for($i=0;$i<$numar;$i++){

$marca=mysql_result($result,$i,"marca");

print "<option>$marca";

}

?>

</select></font>

<BR>

<BR>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Selectati cantitatea (buc):</b></font>

<br>

<input type="radio" name="cantitate" value="10" checked>10 buc<br>

<input type="radio" name="cantitate" value="20">20 buc<br>

<input type="radio" name="cantitate" value="50">50 buc<br>

<input type="radio" name="cantitate" value="100">100 buc<br>

</P>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Modalitatea de plata:</b></font>

<br>

<input type="radio" name="plata" value="card bancar">Card bancar

<br>

<input type="radio" name="plata" value="cash" checked>Cash

</P>

<HR color='green' width="60%"><br>

<center>

<input type="submit" name="ok" value="Adauga">

<input type="reset" value="Sterge"><BR>

<BR>

<IMG width=50 src="files/cos.jpg"><BR>

<font size="-1"><a href="cos.php?cos=0">Vizualizeaza cos </a></font>

</center>

</form>

<center><FONT face=courier size=1>&copy; 2003 <i>RaduL</i>

</BODY>

</HTML>

tastaturi.php – pentru categoria Tastaturi

<?php

// preiau setarile referitoare la baza de date

include("general.php");

// incerc sa ma conectez la serverul mysql

mysql_connect($mysql_host, $mysql_user, $mysql_pass);

// incerc sa selectez baza de date

mysql_select_db("$baza")or die("Nu s-a putut selecta baza de date!");

$string="SELECT distinct marca from $tabela3";

$result=mysql_query($string);

$numar=mysql_numrows($result);

$string1="SELECT distinct tip from $tabela3";

$result1=mysql_query($string1);

$numar1=mysql_numrows($result1);

?>

<HTML>

<!–

Lazar Radu – 354C3

–>

<style>

A:link {color:#000080; text-decoration="none"}

A:visited {color:#000080; text-decoration="none"}

A:hover {color:red; text-decoration="underline overline"}

BODY {

SCROLLBAR-HIGHLIGHT-COLOR: green;

SCROLLBAR-3DLIGHT-COLOR: green;

SCROLLBAR-TRACK-COLOR: #000000;

SCROLLBAR-DARKSHADOW-COLOR: green

}

</style>

<HEAD>

<TITLE>TASTATURI</TITLE>

<SCRIPT language="JavaScript">

//functia valideaza form-urile

function validare(){

if(document.formular.marca[0].selected)

{

alert('Alegeti marca de tastatura!')

document.formular.marca.focus()

return false

}

return true

}

</SCRIPT>

</HEAD>

<BODY onLoad=document.formular.reset()>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr>

<td width="65%"><IMG src="files/tast.jpg" width=80></td>

<td width="35%" bgcolor='green' align=center><font face="Verdana,Arial" size="2" color='white'><b>Comanda on-line Tastaturi</b></font></td>

</tr>

</table>

<BR>

<BR>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr bgcolor="silver">

<td align="center"><a href="cd.php">| &nbsp;CD Blank&nbsp; |</td>

<td align="center"><a href="dischete.php">| &nbsp;Dischete&nbsp; |</td>

<td align="center"><a href="tastaturi.php">| &nbsp;Tastaturi&nbsp; |</td>

</tr>

</table>

<BR>

<BR>

<center><h1>Categoria Tastaturi</h1></center>

<BR>

<BR>

<form name="formular" onSubmit="return validare()" method="post" action="cos.php">

<input type="hidden" name="categorie" value="Tastatura">

<input type="hidden" name="cos" value="1">

<font face="Verdana,Arial" size='2' color='green'><b>Selectati marca de tastatura:</b>

<select name="marca">

<option selected>……

<?

for($i=0;$i<$numar;$i++){

$marca=mysql_result($result, $i, "marca");

print "<option>$marca";

}

?>

</select></font>

<BR>

<BR>

<font face="Verdana,Arial" size='2' color='green'><b>Selectati tipul:</b></font>

<br>

<?

for($i=0;$i<$numar1;$i++){

$tip=mysql_result($result1,$i,"tip");

if($i==0)

print "<input type='radio' name='tip' value='$tip' checked>$tip<br>";

else

print "<input type='radio' name='tip' value='$tip'>$tip<br>";

}

?>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Selectati cantitatea (buc):</b></font>

<br>

<input type="radio" name="cantitate" value="10" checked>10 buc<br>

<input type="radio" name="cantitate" value="20">20 buc<br>

<input type="radio" name="cantitate" value="50">50 buc<br>

<input type="radio" name="cantitate" value="100">100 buc<br>

</P>

<p>

<font face="Verdana,Arial" size='2' color='green'><b>Modalitatea de plata:</b></font>

<br>

<input type="radio" name="plata" value="card bancar">Card bancar

<br>

<input type="radio" name="plata" value="cash" checked>Cash

</P>

<HR color='green' width="60%"><br>

<center>

<input type="submit" name="ok" value="Adauga">

<input type="reset" value="Sterge"><BR>

<BR>

<IMG width=50 src="files/cos.jpg"><BR>

<font size="-1"><a href="cos.php?cos=0">Vizualizeaza cos </a></font>

</center>

</form>

<center><FONT face=courier size=1>&copy; 2003 <i>RaduL</i>

</BODY>

</HTML>

cos.php – cosul de cumparaturi

<?php

session_start();

if($cos!=0)

{

$nr++;

// preiau setarile referitoare la baza de date

include("general.php");

// incerc sa ma conectez la serverul mysql

mysql_connect($mysql_host, $mysql_user, $mysql_pass);

// incerc sa selectez baza de date

mysql_select_db("$baza")or die("Nu s-a putut selecta baza de date!");

if($categorie=="CD")

$string="SELECT pret from $tabela1 WHERE marca='$marca' AND capacitatea='$capacitatea'";

else

if($categorie=="Discheta")

$string="SELECT pret from $tabela2 WHERE marca='$marca'";

else

$string="SELECT pret from $tabela3 WHERE marca='$marca' AND tip='$tip'";

$result=mysql_query($string);

$pret=mysql_result($result, 0, "pret");

$total=$pret*$cantitate;

if($categorie=="CD")

{

$produs=$categorie." ".$capacitatea."MB";

}

else

if($categorie=="Dischete")

{

$produs=$categorie;

}

else

{

$produs=$categorie." ".$tip;

}

$prod[$nr]=$produs;

$marc[$nr]=$marca;

$cant[$nr]=$cantitate;

$pretu[$nr]=$pret;

$prett[$nr]=$total;

}

?>

<html>

<!–

Lazar Radu – 354C3

–>

<style>

A:link {color:#000080; text-decoration="none"}

A:visited {color:#000080; text-decoration="none"}

A:hover {color:red; text-decoration="underline overline"}

</style>

<title>COSUL DUMNEAVOASTRA</title>

<center>

<IMG src="files/cos.jpg">

<TABLE WIDTH="50%" BORDER="1" ALIGN="center" CELLSPACING="3">

<TR bgcolor="gray" align="center">

<TD>

<b>&nbsp;PRODUS&nbsp;</b></TD>

<TD>

<b>&nbsp;MARCA&nbsp;</b></TD>

<TD>

<b>&nbsp;CANTITATE (buc)&nbsp;</b></TD>

<TD>

<b>PRET UNITAR (lei)</b></TD>

<TD>

<b>PRET TOTAL (lei)</b></TD>

</TR>

<?

for($i=1;$i<=$nr;$i++){

print "<TR bgcolor='silver' align='center'>";

print "<TD>

";

print "$prod[$i]</TD>

";

print "<TD>

";

print "$marc[$i]</TD>

";

print "<TD>

";

print "$cant[$i]</TD>

";

print "<TD>

";

print "$pretu[$i]</TD>

";

print "<TD>

";

print "$prett[$i]</TD>

</TR>

";

}

?>

</table>

<table border=0 align=center>

<TR>

<TD bgcolor='gray'><b>TOTAL DE PLATA: </b>

<?

for($i=0;$i<=$nr;$i++)

$tot+=$prett[$i];

print "$tot lei";

?>

</TD>

</TR>

</table>

<BR>

<center>

<table align="center" cellspacing=30 cellpadding=30>

<tr><td>

<a href="javascript:history.back()">CONTINUA</a></td>

<td>

<a href="date.htm">TERMINA</a></td>

</tr>

</table>

</html>

date.htm – fisierul de culegere a datelor personale

<HTML>

<!–

Lazar Radu – 354C3

–>

<style>

A:link {color:#000080; text-decoration="none"}

A:visited {color:#000080; text-decoration="none"}

A:hover {color:red; text-decoration="underline overline"}

BODY {

SCROLLBAR-HIGHLIGHT-COLOR: green;

SCROLLBAR-3DLIGHT-COLOR: green;

SCROLLBAR-TRACK-COLOR: #000000;

SCROLLBAR-DARKSHADOW-COLOR: green

}

</style>

<HEAD>

<TITLE>Date personale</TITLE>

<SCRIPT language="javascript">

//functia se apeleaza la "submit" si evalueaza datele introduse

function trimite() {

if(validare())

{

return true

}

else

return false

}

//functia valideaza form-urile

function validare(){

var valoare=false

//codul postal si nr. de telefon trebuie sa fie numere!

var tel = Number(document.formular.telefon.value)

if (document.formular.nume.value == "")

{

alert('Introduceti numele si prenumele!')

document.formular.nume.focus()

}

else if (document.formular.adresa.value == "")

{

alert('Introduceti adresa!')

document.formular.adresa.focus()

}

else if (document.formular.oras.value == "")

{

alert('Introduceti orasul!')

document.formular.oras.focus()

}

else if (document.formular.judet.value == "")

{

alert('Introduceti judetul!')

document.formular.judet.focus()

}

else if (tel <= 0 || isNaN(tel))

{

alert('Introduceti corect numarul de telefon!')

document.formular.telefon.value=""

document.formular.telefon.focus()

}

//verifica daca e-mailul a fost introdus corekt

else if((document.formular.email.value == "") || (document.formular.email.value.indexOf('@', 0) == -1) || (document.formular.email.value.indexOf('.', 0) == -1))

{

alert('Adresa e-mail gresita!')

document.formular.email.value=""

document.formular.email.focus()

}

else valoare=true

return valoare

}

</SCRIPT>

</HEAD>

<BODY onLoad=document.formular.reset()>

<table border="0" width="100%" CELLPADDING="0" CELLSPACING="0">

<tr>

<td width="65%">&nbsp;</td>

<td width="35%" bgcolor='green' align=center><font face="Verdana,Arial" size="2" color='white'><b>Date Personale</b></font></td>

</tr>

</table>

<BR>

<BR>

<center><h1>Completati datele personale</h1></center>

<BR>

<BR>

<form name="formular" onSubmit="return trimite()" method="post" action="factura.php">

<table border="0" width="100%">

<tr>

<td width="100%" valign=top align=center colspan="3">&nbsp;</td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">Numele si prenume</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="nume"></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">Adresa<br>(str, nr, bl, sc, et, ap, sector)</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="adresa" size=45></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">Oras</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="oras"></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">Judet</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="judet"></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">Telefon</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="telefon" size=15></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right><font face="Verdana,Arial" size="1">E-mail</font></td>

<td width="67%" valign=middle align=left colspan="2"><font face="Verdana,Arial" size="1"><input type="text" name="email" size=25></font></td>

</tr>

<tr>

<td width="33%" valign=middle align=right>&nbsp;</td>

<td width="67%" valign=middle align=left colspan="2">&nbsp;</td>

</tr>

</table>

<HR color='green' width="60%"><br>

<center>

<input type="submit" name="ok" value="Trimite">

<input type="reset" value="Sterge">

</center>

</form>

<center>

<IMG width=50 src="files/cos.jpg"><BR>

<font size="-1"><a href="cos.php?cos=0">Vizualizeaza cos </a></font>

</BODY>

</HTML>

factura.php – fisierul care realizeaza factura proforma

<?

session_start();

?>

</HTML>

<!–

Lazar Radu – 354C3

–>

<title>FACTURA PROFORMA</title>

<body>

<center>

<TABLE borderColor=#111111 cellSpacing=0 cellPadding=0 width="90%" border=2>

<TBODY>

<TR>

<TD vAlign=top width="100%">

<CENTER>

<B><FONT face=Arial size=+1>FACTURA

PROFORMA</FONT></B></CENTER>

<BR>

<BR>

<CENTER>

<TABLE borderColor=#111111 cellSpacing=0

cellPadding=0 width="95%" border=0>

<TBODY>

<TR>

<TD width="33%">

<P>FURNIZOR: <i>RaduL SA</i></P>

<P>NR. REG. COMERTULUI: <i>RL13/1025/13.01.2002</i>

</P>

<P>COD FISCAL:<i>131313</i></P>

<P>SEDIU: <i>Bucuresti, Spl. Independentei 290, P6/303</i></P>

<P>CONT: <i>2238942</i> </P>

<P>BANCA: <i>Raiffeisen Bank, Ag. Mosilor</i></P>

</TD>

<TD vAlign=top width="34%">

<CENTER>

<TABLE borderColor=#111111 cellSpacing=0

cellPadding=0 width="70%" border=1>

<TBODY>

<TR>

<TD width="100%">

<P>DATA: <i><script>document.write(new Date())</script></i>

</P>

</TD>

</TR>

</TBODY></TABLE>

</CENTER>

</TD>

<TD vAlign=top width="32%">

<P>CUMPARATOR: <i><? print "$nume" ?></i></P>

<P>ADRESA: <i><? print "$adresa" ?></i></P>

<P>ORAS: <i><? print "$oras" ?></i></P>

<P>JUDET: <i><? print "$judet" ?></i></P>

<P>TELEFON: <i><? print "$telefon" ?></i></P>

<P>E-MAIL: <i><? print "$email" ?></i></P>

</TD>

</TR>

</TBODY></TABLE>

</CENTER>

<BR>

<DIV align=center>

<CENTER>

<TABLE borderColor=#111111 cellSpacing=0

cellPadding=0 width="95%" border=2>

<TBODY>

<TR>

<TD>

<P>Cota TVA:

19%</P>

<BR>

</TD>

</TR>

</TBODY>

</TABLE>

</CENTER>

</DIV>

<DIV align=center>

<CENTER>

<TABLE borderColor=#111111 cellSpacing=0

cellPadding=0 width="95%" border=1>

<TBODY>

<TR>

<TD width="8%">

<CENTER>

NR. CRT.</CENTER>

</TD>

<TD width="26%">

<CENTER>

PRODUS

</CENTER>

</TD>

<TD width="26%">

<CENTER>

MARCA</CENTER>

</TD>

<TD width="10%">

<CENTER>

<P>CANTITATEA </P>

<P>- buc -</P>

</CENTER>

</TD>

<TD width="10%">

<CENTER>

<P>PRET UNITAR </P>

<P>(cu TVA) </P>

<P>- lei -</P>

</CENTER>

</TD>

<TD width="20%">

<CENTER>

<P>PRET TOTAL </P>

<P>(cu TVA) </P>

<P>- lei -</P>

</CENTER>

</TD></TR>

<TR><TD width="8%">

<CENTER>

0</CENTER>

</TD>

<TD width="26%">

<CENTER>

1</CENTER>

</TD>

<TD width="6%">

<CENTER>

2</CENTER>

</TD>

<TD>

<CENTER>

3</CENTER>

</TD>

<TD width="17%">

<CENTER>

4</CENTER>

</TD>

<TD width="18%">

<CENTER>

5</CENTER>

</TD>

</TR>

<?

for($i=1;$i<=$nr;$i++){

print "<TR bgcolor='silver' align='center'>";

print "<TD>

$i</TD>

";

print "<TD>

$prod[$i]</TD>

";

print "<TD>

";

print "$marc[$i]</TD>

";

print "<TD>

";

print "$cant[$i]</TD>

";

print "<TD>

";

print "$pretu[$i]</TD>

";

print "<TD>

";

print "$prett[$i]</TD>

</TR>

";

}

?>

</TBODY></TABLE>

<table border=0 align=center>

<TR>

<TD bgcolor='gray'><b>TOTAL DE PLATA: </b>

<?

for($i=0;$i<=$nr;$i++)

$tot+=$prett[$i];

print "$tot lei";

?>

</TD>

</TR>

</table>

<BR>

</CENTER>

</DIV>

</TD>

</TR>

</TBODY></TABLE>

</DIV></TD>

</TR>

</TBODY></TABLE>

<input type="button" value="Printeaza factura" onClick="window.print()">

</CENTER>

<font size=2><a href="index.php">Inapoi la index</a></font>

</body>

</HTML>