Database Creation Problem

This is a discussion on "Database Creation Problem" within the Databases section. This forum, and the thread "Database Creation Problem are both part of the Program Your Website category.



 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1  
Old Jun 24th, 2008, 02:11
Junior Member
Join Date: Jun 2008
Location: Manchester
Posts: 23
Thanks: 5
Thanked 0 Times in 0 Posts
Database Creation Problem

Hi All, Im currently learning PHP and MySQL (bloody hell its cool) and I now feel like im ready to take on the project that I started studying these subjects for in the first place. I have everything I need to begin, except the database itself, this is why:
I want to create a emulation site that will serve over 7000 old rom files, now to go about this I could make a CMS that I can use to manually populate the database with the filenames, filesizes, descriptions, id, etc. But that will take me until im too old to enjoy the site! So I need to learn how to create a PHP script that will read all 7000 files in the roms folder, collecting the filename, filesize and assigning an ID to populate the SQL database that way. (I'll still have to go through them adding the description manually but thats not a problem compared to building it manually myself.)
What methods do you recommend to accomplish this? I was thinking maybe a CMS that uploads the roms to the server grabbing the relevant data as it goes. Or Possibly just a script that loops until its read every file populating as it goes before i upload them to the server. If im going about this entirely wrong please point me in the right direction. If any of the methods I proposed are the best way of going about it what tags would i use to strip this data?

Thanks In Advance!

Last edited by c0un7z3r0; Jun 24th, 2008 at 02:13.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Jun 26th, 2008, 19:53
Marc's Avatar
Staff Manager

SuperMember
Join Date: Apr 2007
Location: Scotland, UK
Posts: 1,765
Thanks: 0
Thanked 14 Times in 14 Posts
Re: Database Creation Problem

Is this really a database problem? In my eyes it's a PHP question.

First you'll need to upload the files to a directory on the server, then use PHP to loop through the directory, get the file names, filesize and. Then store the data in the database.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Register into Database Problem Jack Franklin PHP Forum 2 Jun 20th, 2008 19:47
Problem with insert into the database kool77 PHP Forum 3 Jun 4th, 2007 19:21
Syntax problem in PHP table creation masonbarge Databases 4 Jul 13th, 2006 22:27


All times are GMT. The time now is 05:44.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42