Creating a web database application in 5 minutes using AppGini

Creating a web database application in 5 minutes using AppGini


If you are looking for a way to make a user-friendly, fast and feature-rich web application in a very short time, that’s when AppGini comes handy. First we’ll start a new project. Let’s give it a name: in our example we’ll name it “product catalog”. Then we’ll add two tables one for “categories” and another one for “items”. You can assign an icon for each table by clicking on the box at the left of the table name. Next, we’ll add fields to each table. Each table MUST contain a primary key field. If you name a field “ID”, it will automatically become a primary key. You can add as many fields and tables as you need. Now, let us try out some of AppGini’s features. If we set a field as a look-up, it would be displayed to users as a drop-down, listing data from another table. This makes your web application more organized. We’ll set the “category” field as a look-up field simply by clicking on the “look-up field” tab, selecting “category” as the “parent table” then “category name” as the “parent caption field”. In addition, if you want to list items under each category, , you’ll need to configure the “categories” table by opening the “parent/children settings”, select the “items” table, check “enabled”, “show icon” and optionally rename the “tab title” to a more descriptive one. All you need to do now is to generate your web application by clicking the magic stick icon. Choose your application path and AppGini will do the job for you. These are the files generated by AppGini. Let us visit our web application and see this in action. This is the setup data page. Once we are done filling it, we start using our application. As you can see, both tables appear on the first page. Let’s go to the “Categories” table and enter some data. Here you can see the table fields. To start adding a new record simply click “Add new”. You will automatically be directed to the Data entry page, also known as Detail view form. We’ll enter Dresses and T-shirts as an example. Simply press “back” to see how the table looks like. Once we’re done, we jump to “items” table and start adding our data for this table as well. Do you see how the “category” field is displayed? It’s a drop down menu, because we set it up as a look-up field in AppGini. The drop down lists the categories that we entered a moment ago in the “categories” table. AppGini offers special features for fields with immutable data like “size” and “target groups”. This is how the “items” table looks after adding our data. Now let us go back to AppGini to see how to make use of its features. To create a drop-down list, click on the field name, then on “options list”, and type all values you need, separating options with double semicolon. You can choose among three options for how to display your options list. In our case we will choose the “drop-down list”. We’ll perform the same steps for the “target group” field, but this time we’ll choose “radio buttons” instead of “drop-down list”. Once we generate, we get back to our web application, refresh the page and start adding a new record. So this way our “size” field became a drop-down field and our “target group” field became a radio buttons field. Finally, this is how our table looks like. To get to know more about AppGini, please visit our homepage for more video tours.

Danny Hutson

29 thoughts on “Creating a web database application in 5 minutes using AppGini

  1. الله يوفقك يا بشمهندس أحمد ويبارك لك ويسعدك في الدنيا والاخرة

  2. I'm still trying to learn using your program. How do I open a project/table I made and generated. What particular file in that folder should I open in order to load it in appgini?

  3. فخور جدا بكون شركتكم شركة عربية محترمة اتمنى تنزلوا كورس كامل باللغة العربية فائق الاحترام وخالص التحية اخوكم ماجد

  4. can I use this to generate php code and deploy it on a linux server (such as ehost server), and make modification to the php code if needed?

  5. can we make a new database software just like (oracle , mysql and etc database ).without taking any help of oracle,mysql and database etc .And we do practice programming on that software

  6. You show how you open your app in a browser going to localhost/app_name. Well that doesn't work for me. How do I do it?

  7. when i am creating the data base, i am getting this error
    "Database connection error!.".please help to solve this.

  8. Dark WordPress Theme https://visualmodo.com/theme/dark-wordpress-theme/ A fully packed practical tool for premium built and design. Making a positive first impression is essential to developing a strong customer relationship 🌑⚫️⚙️🚀

Leave a Reply

Your email address will not be published. Required fields are marked *