01.<?php
02. include("config_mysqli.php") ;
03.
04. $sql = "SELECT data_user.*,data_car.*,data_prb.*,data_ins.* FROM data_user
05. left JOIN data_car on data_user.id=data_car.id
06. left JOIN data_prb on data_user.id=data_prb.id
07. left join data_ins on data_user.id=data_ins.id
08.
09. WHERE (name LIKE '%".$strKeyword."%' or car_num LIKE '%".$strKeyword."%')";
10.
11.
12. $query = mysqli_query($conn,$sql);
13.
14. $num_rows = mysqli_num_rows($query);
15.
16. $per_page = 3;
17. $page = 1;
18.
19. if(isset($_GET["Page"]))
20. {
21. $page = $_GET["Page"];
22. }
23.
24. $prev_page = $page-1;
25. $next_page = $page+1;
26.
27. $row_start = (($per_page*$page)-$per_page);
28. if($num_rows<=$per_page)
29. {
30. $num_pages =1;
31. }
32. else if(($num_rows % $per_page)==0)
33. {
34. $num_pages =($num_rows/$per_page) ;
35. }
36. else
37. {
38. $num_pages =($num_rows/$per_page)+1;
39. $num_pages = (int)$num_pages;
40. }
41. $row_end = $per_page * $page;
42. if($row_end > $num_rows)
43. {
44. $row_end = $num_rows;
45. }
46.
47.
48. $sql .= " ORDER BY data_user.id desc LIMIT $row_start ,$row_end ";
49. $query = mysqli_query($conn,$sql);
50.
51.?>
จัดไปครับ
