Proverbs
[insert_php]
$today = getdate();
echo “
printf(“Today is %s, %s %d, %s”, $today[weekday], $today[month], $today[mday], $today[year]);
echo “
$link = mysqli_connect(“68.178.253.32”, “d2d23622742927”, “qHvQW}}gp6-L”, “d2d23622742927”, 3311);
if ($today[mday] == 31)
{
$prov_num = rand (1, 30);
}
else
{
$prov_num = $today[mday];
}
/* Select queries return a resultset */
if ($result = mysqli_query($link, “SELECT * FROM proverb_otd WHERE proverb_otd_id = $prov_num”)) {
// printf(“Select returned %d rows.\n”, mysqli_num_rows($result));
}
/* associative array */
//$row = $result->;fetch_array(MYSQLI_ASSOC);
//printf (“%s %s”, $row[“proverb_otd_id”], $row[“proverb_text”]);
while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
echo “
echo ereg_replace(“([0-9]+)”, ”
\\0″, $row[“proverb_text”]);
}
/* free result set */
mysqli_free_result($result);
mysqli_close($link);
[/insert_php]