Bicas

Untitled

Dec 20th, 2014
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.12 KB | None | 0 0
  1. <body>
  2.     <head>
  3.         <title>
  4.             LVKG.lt VVP
  5.         </title>
  6.         <link rel="stylesheet" type="text/css" href="theme/style.css">
  7.     </head>
  8.  
  9.     <center>
  10.         <div class = "loginpanel">
  11.             <div class = "logintext">LVKG.lt VVP Prisijungimas</div>
  12.             <br />
  13.             <form method="POST">
  14.                 <input type="v_p" name = "vardas" placeholder = "Vardas_Pavardė"><br />
  15.                 <br />
  16.                 <input type="password" name = "slaptazodis" placeholder = "Slaptažodis"><br />
  17.                 <br />
  18.                 <input type="submit" value = "Prisijungti">
  19.             </form>
  20.             <form action = "remember.php">
  21.                 <button class = "rememberpw">Prisiminti slaptažodį</button>
  22.             </form>
  23.         </div>
  24.         <center>
  25.             <div class = "versionlogin">
  26.                 <a href = "http://bicas.eu/">bVVP(ALPHA)v0.1 #1</a>
  27.             </div>
  28.         </center>
  29.     </center>
  30. </body>
  31.  
  32. <?php
  33.     session_start();
  34.  
  35.     if(isset($_POST['vardas'], $_POST['slaptazodis']))
  36.     {
  37.         require 'pdo.php';
  38.         $sql = "SELECT vardas, slaptazodis FROM zaidejai WHERE vardas=:vardas AND slaptazodis=:slaptazodis LIMIT 1";
  39.         $query = $pdo->proQuery($sql);
  40.         $query->bindParam(':vardas', $_POST['vardas']);
  41.         $query->bindParam(':slaptazodis', $_POST['slaptazodis']);
  42.         $query->execute();
  43.  
  44.         if($row = $query->fetch()){
  45.             $_SESSION['vardas'] = $row['vardas'];
  46.             header("Location: index.php");
  47.         }
  48.     }
  49. ?>
  50.  
  51. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':vardas AND slaptazodis=:slaptazodis LIMIT 1' at line 1' in C:\xampp\htdocs\vvp\pdo.php:23 Stack trace: #0 C:\xampp\htdocs\vvp\pdo.php(23): PDO->query('SELECT vardas, ...') #1 C:\xampp\htdocs\vvp\login.php(39): mysqlfunctions->proQuery('SELECT vardas, ...') #2 {main} thrown in C:\xampp\htdocs\vvp\pdo.php on line 23
Advertisement
Add Comment
Please, Sign In to add comment