Advertisement
Guest User

Untitled

a guest
Feb 13th, 2019
792
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.14 KB | None | 0 0
  1. sourcefiles:
  2. ____/css: conectat.css_______############################################3
  3.  
  4. #banner {
  5. background-color: #cc33ff;
  6. height: 150px;
  7. }
  8.  
  9. #meniu {
  10. float: left;
  11. width: 15%;
  12. }
  13.  
  14. #continut {
  15. float: right;
  16. width: 80%;
  17. }
  18.  
  19. ____/css: main.css_______###########################################
  20.  
  21. *{
  22. padding: 0;
  23. margin: 0;
  24. }
  25.  
  26. body {
  27. width: 900px;
  28. margin: 0 auto;
  29. }
  30.  
  31. nav ul{
  32. list-style-type: none;
  33. }
  34.  
  35. nav ul a {
  36. text-decoration: none;
  37. }
  38.  
  39.  
  40.  
  41. ____/css: neconectat.css_______#####################################
  42.  
  43.  
  44. #banner{
  45. background: #cc33ff;
  46. height: 150px;
  47. }
  48.  
  49. nav ul li {
  50. display: inline;
  51. }
  52.  
  53. ______/functii: sql_functions.php______########################################3
  54.  
  55. <?php
  56.  
  57. function conectare_bd($host="localhost",$user="root",$pass="",$db="phpc8"){
  58. return mysqli_connect($host, $user, $pass, $db);
  59. }
  60.  
  61.  
  62. function inregistrare($email,$parola){
  63. $link = conectare_bd();
  64. $email= test($email);
  65. $parola = test($parola);
  66. $email = mysqli_real_escape_string($link, $email);
  67. $parola = mysqli_real_escape_string($link, $parola);
  68. $parola= md5($parola);
  69. $sql = "INSERT INTO utilizatori VALUES(NULL,'$email','$parola')";
  70. $user = checkEmail($email);
  71. if($user){
  72. return false;
  73. }else{
  74. return mysqli_query($link, $sql);
  75. }
  76. }
  77.  
  78.  
  79. function preia_utilizatori() {
  80. $link = conectare_bd();
  81. $query = "SELECT * FROM utilizatori";
  82. $r = mysqli_query($link, $query);
  83. $user = array();
  84. while ($email = mysqli_fetch_array($r)) {
  85. array_push($user, $email);
  86. }
  87. return $user;
  88. }
  89.  
  90. function test($input){
  91. $input= trim($input);
  92. $input= htmlspecialchars($input);
  93. $input = stripslashes($input);
  94. return $input;
  95. }
  96.  
  97.  
  98.  
  99. function checkEmail($email){
  100. $link = conectare_bd();
  101. $email = test ($email);
  102. $sql = "SELECT email from utilizatori where email='$email'";
  103. $r = mysqli_query($link, $sql);
  104. return mysqli_fetch_array($r);
  105. }
  106.  
  107. function login($email, $parola){
  108. $link = conectare_bd();
  109. $email = test($email);
  110. $parola = test($parola);
  111. $email = mysqli_real_escape_string($link, $email);
  112. $parola = mysqli_real_escape_string($link, $parola);
  113. $user= checkEmail($email);
  114. if($user){
  115. // return (md5($parola) == $user['parola']);
  116. return 1 ;
  117. }else{
  118. return false;
  119. }
  120. }
  121.  
  122. function adaugare_produs($denumire, $pret, $adresa_imagine){
  123. $link = conectare_bd();
  124. $denumire = test($denumire);
  125. $pret = test($pret);
  126. $adresa_imagine = test($adresa_imagine);
  127. //protectie sqlinjection
  128. // $denumire = mysqli_real_escape_string($link, $denumire);
  129. // $pret = mysqli_real_escape_string($link, $pret);
  130. // $adresa_imagine = mysqli_real_escape_string($link, $adresa_imagine);
  131.  
  132. $sql = "insert into phpc8.produse values (NULL, '$denumire', '$pret','$adresa_imagine')";
  133. return mysqli_query($link, $sql);
  134. }
  135.  
  136. function preia_produse(){
  137. $link = conectare_bd();
  138. $sql = "select * from produse";
  139. $vector_produse = array();
  140. $produse = mysqli_query($link, $sql);
  141. while($produs = mysqli_fetch_array($produse)){
  142. array_push($vector_produse, $produs);
  143. }
  144. return $vector_produse;
  145. }
  146.  
  147. ?>
  148.  
  149. __________/imagini_produse==============############################33
  150.  
  151.  
  152. _________/pagini/conectat/adaugare_produs.php ===##########################3
  153.  
  154. <h1>Formular adaugare produs</h1>
  155. <form method="POST" enctype="multipart/form-data">
  156. <table>
  157. <tr>
  158. <td>
  159. Denumire:
  160. </td>
  161. <td>
  162. <input type="text" name="denumire"/>
  163. </td>
  164. </tr>
  165. <tr>
  166. <td>
  167. Pret:
  168. </td>
  169. <td>
  170. <input type="text" name="pret"/>
  171. </td>
  172. </tr>
  173. <tr>
  174. <td>
  175. Imagine:
  176. </td>
  177. <td>
  178. <input type="file" name="imagine"/>
  179. </td>
  180. </tr>
  181. <tr>
  182. <td colspan="2">
  183. <input type="submit" name="adauga_produs" value="adauga"/>
  184. </td>
  185. </tr>
  186. </table>
  187.  
  188. </form>
  189.  
  190. <?php
  191. require_once 'functii/sql_functions.php';
  192. if (isset($_POST['adauga_produs'])){
  193. $denumire = $_POST['denumire'];
  194. $pret= $_POST['pret'];
  195. if(($_FILES['imagine'])){
  196. if($_FILES['imagine']['error']==0){
  197. switch ($_FILES['imagine']['type']) {
  198. case 'image/jpg':
  199. case 'image/jpeg':
  200. case 'image/png':
  201. case 'image/bmp':
  202. case 'image/gif':
  203. $nume_nou = uniqid().$_FILES['imagine']['name'];
  204. $r= move_uploaded_file($_FILES['imagine']['tmp_name'], 'imagini_produse/'.$nume_nou);
  205. if($r){
  206. $rez = adaugare_produs($denumire, $pret, $nume_nou);
  207. if($rez){
  208. print 'Fisier incarcat';//pe server
  209. }else{
  210. unlink("imagini_produse/$nume_nou");
  211. print "eroare la salvarea in baza date";
  212. }
  213. }else{
  214. print "Eroare";
  215. }
  216. break;
  217.  
  218. default: print "fisierul nu are formatul necesar";
  219. break;
  220. }
  221. }
  222. }
  223. }
  224.  
  225. ?>
  226.  
  227.  
  228. _________/pagini/conectat/vizualizare_produs.php ==========######################333333
  229.  
  230. <h1>Lista produse</h1>
  231.  
  232.  
  233. <?php
  234.  
  235. require_once 'functii/sql_functions.php';
  236. $produse = preia_produse();
  237. if(count($produse)==0){
  238. print "nu exista produse";
  239. }
  240. else{
  241.  
  242. }
  243. ?>
  244. <table witdh="500"
  245. border="10px solid black">
  246. <thead>
  247. <tr>
  248.  
  249. <th>Denumire</th>
  250. <th>Pret</th>
  251. <th>Imagine</th>
  252.  
  253. </tr>
  254. </thead>
  255. <tbody>
  256. <?php
  257. foreach($produse as $produs){
  258. print "<tr>";
  259. print "<td>".$produs['denumire']."</td>";
  260. print "<td>".$produs['pret']."</td>";
  261. print "<td>".$produs['adresa']."</td>";
  262. print "</tr>";
  263. }
  264. ?>
  265. </tbody>
  266. </table>
  267.  
  268. _________/pagini/conectat/cart.php===================############################
  269.  
  270.  
  271. <html>
  272. <h1>Cos de cumparaturi</h1>
  273. </html>
  274. <?php
  275. require_once 'functii/sql_functions.php';
  276. if (isset($_SESSION['cos']) && $_SESSION['cos']!=null) {
  277. foreach($_SESSION['cos'] as $id_pr => $cant_pr) {
  278. $produs = preia_produs_dupa_id($id_pr);
  279. if ($produs) {
  280. print $produs['denumire']." cantitate ".$cant_pr." pret ".$produs['pret'];
  281. print "</br>";
  282. }
  283. }
  284. } else {
  285. print "Cos gol";
  286. }
  287.  
  288. /*
  289. * foreach($elements as $element)
  290. * foreach($elements as $key => $element)
  291. */
  292.  
  293. _________/pagini/neconectat/eroare.php====================================##########
  294.  
  295. <h1>Pagina inexistenta.php
  296.  
  297. ____/ttemplates/template_conectat.php=====================================##########
  298.  
  299.  
  300. <html>
  301. <header id="banner"></header>
  302. <nav id="meniu">
  303. <ul>
  304. <li><?php print "Welcome, " .$_SESSION['email_utilizator']; ?></li>
  305. <li>
  306. <a href="index.php">Vizualizare produse</a>
  307. </li>
  308. <li>
  309. <a href="index.php?p=1">Adaugare produse</a>
  310. </li>
  311. <li>
  312. <a href="index.php?logout">Logout</a>
  313. </li>
  314. </ul>
  315. </nav>
  316. <section id="continut">
  317. </br>
  318. <?php
  319. if(isset($_GET['p'])){
  320. if($_GET['p']=='1'){
  321. require_once 'pagini/conectat/adaugare_produs.php';
  322. }else{
  323. require_once 'pagini/eroare.php';
  324. }
  325. }else{
  326. require_once 'pagini/conectat/vizualizare_produs.php';
  327. }
  328.  
  329. if (isset($_GET['logout'])) {
  330. session_destroy();
  331. header("location:index.php");
  332. }
  333. ?>
  334. </section>
  335. </html>
  336.  
  337.  
  338. ____/ttemplates/template_neconectat.php_____###########################3
  339.  
  340. <html>
  341. <header id="banner"></header>
  342. <nav id="meniu">
  343. <ul>
  344. <li>
  345. <a href="index.php?p=1">Inregistrare</a>
  346. </li>
  347. <li>
  348. <a href="index.php">Conectare</a>
  349. </li>
  350. </ul>
  351. </nav>
  352. <section id="continut">
  353.  
  354. <?php
  355. if(isset($_GET['p'])){
  356. if($_GET['p']=='1'){
  357. require_once 'pagini/neconectat/inregistrare.php';
  358. }else
  359. {
  360. require_once 'pagini/eroare.php';}
  361. }else
  362. {
  363. require_once 'pagini/neconectat/conectare.php';
  364. }
  365.  
  366.  
  367. ?>
  368. </section>
  369. </html>
  370.  
  371. _______________index.php __________######################
  372.  
  373.  
  374. <?php
  375. session_start();
  376. if(isset($_POST['conectare'])){
  377. require_once 'functii/sql_functions.php';
  378. $e = $_POST['email'];
  379. $p = $_POST['parola'];
  380.  
  381. $r= login($e, $p);
  382. if($r){
  383. if(isset($_SESSION['eroare_login'])){
  384.  
  385. unset($_SESSION['eroare_login']);}
  386. $_SESSION['email_utilizator'] = $e;
  387. } else{
  388. $_SESSION['eroare_login']='Conectare esuata';
  389.  
  390. }
  391. }
  392.  
  393. ?>
  394.  
  395. <html>
  396. <head>
  397. <meta charset="UTF-8">
  398. <title></title>
  399. <link type="text/css" rel="stylesheet" href="css/main.css"/>
  400. <?php
  401. if(isset($_SESSION['email_utilizator'])){
  402. ?>
  403. <link type="text/css" rel="stylesheet" href="css/neconectat.css"/>
  404. <?PHP
  405. }else{
  406. ?>
  407. <link type="text/css" rel="stylesheet" href="css/neconectat.css"/>
  408. <?php
  409. }
  410. ?>
  411. </head>
  412. <body>
  413. <?php
  414. if(isset($_SESSION['email_utilizator'])){
  415. require_once 'ttemplates/template_conectat.php';
  416. }else{
  417. require_once 'ttemplates/template_neconectat.php';
  418. }
  419. ?>
  420. </body>
  421. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement