Navigation

    MagicMirror Forum

    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • Donate
    • Discord
    1. Home
    2. kayhanbelek
    K
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    kayhanbelek

    @kayhanbelek

    0
    Reputation
    6
    Posts
    243
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    kayhanbelek Follow

    Best posts made by kayhanbelek

    This user hasn't posted anything yet.

    Latest posts made by kayhanbelek

    • Compliments from MQTT sensor

      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,

      posted in General Discussion
      K
      kayhanbelek
    • RE: Web request when switching profile with MMM-ProfileSwitcher

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

      posted in Requests
      K
      kayhanbelek
    • RE: Simple MySQL query

      @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?

      posted in Requests
      K
      kayhanbelek
    • RE: Simple MySQL query

      @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>
      posted in Requests
      K
      kayhanbelek
    • MMM-Wunderground iconset doesn't work

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

      But icons are still flaticons.

      alt text

      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"
      			}
      		},
      
      posted in Troubleshooting
      K
      kayhanbelek
    • Simple MySQL query

      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

      posted in Requests
      K
      kayhanbelek