// quotes.inc
// Created by Andrew R. Freed (arf132@psu.edu)
// Modified on August 27, 2002
$dbhost = "localhost";
$dbusername = "mxstine";
$dbuserpass = "redrum8102005";
$default_dbname = "mxstine_quotebook";
$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';
function displayRandomQuote()
{
// make connection to database
$connection = db_connect("quotes");
$queryCount = "SELECT COUNT(*) AS numRecs FROM Quotes Q";
//Get record count
$strSqlQuery = $queryCount;
$result = db_query($strSqlQuery, $connection);
$row = db_fetch_row($result);
$numRecs = $row[0];
srand((double)microtime()*1000000);
$myRand = rand(0, $numRecs - 1);
//Get thought of the day
$strSqlQuery = "SELECT Name, Quote, Id FROM Quotes Q WHERE Q.id=" . $myRand;
$result = db_query($strSqlQuery, $connection);
$row = db_fetch_row($result);
print "
\n";
print " \n";
print " | \n";
print " Thought for the Day\n";
print " \"$row[1]\" \n";
print " - $row[0] \n";
print " | \n";
print "
\n";
print "
\n";
}
function db_connect($dbname = "")
{
global $dbhost, $dbusername, $dbuserpass, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpass);
if(!$link_id)
{
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = "Connection failed to the host $dbhost.";
return 0;
}
else if(empty($dbname) && !mysql_select_db($default_dbname))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else if(!empty($dbname) && !mysql_select_db($dbname))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}
function db_select_db($dbname)
{
return mysql_select_db($dbname);
}
function db_query($result, $db_link=NULL)
{
if( empty($db_link) )
return mysql_query($result);
else
return mysql_query($result, $db_link);
}
function db_fetch_row($result)
{
return mysql_fetch_row($result);
}
function db_num_rows($result)
{
return mysql_num_rows($result);
}
function db_close()
{
mysql_close();
}
function sql_error()
{
global $MYSQL_ERRNO, $MYSQL_ERROR;
if(empty($MYSQL_ERROR))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
}
return "$MYSQL_ERRNO: $MYSQL_ERROR";
}
?>