Ajax PHP Learning and Practicing Part 3 Database_PHP Tutorial

This article will continue to explain how to interact with the database through this example. MySQL is used in the example, but you can also replace it with other databases according to your own needs. For the connection method, please refer to the relevant PHP manual.

In the source package below, dbconnector.php provides the connection function with MySQL.

Copy code The code is as follows:

//Define data connection variables
define ( "MYSQLHOST", "localhost");
define ("MYSQLUSER", "root");
define ("MYSQLPASS", "root");
define ("MYSQLDB", "test") ;

function opendatabase(){
//Connect to the server where the database is located
$db = mysql_connect (MYSQLHOST,MYSQLUSER,MYSQLPASS);
try {
if (!$db) {
//If it cannot connect, an error will be prompted
$exceptionstring = "Error connection to database:
";
$exceptionstring .= mysql_errno().": ".mysql_error() ;
throw new exception ($exceptionstring);
}
else{
//Connect to database (test)
mysql_select_db (MYSQLDB,$db);
}
return $db;
}catch (exception $e){
echo $e->getmessage();
die();
}
}
?>

When the mouse is placed on a certain date, the checkfortasks function in functions.js will be called. At the same time, checkfortasks will load the taskchecker.php program, which will query MySQL for all memo information on that date and return the results to the page.

Copy code The code is as follows:

//Call the database connection program
require_once ( "dbconnector.php");
//Connect to the database
$db = opendatabase();
//Query the memo in MySQL
$querystr = "SELECT description FROM task WHERE thedate='". addslashes ($_GET['thedate']) . "'";
//Execute SQL
if ($datequery = mysql_query ($querystr)){
//Determine whether the query has a value
if (mysql_num_rows ($datequery) > 0){
?>

//Display memo information
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 modify data sources such as databases. 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

http://www.bkjia.com/PHPjc/320808.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/320808.htmlTechArticleThis article will continue to explain how to interact with the database through this example. MySQL is used in the example, but you can also replace it with other databases according to your own needs. For the connection method, please refer to PH...