PHP+Ajax實現(xiàn)的博客文章添加類別功能示例

更新時間：2018年03月29日 14:23:58 作者：chengqiuming

這篇文章主要介紹了PHP+Ajax實現(xiàn)的博客文章添加類別功能,結合實例形式分析了php+ajax實現(xiàn)的數(shù)據(jù)交互、數(shù)據(jù)庫連接、查詢等相關操作技巧,需要的朋友可以參考下

本文實例講述了PHP+Ajax實現(xiàn)的博客文章添加類別功能。分享給大家供大家參考，具體如下：

一. 代碼

fun.js

function saveType(typename, username){
  if(typename==''){   //判斷博客類別是否為空
    alert('請輸入類別名稱！');
  }else if(username==''){   //判斷用戶名是否為空
    alert('請輸入用戶名！');
  }else{
    var xmlObj;   //定義XMLHttpRequest對象
    var urlData = "typename="+typename+"&username="+username;    //指定要發(fā)送的數(shù)據(jù)
    if(window.ActiveXObject){   //判斷瀏覽器是否支持ActiveXObject組件，如支持則通過ActiveXObject方式創(chuàng)建XMLHttpRequest對象
      xmlObj = new ActiveXObject("Microsoft.XMLHTTP");
    }else if(window.XMLHttpRequest){   //如果瀏覽器不支持ActiveXObject組件，則使用XMLHttpRequest組件創(chuàng)建XMLHttpRequest對象
      xmlObj = new XMLHttpRequest();
    }
    xmlObj.onreadystatechange = callBackFun;   //指定回調(diào)函數(shù)
    xmlObj.open("POST", "saveType.php", true);   //指定提交方法和頁面
    xmlObj.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;");   //指定發(fā)送數(shù)據(jù)庫類型
    xmlObj.send(urlData);   //指定發(fā)送的數(shù)據(jù)
    function callBackFun(){   //定義回調(diào)函數(shù)
      if(xmlObj.readyState == 4 && xmlObj.status == 200){   //如果服務器端返回內(nèi)容并無錯誤發(fā)生
        if(xmlObj.responseText == 'y'){  //判斷保存是否成功，并給出提示
          alert('類別添加成功！');
        }else{
          alert('類別添加失??！');
        }
      }
    }
  }
}

conn.php

<?php
$host = '127.0.0.1';
$userName = 'root';
$password = 'root';
$connID = mysql_connect($host, $userName, $password);
mysql_select_db('db_database27', $connID);
mysql_query('set names gbk');
?>

index.php

<?php
require_once 'conn.php';
?>
<!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=gb2312" />
<title>添加類別</title>
<link rel="stylesheet" type="text/css" href="css/style.css" rel="external nofollow" rel="external nofollow" />
</head>
<script language="javascript" src="js/fun.js"></script>
<body>
<table border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td><img src="images/banner.gif" width="608" height="109" /></td>
 </tr>
</table>
<table width="200" height="7" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td></td>
 </tr>
</table>
<table width="608" height="200" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#7ED227">
 <tr>
  <td width="150" bgcolor="#F6FEFE" valign="top">
  <table width="150" border="0" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#D6FEFE">
   <?php
     $sql = mysql_query("select typename,username from tb_type order by addtime desc", $connID);
     $result = mysql_fetch_array($sql);
     if ($result){
       do{
   ?>
   <tr>
    <td bgcolor="#A6E617" height="20"><div align="center"><a href="#" rel="external nofollow" rel="external nofollow" class="a1"><?= $result['typename']?></a></div></td>
   </tr>
   <tr>
    <td bgcolor="#F2F2F2" height="12"><div align="left">發(fā)布人：
     <?= $result['username']?>
     </a></div></td>
   </tr>
   <?php
       }while($result = mysql_fetch_array($sql));
     }else{
   ?>
   <tr>
    <td bgcolor="#A6E617" height="20">暫無文章類別</td>
   </tr>
   <?php
     }
   ?>
</table>
  </td>
  <td width="455" bgcolor="#FFFFFF" style="padding-left:30px; line-height:25px">
  請輸入博客類別：<br />
  &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="typename" size="30" id="typename" /><br /><br/>
  發(fā)布人：<br />
  &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="username" size="30" id="username" /><br /><br/>
  <input type="button" value="保存" onclick="saveType(typename.value, username.value)" />
  </td>
 </tr>
</table>
<table width="200" height="7" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td></td>
 </tr>
</table>
<table width="608" height="70" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td background="images/bottom.gif"><div align="center">
   <DIV align="center">『博客』 版權所有 <a  rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="a1">吉林省**科技有限公司</a>!  未經(jīng)授權禁止復制或建立鏡像!<BR>
     <BR>Copyright &copy; <a  rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="a1">www.mingri***.com</a> All Rights Reserved!<BR>
   </DIV>
  </div></td>
 </tr>
</table>
</body>
</html>

saveType.php

<?php
require_once 'conn.php';
?>
<!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=gb2312" />
<title>添加類別</title>
<link rel="stylesheet" type="text/css" href="css/style.css" rel="external nofollow" rel="external nofollow" />
</head>
<script language="javascript" src="js/fun.js"></script>
<body>
<table border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td><img src="images/banner.gif" width="608" height="109" /></td>
 </tr>
</table>
<table width="200" height="7" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td></td>
 </tr>
</table>
<table width="608" height="200" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#7ED227">
 <tr>
  <td width="150" bgcolor="#F6FEFE" valign="top">
  <table width="150" border="0" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#D6FEFE">
   <?php
     $sql = mysql_query("select typename,username from tb_type order by addtime desc", $connID);
     $result = mysql_fetch_array($sql);
     if ($result){
       do{
   ?>
   <tr>
    <td bgcolor="#A6E617" height="20"><div align="center"><a href="#" rel="external nofollow" rel="external nofollow" class="a1"><?= $result['typename']?></a></div></td>
   </tr>
   <tr>
    <td bgcolor="#F2F2F2" height="12"><div align="left">發(fā)布人：
     <?= $result['username']?>
     </a></div></td>
   </tr>
   <?php
       }while($result = mysql_fetch_array($sql));
     }else{
   ?>
   <tr>
    <td bgcolor="#A6E617" height="20">暫無文章類別</td>
   </tr>
   <?php
     }
   ?>
</table>
  </td>
  <td width="455" bgcolor="#FFFFFF" style="padding-left:30px; line-height:25px">
  請輸入博客類別：<br />
  &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="typename" size="30" id="typename" /><br /><br/>
  發(fā)布人：<br />
  &nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="username" size="30" id="username" /><br /><br/>
  <input type="button" value="保存" onclick="saveType(typename.value, username.value)" />
  </td>
 </tr>
</table>
<table width="200" height="7" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td></td>
 </tr>
</table>
<table width="608" height="70" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
  <td background="images/bottom.gif"><div align="center">
   <DIV align="center">『博客』 版權所有 <a  rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="a1">吉林省**科技有限公司</a>!  未經(jīng)授權禁止復制或建立鏡像!<BR>
     <BR>Copyright &copy; <a  rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="a1">www.mingri***.com</a> All Rights Reserved!<BR>
   </DIV>
  </div></td>
 </tr>
</table>
</body>
</html>

二. 運行結果