https://www.turnkeylinux.org

http://www.sitepoint.com/forums/showthread.php?645467-Retreiving-the-previous-and-next-row-through-PDO&p=4425809&viewfull=1#post4425809 SELECT i.images_id ,COALESCE( (SELECT images.images_id FROM images WHERE images.images_id < i.images_id ORDER BY images.images_id DESC LIMIT 1), (SELECT images.images_id FROM images ORDER BY images.images_id DESC LIMIT 1) ) AS previous_images_id ,COALESCE( (SELECT images.images_id FROM images WHERE images.images_id > i.images_id ORDER BY images.images_id ASC LIMIT 1), (SELECT images.images_id FROM images ORDER BY images.images_id ASC LIMIT 1) ) AS next_images_id FROM images i WHERE i.images_id = 1 \========== for record, not for page 1、 get all new\_id in array (PDO fetchAll(PDO::FETCH\_ASSOC) ) > $all\_news\_ids = $crud->sql("select news\_id from news"); 2、get $now\_news\_id key for array > $now\_news\_id\_key\_id = array\_search(array('news\_id'=>$now\_news\_id), $ar\_all\_news\_ids); 3、check $now\_news\_id\_key\_id first, if empty > $prive\_news\_id = empty($now\_news\_id\_key\_id)?"":get\_record\_column('news\_id', $all\_news\_ids, $now\_news\_id\_key\_id+1); > $next\_news\_id = empty($now\_news\_id\_key\_id)?"":get\_record\_column('news\_id', $all\_news\_ids, $now\_news\_id\_key\_id-1); > function get\_array\_column($val, $ar){ > return array\_key\_exists($val, $ar)?$ar\[$val\]:""; > } > function get\_record\_column($val, $ar, $rec\_arrow=0){ > return (isset($ar\[$rec\_arrow\]))?get\_array\_column($val, $ar\[$rec\_arrow\]) : ""; > }

http://www.sikuli.org/

https://yowureport.com/%E6%89%93%E4%B8%8D%E9%81%8E%E5%B0%B1%E4%BB%BF%E6%95%88%EF%BC%8C%E8%A1%8C%E5%8B%95%E7%B6%B2%E9%A0%81%E7%AA%81%E7%A0%B4-app-%E7%94%9F%E6%85%8B%E5%A3%9F%E6%96%B7%E5%B1%80%E9%9D%A2/

好文 http://adz.cool/posts/711838-merchant-mentality-of-1-software-engineer-to-be-redeployed-fastest-growth-ever-year