How to link to .htm file from .php

sulin

Hello,

I have a sample login in http://tsldesigns.com/php/login.htm

Attached is my sample code for a PHP file.
How do I add a link to call HTM file (example, successful.htm) from PHP? Pls add the code for me. This PHP file is to check and add userid and password to database. After that, I want it to go to another HTM file called successful.htm. How to code it? Thanks.

$db_name = "tsl_db";
$table_name = "login";
$connection = mysql_connect("localhost", "myadmin", "somepassword") or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "SELECT id FROM login WHERE id ='$id'";
$result = mysql_query($sql) or die("Couldn't execute query.");

//Check if Id exist in table.
if (mysql_num_rows($result) > 0) {
echo "ID Name exists.";
exit;
} else {

$sql_insert = "INSERT INTO login (id, password) VALUES ('$id', '$password')";
$result_insert = mysql_query($sql_insert) or die ("Couldn't execute query."); 

if(!$result_insert) { 
echo "Insert Unsuccessful: ", mysql_error(); 
exit; 
} else { 
echo "Record is added."; 
}

}

// Close database
mysql_close($connection);

Any help or codeing added will be useful.
Thanks

Su Lin
http://tsldesigns.com

jtsmoke

Use the header() function. Replace the line
echo "Record is added.";
with
header("location:successful.htm");

You must be certain that there is no html output before the header function executes or it will fail.

sulin

Thanks so much, I will try it out now.

Su Lin
http://tsldesigns.com