1、ajax.js文件
// JavaScript Document
var xmlHttp;
function S_xmlhttprequest()
{
xmlHttp=null;
if (window.XMLHttpRequest)
{// code for IE7, Firefox, Opera, etc.
xmlHttp=new XMLHttpRequest();
}
else if (window.ActiveXObject)
{// code for IE6, IE5
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
function getName(name)
{
if(name = document.myform.name.value)
{
S_xmlhttprequest();
xmlHttp.open("get","data.php?name="+name,true);
xmlHttp.onreadystatechange = byname;
xmlHttp.send(null);
}
}
function byname()
{
if(xmlHttp.readyState ==1)
{
document.getElementById('name').innerHTML = "<font color=red>loading....</font>";
}
if(xmlHttp.readyState == 4)
{
if(xmlHttp.status == 200)
{
var name = xmlHttp.responseText;
document.getElementById('name').innerHTML = name;
}
}
}
function getEmail(email)
{
var email = document.myform.email.value;
if(email =="")
{
alert("用户名不能为空");
document.myform.email.focus();
return false;
}
else
{
S_xmlhttprequest();
xmlHttp.open("get","data.php?email="+email,true);
xmlHttp.onreadystatechange = byemail;
xmlHttp.send(null);
}
}
function byemail()
{
if(xmlHttp.readyState ==1)
{
document.getElementById('email').innerHTML = "<font color=red>loading....</font>";
}
if(xmlHttp.readyState == 4)
{
if(xmlHttp.status == 200)
{
var email = xmlHttp.responseText;
document.getElementById('email').innerHTML = email;
}
}
}
2、register.php文件
<script src="/blog_article/Ajax.js" language="javascript"></script>
<body>
<form action="" method="post" name="myform">
<table align="center">
<tr><td>用户名:</td><td><input type="text" name="name" value="" onblur="getName('name')"/></td><td><div id="name"><font color="#CC66CC">*用户名必填*</font></div></td></tr>
<tr><td>邮箱:</td><td><input type="text" name="email" value="" onblur="getEmail('email')"/></td><td><div id="email"><font color="#CC66CC">*邮箱必填*</font></div></td></tr>
</table>
</form>
3、data.php页面，用于ajax查询数据库。
sleep(1);
$connt = mysql_connect()("localhost","root","123456");
mysql_select_db('test',$connt );
mysql_query()("set names 'gb2312'");
if($_GET['name'])
{
$name = $_GET['name'];
$sql = "select * from test where name='$name'";
$restul = mysql_query($sql);
$array = mysql_fetch_row($restul);
// print_r($array);
if(is_array($array))
{
echo "<font color='red'>该用户名已经存在</font>";
}
else
{
echo "<font color='red'>该用户名可以用</font>";
}
}
if($_GET['email'])
{
$name = $_GET['email'];
$sql = "select * from test where email='$email'";
$restul = mysql_query($sql);
$array = mysql_fetch_row($restul);
// print_r($array);
if(is_array($array))
{
echo "<font color='red'>该邮箱已存在</font>";
}
else
{
echo "<font color='red'>该邮箱可以用</font>";
}
}
?>
由此即可实现用户注册时局部刷新的功能了。
1、首先，插入数据的代码。
<?
$action=$_GET['action'];
switch($action){
//添加记录
case"add";
$mail = trim(htmlspecialchars()($_POST["mail"]));
$username = trim(htmlspecialchars($_POST["username"]));
$tel = trim(htmlspecialchars($_POST["tel"]));
$fax = trim(htmlspecialchars($_POST["fax"]));
$company = trim(htmlspecialchars($_POST["company"]));
$address = trim(htmlspecialchars($_POST["address"]));
$sql="insert into crm_company (mail,username,tel,fax,company,address,addtime) values
('$mail','$username','$tel','$fax','$company','$address','$addtime')";
//echo $sql;
mysql_query()($sql,$conn);
print "<mce:script type="text/javascript"><!--location.href='/blog_article/c_companylist.html'; // --></mce:script>";//*/
}?>
2、编辑指定的数据的代码
<?
$action=$_GET['action'];
switch($action){
//添加记录
case"edit";
$uid = trim(htmlspecialchars($_POST["uid"]));
$regtime = trim(htmlspecialchars($_POST["regtime"]));
$deadline = trim(htmlspecialchars($_POST["deadline"]));
$item = trim(htmlspecialchars($_POST["item2"]));
$price = trim(htmlspecialchars($_POST["price"]));
$product = trim(htmlspecialchars($_POST["product"]));
$content = trim(htmlspecialchars($_POST["content"]));
$sql="update crm_info set uid='$uid',regtime='$regtime',deadline='$deadline',item='$item',price='$price',product='$product',
content='$content' where id='$id'";
//echo $sql;
mysql_query($sql,$conn);
print "<mce:script type="text/javascript"><!-- location.href='/blog_article/c_infolist.html'; // --></mce:script>";//*/
}?>
html：
<form id="form1" name="form1" method="post" action="/blog_article/action/edit/amp;id/lt;php echo $rs[.html'id'];?>" onSubmit="return checkadd()"> </form>
3、删除指定数据的代码
<a href="/blog_article/action/del/amp;id/lt; echo $rs[.html'id'];?>" onclick="return confirm('确定删除?')">删除</a>
<?
$action=$_GET['action'];
switch($action){
//删除记录
case"del";
$id=$_GET['id'];
$sql="delete from crm_info where id='$id'";
mysql_query($sql,$conn);
print "<mce:script type="text/javascript"><!--location.href='/blog_article/c_infolist.html';// --></mce:script>";
break;
}
?>
为您推荐： php mysql数据库操作类
php数据库操作类(实现表增删改查、取行数、查询多条数据等)
PHP数据库调用类的应用实例(详细注释)
这里主要用到了session保存当前访问者，并将访问次数写入本地文件。
<?
@session_start();
$counter = intval(file_get_contents("counter.dat"));
if(!$_SESSION[''])
{
$_SESSION[''] = true;
$counter++;
$fp = fopen("counter.dat","w");
fwrite($fp, $counter);
fclose($fp);
}
?>
共访问：
<?php echo "$counter";?>次