Multiple mysql database queries in php

Question

I have a PHP document which contains mostly html, but also some MySql queries which look like this:

<?php
require_once('connectdata.php');

$db = mysqli_connect(DB_HOST, DB_BENUTZER, DB_PASSWORT, DB_NAME);

$myquery = "SELECT name FROM Entries WHERE typ = 'Communication' ORDER BY name";

$result = mysqli_query($db, $myquery);

while($row = mysqli_fetch_object($result))
 {
 echo "$row->name";

 }

mysqli_close($db);

I am using this exact code several times in my document to echo the data I want to display. Is this a good practice or is there a way to just connect once get all the data and echo them later in the document?

Is it bad if I leave it like that?

On a side note, I recommend using PHP's PDO feature. wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers. — Nathan H
– Nathan H, Commented Feb 20, 2014 at 13:20

Codrutz Codrutz · Accepted Answer · 2014-02-20 13:17:21Z

2

You already have your connection. When you have to make a query just use the syntax:

$myquery = "SELECT name FROM Entries WHERE typ = 'Communication' ORDER BY name";

You can include :

$db = mysqli_connect(DB_HOST, DB_BENUTZER, DB_PASSWORT, DB_NAME);

in your connectdata.php file, which you only include ONCE per file(where is needed).

answered Feb 20, 2014 at 13:17

Codrutz Codrutz

4805 silver badges15 bronze badges

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

5 Comments

Marc Ster Over a year ago

ok and when do i close the connection then? with the last query in my document?

Nathan H Over a year ago

Someone can correct me if I am wrong, but I think PHP will close the connection automatically at the end of the script exec. But yes you can call close at the end yourself.

Jite Over a year ago

@NathanH yes, php will close the connection when the script is done. If its a script that will take a lot of time to execute it might be a good idea to release the connection/s when they are not needed any more tho.

Codrutz Codrutz Over a year ago

@Nathan H you're right. PHP does close the connection at the end of the script execution.

Kickstart Over a year ago

With the slight exception of persistent connections

Collectives™ on Stack Overflow

Multiple mysql database queries in php

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest