Hi there,

Is it possible to add any MQTT sensor information in standard compliments? Like weather information or any other MQTT topic from HomeAssistant etc. But not additional area, I want to use default compliments section on center of the mirror.

best,

@Exosys How did you that? Can you share please?

@ralberth said in Simple MySQL query:

current_date()

Yes it’s Turkish

Module is working
But I need a little todo
I’m using this module for my son’s daily course schedule and meal chart.

Previously, I use a php script (on my NAS) to get data from mysql and and parse with my Home Assistan server from RestApi and pull form Home Assistant server via MMM-homeassistant-sensors (I know it’s very dirty method)

MySql query in php is displaying next day’s data after 15:00 each day (sample code bellow) to aware of next day program.

    $bugun = date("l");
    $yarin = date("l", time()+86400);
    $hour = date('H');
    if ($hour > 15) { $bugun = $yarin; }

Is it possible to use additional string and if statement in config file?

@ralberth looks good. Is it possible to add additional variable like date (as bugun in sample code) in sql query?
My table has monthly data, and I want to display related day’s data. here is my php code:

$servername = "localhost";
$username = "user";
$password = "pass";
$dbname = "hometest";
$bugun = date("Y-m-d");
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT tarih, sabah, oglen, aksam FROM yemek WHERE tarih='$bugun'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<table>";
......

```</table>

Hi there,
My mirror is up to date. MMM-Wunderground works well except iconset. My config is below.

But icons are still flaticons.

Any idea?

{
    	module: 'MMM-WunderGround',
    	position: 'top_right',
    	config: {
        apikey: 'XXXXXXXXXX',
        pws: 'Istanbul', 
        hourly: '0',
        fctext: '1',
        fcdaycount: "3",
        fcdaystart: "0",
        hourlyinterval: "3",
        hourlycount: "2",
        alerttime: 10000,
        alerttruncatestring: "english:",
				roundTmpDecs: 1,
				UseCardinals: 0,
				layout: "horizontal",
				sysstat: 0,
				iconset: "VCloudsWeatherIcons"
			}
		},

Hi there,
I’m new here. I installed MagicMirror on RasPi without any problems. My current goal is to print the data of a table in the MySQL database. But I did not find a practical method on the forum. Anyone know of a ready-made module that can do this?

Thanks in advance.

Belek