Hi,
It is really easy to connect to your database, using Wappler. The first thing you need to do is to open the Server Connect panel:
[image]
If you have not selected your server model when defining your project, then you will see a message saying that you need to specify one. Click the project options button:
[image]
Open the server model drop-down and select one - PHP, ASP.NET or Classic ASP:
[image]
In order to connect to a database, we also need to setup a target. You can do this by clicki…
After you created your Database Connection, now it’s time to setup a Database Query. Right click the Database Connection step:
[image]
Open Database Actions:
[image]
Add Database Query:
[image]
Then click the Query Builder button, in order to setup your query:
[image]
Open the database tables drop-down and select a table:
[image]
If you want to add all the table columns to the query, you don’t have to do anything else - the table is already added. If you want to add specific columns to…
After you created your database query let’s bind the data on your page.
First you need to add the server action containing your database query to your page. Select App in the App Structure and click the add new component button:
[image]
Open the Data category:
[image]
And select Server Connect component:
[image]
Once you add it, select your server action:
[image]
The Server Action picker appears. It shows the server actions defined for your site. Click your server action containing the …
Thanks a lot