Advertisement
Sparkster

Untitled

Jul 24th, 2013
335
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.      
  3. $pdo = new PDO("mysql:host=localhost;dbname=_fantapc", '_fpcroot', 'password');
  4.  
  5. if(isset($_POST['addcard'])) {
  6.     $cardname = $_POST['card_input'];
  7.     $rarity = $_POST['rarity_input'];
  8.     $image = $_FILES['file']['name'];
  9.  
  10.     $query = $pdo->prepare("INSERT INTO cards (name,rarity,img) VALUES (:name,:rarity,:img)");
  11.     $query->bindValue(":name", $cardname, PDO::PARAM_STR);
  12.     $query->bindValue(":rarity", $rarity, PDO::PARAM_STR);
  13.     $query->bindValue(":img", $image, PDO::PARAM_STR);
  14.     $query->execute();
  15.  
  16. if ($_FILES["file"]["error"] > 0) {
  17.     echo "Error: " . $_FILES["file"]["error"] . "<br>";
  18. }
  19.  
  20. else {
  21.     echo "Upload: " . $_FILES["file"]["name"] . "<br>";
  22.     echo "Type: " . $_FILES["file"]["type"] . "<br>";
  23.     echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  24.     echo "Stored in: " . $_FILES["file"]["tmp_name"];
  25. }
  26.  
  27. $allowedExts = array("gif", "jpeg", "jpg", "png");
  28. $temp = explode(".", $_FILES["file"]["name"]);
  29. $extension = end($temp);
  30. if ((($_FILES["file"]["type"] == "image/gif")
  31. || ($_FILES["file"]["type"] == "image/jpeg")
  32. || ($_FILES["file"]["type"] == "image/jpg")
  33. || ($_FILES["file"]["type"] == "image/pjpeg")
  34. || ($_FILES["file"]["type"] == "image/x-png")
  35. || ($_FILES["file"]["type"] == "image/png"))
  36. && in_array($extension, $allowedExts)) {
  37.     if ($_FILES["file"]["error"] > 0) {
  38.         echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
  39.         }
  40.  
  41.   else {
  42.     echo "Upload: " . $_FILES["file"]["name"] . "<br>";
  43.     echo "Type: " . $_FILES["file"]["type"] . "<br>";
  44.     echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  45.     echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br>";
  46.  
  47.     if (file_exists("upload/" . $_FILES["file"]["name"])) {
  48.         echo $_FILES["file"]["name"] . " already exists. ";
  49.         }
  50.  
  51.     else {
  52.         move_uploaded_file($_FILES["file"]["tmp_name"],
  53.         "upload/" . $_FILES["file"]["name"]);
  54.         echo "Stored in: " . "/opt/lampp/htdocs/andreas/fantasicapricecheck/upload/" . $_FILES["file"]["name"];
  55.         }
  56.     }
  57. }
  58.  
  59. else {
  60.     echo "Invalid file";
  61. }
  62. }
  63.  
  64. ?>
  65.  
  66. <h1>Add cards</h1>
  67.  
  68. <form action="index.php?page=addcards" method="post" enctype="multipart/form-data">
  69.     <table>
  70.     <tr>
  71.         <td>cardname: </td><td> <input type="text" name="card_input"></td></tr>
  72.     <tr>
  73.         <td>rarity: </td><td>   <select name="rarity_input">
  74.                                 <option value="1">1 star</option>
  75.                                 <option value="2">2 star</option>
  76.                                 <option value="3">3 star</option>
  77.                                 <option value="4">4 star</option>
  78.                                 <option value="5">5 star</option>
  79.                                 <option value="6">6 star</option>
  80.                                 <option value="7">7 star</option>
  81. </select></td></tr>
  82.     <tr>
  83.         <td>image: </td><td><input type="file" name="file" id="file"></td></tr>
  84.     <tr>
  85.         <td></td><td>
  86.                     <input type="hidden" name="addcard" value="1">
  87.                     <input type="submit" value="add card!"></td>
  88. </tr></table></form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement