getting next/previous record via jquery and php -


i have website reads data baseball games. first website displays game dates , scores:

$.post('../php/getgamedates.php', function(returneddates) {     var objdates = jquery.parsejson( returneddates );     $('#content').hide();      var pubstr = "";     (var a=0; a<objdates.length; a++) {         var dateparts = objdates[a].game_date.split("-");                     var mo;                     switch(dateparts[1]) {                         case "04":                             mo = "april"                             break;                         case "05":                             mo = "may"                             break;                         case "06":                             mo = "june"                             break;                         case "07":                             mo = "july"                             break;                         case "08":                             mo = "aug."                             break;                         case "09":                             mo = "sept."                             break;                         case "10":                             mo = "oct."                             break;                         default:                             break;                     }                     var day = dateparts[2].replace(/^0+/, '');          pubstr += "<div class='game_to_click' id='" + objdates[a].game_date + "'>" + mo + " " + day + ", " + dateparts[0] + ": " + objdates[a].score + "</div>"     }     $('#game_dates').append(pubstr); ... });

when click date, popup of data game. there prev/next buttons on popup. thing is, data seems "blink" when appears on popup. suspect that's because of query database. here php code "prev" button:

<?php include_once ('../../../homicide/php/constants_test.php');  // connect database $mysqli = new mysqli(db_host, db_user, db_password, db_name); //open db conn if (mysqli_connect_errno()) {         printf("connect failed: %s", mysqli_connect_error());         exit(); } //date_default_timezone_set('america/new_york'); $thisdate = $_post['thisdate']; //echo $thisdate; //$time = strtotime($thisdate . ' - 1 day'); //$newdate = date('y-m-d',$time); $parts = explode("-", $thisdate); $day = $parts[2]; if (substr($day, -2) == "0") {     $day = substr($day, -1);     $day = intval($day); } $day--; $newdate = $parts[0] . "-" . $parts[1] . "-"; //echo '$day: ' . $day; if (strlen($day) < 2){     $newdate .= "0"; } $newdate .= $day; //echo "new: " . $newdate . " "; tryquery($newdate, $mysqli);  function tryquery($thisdate, $mysqli) {     $q = "select * pirates_games game_date = '" . $thisdate . "'";     $result = $mysqli->query($q);     $row_cnt = mysqli_num_rows($result);     //echo $row_cnt;     if ($row_cnt > 0) {         while($row = $result->fetch_array(mysqli_assoc)) {             $arrgame = $row;         }         echo json_encode($arrgame);         mysqli_close($mysqli);     }     else {         //echo 'date on entry: ' . $thisdate . " ";         $parts = explode("-", $thisdate);         $day = $parts[2];         if (substr($day, -2) == "0") {             $day = substr($day, -1);             $day = intval($day);         }         $day--;         $newdate = $parts[0] . "-" . $parts[1] . "-";         //echo '$day: ' . $day;         if (strlen($day) < 2){             $newdate .= "0";         }         $newdate .= $day;         //echo "new: " . $newdate . " ";         //$time = strtotime($thisdate . ' - 1 day');         //$newdate = date('y-m-d',$time);         //echo "new: " . $newdate;         tryquery($newdate, $mysqli);     } }   ?>

is method of trying first 1 query right way go this? times, there game next day or previous day, sometimes, dates skip day. i'm not sure how account skipped days when try find next or previous game.

my way of thinking on load games sequential rather date based method. recode show previous 'game' rather 'previous day's game', (or next day's game) etc... it's more accurate game sequence you've described. way previous game's date associated information, part of display.

if doesn't appeal you, load dates array associated games (date being key , game or no game being data). on dates have no game can show in display options.


Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more