Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,195,349 members, 7,957,926 topics. Date: Wednesday, 25 September 2024 at 02:46 AM

Creating A Dynamic Database App In Php - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Creating A Dynamic Database App In Php (337 Views)

#need Pro Web Programmer For A Dynamic Website Built From Scratch? Call Us Now! / Steps To Take Before Creating A Website - Techknowng.com (2) (3) (4)

(1) (Reply)

Creating A Dynamic Database App In Php by Nobody: 11:50am On Jan 10, 2017
Firstly i am going to explain what i am trying to do. I am trying to create an app in which the user can create or remove existing database fields.

There will be a drag and drop form builder that will manage each of the form fields in existing tables.

More over the user can also create new tables from the front end. For example, there may existing tables like books, class timetable and the user may want to create a new form/table which would be called tasks. After this, the user can create form fields in this newly create form/table.

I have drawn out some plans on how to do this but i am looking for better suggestions out there. I am really confused on whether to create new tables for each new custom feature the user wants to add.

A typical example of this kind of app is zoho crm. You can check through the screenshots.

My major questions are

How to structure the database for this
How to create the drag and drop form builder that will save the new fields and update existing fields on the database.

Re: Creating A Dynamic Database App In Php by Nobody: 1:30pm On Jan 10, 2017
Most times, the basic idea you need to know to build standard web applications is what I like to call "Normalization".
.
Think about every possible database table you'll need in your application and write them down. Now, for each table, make a rough drawing, indicating all the fields (columns) you'll like to have in it. You can do this using any word processor like MS-WORD.
.
After that, try to see if you'll find similarities between tables. If two or more tables seem to have similar fields, then you're heading to get something done the wrong way. On the other hand, if there are no similar fields appearing in multiple tables, then you're getting it right!
.
The main point here is to assign unique content to separate tables. For example, let's say we have three tables:
1. teachers
2. students
3. subjects
.
Different teachers may teach different subjects in a school. And students may also have different subjects. So, it's okay for me to create each table separately.
.
Hope it helps. grin

(1) (Reply)

Web Design Nigeria / Blogger Or Wordpress? / Free Career-development Training Platform In Web Design & Development

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 13
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.