PHP ajax registration verification code exists_PHP tutorial

php ajax registration verification code exists for username This is a registration program. When the user enters the user name, it will automatically go to the database to check whether the user name that the user wants to register has been registered. If so, it will return a prompt, otherwise it will prompt that the user can register.

php tutorial ajax registration verification code for username existence
This is a registration program. When the user enters the user name, it will automatically go to the database tutorial to check whether the user name that the user wants to register has been registered. If so, it will return a prompt, otherwise it will prompt that the user can register.
conn.php file

<script><br /> var xmlhttp<br /> function showhint(str)<br /> {<br /> if (str.length==0)<br /> { <br /> document.getelementbyid("txthint").innerhtml=""<br /> return<br /> }<br /> xmlhttp=getxmlhttpobject()<br /> if (xmlhttp==null)<br /> {<br /> alert ("browser does not support http request")<br /> return<br /> } <br /> xmlhttp.onreadystatechange=statechanged <p>var geturl="conn.php?q="+str<br /> //sid is to add a random number to prevent the page from enabling caching technology·<br /> geturl=geturl+"&sid="+math.random()<br /> geturl=encodeuri(geturl);<br /> geturl=encodeuri(geturl); <br /> xmlhttp.open("get",geturl,true)<br /> xmlhttp.send(null)<br /> } <br /> function statechanged() <br /> { <br /> if (xmlhttp.readystate==4 || xmlhttp.readystate=="complete")<br /> { <br /> document.getelementbyid("txthint").innerhtml=xmlhttp.responsetext <br /> } <br /> }<br /> function getxmlhttpobject()<br /> {<br /> var xmlhttp=null;<br /> try<br /> {<br /> // firefox, opera 8.0+, safari<br /> xmlhttp=new xmlhttprequest();<br /> }<br /> catch (e)<br /> {<br /> // internet explorer<br /> try<br /> {<br /> xmlhttp=new activexobject("msxml2.xmlhttp");<br /> }<br /> catch (e)<br /> {<br /> xmlhttp=new activexobject("microsoft.xmlhttp");<br /> }<br /> }<br /> return xmlhttp;<br /> } <p></script>

Username:

$q=$_get["q"];
$q = urldecode($q);

if (strlen($q) > 0)
{
$conn = @mysql tutorial_connect("localhost","root","1010") or die ("mysql connection error");
mysql_select_db("xin",$conn);
mysql_query("set names 'utf8'");

$sql = "select username from message where username = '$q'";
$query = mysql_query($sql);
@$row = mysql_fetch_array($query);

if(!empty($row['username']))
{
$response = "Already registered!";
}else
{
$response = "Congratulations! You can register!";
}

echo $response;
}

?>

Database
drop database if exists `xin`;
create database `xin` /*!40100 default character set utf8 */;
use `xin`;

create table `message` (
`id` int(11) not null auto_increment,
`username` varchar(20) default null,
primary key (`id`)
) engine=innodb auto_increment=2 default charset=utf8;

http://www.bkjia.com/PHPjc/632060.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632060.htmlTechArticlephp ajax registration verification code to verify whether the user name exists. This is the registration program. When the user completes entering the user name, It will automatically go to the database to check whether the user name to be registered has been registered...