Le code de création de la table:
CREATE TABLE IF NOT EXISTS `graph_tbl` (
`ffeed` text COLLATE utf8_unicode_ci NOT NULL,
`ftimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`fvalue` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
La page php d’alimentation de la table.
serveur : les-fougs.com/phpMyAdmin
MariaDB 5
MariaDB 10 héberge la base wordpress du site Inform@+
<?php
$db_name = "samsoulmod1";
$db_table = "graph_tbl";
$db_login = "samsoulmod1";
$db_passw = "xxxxxxxx";
if (!isset($_GET['f1']) || !isset($_GET['v1']))
die ("v or f is null");
$feeds = $_GET['feeds'];
$db = mysql_connect(‘localhost’, $db_login, $db_passw);
mysql_select_db($db_name, $db) or die(‘Erreur SQL !
’.mysql_error());
$sql = "INSERT INTO ".$db_table." (ffeed, ftimestamp, fvalue) VALUES";
for($i=1;$i<=$feeds;$i++){
$feed = $_GET['f'.$i];
$value = $_GET['v'.$i];
if ($i==$feeds){
$sql.=" (\"".$feed."\", NOW(), ".$value.")";
} else {
$sql.=" (\"".$feed."\", NOW(), ".$value."),";
}
mysql_query($sql, $db) or die(‘Erreur SQL !
’.mysql_error());
echo "OK";
?>
