Large Data Entry from Form help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
oscardog
Forum Contributor
Posts: 245
Joined: Thu Oct 23, 2008 4:43 pm

Large Data Entry from Form help

Post by oscardog »

So the plan is that the user will access a page, this is mostly done, just the main hard part to go.

Now they can input planner entries, so from 6am-10pm or whatever throughout the day they can put one entry in per hour - i'd love to have it so they could be more specific - so like '6.00, 6.15, 6.30, 6.45, 7' etc so if you can work that in, that'd be a bonus but..

I know how to do it with a form and textfields, and they submit it and it enters a database - I'm not that nooby ;)

But say im a really active user, and put my whole years plans in, and there are roughly 10 entries I put in per day... thats 3650 entries per year, thats just one person, that's going to eat a database. So what im asking is what is the best way of doing this, so that i can conserve some database space, and also how many entries(roughly) could i fit into a standard MySQL database(on a standard webshost, that is payed for)

Ashley/Oscardog
mattpointblank
Forum Contributor
Posts: 304
Joined: Tue Dec 23, 2008 6:29 am

Re: Large Data Entry from Form help

Post by mattpointblank »

If you're just storing basic text strings / times, thousands of rows won't be particularly large in terms of storage. Just make sure you use appropriate data types for the columns and use a sensible database relation structure.
oscardog
Forum Contributor
Posts: 245
Joined: Thu Oct 23, 2008 4:43 pm

Re: Large Data Entry from Form help

Post by oscardog »

Thanks :)

What is a database relation structure?

Also say i get a full database, and i need to say have 'DB_DIARY_ENTRIES1' and then 'DB_DIARY_ENTRIES2' how would i then use a select statement on both, or would i have to them separate?
mattpointblank
Forum Contributor
Posts: 304
Joined: Tue Dec 23, 2008 6:29 am

Re: Large Data Entry from Form help

Post by mattpointblank »

You'd have to do separate queries, since you can only be connected to one database at a time.

Relational database structuring basically refers to a mode of storage that prevents repeat/duplicate information... sorta. It's hard to sum up, but read up here: http://dev.mysql.com/tech-resources/art ... ation.html
oscardog
Forum Contributor
Posts: 245
Joined: Thu Oct 23, 2008 4:43 pm

Re: Large Data Entry from Form help

Post by oscardog »

*Blinks* After reading it several times, i think i got it - thanks for the help!
Post Reply