***Effective pagination system with php on my game/movie site.***
I am very confused with the pagination system of my site, the site consist two services android games and movies but in each they all have their categories for example the android games has categories as follows:
*** ANDRIOD GAMES ***
1. Arcade
2. Sports
3. Action
4. Adventure
5. Simulation
6. Racing
*** MOVIES ***
1. Hd movies
2. Hollywood
3. Bollywood
4. T.V series
5. Mobile-movies
6. Cartoon/Anime
But for now i am working on the android games pagination,
In the ***database***
I have a list of tables for specific categories of android apps in the database
> Arcade_apps_andriod
> Sports_apps_andriod
> Action_apps_andriod
> Adventure_apps_andriod
> Simulation_apps_andriod
> Racing_apps_andriod
For the table this are its fields/columns : Note *** [the same thing apply s to the all fields ] ***
id: 1
features: "Game description: Wings: Remastered edition - a new version of a popular game, where you will participate in air battles of World War I times. Features: 5 fascinating levels Fine graphics Destroy all enemies"
[//this for the app features to be displayed if the user wants to see more about the app.]
page_number: 1 [//the curent page the app is in.]
app_name: "Wings: Remastered edition"[// the name of the app]
app_number: 1 [//the current app number that wil be saved on the data-attr of the app element(div)]
app_cat: "adv_app"[// the app category]
app_img_path: "images/1_subway_surfers.jpg"[// the image path to be place in the image element]
app_pre_img_path1: "images/1_subway_surfers.jpg"
app_pre_img_path2: "images/1_subway_surfers.jpg"
app_pre_img_path3: "images/1_subway_surfers.jpg"
app_pre_video_path: "images/1_subway_surfers.jpg"
This is what i have done on the so far on the pagination script.
In the index_main.php //stop here drop a link
this is are all the selection for the user to click
<div id="andriod_menu">
<div id="categories">
<ul id='cat_con'>
<li id="Arc" data-app="arc_app" data-db-table="arcade_apps_andriod">
<a href="index_main.php?app_cat=arc_app">
<div id="Arc_txt">Arcade
<img src="images/ajax-loader (5).gif" id="loader_ard" value="ard">
</div>
</a>
</li>
<li id="Spo" data-app="spo_app" data-db-table="sports_apps_andriod">
<a href="index_main.php?app_cat=spo_app">
<div id="Spo_txt">Sports
<img src="images/ajax-loader (5).gif" id="loader_ard" value="spo">
</div>
</a>
</li>
<li id="act" data-app="act_app" data-db-table="action_apps_andriod">
<a href="index_main.php?app_cat=act_app">
<div id="act_txt">Action
<img src="images/ajax-loader (5).gif" id="loader_ard" value="act">
</div>
</a>
</li>
<li id="adv" data-app="adv_app" data-db-table="adventure_apps_andriod">
<a href="index_main.php?app_cat=adv_app">
<div id="adv_txt">Adventure
<img src="images/ajax-loader (5).gif" id="loader_ard" value="adv">
</div>
</a>
</li>
<li id="sim" data-app="sim_app" data-db-table="simulation_apps_andriod">
<a href="index_main.php?app_cat=sim_app">
<div id="sim_txt">Simulation
<img src="images/ajax-loader (5).gif" id="loader_ard" value="sim">
</div>
</a>
</li>
<!--<li id="spo"><div id="spo_txt">sports</div></li>-->
<li id="rac" data-app="rac_app" data-db-table="racing_apps_andriod">
<a href="index_main.php?app_cat=rac_app">
<div id="rac_txt">Racing
<img src="images/ajax-loader (5).gif" id="loader_ard" value="rac">
</div>
</a>
</li>
</ul>
</div>
**This are all the apps (app_box() - app_box6() )**
function app_box($app_path1,$app_path2,$app_path3,$app_path4,$app_path5,$app_path6,$app_path7,$app_path8,$app_path9,$app_path10)
{
//$app_path1="images/1_subway_surfers.jpg";
echo'
<div id="app_box1">
<div id="app_1_apkhood" data-app-number="1">
<img src="'.$app_path1.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="1">View More</button>
</div>
<div id="app_2_apkhood" data-app-number="2">
<img src="'.$app_path2.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="2">View More</button>
</div>
<div id="app_3_apkhood" data-app-number="3">
<img src="'.$app_path3.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="3">View More</button>
</div>
<div id="app_4_apkhood" data-app-number="4">
<img src="'.$app_path4.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="4">View More</button>
</div>
<div id="app_5_apkhood" data-app-number="5">
<img src="'.$app_path5.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="5">View More</button>
</div>
<div id="app_6_apkhood" data-app-number="6">
<img src="'.$app_path6.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="6">View More</button>
</div>
<div id="app_7_apkhood" data-app-number="7">
<img src="'.$app_path7.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="7">View More</button>
</div>
<div id="app_8_apkhood" data-app-number="8">
<img src="'.$app_path8.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="8">View More</button>
</div>
<div id="app_9_apkhood" data-app-number="9">
<img src="'.$app_path9.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="9">View More</button>
</div>
<div id="app_10_apkhood" data-app-number="10">
<img src="'.$app_path10.'" id="app_1_img">
<button class="btn btn-large btn-primary" id="view_more" value="10">View More</button>
</div>
</div>
<div id="pagination_box_model">
<tr>
<td><a href="index_main.php?default_app_cat=arc_app&page=back">Back</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=1">1</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=2">2</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=3">3</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=4">4</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=5">5</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=6">6</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=7">7</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=8">8</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=9">9</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=10">10</a></td>
<td><a href="index_main.php?default_app_cat=arc_app&page=11">Next</a></td>
</tr>
</div>
';
}
Then i did a switch case on the URL $_GET['app_cat'] to output each games based on the category selected. this the code
<?php
if (isset($_GET['app_cat'])) {
$vvv=$_GET['app_cat'];
switch ($vvv) {
case 'arc_app':
$app_path1="images/1_wings_remastered_edition.jpg";
$app_path2="images/1_wings_remastered_edition.jpg";
$app_path3="images/1_wings_remastered_edition.jpg";
$app_path4="images/1_wings_remastered_edition.jpg";
$app_path5="images/1_wings_remastered_edition.jpg";
$app_path6="images/1_wings_remastered_edition.jpg";
$app_path7="images/1_wings_remastered_edition.jpg";
$app_path8="images/1_wings_remastered_edition.jpg";
$app_path9="images/1_wings_remastered_edition.jpg";
$app_path10="images/1_wings_remastered_edition.jpg";
app_box1($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
case 'spo_app':
$app_path1="images/1_madagascar_join_the_circus.jpg";
$app_path2="images/1_madagascar_join_the_circus.jpg";
$app_path3="images/1_madagascar_join_the_circus.jpg";
$app_path4="images/1_madagascar_join_the_circus.jpg";
$app_path5="images/1_madagascar_join_the_circus.jpg";
$app_path6="images/1_madagascar_join_the_circus.jpg";
$app_path7="images/1_madagascar_join_the_circus.jpg";
$app_path8="images/1_madagascar_join_the_circus.jpg";
$app_path9="images/1_madagascar_join_the_circus.jpg";
$app_path10="images/1_madagascar_join_the_circus.jpg";
app_box2($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
case 'act_app':
$app_path1="images/andriod_apps_label.png";
$app_path2="images/andriod_apps_label.png";
$app_path3="images/andriod_apps_label.png";
$app_path4="images/andriod_apps_label.png";
$app_path5="images/andriod_apps_label.png";
$app_path6="images/andriod_apps_label.png";
$app_path7="images/andriod_apps_label.png";
$app_path8="images/andriod_apps_label.png";
$app_path9="images/andriod_apps_label.png";
$app_path10="images/andriod_apps_label.png";
app_box3($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
case 'adv_app':
$app_path1="images/andriod_logo_1.png";
$app_path2="images/andriod_logo_1.png";
$app_path3="images/andriod_logo_1.png";
$app_path4="images/andriod_logo_1.png";
$app_path5="images/andriod_logo_1.png";
$app_path6="images/andriod_logo_1.png";
$app_path7="images/andriod_logo_1.png";
$app_path8="images/andriod_logo_1.png";
$app_path9="images/andriod_logo_1.png";
$app_path10="images/andriod_logo_1.png";
app_box4($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
case 'sim_app':
$app_path1="images/movies1.jpg";
$app_path2="images/movies1.jpg";
$app_path3="images/movies1.jpg";
$app_path4="images/movies1.jpg";
$app_path5="images/movies1.jpg";
$app_path6="images/movies1.jpg";
$app_path7="images/movies1.jpg";
$app_path8="images/movies1.jpg";
$app_path9="images/movies1.jpg";
$app_path10="images/movies1.jpg";
app_box5($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
case 'rac_app':
$app_path1="images/movies2.jpg";
$app_path2="images/movies2.jpg";
$app_path3="images/movies2.jpg";
$app_path4="images/movies2.jpg";
$app_path5="images/movies2.jpg";
$app_path6="images/movies2.jpg";
$app_path7="images/movies2.jpg";
$app_path8="images/movies2.jpg";
$app_path9="images/movies2.jpg";
$app_path10="images/movies2.jpg";
app_box6($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10);
break;
default:
# code...
break;
}
}
$app_path1="images/1_subway_surfers.jpg";
$app_path2="images/1_subway_surfers.jpg";
$app_path3="images/1_subway_surfers.jpg";
$app_path4="images/1_subway_surfers.jpg";
$app_path5="images/1_subway_surfers.jpg";
$app_path6="images/1_subway_surfers.jpg";
$app_path7="images/1_subway_surfers.jpg";
$app_path8="images/1_subway_surfers.jpg";
$app_path9="images/1_subway_surfers.jpg";
$app_path10="images/1_subway_surfers.jpg";
?>
<?php app_box($app_path1,
$app_path2,
$app_path3,
$app_path4,
$app_path5,
$app_path6,
$app_path7,
$app_path8,
$app_path9,
$app_path10); ?>
</div>
<?php
if ((isset($_GET['default_app_cat']))&&(isset($_GET['page']))) {
$www=$_GET['default_app_cat'];
$dic=$_GET['page'];
}
?>
This is where my problem is, the pagination based on the from page one to page to next page to store the value the a particular category was selected say "arcade" for example, all app showing should be showing arcade apps only please how can i do that.