mosca mysql,php mysql 和MQTT的連接問題

大家好:

想請教想把韌體的資料透過IP傳到mysql該怎麼做?

我試著用"TCP &UDP Dubuger"想傳資料到mysql但都失敗

但還是沒頭緒.....

而且測試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 ';

}

?>

謝謝