01.
02.
03.<?php
04.$con = parser_database_connect( $host, $db, $user, $psw );
05.$rq = (object)$_POST;
06.$ro = $con->query( 'select * from table_name where id = ? ', $rq->id)->row();
07.$er='';
08.switch( $rq->op ){
09. case 'up':
10. $ro_step = $con->query( 'select * from table_name where step < ? order by step desc limit 1 ', $ro->step )->row()??(object)['id'=>false];
11.
12. if( ! $ro_step->id ){
13. $er = 'เป็นรายการ แรกอยู่แล้ว';
14. }
15. break;
16. case 'dn':
17. $ro_step = $con->query( 'select * from table_name where step > ? order by step asc limit 1 ', $ro->step )->row();
18.
19. if( ! $ro_step->id ){
20. $er = 'เป็นรายการ สุดท้ายอยู่แล้ว';
21. }
22. break;
23.}
24.if( strlen($er)<1 ){
25. $con->query( 'update table_name set step = ? where id = ? ', $ro_step->step, $ro->id );
26.
27. $con->query( 'update table_name set step = ? where id = ? ', $ro->step, $ro_step->id );
28.
29.}
30.header('Content-Type: application/json; charset=utf-8');
31.echo json_encode((object)['success'=>$er ? 0 : 1, 'error'=>$er]);
