Manipulating MySQL database using php

Question

Let's say that I want to perform 2 MySQL operations:

Operation 1:

SELECT * From Comments ORDER BY ID DESC

Operation 2:

SELECT * From Comments WHERE Date >'2012-05-01', ORDER BY ID ASC

Clearly, the second table is contained within the first; the specifics are just hypothetical. My question: Rather than perform 2 separate MySQL queries as done above, is it possible to obtain just the first, use it, then LATER manipulate it using php to obtain the second? In the example above, the php function would need to alter the order of the table and remove inapplicable rows, but again, it's just an example.

Why do I care?

Well, I'm trying to limit the number of MySQL connections to my server. Rather than have 5 separate queries that reference the same one master table, I'd prefer to have just 1, and use php to manipulate it 4 times so as to get the same final product.

Thanks!

Please go through JOIN

arunrc
– arunrc

2014-08-22 05:27:42 +00:00
Commented Aug 22, 2014 at 5:27 — arunrc
– arunrc, Commented Aug 22, 2014 at 5:27

deceze · Accepted Answer · 2014-08-22 05:29:35Z

3

No, you cannot "alter the table". When you query the database from PHP, you're not getting "the table" back as a result, you're just getting a result set back. What you can perfectly do is store this result in a PHP variable and use PHP code to further filter or sort that data:

$result  = $pdo->query('SELECT * From Comments ORDER BY ID DESC')->fetchAll();
$result2 = array_filter($result, function (array $row) {
    return strtotime($row['Date']) > strtotime('2012-05-01');
});
usort($result2, function (array $a, array $b) {
    return $a['ID'] - $b['ID'];
});

answered Aug 22, 2014 at 5:29

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

Comments

walkeros · Accepted Answer · 2014-08-22 05:30:50Z

0

It seems that can be done like this:

Launch first query
iterate backwords through results (you will programatically have ASC order instead of DESC)

2a. for each record check if "Date" meets your criteria

answered Aug 22, 2014 at 5:30

walkeros

5,0254 gold badges41 silver badges49 bronze badges

Collectives™ on Stack Overflow

Manipulating MySQL database using php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related