L5 final TXT ------------------------------------------------------------------------ produse.txt ------------------------------------------------------------------------ papetarie carte mai multe pagini scrise legate 100 0 papetarie caiet mai multe pagini goale legate 75 0 instrumente penar loc de depozitat instrumente de scris 150 0 instrumente stilou instrument de scris albastru 125 0 instrumente creion instrument de scris gri 25 0 papetarie hartie scris mai multe pagini goale NElegate 50 0 instrumente marker instrument de scris verde 25 0 audio-video cd canta 50 0 audio-video dvd vizual 100 0 audio-video blue ray vizual extrem 500 0 ------------------------------------------------------------------------ antet.php ------------------------------------------------------------------------ Magazin online Firma X SRL $valori[2], "pret" => $valori[3], "cant" => $valori[4]); } ?>

Magazin online Firma X SRL

------------------------------------------------------------------------ subsol.php ------------------------------------------------------------------------

------------------------------------------------------------------------ lista_categ.php ------------------------------------------------------------------------

Categorii Produse

Alegeti categoria:

$lista_categ) {?>

Nr.	Categorie	Total Produse

	Toate Categoriile

Total produse:

------------------------------------------------------------------------ formular.php ------------------------------------------------------------------------

Realizati comanda

------------------------------------------------------------------------ rezultat.php ------------------------------------------------------------------------

Rezultate comanda

Pret total (fara TVA): $lista_categ) foreach ($lista_categ as $prod => $cant) { $pret += $cant*$produse[$categ][$prod]['pret']; $afis .= "+".$cant."x".$produse[$categ][$prod]['pret']; } echo $pret; ?>

Obtinut astfel:

Pret total (cu TVA):

"; print_r ($_POST); echo ""; ?>

Comanda receptionata la data:

------------------------------------------------------------------------ L5 final XML lista.xml ------------------------------------------------------------------------ mai multe pagini scrise legate carte 100 0 mai multe pagini goale legate caiet 75 0 mai multe pagini goale NElegate hartie scris 50 0 loc de depozitat instrumente de scris penar 150 0 instrument de scris albastru stilou 125 0 instrument de scris gri creion 25 0 canta cd 50 0 vizual dvd 100 0 vizual extrem blue ray 500 0 ------------------------------------------------------------------------ antet.php ------------------------------------------------------------------------ Magazin online Firma X SRL categorie as $categorie) { $produse[(string)$categorie["nume"]]=array(); foreach ($categorie->produs as $prod_cur) { $produse[(string)$categorie["nume"]][(string)$prod_cur->nume]=array ("descr" => (string)$prod_cur->desc, "pret" => (string)$prod_cur->pret, "cant" => (string)$prod_cur->cant); } } } ?> ------------------------------------------------------------------------ $hostname = "localhost"; $database = "tmpaw"; $username = "web"; $password = "test"; $conex= mysql_connect($hostname, $username, $password); mysql_select_db($database, $conex); $query = "SELECT * FROM `categorii` AS c"; $result_c = mysql_query($query, $conex) or die(mysql_error()); $row_result_c = mysql_fetch_assoc($result_c); $totalRows_result = mysql_num_rows($result_c); do { $query = "SELECT * FROM `produse` AS p WHERE `id_categ` = ".$row_result_c['id_categ']; $result_p = mysql_query($query, $conex) or die(mysql_error()); $row_result_p = mysql_fetch_assoc($result_p); $totalRows_result = mysql_num_rows($result_p); $produse[$row_result_c['nume']]=array(); do { $produse[$row_result_c['nume']][$row_result_p['nume']]=array ("descr" => $row_result_p['detalii'], "pret" => $row_result_p['pret'], "cant" => $row_result_p['cant']); } while ($row_result_p = mysql_fetch_assoc($result_p)); } while ($row_result_c = mysql_fetch_assoc($result_c)); ------------------------------------------------------------------------ $hostname = "localhost"; $database = "tmpaw"; $username = "web"; $password = "test"; $conex= mysql_connect($hostname, $username, $password); mysql_select_db($database, $conex); $query = "SELECT p.*, c.`nume` AS `nume_categ` FROM `produse` AS p LEFT JOIN `categorii` AS c ON (c.`id_categ` = p.`id_categ`)"; $result = mysql_query($query, $conex) or die(mysql_error()); $row_result = mysql_fetch_assoc($result); $totalRows_result = mysql_num_rows($result); do { $produse[$row_result['nume_categ']][$row_result['nume']]=array ("descr" => $row_result['detalii'], "pret" => $row_result['pret'], "cant" => $row_result['cant']); } while ($row_result = mysql_fetch_assoc($result)); ------------------------------------------------------------------------ ------------------------------------------------------------------------ query ("SELECT 'Please do not use the mysql extension ' AS _msg FROM DUAL"); $row = $res->fetch_assoc(); echo $row['_msg']; $mysql = mysql_connect("example.com", "user", "password"); mysql_select_db("test"); $res = mysql_query("SELECT ' for new developments.' AS _msg FROM DUAL", $mysql); $row = mysql_fetch_assoc($res); echo $row['_msg']; ------------------------------------------------------------------------ ------------------------------------------------------------------------ $hostname = "localhost"; $database = "tmpaw"; $username = "web"; $password = "test"; $conex= mysql_connect($hostname, $username, $password); mysql_select_db($database, $conex); $query = "SELECT p.*, c.`nume` AS `nume_categ` FROM `produse` AS p LEFT JOIN `categorii` AS c ON (c.`id_categ` = p.`id_categ`)"; $result = mysql_query($query, $conex) or die(mysql_error()); $row_result = mysql_fetch_assoc($result); $totalRows_result = mysql_num_rows($result); do { $produse[$row_result['nume_categ']][$row_result['nume']]=array ("descr" => $row_result['detalii'], "pret" => $row_result['pret'], "cant" => $row_result['cant']); } while ($row_result = mysql_fetch_assoc($result)); ------------------------------------------------------------------------ ------------echivalent cu:---------------------------------------------- ------------------------------------------------------------------------ $hostname = "localhost"; $database = "tmpaw"; $username = "web"; $password = "test"; //$conex= mysql_connect($hostname, $username, $password); //mysql_select_db($database, $conex); $conex = mysqli_connect($hostname, $username, $password, $database); $query = "SELECT p.*, c.`nume` AS `nume_categ` FROM `produse` AS p LEFT JOIN `categorii` AS c ON (c.`id_categ` = p.`id_categ`)"; //$result = mysql_query($query, $conex) or die(mysql_error()); $result = mysqli_query($conex, $query); //$row_result = mysql_fetch_assoc($result); $row_result = mysqli_fetch_assoc($result); //$totalRows_result = mysql_num_rows($result); $totalRows_result = mysqli_num_rows($result); do { $produse[$row_result['nume_categ']][$row_result['nume']]=array ("descr" => $row_result['detalii'], "pret" => $row_result['pret'], "cant" => $row_result['cant']); } //while ($row_result = mysql_fetch_assoc($result)); while ($row_result = mysqli_fetch_assoc($result)); ------------------------------------------------------------------------ ------------echivalent cu:---------------------------------------------- ------------------------------------------------------------------------ $hostname = "localhost"; $database = "tmpaw"; $username = "web"; $password = "test"; //$conex= mysql_connect($hostname, $username, $password); //mysql_select_db($database, $conex); //$conex = mysqli_connect($hostname, $username, $password, $database); $conex = new mysqli($hostname, $username, $password, $database); $query = "SELECT p.*, c.`nume` AS `nume_categ` FROM `produse` AS p LEFT JOIN `categorii` AS c ON (c.`id_categ` = p.`id_categ`)"; //$result = mysql_query($query, $conex) or die(mysql_error()); //$result = mysqli_query($conex, $query); $result = $conex->query( $query ); //$row_result = mysql_fetch_assoc($result); //$row_result = mysqli_fetch_assoc($result); $row_result = $result->fetch_assoc(); //$totalRows_result = mysql_num_rows($result); //$totalRows_result = mysqli_num_rows($result); $totalRows_result = $result->num_rows; do { $produse[$row_result['nume_categ']][$row_result['nume']]=array ("descr" => $row_result['detalii'], "pret" => $row_result['pret'], "cant" => $row_result['cant']); } //while ($row_result = mysql_fetch_assoc($result)); while ($row_result = $result->fetch_assoc()); ?>

Inceput | Inapoi

Magazin online Firma X SRL

------------------------------------------------------------------------ index.php ------------------------------------------------------------------------

Alegeti:

------------------------------------------------------------------------ admin_categ.php ------------------------------------------------------------------------ addChild("categorie"); $categ_nou->addAttribute("nume", $_POST["nou"]); $xml->asXML("lista.xml"); // salvare fisier $produse[$_POST["nou"]]=array(); // update matrice produse echo "

Categoria ".$_POST["nou"]." adaugata!

"; } ?>

Categorii Produse

Alegeti categoria:

$lista_categ) {?>

Nr.	Categorie	Total Produse

Total produse:

------------------------------------------------------------------------ admin_lista.php ------------------------------------------------------------------------

Lista produse in categoria

$detalii) {?>

Nr.	Produs	Descriere	Pret	Cantitate	Actiuni
					modifica
-	Produs nou				adauga

Alegeti categoria! ------------------------------------------------------------------------ admin_formular.php ------------------------------------------------------------------------ $_POST['descriere'], "pret" => $_POST['pret'], "cant" => $_POST['cantitate']); //codul care urmeaza poate fi folosit initial pentru a face conversia spre XML din alte formate $xml=new SimpleXMLElement("\n\n"); foreach ($produse as $categ => $lista_categ) { //adaugare categorie noua $categ_nou=$xml->addChild("categorie"); $categ_nou->addAttribute("nume",$categ); foreach ($lista_categ as $prod => $detalii) { //adaugare descendent tip produs in categorie $produs_nou=$categ_nou->addChild("produs"); //adaugare descendenti detalii in produs $produs_nou->addChild("nume",$prod); $produs_nou->addChild("desc",$detalii["descr"]); $produs_nou->addChild("pret",$detalii["pret"]); $produs_nou->addChild("cant",$detalii["cant"]); } } $xml->asXML("lista.xml"); // salvare fisier ?>

Alegeti categoria! (sau vezi fisierul xml in browser)

Produs in categoria

Alegeti categoria! ------------------------------------------------------------------------ $hostname = "localhost"; $database = "world"; $username = "web"; $password = "ceva"; $conex= mysql_connect($hostname, $username, $password); mysql_select_db($database, $ conex); $query = "SELECT `Code`,`Name`,`Population` FROM `country` AS c "; $result = mysql_query($ query, $ conex) or die(mysql_error()); $row_result = mysql_fetch_assoc($ result ); $totalRows_ result = mysql_num_rows($ result ); ------------------------------------------------------------------------

Nr.	Produs	Pret	Cantitate
			" type="text" value="0" size="3" maxlength="3" />
			" type="text" value="0" size="3" maxlength="3" />