Forum Moderators: coopster

Message Too Old, No Replies

mySQL

never tried

         

WhosAWhata

6:25 pm on Jul 11, 2004 (gmt 0)

10+ Year Member



my host is a little stingy with mySQL, i get one free database included, then i have to buy additional databases.

for this reason i have been very reluctant to learn much about mySQL. I mean why learn what seems like a whole new language if i can only use it once.

however since i seem to be leaning towards semi-pro web design, i figure i should probably get to learning

can someone dirrect me to a few good tutorials that they know to be effective?

thanks

dmorison

6:41 pm on Jul 11, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



What are your usage restrictions on that single database?

There is no reason why a single "database" can't support multiple applications. Pick a simple naming convention and start all tables for the same application with the same few letters and an underscore.

WhosAWhata

6:43 pm on Jul 11, 2004 (gmt 0)

10+ Year Member



ok, i've been reading up on it a little and it looks like i can have a bunch of self containded tables in that single database, i wish i had realized that before

ok, so i could still use a few good tutorials

Zipper

6:51 pm on Jul 11, 2004 (gmt 0)

10+ Year Member



get it from the pros, [dev.mysql.com...]
or jump start [dev.mysql.com...]

WhosAWhata

6:56 pm on Jul 11, 2004 (gmt 0)

10+ Year Member



the problem is that i keep finding one of these two

running mySQL from command line
or
mySQL/PHP tutorials for beginners in both

i am at a point where i am getting pretty good at PHP

what i need is a tutorial about ontegrating mySQL into PHP without trying to teach basic PHP

does anyone know of a tutorial about PHP and mySQL that deals mainly with the mySQL php functions and ability?

Birdman

7:07 pm on Jul 11, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Well, for PHP/MySQL functions, I would go here [php.net].

But, be advised that, you should delve into database design as well because if db isn't designed efficiently, it's an uphill battle. I know this from experience ;)

Birdman

Zipper

7:09 pm on Jul 11, 2004 (gmt 0)

10+ Year Member



lol... I dont see a better way than to learning something from the creators itself. anyway, if you are really interested in the functions look here [php.net...]

google php mysql tutorials to get some good ones, but the best way is to get to know what each function does, so that u know what excatly u need and what u do. try phpfreaks or zend for some tutorials.

jatar_k

11:40 pm on Jul 11, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



WhosAWhata,

also take a look at the PHP Library [webmasterworld.com] also there are some threads in the Perl Library [webmasterworld.com] from before we split the forums. There are some good threads in both.