<?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() );

?>