I am currently able to communicate with my server and store data in my database, But I don't know how to receive a specific row values or specific column values or specific row & column value from the table of my database. I have searched on many website but nothing matched my intension.
I would be really happy, If you could suggest me any ideas to implement it, provide links and etc.
send the row and column data in the query string. Then on the webserver respond with the data instead of a HTML page.
It should use the same method you are already using to store the data.
Need the SQL? Post your table layout ( column names & data types ) and maybe a few rows of sample data, your task is quite simple.
I think this post would be better off in "Interfacing with Software on the Computer' topic.
your task is quite simple.
I would never have guessed that...
First, phpMyAdmin is a PHP script for creating, modify, and deleting users, tables, etc. in MySQL. It is not able to read from, or write to, the serial port. Nor does it provide a means of accessing specific data from a specific table via a web browser (it simply uses a web browser as the display mechanism).
You need a PHP script that is able to access the MySQL database that contains the data of interest and is able to perform the SELECT statement needed to get the data of interest. That PHP script needs to talk to the serial port or it needs to be on a web server that the Arduino as client can query or it needs to make a GET request of the Arduino as server.
You need to define exactly how the Arduino is to be connected to the PC that PHP is running on.
raschemmel:
your task is quite simple.
I would never have guessed that...
That's what I'm here for. Stick around and you'll learn something new every day.
I do.