Etiquette and proper use of php

[sanderphp]

I'm still tweaking my first ever php project and want to learn how to properly do things.

 

I have:

login.php that is just a form

checklogin.php which verifies the username and password

login_success.php where the user enters the data

add_data.php which writes the data to the table

submit_success.php which displays the entry and total miles ridden this year

 

My presumption is that I can probably do a lot of these functions in one or two php files.

 

I'm also loading stuff like this on most pages which seems really repetitive:

 

$host="localhost"; // Host name 
$username="stuff_admin"; // Mysql username 
$password="password"; // Mysql password 
$db_name="stuff_cycling"; // Database name 
$tbl_name="riders"; // Table name 

// Connect to server and select databse.
$conn = mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

 

I would guess that I should be storing the password in a file so someone couldn't just open my php files and access my db  but I haven't been able to find a tutorial on how to do that anywhere. 

 

 

 

[bilis_money]

$host="localhost"; // Host name

$username="stuff_admin"; // Mysql username

$password="password"; // Mysql password

$db_name="stuff_cycling"; // Database name

$tbl_name="riders"; // Table name

 

// Connect to server and select databse.

$conn = mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

just use include();

 

for a nice tutorial visit this.

http://www.evolt.org/PHP-Login-System-with-Admin-Features

 

good luck.