This signup script is ok on local but is having problem on the host.
Can you help me? the link is http://takfekr.com/testregister.php
thanks
code but user, pass
the first error is
A database error occurred in processing checking your '.
'submission.\\nIf this error persists, please '.
'contact m2babaeyt@yahoo.com
and if i remove that part of code, "no database selected
Code: Select all
<?php // signup.php
include("head.php");
include("common.php");
function pak($chars){
$chars= mysql_real_escape_string($chars);
$chars= htmlspecialchars($chars);
return $chars;
}
if (!isset($_POST['submit'])):
// Display the user signup form
?>
<!DOCTYPE html PUBLIC "-//W3C/DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=utf-8
</head>
<body>
<p align=right>
<font color="orangered" size="+1"><tt><p align=right><b></b></tt></font>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']?>">
<br> <br> <br><p align=center>
name
<br><input name="name" type="text" dir=rtl maxlength="100" size="25" /><br>
email
<br><input name="email" type="text" maxlength="100" size="25" dir=ltr /><br>
state
<br><input name="state" type="text" dir=rtl maxlength="100" size="25" /><br><br>
city
<br><input name="city" type="text" dir=rtl maxlength="100" size="25" /><br><br>
username
<br><input name="username" type="text" maxlength="100" size="25" dir=ltr /><br>
<br>
password
<br><input name="pass" type="password" maxlength="100" size="25" dir=ltr /><br>
<br>
password again
<br><input name="pass2" type="password" maxlength="100" size="25" dir=ltr /><br>
<br>
<input type="submit" name="submit" value=" register " />
</form>
</body>
</html>
<?php
else:
mysql_connect('localhost', 'username', 'pass');
mysql_select_db('articles');
$_POST['pass']=md5($_POST['pass']);
$_POST['pass2']=md5($_POST['pass2']);
$_POST['name']=pak($_POST['name']);
$_POST['username']=pak($_POST['username']);
$_POST['pass']=pak($_POST['pass']);
$_POST['pass2']=pak($_POST['pass2']);
$_POST['city']=pak($_POST['city']);
$_POST['state']=pak($_POST['state']);
// Process signup submission
if ($_POST['name']=='' or $_POST['username']=='' or $_POST['pass']==''
or $_POST['pass2']=='') {
error('please enter name,username & passwords');
}
// this makes sure both passwords entered match
if ($_POST['pass'] != $_POST['pass2'])
error('passwords don not match');
// Check for existing user with the new id
$sql = "SELECT COUNT(*) FROM `user` WHERE `username` = '$_POST[username]'";
$result = mysql_query($sql);
if (!$result) {
error('A database error occurred in processing checking your '.
'submission.\\nIf this error persists, please '.
'contact m2babaeyt@yahoo.com.');
}
if (mysql_result($result,0,0)>0) {
error('username already taken');
}
mysql_query("INSERT INTO member(name, email, state, city, username, password) VALUES('$_POST[name]', '$_POST[email]', '$_POST[state]','$_POST[city]','$_POST[username]','$_POST[pass]' ) ")
or die(mysql_error());
if (!mysql_query($sql))
error('A database error occurred in processing your '.
'submission.\\nIf this error persists, please '.
'contact m2babaeyt@yahoo.com.\\n' . mysql_error());
// Email the new password to the person.
?>
<!DOCTYPE html PUBLIC "-//W3C/DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title> Registration Complete </title>
<meta http-equiv="Content-Type"
content="text/html; charset=utf-8" />
</head>
<body>
<p ><strong>Success</strong></p>
<p>
</body>
</html>
<?php
endif;
?>