Advertisement
Guest User

Untitled

a guest
Apr 24th, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1.  
  2.  
  3. <div id="content">
  4. <h3>Wildlife Collision Record</h3>
  5.  
  6. <?php
  7. require_once("db.php");
  8.  
  9. $species1 = $_POST['species'];
  10. $species2 = $_POST['txtSpecies'];
  11. $gender = $_POST['rbGender'];
  12. $age = $_POST['rbAge'];
  13. $date = $_POST['rpDate'];
  14. $location = $_POST['location'];
  15. $latitude = $_POST['lat'];
  16. $longitude = $_POST['lng'];
  17. if ($species1 === "Others");
  18. $species1 = $species2;
  19. if (!empty($species1) && is_string($species1) && !empty($location)&& is_string($location))
  20. {
  21. $imgURL = null;}
  22. ?>
  23. <p>Your information been recorded.</p>
  24. <dl>
  25. <dt>Species</dt>
  26. <dd><?php print $species1; ?></dd>
  27. </dl>
  28.  
  29. <?php
  30. if ($_FILES["imgFile"]["error"] > 0){
  31. print ("<p>File Upload Error: " . $_FILES["imgFile"]["error"] . "</p>");
  32. }
  33. elseif(( $_FILES["imgFile"]["type"] == "image/gif") ||
  34. ($_FILES["imgFile"]["type"] == "image/jpeg") ||
  35. ($_FILES["imgFile"]["type"] == "image/jpg") ||
  36. ($_FILES["imgFile"]["type"] == "image/png") &&
  37. ($_FILES["imgFile"]["size"] < 1000000)){
  38.  
  39. //get file name
  40. $filename = $_FILES["imgFile"]["name"];
  41. //get tmp name
  42. $tmpname = $_FILES["imgFile"] ["tmp_name"];
  43. //get path
  44. $path = "uploads\\";
  45. //set dest
  46. $imgURL = $destpath . $filename;
  47.  
  48. //if file exists
  49. if(file_exists($imgURL)){
  50. print("<p>File Upload Error: " . $filename . " already exists.</p>");
  51. }
  52. else{
  53. if(move_uploaded_file($tmpname, $imgURL)){
  54. print("<p>File " . $filename . " uploaded successfully.</p>");
  55.  
  56. else
  57. print("<p>File Upload Error: " . "File cannot be moved.</p>");
  58.  
  59. }
  60. }//end elseif statement- checking valid file format and size
  61.  
  62. else{
  63. print("<p>File upload Error:Invalid File </p>");
  64. }
  65.  
  66. $sql = //"insert collisions(species, gender, age, report_date, location,
  67. //latitude, longitude, img_url) values ('$species1','$gender','$age', '$date', '$location' , '$latitude', '$longitude', '$imgURL')";
  68. INSERT INTO collisions (species, gender, age, report_date, location, latitude, longitude, img_url ) VALUES ('$species1','$gender','$age', '$date',
  69. '$location' , '$latitude', '$longitude', '$imgURL');
  70.  
  71.  
  72. $result = mysqli_query($con, $sql);
  73.  
  74. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement