Quote Script

[Brian]

I'm going to have a quote section on my new website, and I'm in search of a reliabe, free, and sturdy script for it. I would prefer it be written in php/mySQL and easily customizable, but if it is written in perl I'll live.

Any suggestions?

[kwvarga]

kind of like www.bash.org?

[Brian]

Nope. Kind of like another column. It just displays a random quote, calling it from the database, and I can place the quote anywhere on the site.

[kwvarga]

mmhh
mysql table needs to have 1 column.. quote
mysql.php:
[code:1:6405d18239]<?php
mysql_connect("host", "user", "pass");
mysql_select_db("db");
?>[/code:1:6405d18239]

quote.php:
[code:1:6405d18239]<?php
include("mysql.php");
$query = "SELECT quote FROM table";
$result = mysql_query($query) or die(mysql_error());
$num = mysql_affected_rows();
$rand = rand(1,$num);
$query = "SELECT quote FROM table LIMIT '$rand', '$rand'";
$result = mysql_query($query) or die(mysql_error());
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$quote = $line['quote'];
}?>[/code:1:6405d18239]

index.php or wherever you want to call it from
[code:1:6405d18239]<?php include("quote.php"); ?> and whereever you want to display quote: <?php echo $quote; ?>[/code:1:6405d18239]

want an addquote.php too?

[Brian]

Sure! Thanks Spear

[kwvarga]

addquote.php
[code:1:4a857e22c7]<?php
include("mysql.php");
if (isset($_POST['quote'])) {
$quote = $_POST['quote'];
$query = "INSERT INTO table (quote) VALUES('$quote')";
$result = mysql_query($query) or die(mysql_error());
echo "Quote added.";
} else {
echo "<form method="POST" action="addquote.php"><input name="quote"><input type="submit"></form";
}
?>[/code:1:4a857e22c7]

[kwvarga]

Backlinks are always appreciated yum.

[samer]

nice script spear

[Brian]

Thanks spear You'll get a link on my links page when I get the site up

[kwvarga]

yummy.

[samer]

Hehe lol