Is it possible to do this with jquery and how? Sample code in php & mysql

Is it possible to do this with jquery and how? Sample code in php & mysql

Hello!

I'm really new to jquery and doesn't know if it's possible to do this with it but please help me.

I have coded a really simple image gallery with php and mysql to try to get it work with jquery, far from the best I have coded and not so secure but its just for testing so just help me with the jquery.

I have a next button and a previous button and if the user presses at one those I just want to change my content in my picture div. I want it to work like facebook gallery, if a user clicks at next it changes picture, comment and address in my browsers addressfield. I want mine to do the same. I want my next / previous buttons to work the same way as now but with jquery so I doesn't need to update my whole page every time I click on next or previous.

I know that I haven't attached any jquery code but its because I'm stranded and doesn't know where to begin.

So please help with this or to help me start with my next / previous buttons.

test.php
  2. <?php
  3. include "db_photos.php";
  4. ?>
  5. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  6. <html xmlns="http://www.w3.org/1999/xhtml">
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  9. </head>
  10. <body>
  11. <div id="logo">Logo</div>
  12. <div id="picture">
  13. <?php
  14. // Skriv ut bilden
  15. if($picture){
  16. echo '<div class="picture">'.$picture.'</div>';
  17. echo "<br />";
  18. echo '<a href="test.php?pid='.$prev.'&gid='.$_GET['gid'].'">< Previous</a>';
  19. echo " || ";
  20. echo '<a href="test.php?pid='.$next.'&gid='.$_GET['gid'].'">Next ></a>';
  21. echo '<h1>Kommentarer</h1>';
  22. if($comments != null){
  23. foreach($comments as $comment){
  24. echo $comment."<br />";
  25. }
  26. }
  27. else
  28. echo "No comments yet..";
  29. }
  30. ?>
  31. <!-- Comments Form -->
  32. <form action="" method="post">
  33. <h1>Comment</h1>
  34. <?php
  35. if($msg){
  36. echo '<div class="msg">'.$msg.'</div>';
  37. }
  38. ?> 
  39. <textarea id="comment" name="comment"></textarea>
  40. <div class="clear"></div>
  41. <p><input type="submit" name="submit" value="Comment" /></p>
  42. </form>
  43. </div>
  44. <div id="footer">Footer</div>
  45. </body>
  46. </html>

db_photos.php
  2. <?php

  4. include('db_connection.php');

  6. $err = array();
  7. $success = array();

  9. if($_GET['pid'] && $_GET['gid'] &&  $_GET['gid'] != null){
  10. $pid = mysql_real_escape_string($_GET['pid']);
  11. $gid = mysql_real_escape_string($_GET['gid']);
  13. $result = mysql_query("SELECT address FROM photos WHERE id='".$pid."' AND galleryid='".$gid."'");
  14. if(mysql_num_rows($result) == 1){
  15. $result = mysql_fetch_assoc($result);
  16. $address = $result['address'];
  17. $picture = "<img src='".$address."' />";
  19. // Next
  20. $result = mysql_query("
  21. SELECT id
  22. FROM photos
  23. WHERE id > '".$pid."'
  24. ORDER BY id ASC 
  25. LIMIT 1");
  26. if(mysql_num_rows($result) > 0){
  27. $result = mysql_fetch_assoc($result);
  28. $next = $result['id'];
  29. }
  30. else{
  31. $result = mysql_fetch_assoc(mysql_query("
  32. SELECT id
  33. FROM photos
  34. ORDER BY id ASC 
  35. LIMIT 1"));
  36. $next = $result['id'];
  37. }
  38. // Previous
  39. $result = mysql_query("
  40. SELECT id
  41. FROM photos
  42. WHERE id < '".$pid."'
  43. ORDER BY id DESC 
  44. LIMIT 1");
  45. if(mysql_num_rows($result) > 0){
  46. $result = mysql_fetch_assoc($result);
  47. $prev = $result['id'];
  48. }
  49. else{
  50. $result = mysql_fetch_assoc(mysql_query("
  51. SELECT id
  52. FROM photos
  53. ORDER BY id DESC
  54. LIMIT 1"));
  55. $prev = $result['id'];
  56. }
  58. $result = mysql_query("
  59. SELECT comment
  60. FROM photo_comments
  61. WHERE pid=".$_GET['pid']."");
  62. while ($row = mysql_fetch_array($result)){ 
  63. $comments[] = $row['comment'];
  64. }
  65. }
  66. else{
  67. $err[] = 'Your picture doesnt exists';
  68. }
  69. }

  71. if ($_POST['submit']=='Comment'){
  72. if($_POST['comment'] != null){
  73. $_POST['comment'] = mysql_real_escape_string($_POST['comment']);
  74. $_GET['pid'] = mysql_real_escape_string($_GET['pid']);
  76. mysql_query("INSERT INTO photo_comments(pid, comment, dt)
  77. VALUES(
  78. '".$_GET['pid']."',
  79. '".$_POST['comment']."',
  80. NOW()
  81. )");
  82. if(mysql_affected_rows($db_connection)==1){
  83. $success[]='You have added an comment';
  84. }
  85. else{
  86. $err[]='Something went wrong, please try again';
  87. }
  88. }
  89. else{
  90. $err[]='You have to write your comment before you can publish it.';
  91. }
  92. }

  94. if(count($err)){
  95. $msg = $msg.implode('<br />',$err)."<br />";
  96. }
  97. if(count($success)){
  98. $msg = $msg.implode('<br />',$success)."<br />";
  99. }
  100. ?>

    • Topic Participants

    • uffe