cannot connect database in php using phpmyadmin?

S

Smith

New member
i have create a php page and connect to a database using phpmyadmin in my computer and its works perfectly but when i transfer the same page and connect it to the same database in another computer..its does not work..the page open and all the php code appears above the table form..
below is the php codes
<?php
echo "<h1>register</h1>";
$submit=$_POST['submit'];


$firstname=strip_tags($_POST['firstname']);
$lastname=strip_tags($_POST['lastName']);
$email=strip_tags($_POST['email']);
$telephone=strip_tags($_POST['telephone']);
$address=strip_tags($_POST['address']);
$username=strip_tags($_POST['username']);
$password=(strip_tags($_POST['password']));
$repeatpassword=(strip_tags($_POST['repeatpassword']));

if($submit)
{
//open database
$connect=mysql_connect("localhost","root","");
mysql_select_db("register");
$namecheck=mysql_query("SELECT username FROM users WHERE username='$username'");
$count=mysql_num_rows($namecheck);
if ($count!=0)
{
die("username already taken");
}


//CHECK FOR EXISTANCE
if ($firstname&&$lastname&&$email&&$telephone&&$address&&$username&&$password&&$repeatpassword)
{

if ($password==$repeatpassword)
{
//chek char length of username and names
if (strlen($firstname)>20||strlen($lastname)>20||strlen($username)>20)
{
echo "Max Limit for first name, last name and username are 20 characters";
}
else
{
//check password length
if (strlen($password)>25||strlen($password)<6)
{
echo "Passowrd must be between 6 and 25 characters";
}
else
{
//register the user
$queryreg=mysql_query("
INSERT INTO users VALUES ('','$firstname','$lastname','$email','$telephone','$address','$username','$password')
");
die ("you have been registered");
}
}
}
else
echo "your passsword do not match";
}
else
echo "please fills in <b>all</b> fields";
}


?>
<html>
<p align="left">
<form action='register.php' method='POST'>
<table>
<tr>
<td>
<b>First Name:</b>
</td>
<td>
<input type='text' name='firstname'>
</td>
</tr>
<tr>
<td height="36">
<b>Last Name:</b>
</td>
<td>
<input type='text' name='lastName'>
</td>
</tr>
<tr>
<td height="36">
<b>Email:</b>
</td>
<td>
<input type='text' name='email'>
</td>
</tr>
<tr>
<td height="36">
<b>Telephone::</b>
</td>
<td>
<input type='text' name='telephone'>
</td>
</tr>
<tr>
<td height="36">
<b>Address:</b>
</td>
<td>
<input type='text' name='address'>
</td>
</tr>
<tr>
<td height="36">
<b>Username:</b>
</td>
<td>
<input type='text' name='username'>
</td>
</tr>
<tr>
<td height="36">
<b>Password:</b>
</td>
<td>
<input type='text' name='password'>
</td>
</tr>
</tr>
<tr>
<td height="36">
<b>Repeat Passowrd:</b>
</td>
<td>
<input type='text' name='repeatpassword'>
</td>
</tr>
<tr>
<td>
<input type='submit' name='submit' value='Register'>
</td>
</tr>
</table>
</form>
</p>
</html>
 
Back
Top