PHP MySql Mutliple select queries in one php file

Question

I have a php file which I use to build a table. I am basically echoing out the html code... For the data, I am using multiple select queries. The queries take the data in different tables... My question: Is it ok to run multiple select queries in one file? For security purpose or else? Thank you in advance for your replies. Cheers. Marc.

:D yes it definitively is okay :P

Vyktor
– Vyktor

2012-02-10 15:28:14 +00:00
Commented Feb 10, 2012 at 15:28 — Vyktor
– Vyktor, Commented Feb 10, 2012 at 15:28

Christoph Grimmer · Accepted Answer · 2012-02-10 15:30:59Z

3

There is no problem to run several queries from the same PHP script. Some advice: Work through the results once the query is sent and store information in a local data structure if needed. That way resources can be freed quickly. Even better would be to join the queries if possible because each database call costs a lot of time.

answered Feb 10, 2012 at 15:30

Christoph Grimmer

4,3434 gold badges43 silver badges66 bronze badges

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

1 Comment

Marc Over a year ago

Thanks Christop for the tips.

mirza · Accepted Answer · 2012-02-10 15:32:25Z

1

Security concerns should be same for multiple queries and a single query. On the other hand, when it comes to mysql queries you should concern about performance. You may combine that seperate queries in one query and that way you can gain performance for avoiding sending multiple requests seperatly.

answered Feb 10, 2012 at 15:32

mirza

5,82111 gold badges48 silver badges75 bronze badges

Collectives™ on Stack Overflow

PHP MySql Mutliple select queries in one php file

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related