{"id":689,"date":"2013-11-15T09:59:23","date_gmt":"2013-11-15T08:59:23","guid":{"rendered":"http:\/\/sam-soul.fr\/Info\/?p=689"},"modified":"2019-10-08T10:29:18","modified_gmt":"2019-10-08T08:29:18","slug":"graph-sur-myvera","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2013\/11\/15\/graph-sur-myvera\/","title":{"rendered":"Graph sur MyVera"},"content":{"rendered":"<h2>Le code de cr\u00e9ation de la table:<\/h2>\n<pre>CREATE TABLE IF NOT EXISTS `graph_tbl` (\n `ffeed` text COLLATE utf8_unicode_ci NOT NULL,\n `ftimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `fvalue` double NOT NULL\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<\/pre>\n<h2>La page php d&rsquo;alimentation de la table.<\/h2>\n<pre><a href=\"http:\/\/les-fougs.com\/phpMyAdmin\/index.php\">serveur : les-fougs.com\/phpMyAdmin<\/a>\n\nMariaDB 5 \nMariaDB 10 h\u00e9berge la base wordpress du site Inform@+<\/pre>\n<pre>\n&lt;?php\n $db_name = \"samsoulmod1\";\n $db_table = \"graph_tbl\";\n $db_login = \"samsoulmod1\";\n $db_passw = \"xxxxxxxx\";\n\nif (!isset($_GET['f1']) || !isset($_GET['v1']))\n die (\"v or f is null\");\n$feeds = $_GET['feeds'];\n$db = mysql_connect(\u2018localhost\u2019, $db_login, $db_passw);\n mysql_select_db($db_name, $db) or die(\u2018Erreur SQL !\n \u2019.mysql_error());\n\n$sql = \"INSERT INTO \".$db_table.\" (ffeed, ftimestamp, fvalue) VALUES\";\n for($i=1;$i&lt;=$feeds;$i++){\n $feed = $_GET['f'.$i];\n $value = $_GET['v'.$i];\n if ($i==$feeds){\n $sql.=\" (\\\"\".$feed.\"\\\", NOW(), \".$value.\")\";\n } else {\n $sql.=\" (\\\"\".$feed.\"\\\", NOW(), \".$value.\"),\";\n }\n\n mysql_query($sql, $db) or die(\u2018Erreur SQL !\n \u2019.mysql_error());\n echo \"OK\";\n ?&gt;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Le code de cr\u00e9ation 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&rsquo;alimentation de la table. serveur : les-fougs.com\/phpMyAdmin MariaDB 5 MariaDB 10 h\u00e9berge la base wordpress du site &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2013\/11\/15\/graph-sur-myvera\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Graph sur MyVera&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/689"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":2,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/689\/revisions"}],"predecessor-version":[{"id":2302,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/689\/revisions\/2302"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=689"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}