# MySQL/PHP get requests

**URL:** <https://community.thunkable.com/t/mysql-php-get-requests/75956>\
**Category:** Questions about Thunkable X\
**Created:** [May 7, 2019, 1:37pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956 "2019-05-07T13:37:23Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [May 7, 2019, 1:37pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/1 "2019-05-07T13:37:23Z")

</div>

Hello valuable users of Thunkable, I’m really been more than 2 months to a problem that I really need to be fixed for my uni project. I want to read from a Mysql database and PHP and put the read value in a Label for example. I tried the Puravid Apps method but it viewed all the readings from the database I just want to select a specific row from the database. Please help me guys and gals as it would be very much appreciated. Thanks in advance.

---

<div class="post-metadata">

**Author:** ![zoran\_vujacic](https://avatars.discourse-cdn.com/v4/letter/z/9de0a6/32.png) [@zoran\_vujacic](https://community.thunkable.com/u/zoran_vujacic)\
**Post date:** [May 8, 2019, 7:08pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/2 "2019-05-08T19:08:53Z")

</div>

Look here  
[http://www.newthinktank.com/2014/05/connect-app-inventor-mysql-database/](http://www.newthinktank.com/2014/05/connect-app-inventor-mysql-database/)

I use PHP code on web server… similiary like this.  
…  
$sql = “SELECT \* FROM dbname WHERE Date BETWEEN ‘$dateFrom\_ap’ AND ‘$dateTo\_ap’ $req\_ap ORDER BY Date ASC”;  
This select rows between date…

Look here for sql commands  
[https://www.w3schools.com/sql/default.asp](https://www.w3schools.com/sql/default.asp)

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [May 9, 2019, 8:47am UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/3 "2019-05-09T08:47:07Z")

</div>

> [@Abanoub\_Gallah](#):
>
> I tried the Puravid Apps method

Hi @Abanoub_Gallah, are you using Thunkable X or Thunkable Classic?

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [May 9, 2019, 1:04pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/4 "2019-05-09T13:04:28Z")

</div>

I’m using Thunkable X

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [May 9, 2019, 1:08pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/5 "2019-05-09T13:08:36Z")

</div>

Then which Puravida Apps Method are you referring to?

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [May 9, 2019, 1:10pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/6 "2019-05-09T13:10:13Z")

</div>

Thank you for your help, I want to display the recent data on Mysql to a label in Thunkable X can’t find how

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [May 9, 2019, 1:13pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/7 "2019-05-09T13:13:21Z")

</div>

The one found here: [https://puravidaapps.com/mysql.php](https://puravidaapps.com/mysql.php)  
When I try it with my app it doesn’t work. All I want to do is read from mysql database the recent data entry which is a datetime data type into a Label in my app.

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [May 9, 2019, 1:20pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/8 "2019-05-09T13:20:19Z")

</div>

That tutorial is only really relevant to Classic users.

Can you send me a screenshot of the headers you are using:

![45](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/8/9875bf24030e74dde23eaddb12df7744829c70d6.png)

And another screenshot of the the blocks you are using too.  
Thanks!

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [April 11, 2019, 12:15am UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/9 "2019-04-11T00:15:51Z")

</div>

Hello, I need help to just read a value from MySql database with PHP server and place its value in a Label in Thunkable X. Please help me as I’m really struggling to find a solution.

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [June 5, 2019, 11:34am UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/10 "2019-06-05T11:34:32Z")

</div>

@Abanoub_Gallah - have you had any luck with this?

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [June 7, 2019, 11:58am UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/11 "2019-06-07T11:58:30Z")

</div>

Hello, @domhnallohanlon thanks for keeping up. Unfortunately, the issue has not been solved yet. You mentioned that Puravidapps is irrelevant in Thunkable X (lacking components?). Also, I don’t understand what do you mean by the Headers. I still don’t know what blocks to create for this task.

---

<div class="post-metadata">

**Author:** ![Abanoub\_Gallah](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Abanoub\_Gallah](https://community.thunkable.com/u/Abanoub_Gallah)\
**Post date:** [June 13, 2019, 12:33am UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/12 "2019-06-13T00:33:39Z")

</div>

I want to write back as I found the solution by converting PHP to JSON then I read it from the app and placed it in a label.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/mysql-php-get-requests/75956/13 "2024-11-08T12:13:26Z")

</div>


