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.
|
|
|
|
|
![]() |
||
Database Creation Problem
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
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. |
|
|
|
#2
|
||||
|
||||
|
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. |
![]() |
| Thread Tools | |
|
|
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 |