Guest User

Untitled

a guest
Mar 9th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.93 KB | None | 0 0
  1. $('#rev').on('click', function () {
  2. firstName = $('#firstName').val();
  3. lastName = $('#lastName').val();
  4. textarea1 = $('#exampleFormControlTextarea1').val();
  5. ratEvent = $("select[name=ratingEv]").val();
  6. ratCom = $("select[name=ratingCom]").val();
  7. ratingProg = $("select[name=ratingProg]").val();
  8. ratingPart = $("select[name=ratingPart]").val();
  9. ratingDisk = $("select[name=ratingDisk]").val();
  10. checkPub = $('#same-address').is(':checked');
  11. checkInf = $('#save-info').is(':checked');
  12. checkInf = $('#save-info').is(':checked');
  13. var status = $("select[name=stat]").val();
  14. var dataString = 'firstName='+ firstName + '&lastName=' + lastName + '&textarea1=' + textarea1 + '&ratEvent=' + ratEvent + '&ratCom =' + ratCom + '&ratingProg=' + ratingProg +'&ratingPart=' + ratingPart + '&ratingDisk' + ratingDisk + '&checkPub=' + checkPub + '&checkInf=' + checkInf+ '&resp=' + resp+ '&status=' + status;
  15. $.ajax({
  16. url: "load.php",
  17. type: "POST",
  18. data: dataString,
  19. success: function (data) {
  20. alert(data);
  21. }
  22. });
  23.  
  24. });
  25.  
  26. <?php
  27.  
  28.  
  29.  
  30. if(!$_POST) exit;
  31.  
  32. if (!defined("PHP_EOL")) define("PHP_EOL", "rn");
  33.  
  34. $host="localhost";
  35. $user="root";
  36. $pass="root"; //установленный вами пароль
  37. $db_name="u997029462_bo";
  38.  
  39. $link=mysqli_connect($host,$user,$pass);
  40. mysqli_select_db($link,$db_name);
  41.  
  42. $firstName = $_POST['firstName'];
  43. $lastName = $_POST['lastName'];
  44. $textarea1 = $_POST['textarea1'];
  45. $ratEvent = $_POST['ratEvent'];
  46. $ratCom = $_POST['ratCom'];
  47. $ratingProg = $_POST['ratingProg'];
  48. $ratingPart = $_POST['ratingPart'];
  49. $ratingDisk = $_POST['ratingDisk'];
  50. $checkPub = $_POST['checkPub'];
  51. $checkInf = $_POST['checkInf'];
  52. $resp = $_POST['resp'];
  53. $status = $_POST['status'];
  54.  
  55.  
  56.  
  57. if (isset($_POST["firstName"])||isset($_POST["lastName"])||isset($_POST["textarea1"])||isset($_POST["ratEvent"])||isset($_POST["ratCom"])||isset($_POST["ratingProg"])||isset($_POST["ratingPart"])||isset($_POST["ratingDisk"])||isset($_POST["checkPub"])||isset($_POST["checkInf"])||isset($_POST["resp"])||isset($_POST["status"]))
  58. {
  59. //Вставляем данные, подставляя их в запрос
  60. $date = date('Y/m/d H:i:s');
  61. $sql = "INSERT INTO `comment` (`Name`,`surname`, `status`,`comment`, `EventRating`,`OrganizationalCommitteeRating`,`ProgramRatingOfTheEvent`, `RatingOfPartners`,`DiscothequeRating`,`Publication`,`Notice`,`Photo`,`Date`) VALUES ('$firstName','$lastName','$status','$textarea1','$ratEvent','$ratCom','$ratingProg','$ratingPart','$ratingDisk','$checkPub','$checkInf','$resp','$date')";
  62. $query = mysqli_query($link,$sql);
  63. //Если вставка прошла успешно
  64. if ($query) {
  65. echo $_POST['ratingDisk'];
  66. echo $query;
  67. } else {
  68. echo $query;
  69. echo $_POST['ratCom'];
  70. }
  71. }
Add Comment
Please, Sign In to add comment