how to connect php to mysql

[duchaine1]

Hi,

Being somewhat new to the subject I ALREADY have the connection code to database, what I need is WHERE to place it.

In other words where do I put THIS...

<?php $conn = mysqli_connect(         <location-of-your-database>,         <your-MySQL database-username>,         '<your-MySQL-database-password>,

and so on.

It is all done and ready to go. So, do I put it in index.html, no good, DB error so where does it go? Also is it a <PHP> page?  

Surprisingly this is hard to find. Everybody talks in detail about the script, but NOBODY mentions where it is placed! 

Thanks!

Duchaine

(du shane)

 

 

[mac_gyver]

by default, only files with a .php extension will be operated on by the php language engine.

the code in for any .php page should be laid out in this general order -

1. initialization
2.  post method form processing
3. get method business logic - get/produce data needed to display the page
4. html document

the database connection would be made at the earliest point where it is needed, usually in the initialization section.

if you are just starting out, the PDO extension is much simpler and better designed then the mysqli extension, especially when using prepared queries, which you should be using when supplying external, unknown, dynamic values to a query when it gets executed.