This is a sample code i wrote for a Mysql Database using PHP. make sure to protect ur self against SQL injection before sending the data to this code. Hope u find this useful.
<?php
$user = $_POST['user']; //user name from login page
$pass = $_POST['pass']; //password from login page
$conn = mysql_connect("Server IP", "user name", "password"); //server IP | Login User Name | Password
mysql_select_db("database name", $conn); //Database Name
$query = "SELECT * FROM Table_name WHERE user_column='$user' AND pass_column='$pass'";
$res = mysql_query($query);
if (mysql_num_rows($res)==1) {
session_start();
header( "Location: pagename.php" );
} else {
header( "Location: errorpage.php" );
}
?>