[SOLVED] Best Practice

[Andy-H]

What is the best practice for connecting to, selecting and querying a database in MySQL.

 

Thanks for any replies.

[fenway]

Anything specific?

[Andy-H]

Just for a text based MORPG?

[fenway]

Just for a text based MORPG?

That's not really specific... I mean a specific question about how to query.

[SeanHarding]

I guess the best practise would be to have your connect to the database password behind your DNS wall.

 

<?php # connect.php

DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'yourpassword');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', databasename);

$connect = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die ('Could not connect to MySQL: ' . mysqli_connect_error());

?>

 

The in your main DNS page use

<?php
require_once('../connect.php')

$what = "SELECT * bla bla bla";
$query = mysqli_query($connect, $what);

// dont forget to close connection!
mysqli_close($connect);
?>

[Andy-H]

thanks