I need PDO Pagination WITHOUT specific WHERE clauses for rows

I need PDO Pagination WITHOUT specific WHERE clauses for rows

I don't know much PDO, but I want to switch over to it.

Because I have an estimated 8 million WHERE clauses like this:

WHERE city LIKE ('Salt Lake City - UTAH - USA *') AND ethnicityage LIKE ('Caucasian White Males 1954 --- 57 to 58 years old') LIMIT {$t},{

I need to get away from such where clauses and use a general variable (or whatever the technical name for it is) such as:

WHERE city='$city'";

WHERE ethnicity='$ethnicity'";


to pull the specific city, ethnicity, whatever from dropdown lists WITHOUT actually listing all 8 million specifics.

I have this working by itself. I also have pagination working by itself. But when I try to combine the two, the pagination no longer works.

Perhaps it just needs a javascript change? I don't know. But I want to upgrade to PDO now and not just "mysql" or "mysqli".

Here are a couple current scripts but you'll probably be best to create your own?

To VIEW one of the current SEARCHES:

[url removed, login to view]

go to the bottom of the cities and click on "Salt Lake City - UTAH - USA *"

on the ethnicities dropdown click on "Caucasian - White Males 1954 --- 58 to 59 years old"

(BUT actually these pages are NOT hooked up well and clicking on anything will work ... THIS is just an example of something like what I want):

[url removed, login to view]

Compétences : Javascript, MySQL, PHP

en voir plus : pagination pdo, pdo pagination, i.t. works, i don t know, php pagination pdo, specific, Salt, rows, php pdo, pdo, mysqli, mysql specific, mysql combine, click dropdown javascript, pagination pdo php, pagination php pdo, technical scripts, pdo pagination php, pdo mysql, need name usa, php pdo pagination, pagination php mysql example, combine javascript, need china, pagination mysql php

Concernant l'employeur :
( 10 commentaires ) Sandy City, United States

Nº du projet : #2372705

Décerné à:


I think I can meet your demands. Time of completion may be adjusted.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(3 Commentaires)

5 freelance font une offre moyenne de $110 pour ce travail


Actually your description is very funny. PDO is just an abstract database layer.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)

Ready to start now. Please check PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(13 Commentaires)

Hello, Greetings from Voyage SoftTech, Thank you for taking the time to review our proposal. We are having well experienced team of experts in designing and development using PHP, HTML, Joomla, Magneto, word Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Custom software development - <b><i>Removed by Admin</i></b>

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)