Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sourcefiles:
- ____/css: conectat.css_______############################################3
- #banner {
- background-color: #cc33ff;
- height: 150px;
- }
- #meniu {
- float: left;
- width: 15%;
- }
- #continut {
- float: right;
- width: 80%;
- }
- ____/css: main.css_______###########################################
- *{
- padding: 0;
- margin: 0;
- }
- body {
- width: 900px;
- margin: 0 auto;
- }
- nav ul{
- list-style-type: none;
- }
- nav ul a {
- text-decoration: none;
- }
- ____/css: neconectat.css_______#####################################
- #banner{
- background: #cc33ff;
- height: 150px;
- }
- nav ul li {
- display: inline;
- }
- ______/functii: sql_functions.php______########################################3
- <?php
- function conectare_bd($host="localhost",$user="root",$pass="",$db="phpc8"){
- return mysqli_connect($host, $user, $pass, $db);
- }
- function inregistrare($email,$parola){
- $link = conectare_bd();
- $email= test($email);
- $parola = test($parola);
- $email = mysqli_real_escape_string($link, $email);
- $parola = mysqli_real_escape_string($link, $parola);
- $parola= md5($parola);
- $sql = "INSERT INTO utilizatori VALUES(NULL,'$email','$parola')";
- $user = checkEmail($email);
- if($user){
- return false;
- }else{
- return mysqli_query($link, $sql);
- }
- }
- function preia_utilizatori() {
- $link = conectare_bd();
- $query = "SELECT * FROM utilizatori";
- $r = mysqli_query($link, $query);
- $user = array();
- while ($email = mysqli_fetch_array($r)) {
- array_push($user, $email);
- }
- return $user;
- }
- function test($input){
- $input= trim($input);
- $input= htmlspecialchars($input);
- $input = stripslashes($input);
- return $input;
- }
- function checkEmail($email){
- $link = conectare_bd();
- $email = test ($email);
- $sql = "SELECT email from utilizatori where email='$email'";
- $r = mysqli_query($link, $sql);
- return mysqli_fetch_array($r);
- }
- function login($email, $parola){
- $link = conectare_bd();
- $email = test($email);
- $parola = test($parola);
- $email = mysqli_real_escape_string($link, $email);
- $parola = mysqli_real_escape_string($link, $parola);
- $user= checkEmail($email);
- if($user){
- // return (md5($parola) == $user['parola']);
- return 1 ;
- }else{
- return false;
- }
- }
- function adaugare_produs($denumire, $pret, $adresa_imagine){
- $link = conectare_bd();
- $denumire = test($denumire);
- $pret = test($pret);
- $adresa_imagine = test($adresa_imagine);
- //protectie sqlinjection
- // $denumire = mysqli_real_escape_string($link, $denumire);
- // $pret = mysqli_real_escape_string($link, $pret);
- // $adresa_imagine = mysqli_real_escape_string($link, $adresa_imagine);
- $sql = "insert into phpc8.produse values (NULL, '$denumire', '$pret','$adresa_imagine')";
- return mysqli_query($link, $sql);
- }
- function preia_produse(){
- $link = conectare_bd();
- $sql = "select * from produse";
- $vector_produse = array();
- $produse = mysqli_query($link, $sql);
- while($produs = mysqli_fetch_array($produse)){
- array_push($vector_produse, $produs);
- }
- return $vector_produse;
- }
- ?>
- __________/imagini_produse==============############################33
- _________/pagini/conectat/adaugare_produs.php ===##########################3
- <h1>Formular adaugare produs</h1>
- <form method="POST" enctype="multipart/form-data">
- <table>
- <tr>
- <td>
- Denumire:
- </td>
- <td>
- <input type="text" name="denumire"/>
- </td>
- </tr>
- <tr>
- <td>
- Pret:
- </td>
- <td>
- <input type="text" name="pret"/>
- </td>
- </tr>
- <tr>
- <td>
- Imagine:
- </td>
- <td>
- <input type="file" name="imagine"/>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <input type="submit" name="adauga_produs" value="adauga"/>
- </td>
- </tr>
- </table>
- </form>
- <?php
- require_once 'functii/sql_functions.php';
- if (isset($_POST['adauga_produs'])){
- $denumire = $_POST['denumire'];
- $pret= $_POST['pret'];
- if(($_FILES['imagine'])){
- if($_FILES['imagine']['error']==0){
- switch ($_FILES['imagine']['type']) {
- case 'image/jpg':
- case 'image/jpeg':
- case 'image/png':
- case 'image/bmp':
- case 'image/gif':
- $nume_nou = uniqid().$_FILES['imagine']['name'];
- $r= move_uploaded_file($_FILES['imagine']['tmp_name'], 'imagini_produse/'.$nume_nou);
- if($r){
- $rez = adaugare_produs($denumire, $pret, $nume_nou);
- if($rez){
- print 'Fisier incarcat';//pe server
- }else{
- unlink("imagini_produse/$nume_nou");
- print "eroare la salvarea in baza date";
- }
- }else{
- print "Eroare";
- }
- break;
- default: print "fisierul nu are formatul necesar";
- break;
- }
- }
- }
- }
- ?>
- _________/pagini/conectat/vizualizare_produs.php ==========######################333333
- <h1>Lista produse</h1>
- <?php
- require_once 'functii/sql_functions.php';
- $produse = preia_produse();
- if(count($produse)==0){
- print "nu exista produse";
- }
- else{
- }
- ?>
- <table witdh="500"
- border="10px solid black">
- <thead>
- <tr>
- <th>Denumire</th>
- <th>Pret</th>
- <th>Imagine</th>
- </tr>
- </thead>
- <tbody>
- <?php
- foreach($produse as $produs){
- print "<tr>";
- print "<td>".$produs['denumire']."</td>";
- print "<td>".$produs['pret']."</td>";
- print "<td>".$produs['adresa']."</td>";
- print "</tr>";
- }
- ?>
- </tbody>
- </table>
- _________/pagini/conectat/cart.php===================############################
- <html>
- <h1>Cos de cumparaturi</h1>
- </html>
- <?php
- require_once 'functii/sql_functions.php';
- if (isset($_SESSION['cos']) && $_SESSION['cos']!=null) {
- foreach($_SESSION['cos'] as $id_pr => $cant_pr) {
- $produs = preia_produs_dupa_id($id_pr);
- if ($produs) {
- print $produs['denumire']." cantitate ".$cant_pr." pret ".$produs['pret'];
- print "</br>";
- }
- }
- } else {
- print "Cos gol";
- }
- /*
- * foreach($elements as $element)
- * foreach($elements as $key => $element)
- */
- _________/pagini/neconectat/eroare.php====================================##########
- <h1>Pagina inexistenta.php
- ____/ttemplates/template_conectat.php=====================================##########
- <html>
- <header id="banner"></header>
- <nav id="meniu">
- <ul>
- <li><?php print "Welcome, " .$_SESSION['email_utilizator']; ?></li>
- <li>
- <a href="index.php">Vizualizare produse</a>
- </li>
- <li>
- <a href="index.php?p=1">Adaugare produse</a>
- </li>
- <li>
- <a href="index.php?logout">Logout</a>
- </li>
- </ul>
- </nav>
- <section id="continut">
- </br>
- <?php
- if(isset($_GET['p'])){
- if($_GET['p']=='1'){
- require_once 'pagini/conectat/adaugare_produs.php';
- }else{
- require_once 'pagini/eroare.php';
- }
- }else{
- require_once 'pagini/conectat/vizualizare_produs.php';
- }
- if (isset($_GET['logout'])) {
- session_destroy();
- header("location:index.php");
- }
- ?>
- </section>
- </html>
- ____/ttemplates/template_neconectat.php_____###########################3
- <html>
- <header id="banner"></header>
- <nav id="meniu">
- <ul>
- <li>
- <a href="index.php?p=1">Inregistrare</a>
- </li>
- <li>
- <a href="index.php">Conectare</a>
- </li>
- </ul>
- </nav>
- <section id="continut">
- <?php
- if(isset($_GET['p'])){
- if($_GET['p']=='1'){
- require_once 'pagini/neconectat/inregistrare.php';
- }else
- {
- require_once 'pagini/eroare.php';}
- }else
- {
- require_once 'pagini/neconectat/conectare.php';
- }
- ?>
- </section>
- </html>
- _______________index.php __________######################
- <?php
- session_start();
- if(isset($_POST['conectare'])){
- require_once 'functii/sql_functions.php';
- $e = $_POST['email'];
- $p = $_POST['parola'];
- $r= login($e, $p);
- if($r){
- if(isset($_SESSION['eroare_login'])){
- unset($_SESSION['eroare_login']);}
- $_SESSION['email_utilizator'] = $e;
- } else{
- $_SESSION['eroare_login']='Conectare esuata';
- }
- }
- ?>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- <link type="text/css" rel="stylesheet" href="css/main.css"/>
- <?php
- if(isset($_SESSION['email_utilizator'])){
- ?>
- <link type="text/css" rel="stylesheet" href="css/neconectat.css"/>
- <?PHP
- }else{
- ?>
- <link type="text/css" rel="stylesheet" href="css/neconectat.css"/>
- <?php
- }
- ?>
- </head>
- <body>
- <?php
- if(isset($_SESSION['email_utilizator'])){
- require_once 'ttemplates/template_conectat.php';
- }else{
- require_once 'ttemplates/template_neconectat.php';
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement