Create a PHP web app based on MySQL database structure

appgini-templateWhenever there is a requirement for a new system, what would your approach be when it comes to implementing the system?

A common question that CTO and IT managers usually ask is, should we build or buy? Image by AppGini Templates.

If we buy, we get a working system much faster but the cost may be quite high especially when we need to purchase licenses, hardware and pay for consulting fees.

If we build, the process to get the system up and running usually takes longer as it requires more time to plan, code, test and deploy. However, the system can be developed to be very detailed and unique. Organization who build their own systems give themselves a competitive advantage over their competitors without such systems.

AppGini LogoToday’s post will be about a tool called AppGini which helps IT folks develop PHP web applications easily by just defining a MySQL database structure. Once a database structure has been defined, creating a web application is as simple as clicking on the Generate PHP Code button.

Sometimes when I’m doing programming and feeling the pain of coding in the middle of the night, I just wished that there’s a Generate PHP Code button for me to just click and head straight to bed. generate php codeHowever, this button only exist in AppGini as well as in my dream! 🙂

Before I proceed to go in detail what AppGini can help us do, check out this simple visitor management system that I’ve created using AppGini. All done in within 10 minutes. See the screenshot below.

visitor management system

The app above is a simple visitor management system which allows visitors to enter their name, social security number and the datetime they check in to visit. Looking at the screenshot, I think I should have also added in the check out time so that the records look more complete.

In case you’re wondering what I did in order come out with the system above, these are the steps:

  1. Launched AppGini
  2. Added a new table and added the fields (for e.g, Name, SSN, etc)
  3. Clicked on Generate PHP codes
  4. Copied the generated PHP codes into my XAMPP htdocs folder
  5. Ran the system from a browser
  6. Entered MySQL admin details to create the database
  7. Renamed administrator password
  8. Created a group

Well, that’s about all the steps I ran to create a simple PHP web application with AppGini.

Some of AppGini’s other features includes:

  • Automatic PHP code generation
  • Easily search the entered records
  • Easily export data to .csv format
  • Easily sort data by column ascending or descending
  • Admin interface to manage users, permissions and data
  • Create multi users with different access rights, for eg. to add, edit, delete can be 3 different users

I personally think that AppGini is a great tool to get a simple system up and running really quickly. Since the codes are automatically generated for you in less than a minute, you can easily add in more codes of your own to enhance the system capabilities and to make it look nicer. Oh ya, there are also additional AppGini Themes which you can download and use if you’re not happy with the default colors.

To find out more about AppGini, I’d suggest you to look through AppGini’s Website and Video Tours. Enjoy!

About the author

Bob Lee

Hi! My name is Bob Lee and I’m a web developer / technical writer who specializes in developing and reviewing web applications. As an entrepreneur, blogger, developer, and tech enthusiast, I have been in this field for more than 10 years, and have been loving every minute of it.

Leave a Comment

/* ]]> */