How to pass array value in mysql select query

Question

With the help of to this question, "Divide numbers into equal parts to create Sitemap from mysql", I got this result:

Array ( [0] => 0,500 
        [1] => 500,1000 
        [2] => 1000,1500 
        [3] => 1500,2000 
        [4] => 2000,2500 
        [5] => 2500,2990 )

My question is, I want to pass the above Array values to select query limit. like this:

 "SELECT * FROM `table_name` WHERE `rec_id`='1' limit 0 OFFSET 500 "

and so on upto limit 2500, 2990.

How to do this? I am new to development. please help me with the solution.

Thank you in advance.

while looping in outside array, u can explode innner array or u can multiply the index with 500 and u will have starting index. — Purushottam zende
– Purushottam zende, Commented Dec 14, 2016 at 12:24
@RiggsFolly not like pagination. I want to send mails in group. so for this i have created group of 500 contacts. and fetching 500 email address from table . but i am confused how to use it in query? — php_coder
– php_coder, Commented Dec 14, 2016 at 12:26
You need to start by creating the array correctly so you get [0] => 0,500, [1] => 501,500,...... — RiggsFolly
– RiggsFolly, Commented Dec 14, 2016 at 13:44

Yoleth · Accepted Answer · 2016-12-14 12:25:30Z

2

Actually you want a pagination with 500 results begining at an index, right ? So limit should always be 500, only offset value should change.

$queries = [];
$array = Array ( [0] => 0,500 
    [1] => 500,1000 
    [2] => 1000,1500 
    [3] => 1500,2000 
    [4] => 2000,2500 
    [5] => 2500,2990 );

foreach ( $array as $value ){
    $offsets = explode(',', $value);
    $queries[] = "SELECT * FROM `table_name` WHERE `rec_id`='1' limit 500 OFFSET $offsets[0]";
}

answered Dec 14, 2016 at 12:25

Yoleth

1,2727 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2016-12-14 12:23:41Z

1

Here is the code

foreach($arr as $k => $v){

  list($limit, $offset) = explode(','$v);

   $query_arr[] = "SELECT * FROM `table_name` WHERE `rec_id`='1' limit $limit OFFSET $offset";
}

And then fire $query_arr as you want

answered Dec 14, 2016 at 12:23

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Collectives™ on Stack Overflow

How to pass array value in mysql select query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related