Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Developer Center > MySQL tables vs whole DBs...

MySQL tables vs whole DBs...
Thread Tools
Professional Poster
Join Date: Jan 2001
Location: Salt Lake City, UT USA
Status: Offline
Reply With Quote
Feb 20, 2006, 12:27 PM
 
I'm thinking about setting up a website where a user would be able setup an account and would be given a (very limited) access to MySQL so he/she could learn a bit about connecting to MySQL and making database calls from PHP (or something similar.)

What's the biggest difference between having a whole Database to work with vs. just having access to your own table? Is it significant enough that a user would need his own DB to work with? I think a table would be sufficient, but I could use more opinions.
2008 iMac 3.06 Ghz, 2GB Memory, GeForce 8800, 500GB HD, SuperDrive
8gb iPhone on Tmobile
     
Clinically Insane
Join Date: Oct 2001
Location: San Diego, CA, USA
Status: Offline
Reply With Quote
Feb 20, 2006, 12:48 PM
 
I guess it depends on whether the focus is MySQL or PHP. If they want to learn about joins or something, having more than one table would be necessary. If all they're learning about is how to call to MySQL from PHP, a table would be plenty, I think.
Chuck
___
"Instead of either 'multi-talented' or 'multitalented' use 'bisexual'."
     
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status: Offline
Reply With Quote
Feb 21, 2006, 11:45 PM
 
you should just write a tutorial on how to install mysql on your mac (its damn easy). and connect to it with your macs php/apache. dont give the world access to your db not even one table.
The Bitcastle
graphic design, web development, hosting
     
Professional Poster
Join Date: Jan 2001
Location: Salt Lake City, UT USA
Status: Offline
Reply With Quote
Feb 22, 2006, 12:03 AM
 
I don't doubt that it's easy to install. Heck, I did it

But that's not the point. This website is intended to help novice programmers learn PHP through practical example. Things like "Write a script that will grab entries from a DB based on this variable, then order them in a list."

I found that as I was learning PHP, the biggest roadblock was that I didn't have any reason to learn what I was doing. I wanted to provide new PHP users some practical examples they could take home and implement.

So I wanted to provide a MySQL table for a registered user that would allow him to access data and throw it out. The plan would be to limit the table in dimensions and size to avoid abuse. It would be so limited that there would be no pratical reason to hack it.

That's the idea anyway.
2008 iMac 3.06 Ghz, 2GB Memory, GeForce 8800, 500GB HD, SuperDrive
8gb iPhone on Tmobile
     
   
Thread Tools
Forum Links
Forum 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
Top
Privacy Policy
All times are GMT -5. The time now is 09:30 PM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2