Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <?php
- session_start();
- require_once 'functii/sql_functions.php';
- if (isset($_POST['con'])) {
- $email = $_POST['email'];
- $parola = $_POST['pass'];
- $rezultat = conectare($email, $parola);
- if ($rezultat) {
- if (isset($_SESSION['eroare'])) {
- unset($_SESSION['eroare']);
- }
- $_SESSION['email'] = $email;
- } else {
- $_SESSION['eroare'] = 'Conectare esuata';
- }
- }
- if (isset($_GET['logout'])) {
- session_destroy();
- header('location: index.php');
- }
- ///////////
- if (isset($_GET['id_pr'])) {
- //$_SESSION['cos'][5] = 2
- $idProdus = $_GET['id_pr'];
- if (isset($_SESSION['cos'][$idProdus])) {
- $_SESSION['cos'][$idProdus]++;
- } else {
- $_SESSION['cos'][$idProdus] = 1;
- }
- }
- if (isset($_GET['id_sters'])) {
- $idSters = $_GET['id_sters'];
- if ($_SESSION['cos'][$idSters] > 1) {
- $_SESSION['cos'][$idSters] --;
- } else {
- unset($_SESSION['cos'][$idSters]);
- }
- }////////////////////////////
- ?>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- <link rel="stylesheet" href="css/main.css";
- </head>
- <body>
- <?php
- require_once 'functii/sql_functions.php';
- if (isset($_SESSION['email'])) {
- require_once 'template/template_conectat.php';
- } else {
- require_once 'template/template_neconectat.php';
- }
- ?>
- </body>
- </html>
- ////////////////////// SQL FUNCTIONS
- <?php
- function conectareBD($host='localhost',$user='root', $password = '' , $database='cinema')
- {
- return mysqli_connect($host, $user, $password, $database);
- }
- function testData($input,$link){
- $input= trim($input);
- $input= htmlspecialchars($input);
- $input= stripslashes($input);
- $input= mysqli_real_escape_string($link,$input);
- return $input;
- }
- function checkUser($email){
- $link= conectareBD();
- $email= testData($email, $link);
- $query = "SELECT * FROM users WHERE email='$email'";
- $user= mysqli_query($link, $query);
- return mysqli_fetch_array($user, MYSQLI_ASSOC);
- }
- function inregistrare($nume,$prenume,$varsta,$email,$password){
- $link= conectareBD();
- $email= testData($email, $link);
- $user= checkUser($email);
- if($user)
- {
- return false;
- }
- $nume= testData($nume, $link);
- $prenume= testData($prenume, $link);
- $varsta= testData($varsta, $link);
- $password = testData($password, $link);
- $password = md5($password);
- $query = "INSERT INTO users VALUES(NULL, '$nume','$prenume','$varsta','$email','$password') ";
- return mysqli_query($link, $query);
- }
- function conectare ($email, $password){
- $link= conectareBD();
- $email= testData($email, $link);
- $password= testData($password, $link);
- $user= checkUser($email);
- if($user){
- if($user['parola'] == md5($password)){
- return $user;
- }
- else{
- return false;
- }
- }
- }
- function adaugareFilm($numeFilm, $tipFilm,$locuriDisponibile, $imagine)
- { $link= conectareBD();
- $numeFilm= testData($numeFilm, $link);
- $tipFilm= testData($tipFilm, $link);
- $locuriDisponibile = testData($locuriDisponibile, $link);
- $imagine = testData($imagine, $link);
- $query= "INSERT INTO filme VALUES(NULL, '$numeFilm','$tipFilm','$locuriDisponibile', '$imagine') ";
- return mysqli_query($link, $query);
- }
- function afisareFilm(){
- $link= conectareBD();
- $query = "SELECT * FROM filme ";
- $filmes = mysqli_query($link, $query);
- $arrayFilme=array();
- while ($filme = mysqli_fetch_array($filmes, MYSQLI_ASSOC)){
- array_push($arrayFilme,$filme);
- }
- return $arrayFilme;
- }
- function afisareFilmDupaId($id){
- $link= conectareBD();
- $id= testData($id, $link);
- $query="SELECT * FROM filme WHERE id=$id";
- $filme= mysqli_query($link, $query);
- return mysqli_fetch_array($filme, MYSQLI_ASSOC);
- }
- ?>
- ///////////// TEMPLATE CONECTAT
- <header id="banner"></header>
- <div id="meniu">
- <ul>
- <li><a href="index.php">Cumpara bilet</a></li>
- <li><a href="index.php?page=1">Adauga film</a></li>
- <li><a href="index.php?page=2">Adauga review</a></li>
- <li><a href="index.php?logout">Logout</a></li>
- </ul>
- </div>
- <section id="continut">
- <?php
- if(isset($_GET['page'])){
- $page=$_GET['page'];
- if($page==1){
- require_once 'pagini/conectat/adauga_film.php';
- }
- elseif ($page==2) {
- require_once 'pagini/conectat/adauga_review.php'; }
- else{
- require_once 'pagini/eroare.php';
- }
- }
- else{
- require_once 'pagini/conectat/cumpara_bilet.php';
- }
- ?>
- </section>
- ///////////////template NECONECTAT
- <header id="banner"></header>
- <div id="meniu">
- <ul>
- <li><a href="index.php">Home</a></li>
- <li><a href="index.php?page=1">Conectare</a></li>
- <li><a href="index.php?page=2">Inregistrare</a></li>
- <li><a href="index.php?page=3">Program Cinema</a></li>
- </ul>
- </div>
- <section id="continut">
- <?php
- if(isset($_GET['page'])){
- $page=$_GET['page'];
- if($page==1){
- require_once 'pagini/neconectat/conectare.php';
- }
- elseif ($page==2) {
- require_once 'pagini/neconectat/inregistrare.php';
- }
- elseif ($page==3) {
- require_once 'pagini/neconectat/program_cinema.php';
- }
- }
- else{
- require_once 'pagini/neconectat/home.php';
- }
- ?>
- </section>
- ////////// ADAUGA FILM
- <h1>Adauga film</h1>
- <form method="POST">
- Nume film:<input type="text" name="numeFilm"/><br>
- Ce tip de film este:<select name="tipFilm">
- <option> Actiune</option>
- <option> Comedie </option>
- <option> Drama </option>
- </select><br>
- Locuri disponibile: <input type="number" name="locuriDisponibile"/><br>
- Cover: <input type="file" name="img"/><br>
- <input type="submit" name="addfilm" value="Adauga film"/>
- </form>
- <?php
- require_once 'functii/sql_functions.php';
- if (isset($_POST['addfilm'])){
- $numeFilm=$_POST['numeFilm'];
- $tipFilm=$_POST['tipFilm'];
- $locuriDisponibile=$_POST['locuriDisponibile'];
- if($_FILES['img']) {
- if($_FILES['img']['error']==0){
- switch ($_FILES['img']['type']){
- case 'imagini/jpg';
- case 'imagini/jpeg';
- case 'imagini/png';
- case 'imagini/gif';
- $numeNou = uniqid(). $_FILES['img']['name'];
- $salvareServer = move_uploaded_file($_FILES['img']['tmp_name'],'imagini/'.$numeNou);
- if($salvareServer){
- $adaugaFilm= adaugareFilm($numeFilm, $tipFilm, $locuriDisponibile);
- if($adaugaFilm){
- print 'Film adaugat cu sucees';
- }
- else {
- print 'Eroare la salvare in BD';
- unlink('imagini/'.$numeNou);
- }
- }else{
- print 'Eroare la salvarea pe server';
- }
- break;
- default: print 'Format neacceptat';
- }
- } else {
- print 'A aparut o eroare!';
- }
- } }
- // $adaugaFilm= adaugareFilm($numeFilm, $tipFilm, $locuriDisponibile);
- // if($adaugaFilm)
- // {
- // print "Film adaugat cu succes";
- // }
- // else {
- // print "Eroare la adaugarea filmului";
- // }
- ?>
- ///// CUMPARA BILET
- <h1>Cumpara bilet</h1>
- <?php
- require_once 'functii/sql_functions.php';
- $filmes = afisareFilm();
- if(count($filmes)==0){
- print "Nu exista filme disponibile";
- }
- else{
- ?>
- <table border="1" width="300px">
- <tr>
- <th>Nume film</th>
- <th>Tip filme</th>
- <th>Locuri disponibile</th>
- </tr>
- <tr>
- <?php
- foreach ($filmes as $filme){
- print "<td>". $filme[nume_film] . "</td>";
- print "<td>". $filme[tip_film] . "</td>";
- print "<td>". $filme[locuri_disponibile] . "</td>";
- ?>
- </tr>
- <?php
- }
- ?> </table>
- <?php
- }
- ?>
- <!--<h1>Cos de cumparaturi</h1>
- <?php
- if (isset($_SESSION['cos']) && $_SESSION['cos'] != NULL ) {
- $pretTotal = 0;
- ?>
- <table border="1">
- <tr>
- <td>Denumire</td>
- <td>Pret</td>
- <td>Cantitate</td>
- <td></td>
- </tr>
- <?php
- foreach ($_SESSION['cos'] as $id => $cantitate) {
- $produs = preiaProdusDupaId($id);
- if ($produs) {
- $pretTotal = $pretTotal + $cantitate * $produs['pret'];
- ?>
- <tr>
- <td><?php echo $produs['denumire'] ?></td>
- <td><?php echo $produs['pret'] ?></td>
- <td><?php echo $cantitate ?></td>
- <td><a href="index.php?page=cos&id_sters=<?php echo $id; ?>">Sterge</a></td>-->
- </tr>
- //<?php
- // }
- // }
- // ?>
- </table>
- //<?php
- // print "Pret total: $pretTotal";
- // } else {
- // print 'Nu exista produse in cos';
- // }
- ?>
- ///// CONECTARE
- <form method="POST">
- Email: <input type="email" name="email"/><br>
- Parola: <input type="password" name="pass"/><br>
- <input type="submit" value="Conectare" name="con"/>
- </form>
- <?php
- if (isset($_SESSION['eroare'])) {
- print $_SESSION['eroare'];
- }
- ///////// INREGISTRARE
- <h1> Inregistrare</h1>
- <form method="POST">
- Nume: <input type="text" name="nume"/> <br>
- Prenume: <input type="text" name="prenume"/> <br>
- Varsta: <input type="number" name="varsta"/> <br>
- Email: <input type="email" name="email"/> <br>
- Parola: <input type="password" name="pass"/> <br>
- <input type="submit" name="add" value="Inregistrare"/>
- </form>
- <?php
- require_once 'functii/sql_functions.php';
- if(isset($_POST['add'])){
- $nume=$_POST['nume'];
- $prenume=$_POST['prenume'];
- $varsta=$_POST['varsta'];
- $email=$_POST['email'];
- $password=$_POST['pass'];
- $salvareBd= inregistrare($nume, $prenume, $varsta, $email, $password);
- if($salvareBd){
- print "Inregistrare realizata cu succes";
- }
- else{
- print "Eroare la inregistrare";
- }}
- ?>
- ///// CSS
- * {
- margin:0;
- padding:0;
- }
- body {
- margin: 0 auto;
- width: 900px;
- }
- #banner {
- height: 150px;
- background-color: red;
- }
- #meniu ul li {
- list-style-type: none;
- display: inline;
- padding-left: 10px;
- }
- #meniu ul li a {
- text-decoration: none;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement