Ajax & PHP Learning and Practicing Part 3 Database_PHP Tutorial

在上一篇备忘日历实例中，实现了当鼠标放在某个日期上时，如果当天有备忘信息则会显示出来，但是这些信息是为了测试方便事先写在数组中的数据，不能体现其实时性。本篇将继续通过该实例讲解与数据库的交互方式。实例中用到的是MySQL，也可以根据自己的需要替换为其他数据库，其连接方式可以参考PHP相关手册。

在下面源程序包中dbconnector.php 提供了与MySQL的连接函数。 Copy to Clipboard引用的内容：[www.bkjia.com] //定义数据连接变量
define ("MYSQLHOST", "localhost");
define ("MYSQLUSER", "root");
define ("MYSQLPASS", "root");
define ("MYSQLDB", "test");

function opendatabase(){
//连接数据库所在服务器
$db = mysql_connect (MYSQLHOST,MYSQLUSER,MYSQLPASS);
try {
if (!$db){
//若无法连接则提示错误
$exceptionstring = "Error connection to database:
";
$exceptionstring .= mysql_errno().": ".mysql_error();
throw new exception ($exceptionstring);
}
else{
//连接数据库（test）
mysql_select_db (MYSQLDB,$db);
}
return $db;
}catch (exception $e){
echo $e->getmessage();
die();
}
}
?> 当鼠标放到某个日期上时会调用functions.js中的checkfortasks函数。同时checkfortasks会加载taskchecker.php程序，它会到MySQL中查询该日期下所有的备忘录信息，并将结果返回到页面中。  Copy to Clipboard引用的内容：[www.bkjia.com] //调用数据库连接程序
require_once ("dbconnector.php");
//连接数据库
$db = opendatabase();
//在MySQL查询备忘录
$querystr = "SELECT description FROM task WHERE thedate='" . addslashes ($_GET['thedate']) . "'";
//执行SQL
if ($datequery = mysql_query ($querystr)){
//判断查询是否有值
if (mysql_num_rows ($datequery) > 0){
?>

//显示备忘录信息
while ($datedata = mysql_fetch_array ($datequery)){
if (!get_magic_quotes_gpc()){
echo stripslashes ($datedata['description']);
}
else{
echo $datedata['description'];
}
}
?>

}
}
else{
//Database query error
echo mysql_error();
}
//Close the database
mysql_close ($db);
?>

The principle of using Ajax is the same as the previous article: 1. Call the Ajax function through events; 2. Request other PHP programs through functions. PHP programs can read, write, and read data sources such as databases. Change the operation; 3. Load the processing results to the event firing page. When the mouse is placed on No. 26 in the picture below, Ajax will query the "Football Match" event in MySQL and load it to the current page.

Source code download: Sample4.rar

Author’s blog: http://www.cnblogs.com/gnielee/

http://www.bkjia.com/PHPjc/364428.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364428.htmlTechArticleIn the previous memo calendar example, when the mouse is placed on a certain date, if the current day Memo information will be displayed, but this information is written in advance for testing convenience...