Advertisement
Guest User

Untitled

a guest
Apr 15th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. $('#selection').change(function() {
  2. var selected_value = $("input[name='kobegreat']:checked").val();
  3.  
  4. $.ajax( {
  5. url: "kobegreat.php",
  6. data: {"name": selected_value},
  7. type: "GET",
  8. dataType: "json",
  9.  
  10. success: function(json) {
  11. var $imgEl = $("img");
  12. if( $imgEl.length === 0) {
  13. $imgEl = $(document.createElement("img"));
  14. $imgEl.insertAfter('h3');
  15. $imgEl.attr("width", "300px");
  16. $imgEl.attr("alt", "kobepic");
  17. }
  18. var link = json.link + ".jpg";
  19. $imgEl.attr('src', link);
  20. alert("AJAX was a success");
  21. },
  22. cache: false
  23. });
  24. });
  25.  
  26. <?php
  27.  
  28.  
  29. $db_user = 'test';
  30. $db_pass = 'test1';
  31.  
  32. if($_SERVER['REQUEST_METHOD'] == "GET") {
  33. $value = filter_input(INPUT_GET, "name");
  34. }
  35.  
  36. try {
  37. $conn = new PDO('mysql: host=localhost; dbname=kobe', $db_user, $db_pass);
  38. $conn->setAttribute(PDO:: ATTR_ERRMODE, PDO:: ERRMODE_EXCEPTION);
  39. $stmt = $conn->prepare('SELECT * FROM greatshots WHERE name = :name');
  40. do_search($stmt, $value);
  41. } catch (PDOException $e) {
  42. echo 'ERROR', $e->getMessage();
  43. }
  44.  
  45. function do_search ($stmt, $name) {
  46. $stmt->execute(['name'=>$name]);
  47.  
  48. if($row = $stmt->fetch()) {
  49. $return = $row;
  50. echo json_encode($return);
  51. } else {
  52. echo '<p>No match found</p>;
  53. }
  54. }
  55.  
  56. ?>
  57.  
  58. <h2>Select a Great Kobe Moment.</h2>
  59. <form id="selection" method="get">
  60. <input type="radio" name="kobegreat" value="kobe1" checked/>Kobe1
  61. <input type="radio" name="kobegreat" value="kobe2"/>Kobe2
  62. <input type="radio" name="kobegreat" value="kobe3"/>Kobe3
  63. </form>
  64.  
  65. <div id="target">
  66. <h3>Great Kobe Moment!</h3>
  67. </div>
  68.  
  69. greatshots(name, link)
  70.  
  71. name link
  72. ------ --------
  73. kobe1 images/kobe1
  74. kobe2 images/kobe2
  75. kobe3 images/kobe3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement