PHP and MySQL database resources?

[charles_s]

I'm interested in using PHP and MySQL together for database development, but every web site and book I read is limited to the most basic stuff imaginable. ("Here's how to post your CD collection online!")

Can anyone recommend any web sites that discuss these subjects that won't insult my intelligience?

[jatar_k]

Welcome to WebmasterWorld charles_s,

One that seems to be recommended around here often is

PHP and MySQL Web Development, Second Edition
by Luke Welling and Laura Thomson

and the intelligent folk who recommended it didn't seem insulted. ;)

there are always the standard best resources for each as well
www.mysql.com
www.php.net

[charles_s]

I went out a bought a copy. I agree; it's a very comprehensive book. Thanks for the advice.

[sigg]

Agree PHP and MySQL second Edition is good.
Authors
Luke Welling
Laura Thomson

[charles_s]

I can't consider myself a true webmaster, since we employ a host to handle everything for us, and I noticed that much of the advanced topics in the book (in particular: security) deal with command line instructions and MySQL settings that I, as a remote db admin, have no control over.

What I'm looking for is an answer to my problem of limiting certain users to viewing certain information. For example, I don't want another employee to see my SSN, but I'm okay with my boss and my HR guys seeing and altering it.

But, I'm only skimming now, I'm sure things will seem more clear once I've read everything in context.

[lorax]

Welcome to WebmasterWorld charles_s,
Yeah it will become more clear as you read along. You don't need command line access to build a uname/pwd secure site. If you don't already have PHPMyAdmin installed, you should check into getting it installed as it will make working with the db alot easier.

I second jatar_k's suggestions. Between the PHP and MySQL websites and the book I've been able to answer 98% of my questions and move along in my work. The other 2% I bring here to see if I can stump the hard-core coders. ;)