{"id":2441,"date":"2009-11-04T00:50:20","date_gmt":"2009-11-03T16:50:20","guid":{"rendered":"http:\/\/www.softwareforenterprise.us\/?p=2441"},"modified":"2022-07-20T17:46:10","modified_gmt":"2022-07-20T09:46:10","slug":"automatically-create-a-php-web-application-based-on-a-mysql-database-structure","status":"publish","type":"post","link":"https:\/\/www.softwareforenterprise.us\/hub\/automatically-create-a-php-web-application-based-on-a-mysql-database-structure\/","title":{"rendered":"Create a PHP web app based on MySQL database structure"},"content":{"rendered":"

\"appgini-template\"Whenever there is a requirement for a new system, what would your approach be when it comes to implementing the system?<\/p>\n

A common question that CTO and IT managers usually ask is, should we build or buy?<\/p>\n

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

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. An organization that builds its own systems gives itself a competitive advantage over its competitors without such systems.<\/p>\n

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

Sometimes when I’m doing programming and feeling the pain of coding in the middle of the night, I just wished that there was a Generate PHP Code button for me to just click and head straight to bed. \"generateHowever, this button only exists in AppGini as well as in my dream! \ud83d\ude42<\/p>\n

Before I proceed to go into detail about what AppGini can help us do, check out this simple visitor management system that I’ve created using AppGini. All done within 10 minutes. See the screenshot below.<\/p>\n

\"visitor<\/p>\n

The app above is a simple visitor management system that allows visitors to enter their name, social security number, and the date & time they check in to visit. Looking at the screenshot, I think I should have also added in the checkout time so that the records look more complete.<\/p>\n

In case you’re wondering what I did in order to come out with the system above, these are the steps:<\/p>\n

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

    Well, that’s about all the steps I ran to create a simple PHP web application with AppGini.<\/p>\n

    Some of AppGini’s other features include:<\/p>\n