PHP - Dedicated Connection + File Handling

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hendy
Forum Newbie
Posts: 24
Joined: Sat Nov 29, 2003 6:35 am
Location: UK

PHP - Dedicated Connection + File Handling

Post by hendy »

Ladies and Gentlemen of the advance PHP Database Race, I have a question here that i desperatley need an answer for a question at Uni, please please could someone breifly tell me what the advantages and disadvantages in using a connection to a dedicated
database server to store data over using PHP’s dedicated file handling
functions?????

Any help would be great, thanks
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

database: a lot easier handling, sorting, faster queries unless you have some awesome hashing skill. Simple query language.
file handling: you have to write your own database of sorts, lots of debugging, time wasted...

unless it's for learning how databases work internally, I wouldn't use the file system..
hendy
Forum Newbie
Posts: 24
Joined: Sat Nov 29, 2003 6:35 am
Location: UK

Post by hendy »

Cheers thanks for that...



Regards

Hendy
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

with using MySQL, i know feyd said it but didnt elaborate on it

you can manupilate data using MySQL functions, like math wise (with COUNT, MIN and MAX, etc.)

and doing it mysql-side, its faster then with phps file handling.

feyd basically mentioned the whole nine yards tho,

go db!
hendy
Forum Newbie
Posts: 24
Joined: Sat Nov 29, 2003 6:35 am
Location: UK

Post by hendy »

Thanks guys, you have been a great help


Regards
Hendy
hendy
Forum Newbie
Posts: 24
Joined: Sat Nov 29, 2003 6:35 am
Location: UK

SOLVED

Post by hendy »

Thanks everyone
Post Reply