API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 6th, 2017
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.38 KB | None | 0 0
raw download clone embed print report
  1. <!doctype html>
  2. <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7" lang=""> <![endif]-->
  3. <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8" lang=""> <![endif]-->
  4. <!--[if IE 8]> <html class="no-js lt-ie9" lang=""> <![endif]-->
  5. <!--[if gt IE 8]><!--> <html class="no-js" lang=""> <!--<![endif]-->
  6. <head>
  7. <?php session_start(); $login=(isset($_SESSION['login']))?$_SESSION['login']:'NO_CONNECT';
  8.  
  9. if ($login=='NO_CONNECT'){
  10. print("Vous n'êtes pas connecté");
  11. }
  12. else{
  13. print("Connecté en tant que: $login");
  14. }
  15. ?>
  16. <meta charset="utf-8">
  17. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  18. <title></title>
  19. <meta name="description" content="">
  20. <meta name="viewport" content="width=device-width, initial-scale=1">
  21. <link rel="apple-touch-icon" href="apple-touch-icon.png">
  22.  
  23. <link rel="stylesheet" href="assets/css/bootstrap.min.css">
  24. <!-- <link rel="stylesheet" href="assets/css/bootstrap-theme.min.css">-->
  25.  
  26.  
  27. <!--For Plugins external css-->
  28. <link rel="stylesheet" href="assets/css/plugins.css" />
  29. <link rel="stylesheet" href="assets/css/roboto-railway-webfont.css" />
  30. <link rel="stylesheet" href="assets/css/linearicons-web-font.css" />
  31. <link rel="stylesheet" href="assets/css/magnific-popup.css">
  32.  
  33. <!--Theme custom css -->
  34. <link rel="stylesheet" href="assets/css/style.css">
  35.  
  36. <!--Theme Responsive css-->
  37. <link rel="stylesheet" href="assets/css/responsive.css" />
  38.  
  39. <script src="assets/js/vendor/modernizr-2.8.3-respond-1.4.2.min.js"></script>
  40. </head>
  41. <body>
  42. <!--[if lt IE 8]>
  43. <p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
  44. <![endif]-->
  45.  
  46. <div class='preloader'><div class='loaded'>&nbsp;</div></div>
  47.  
  48.  
  49. <nav id="main-nav">
  50. <ul>
  51. <li><a href="http://localhost/photograph/index.php"><span>Accueil</span></a></li>
  52. <li><a href="http://localhost/photograph/catalogue.php"><span>Catalogue</span></a></li>
  53. <li><a href="http://localhost/photograph/pagepanier.php"><span>Panier</span></a></li>
  54. <?php $login=(isset($_SESSION['login']))?$_SESSION['login']:'NO_CONNECT';
  55.  
  56. if ($login=='NO_CONNECT'){
  57. print("
  58. <li><a href=\"http://localhost/photograph/pageconnexion.php\"><span>Connexion</span></a></li>
  59. <li><a href=\"http://localhost/photograph/pageinscription.php\"><span>Inscription</span></a></li>
  60. ");
  61. }
  62. if ($login=='admin'){
  63. print("<li><a href=\"http://localhost/photograph/pageconnexion.php\"><span>Deconnexion</span></a></li>
  64. <li><a href=\"http://localhost/photograph/pageadmin.php\"><span>Administration</span></a></li>");
  65. }
  66. else{
  67. print("<li><a href=\"http://localhost/photograph/pageconnexion.php\"><span>Deconnexion</span></a></li>");
  68. }
  69. ?>
  70.  
  71. </ul>
  72. <a href="#0" class="cd-close-menu">Close<span></span></a>
  73. </nav>
  74.  
  75. <!--Home page style-->
  76. <header id="home" class="home home-main-content">
  77. <div class="overlay sections">
  78. <div class="container text-center">
  79. <div class="row">
  80. <div class="div-menu">
  81. <header class="cd-header">
  82. <div id="cd-logo">
  83. <a href="index.php"><img src="assets/images/logo.png" alt="Logo"></a>
  84. </div>
  85. <a class="cd-menu-trigger" href="#main-nav"><span></span></a>
  86. </header>
  87. </div>
  88.  
  89.  
  90. <div class="home-wrapper">
  91. <div class="col-md-6 col-md-offset-3 col-sm-12 col-xs-12">
  92. <div class="home-content">
  93. <h1>Kongasiou <br><br>Chermette</h1>
  94. <p>#Photographe &nbsp; #Nature &nbsp; #Innovant</p>
  95. </div>
  96. </div>
  97. </div>
  98. </div>
  99. </div>
  100. </div>
  101. </header>
  102.  
  103. <section id="portfolio" class="sections">
  104. <div class="container">
  105.  
  106. <div class="heading-content text-center">
  107. <h3>Catalogue</h3>
  108. <p>Dernières photos:</p>
  109. </div>
  110.  
  111. <!-- Example row of columns -->
  112. <form action="catalogue.php" method="get">
  113. Tag 1: <input type="text" name="Tag1"><br>
  114. Tag 2: <input type="text" name="Tag2"><br>
  115. Tag 3: <input type="text" name="Tag3"><br>
  116. <input type="submit">
  117. </form>
  118.  
  119.  
  120. <?php
  121.  
  122. //Connection BDD
  123. $dsn='mysql:host=';
  124. $dsn.="localhost";
  125. $dsn.=';port=3306;dbname=';
  126. $dsn.="photograph";
  127. //instanciation
  128. $user="root";
  129. $password="";
  130. $pdo = new PDO($dsn,$user,$password);
  131. //
  132. //On compte le nombre d'image pour connaître le nombre de lignes
  133. if(!isset($_GET['Tag1']) or !isset($_GET['Tag1']) or !isset($_GET['Tag1'])){
  134. $qr="SELECT COUNT(*) from photo order by ID desc LIMIT 1";
  135. $stmt = $pdo->query($qr);
  136. $row=$stmt->fetch();
  137. $result=$row[0];
  138.  
  139. //Selection d'images
  140. $qr2="SELECT Adresse,prix from photo order by ID desc";
  141. $stmt2 = $pdo->query($qr2);
  142. // $row2=$stm2t->fetch();
  143.  
  144. echo "<br>";
  145.  
  146. //Affichage de la dernière image uploadé
  147.  
  148. $i = 0;
  149. $cnt =0;
  150. $adr = array();
  151. $prix = array();
  152. //Nombres de ligne d'images sachant qu'une ligne contient 4 images
  153.  
  154. //Stock les images dans un array
  155. while($row2=$stmt2->fetch()){
  156. /*
  157. echo htmlentities($row2[0]);
  158. echo "<br>";
  159. */
  160. $adr[$cnt]=$row2[0];
  161. $prix[$cnt]=$row2[1];
  162. $cnt++;
  163.  
  164. }
  165. echo("<form method='POST' action='gestionCatalogue.php'>");
  166.  
  167.  
  168. print("
  169. <div class=\"row\">
  170. <div class=\"portfolio-wrapper\">");
  171.  
  172. //While chaque images
  173. $result--;
  174. $test=0;
  175. while($result>-1){
  176. //$test++;
  177. //echo "Img $result: $adr[$result] <br>";
  178.  
  179. //Affiche une image avec son form avec le prix
  180. print("
  181. <div class=\"col-md-4 col-sm-6 col-xs-12\">
  182. <div class=\"portfolio-item\">
  183. <a href=\"image_creation.php?IMG=$adr[$result]\" class=\"portfolio-img\"><img src=\"image_creation.php?IMG=$adr[$result]\" class='img-rounded' alt=\"\" /></a>
  184. <br/><input type=\"checkbox\" name='buy[]' value=$adr[$result]> Prix: $prix[$result] €
  185. </div>
  186. </div>
  187. ");
  188. $result--;
  189. /*
  190. if ($test>4){
  191. break;
  192. }*/
  193. }
  194. print("</div></div>");
  195.  
  196.  
  197.  
  198. echo("<input type='submit' class='btn btn-success' value='Valider mes choix'>");
  199. echo "</form>";
  200. }
  201.  
  202. else{
  203. $tag1=$_GET['Tag1'];
  204. $tag2=$_GET['Tag2'];
  205. $tag3=$_GET['Tag3'];
  206. if ($tag2!=""){
  207. $tag2="AND Tag like '%$tag2%'";
  208. }
  209. if ($tag3!=""){
  210. $tag3="AND Tag like '%$tag3%'";
  211. }
  212. //On compte le nombre d'image pour connaître le nombre de lignes
  213. $qr="SELECT COUNT(*) from photo where Tag like '%$tag1%' $tag2 $tag3 ";
  214. $stmt = $pdo->query($qr);
  215. $row=$stmt->fetch();
  216. $result=$row[0];
  217.  
  218. //Selection d'images
  219. $qr2="SELECT Adresse,prix from photo where Tag like '%$tag1%' $tag2 $tag3 ";
  220. $stmt2 = $pdo->query($qr2);
  221. // $row2=$stm2t->fetch();
  222.  
  223. $i = 0;
  224. $cnt =0;
  225. $adr = array();
  226. $prix = array();
  227.  
  228. //Stock les images dans un array
  229. while($row2=$stmt2->fetch()){
  230. //On insert dans adr[] les adresses des images et dans prix[] leur prix
  231. $adr[$cnt]=$row2[0];
  232. $prix[$cnt]=$row2[1];
  233. $cnt++;
  234.  
  235. }
  236.  
  237. echo("<form method='POST' action='gestionCatalogue.php'>");
  238.  
  239. print("
  240. <div class=\"row\">
  241. <div class=\"portfolio-wrapper\">"
  242. );
  243. //While chaque images
  244. $result--;
  245. $test=0;
  246. while($result>-1){
  247. //$test++;
  248. //echo "Img $result: $adr[$result] <br>";
  249.  
  250. //Affiche une image avec son form avec le prix
  251. print("
  252. <div class=\"col-md-4 col-sm-6 col-xs-12\">
  253. <div class=\"portfolio-item\">
  254. <a href=\"image_creation.php?IMG=$adr[$result]\" class=\"portfolio-img\"><img src=\"image_creation.php?IMG=$adr[$result]\" class='img-rounded' alt=\"\" /></a>
  255. <br/><input type=\"checkbox\" name='buy[]' value=$adr[$result]> Prix: $prix[$result] €
  256. </div>
  257. </div>
  258. ");
  259. $result--;
  260. /*
  261. if ($test>4){
  262. break;
  263. }*/
  264. }
  265. print("</div></div>");
  266.  
  267. echo("<input type='submit' class='btn btn-success' value='Valider mes choix'>");
  268.  
  269. echo "</form>";
  270. }
  271.  
  272.  
  273. ?>
  274.  
  275. <!--
  276. <div class="row">
  277. <div class="portfolio-wrapper">
  278. <div class="col-md-3 col-sm-6 col-xs-12">
  279. <div class="portfolio-item">
  280. <a href="assets/images/portfolio/pf1.jpg" class="portfolio-img"><img src="assets/images/portfolio/pf1.jpg" alt="" /></a>
  281. <form><input type="checkbox" name="buy"> $5.75 </form>
  282. </div>
  283. </div>
  284.  
  285. <div class="col-md-3 col-sm-6 col-xs-12">
  286. <div class="portfolio-item">
  287. <a href="assets/images/portfolio/pf2.jpg" class="portfolio-img"><img src="assets/images/portfolio/pf2.jpg" alt="" /></a>
  288. <form><input type="checkbox" name="buy"> $5.75 </form>
  289. </div>
  290. </div>
  291.  
  292. <div class="col-md-3 col-sm-6 col-xs-12">
  293. <div class="portfolio-item">
  294. <a href="assets/images/portfolio/pf3.jpg" class="portfolio-img"><img src="assets/images/portfolio/pf3.jpg" alt="" /></a>
  295. <form><input type="checkbox" name="buy"> $5.75 </form>
  296. </div>
  297. </div>
  298.  
  299. <div class="col-md-3 col-sm-6 col-xs-12">
  300. <div class="portfolio-item">
  301. <a href="assets/images/portfolio/back4.png" class="portfolio-img"><img src="assets/images/portfolio/back4.png" alt="" /></a>
  302. <form><input type="checkbox" name="buy"> $5.75 </form>
  303. </div>
  304. </div>
  305.  
  306.  
  307. </div>
  308. </div>
  309.  
  310.  
  311.  
  312.  
  313. <div class="row">
  314. <div class="portfolio-wrapper2">
  315. <div class="col-md-6 col-sm-6 col-xs-12">
  316. <div class="portfolio-item width-img">
  317. <a href="assets/images/portfolio/pf1.jpg" class="portfolio-img"><img src="assets/images/portfolio/back4.png" alt="" /></a>
  318. </div>
  319. </div>
  320.  
  321. <div class="col-md-3 col-sm-6 col-xs-12">
  322. <div class="portfolio-item">
  323. <a href="assets/images/portfolio/pf2.jpg" class="portfolio-img"><img src="assets/images/portfolio/back4.png" alt="" /></a>
  324. </div>
  325. </div>
  326.  
  327. <div class="col-md-3 col-sm-6 col-xs-12">
  328. <div class="portfolio-item">
  329. <a href="assets/images/portfolio/pf3.jpg" class="portfolio-img"><img src="assets/images/portfolio/pf3.jpg" alt="" /></a>
  330. </div>
  331. </div>
  332.  
  333. </div>
  334. </div>
  335. -->
  336.  
  337. </div> <!-- /container -->
  338. </section>
  339.  
  340.  
  341. <!--Footer-->
  342. <footer id="footer" class="footer">
  343. <div class="container text-center">
  344. <div class="row">
  345. <div class="col-md-6 col-md-offset-3 col-sm-12 col-xs-12">
  346. <div class="main-footer">
  347.  
  348. <div class="social">
  349. <a href="#"><i class="fa fa-twitter"></i></a>
  350. <a href="#"><i class="fa fa-linkedin"></i></a>
  351. <a href="#"><i class="fa fa-behance"></i></a>
  352. <a href="#"><i class="fa dribbble fa-dribbble"></i></a>
  353. </div>
  354.  
  355. <p>Made with <i class="fa fa-heart"></i> by <a target="_blank" href="http://bootstrapthemes.co"> Bootstrap Themes </a>2016. All rights reserved.</p>
  356.  
  357. </div>
  358. </div>
  359. </div>
  360. </div>
  361.  
  362. </footer>
  363.  
  364.  
  365. <script src="assets/js/vendor/jquery-1.11.2.min.js"></script>
  366. <script src="assets/js/vendor/bootstrap.min.js"></script>
  367.  
  368. <script src="assets/js/plugins.js"></script>
  369. <script src="assets/js/jquery.magnific-popup.js"></script>
  370. <script src="assets/js/modernizr.js"></script>
  371.  
  372. <script src="assets/js/main.js"></script>
  373. </body>
  374. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!