Beginners PHP and MySQL

[Pryach]

I have a friend who I am letting use some space from my website. They want to learn PHP and MySQL. I'm just wondering if people could point me to a few tutorials that would help someone learn PHP and MySQL.

I have already setup a database for them. However, they do not have a command line, so any interfacing with the database will have to be done via a PHP scripts, so I'd prefer if the tutorials had that information instead of using a command line to create/modify the database.

Thanks for any help.

 

[slantednet]

There are tons of tutorials on PHP and Mysql (http://www.w3schools.com/php/default.asp is a decent one)

Google is your friend.

 

[Pryach]

Right, but I need one that has MySQL information (w3schools doesn't), and doesn't involve a command line. That's a bit trickier.

 

[axilant]

If you search on google for a php and mysql newbie tutorial, i bet you will get a few millions results

 

[RegFee]

http://zend.com/php/beginners/index.php

specifically
http://zend.com/php/beginners/php101-8.php

Which is the tutorial on databases and connecting to them using PHP.

Hope that helps!

 

[unknowngiver]

nice tutorial link azt

 

[RegFee]

nice tutorial link azt

Thanks, rep appreciated :blink:

 

[slantednet]

Just a note, your setting your friend up for tons of frustration right off the bat. Having to learn MySQL *only* through PHP (using PHP to both issue DDL and DML statements) while *learning* PHP and having to use PHP's error handling and reporting to see what your doing wrong is going to be a b***h to do. Even with 8-9 years of PHP/MySQL under my belt I still find myself jumping to the mysql command line to reissue commands and see where the failure is (Is it my code or is it MySQL choking on the statement)...

It's, IMHO, far better for him to get a grasp on PHP prior to jumping to MySQL if he's only going to be able to use PHP to issue MySQL statements/commands. Even having something like phpMyAdmin would be 100x's better than what your proposing for him.

Suggestion: instead of helping him by giving him the limited environment on your shared hosting account, send him to http://www.wampserver.com/en/index.php and let him download Apache, MySQL, and PHP for Windows. Then he'll have access to the full tool suite to learn this language on.

Good luck,
Mike