title: How to download data from web server Mysql database to Arduino Yun using PHP?
body: <p>I am using an Arduino Yun for my project. I need to download data from web host, 000webhost, mysql database to my Arduino Yun. How can I achieve that? I want to use php file, which should be working independently. How should I on the Arduino Yun side.
  Here is my PHP script code:</p>
  
  <pre><code>&lt;?php
      $db_name = "00000";
      $mysql_user = "0000";
      $mysql_pass = "0000";
      $server_name = "mysql9.000webhost.com";
  
      $con = mysqli_connect($server_name,$mysql_user,$mysql_pass,$db_name);
  
      $dname = $_GET["dname"];
      $dlastname = $_GET["dlastname"];
      $pname = $_GET["pname"];
      $plastname = $_GET["plastname"];
  
      $statement = mysqli_prepare($con, "SELECT * FROM drug WHERE dname = ? AND dlastname = ? AND pname = ? AND plastname = ?");
      mysqli_stmt_bind_param($statement, "ssss", $dname, $dlastname, $pname, $plastname);
      mysqli_stmt_execute($statement);
  
      mysqli_stmt_store_result($statement);
      mysqli_stmt_bind_result($statement, $userID, $dname, $dlastname, $pname, $plastname, $drug, $time, $minute, $amount, $op);
  
      $response = array();
      $response["success"] = false;  
  
      while(mysqli_stmt_fetch($statement)){
          $response["success"] = true;
          $response["userID"] = $userID;  
          $response["dname"] = $dname;
          $response["dlastname"] = $dlastname;
          $response["pname"] = $pname;
          $response["plastname"] = $plastname;
          $response["drug"] = $drug;
          $response["time"] = $time;
          $response["minute"] = $minute;
          $response["amount"] = $amount;
          $response["op"] = $op;
      }
      //echo"Drug: ".$drug;
      //echo"Hour: ".$time;
      //echo"Minute: ".$minute;
      //echo"Op: ".$op;
  
  
  ?&gt;
  </code></pre>
  
  <p>Basically just get the input from Arduino: dname, dlastname, pname, and plastname. And then search the whole table. If these four columns match, just download the whole information of that row from Mysql database.</p>
  
  <p>Two question:
  1. If there is no problem with php script, how should write the code in Arduino yun 
  2.How to download data from php file? Is there something like a return so that I can get all data in Arduino Yun?</p>