大家好:

想請教想把韌體的資料透過IP傳到mysql該怎麼做?
我試著用"TCP &UDP Dubuger"想傳資料到mysql但都失敗

我有參考這篇文章
http://scolin912.blogspot.com/2017/05/php-mysql-mqtt.html

但還是沒頭緒.....
而且測試PHP時，他都會出現

以下是程式碼:

<?php
   require_once("phpMQTT.php"); //同個資料夾下，要有phpMQTT.php這個檔案
  $host = "127.0.0.1";
  $port = 1883;
  $username = "";
  $password = "";

  $mqtt = new phpMQTT($host, $port, "ClientID".rand());

  if(!$mqtt->connect(true,NULL,$username,$password)){
    exit(1);
  }

  //currently subscribed topics
  $topics_update_BLE['hello/update_BLE_data'] = array("qos"=>0, "function"=>"procmsg");
  $topics_add_data['hello/add_data'] = array("qos"=>0, "function"=>"procmsg1");
  $mqtt->subscribe($topics_update_BLE,0);
  $mqtt->subscribe($topics_add_data,0);

  while($mqtt->proc()){       
  }

  $mqtt->close();
  function procmsg($topic_update_BLE,$msg){
    $NewString = explode('\\', $msg,5);
      mysql_connect("localhost","","") or die("connect error!");
      mysql_select_db('test') or die("db error");
      mysql_query("insert into tt(acc) values ('333')");
      echo 'Update_data success ';
  }

?>

謝謝