How to receive a value from MYSQL server and save it as value in arduino


I would like to know how can i receive a value from MYSQL server and save it as value in arduino

i already have php code that shows the values that stored in databse

header("Refresh: 5; URL=$url");  // Refresh the webpage every 5 seconds
    <title>Light Sensor</title>
        <h1>Light sensor readings</h1>
    <table border="0" cellspacing="0" cellpadding="4">
    // Connect to database

   // IMPORTANT: If you are using XAMPP you will have to enter your computer IP address here, if you are using webpage enter webpage address (ie. "")
    // Retrieve all records and display them   
    $result = mysqli_query($con,'SELECT * FROM table ORDER BY id DESC');
    // Process every record
    while($row = mysqli_fetch_array($result))
        echo "<tr>";
        echo "<td>" . $row['id'] . "</td>";
        echo "<td>" . $row['time'] . "</td>";
        echo "<td>" . $row['value'] . "</td>";
        echo "</tr>";
    // Close the connection   

and arduino code

  client.println("GET /copy.php HTTP/1.1");
    client.println("Connection: close");

the code only shows the content of webpage how can i store it to variable in arduino

if you want to store it directly to the arduino, look at arduino EEROM.

if you want to store it to sd card, look at arduino sd card.

both has extensive tutorials/walk-throughs/examples.

Your PHP script appears able to deliver a number of rows of data.
If you have got a far as retrieving the data from a the web page as text, then you must parse the contents of that web page to extract the individual data items.
You haven't said what network device you are using (ethernet card, ESP8266 etc.).
Anyway, you can make life easier for yourself by formatting the output of the PHP page for easier parsing. You can also look at JSON which can be used here to pack the data into a nice format on the PHP side and there are libraries for unpacking it on the Arduino side.

The php script is a beginning i will edit it to show specific value , i'm using ESP8266 as network device and WiFiEsp.h library to program ESP8266

i am asking is there any way to save value from a web page to arduino variable

Google for "arduino esp8266 parse web page" and you'll see some examples.