<?php
// ------------------------------------------------------------------------- //
// Génère une boîte javascript à partir de données MySQL. //
// Insérer le code suivant : //
// <SCRIPT LANGUAGE="JavaScript" SRC='boite-javascript.php'> //
// </SCRIPT> //
// ------------------------------------------------------------------------- //
// Auteur: J-Pierre Dézélus //
// Email: jpdezelus@phpinfo.net //
// Web: http://www.phpinfo.net/ //
// ------------------------------------------------------------------------- //
/*
CREATE TABLE `news` (
`code` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`titre` varchar(100) NOT NULL default '',
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`code`)
)
*/
$cfg_host = 'localhost';
$cfg_user = 'root';
$cfg_pass = '';
$cfg_base = 'base';
function tableau_deb($fond, $padding, $spacing, $largeur = "")
{
if ($largeur != '') $largeur = "WIDTH='$largeur'";
if ($fond != '') $fond = "BGCOLOR='$fond'";
$chaine = "<TABLE BORDER='0' $fond CELLSPACING='$spacing' ";
$chaine .= "CELLPADDING='$padding' $largeur>";
$chaine .= "<TR VALIGN='top'><TD>";
return($chaine);
}
function tableau_fin()
{
$chaine = "</TD></TR></TABLE>";
return($chaine);
}
function jscript($chaine)
{
return("document.write(\"".$chaine."\");\n");
}
echo jscript( tableau_deb("#1C2D67", "1", "0", "") );
echo jscript( tableau_deb("#B8C8FE", "5", "0", "100%") );
echo jscript( "<CENTER>" );
echo jscript( "<A HREF='http://www.phpinfo.net' TARGET='_blank'>" );
echo jscript( "<IMG SRC='http://www.phpinfo.net/images/phpinfo-button.gif' BORDER=0 " );
echo jscript( "ALIGN='absmiddle' WIDTH='88' HEIGHT='31'></A>" );
echo jscript( "</CENTER>" );
echo jscript( "<HR COLOR='5A6BA5' NOSHADE>" );
if (@mysql_connect($cfg_host, $cfg_user, $cfg_pass))
{
$sql = "SELECT code, DATE_FORMAT(date, '%d-%m'), titre ";
$sql .= "FROM news ";
$sql .= "WHERE active = 1 AND date <= '".date("Y-m-d")."' ";
$sql .= "ORDER BY date DESC, code DESC ";
$sql .= "LIMIT 0,10";
$resultat= @mysql_db_query($cfg_base, $sql);
$cpt = 0;
while ($enr = @mysql_fetch_array($resultat))
{
if ($cpt++ > 0)
echo jscript( "<BR>" );
echo jscript( "<FONT FACE=Helvetica SIZE=-2 COLOR=#354785>[".$enr[1]."] </FONT>" );
echo jscript( "<FONT FACE=Helvetica SIZE=-2 COLOR=#0540FD>" );
echo jscript( "<A HREF='http://www.phpinfo.net/?p=archives&idnews=".$enr[0]."' " );
echo jscript( "TARGET='_blank'>" );
$texte = strlen($enr[2]) > 24 ? substr($enr[2], 0, 20)." ..." : $enr[2];
echo jscript( htmlspecialchars($texte)."</A></FONT>" );
}
}
echo jscript( tableau_fin() );
echo jscript( tableau_fin() );
?>