Version: 1.0
Type: Full Script
Category: Other
License: GNU General Public License
Description: “The World’s simplest PHP Message/Quote of the Day Script” is a simple “quote-of-the-day script” that needs access to a MySQL database. It only consists of one script that’s SIMPLE and hence easy to customize. This is how it works: You put any number of quotes/messages/whatever into the database, and then the script will show one quote every day. When all quotes have been shown, the script starts from the beginning of the quotes again. And if your quote-of-the-day page doesn’t receive any visitors on a given day, the given quote-of-the-day will be shown the next day too. It simple, yet smart.
<html>
<head>
<title>Quote of the day <?php echo date("F jS, Y"); ?></title>
</head>
<body>
<h1>Quote of the day <?php echo date("F jS, Y"); ?></h1>
<table border="2" cellpadding="6" style="border-collapse: collapse" bordercolor="#C0C0C0" width="60%" cellspacing="0">
<tr>
<td width="100%"><code>
<?php
// *****************************************************************************
// -------"The World's simplest PHP Message/Quote of the Day Script"----------
//
// Author: Mads Sgaard ([email protected])
// Homepage: http://www.emacs.dk/quote/
// Version: 1.0
//
//
// *****************************************************************************
// -------------------- Description --------------------------------------------
//
// "The World's simplest PHP Message/Quote of the Day Script" is a simple
// "quote-of-the-day script" that needs access to a MySQL database. It only
// consists of one script that's SIMPLE and hence easy to customize. This is how
// it works: You put any number of quotes/messages/whatever into the database,
// and then the script will show one quote every day. When all quotes have been
// shown, the script starts from the beginning of the quotes again. And if your
// quote-of-the-day page doesn't receive any visitors on a given day, the given
// quote-of-the-day will be shown the next day too. It simple, yet smart.
//
//
// *****************************************************************************
// -------------------- Installation --------------------------------------------
// 1. Upload the quote.php to your web server.
// 2. Change the following variables $DB_SERVER,$DB_USER, $DB_PASS, $DB_NAME
// (see below)
// 3. Create the needed tables in your database with the quotes.sql file.
// You can do it from the prompt (mysql -u[username] [-p] [database] < quotes.sql)
// or you can use the wonderful phpMyAdmin at http://www.phpwizard.net/projects/phpMyAdmin/
// 4. Point your browser to http://yourdomain/quotes.php
// 5. Add your own quotes to the database and custumize the script as you see fit.
//
// *****************************************************************************
// -------------------- Do you find this script useful? ------------------------
//
// Then by all means recommend it to other people! Or link back to me from your
// homepage (that would be greatly appreciated)
// You can also review my script and give it good grades at:
// http://www.hotscripts.com/PHP/Scripts_and_Programs/Quote_Display/
// (or anywhere else you may have found it)
//
// ******************************************************************************
// ****************************************
// Fill in your database information below
// ****************************************
$DB_SERVER = "your-db-server.com";
$DB_USER = "your-username";
$DB_PASS = "your-password";
$DB_NAME = "the-name-of-your-database";
// ****************************************
// ****************************************
// you do NOT have to edit below this line
// ****************************************
$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
mysql_select_db($DB_NAME);
$getNoOfQuotesQuery = mysql_query("select count(*) from quotes", $con);
$no_of_quotes = mysql_result($getNoOfQuotesQuery,0);
$getMetaDataQuery = mysql_query("SELECT * FROM quotes_meta", $con);
$row = mysql_fetch_row($getMetaDataQuery);
$number_reached = $row[1];
$date_modified= $row[2];
// get the current day of the month (from 1 to 31)
$day_today = date("j");
if ($date_modified != $day_today){
// we have reached the end of the quotes
if ($number_reached >($no_of_quotes - 1)){
$number_reached = 1;
$query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con);
mysql_query($query3,$con);
} else {
// we haven't reached the end of the quotes
// therefore we increment $number_reached
$number_reached = $number_reached + 1;
$query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con);
mysql_query($query3,$con);
}
}
// we get the quote with 'id = $number_reached' from the database
$getQuoteQuery = mysql_query("SELECT quote,author FROM quotes WHERE id = ".$number_reached, $con);
$row = mysql_fetch_row($getQuoteQuery);
// we print the quote ($row[0]) and the author ($row[0])
echo $row[0]."<p align='right'><i>-- " . $row[1];
// close the database connection
mysql_close($con);
?>
</i></code></td>
</tr>
</table>
<p> </p>
</body>
</html>
