Best way to learn PHP/Mysql

spacetrain · 06-22-2006, 04:53 PM

Hey,

I want to know the easiest way to learn PHP/Mysql as i know there are tutorials i could put together to get what i want for my site but i want to understand the code so i know everything im coding so i can change and adapt it to my needs. Ive looked at a few ebooks on amazon but everyone seems to say there great or really crap which makes me unsure. So does anyone know any online sites which provide a step by step guide from total beginners to advanced programming tutorials?

lpxxfaintxx · 06-22-2006, 06:06 PM

1) Get a book. I recomment PHP and MySQL - For Dynamic Websites 2nd Edition
2) After you get the basics, just start looking at tutorials, taking notes
3) Build a portfolio, slowly, adding every php script you've made.
4) You'll be surprised how much you learned.

Kadenz · 06-22-2006, 06:41 PM

My favorite book is Sams Teach yourself PHP, MySQL and Apache All In One, only book I have and very useful.

Dan · 06-22-2006, 07:14 PM

www.php.net

If their description doesn't help you, read the comments for each function. People post the functions they make and are normally EXACTLY what I want.

spacetrain · 06-23-2006, 04:04 AM

Thanks, Ill check out some books now

I think ive got like 4 months to become a master of php

EDIT: Ive ordered PHP and MYSQL Web Development 3rd Edition

Its got alot of 5 star ratings over at amazon and it looks like the one for me

NonProphet · 06-26-2006, 07:40 AM

http://www.php-mysql-tutorial.com/

thats a great site to learn PHP/MySQL, starts you off with the basic and walks you through several nice projects.

lee101 · 06-28-2006, 09:43 AM

I have learnt everything I know from here:
http://www.freewebmasterhelp.com/tutorials/php (php)
and here:
http://www.freewebmasterhelp.com/tutorials/phpmysql

and once i knew the basics I used the php.net site to look up functions, and that also has a lot of code snippets which you can learn from

LeetPCUser · 06-28-2006, 10:04 AM

I learned from books too. The best are the ones that come with the cd with all the files so you can go threw it. There are books out there that teach both together in one.

aaronfalloon · 06-28-2006, 12:30 PM

I'm currently learning from a book, PHP and MySQL Web Development. My advice is to take your time, I’ve tried to rush it and I’ve got frustrated and fed up.

daworm · 06-28-2006, 03:58 PM

After you've studied the basics the fastest way to learn is to look at other people's source code. Look at Joomla , Drupal, Codeigniter etc... source codes and you will learn a lot easier and you got to know the how the pros does it.

PS
Though sugarCRM is very good at the outside , I really dont like the way they organized their codes. Tooo messyyy......

firecubes · 06-29-2006, 04:04 AM

2 words for dummies. They are great books.

BillyConnite · 06-29-2006, 04:08 AM

Hey spacetrain,

the best way to learn is by example.

About a years ago somebody made a very simply php page that simply extracted some data from a mysql database. I just tweaked around with it for ages, and then you get the hang of it and learn as you go.

php and mysql are very easy languages to learn, you'll see once you get the basics

. Especially when php.net is at your side

dongan · 06-29-2006, 05:24 AM

My best practise is to work out some examples and will start to learn things then and there. It will be suitable for PHP expecailly.

chronic · 06-29-2006, 05:34 PM

Honestly, I wouldn't learn PHP from a book, because the book includes code and practices that were used when the book was published, and half the time, there have been updates or new uses of code that are taught differently in a book. Also, a book just teaches you conventional methods of how to do stuff, however not always bad if you are just a beginner.

I recommend look through some tutorials on tutorial sites, download PHP scripts and have a look at their way of making the script functional and finally, looking at PHP.net for any help you may need with a specific function.

Good luck with your PHP coding.

dkr · 06-30-2006, 11:02 AM

The best way to learn PHP is to get a PHP guru to tutor you, just like what I am doing right now

. I recommend John (jescripts[at]gmail[dot]com), as he is doing a very good job teaching me

. Good luck.

06-22-2006, 04:53 PM	THREAD STARTER #1 (permalink)
spacetrain NamePros Member Join Date: May 2006 Posts: 133	Best way to learn PHP/Mysql Hey, I want to know the easiest way to learn PHP/Mysql as i know there are tutorials i could put together to get what i want for my site but i want to understand the code so i know everything im coding so i can change and adapt it to my needs. Ive looked at a few ebooks on amazon but everyone seems to say there great or really crap which makes me unsure. So does anyone know any online sites which provide a step by step guide from total beginners to advanced programming tutorials?

06-22-2006, 06:06 PM	#2 (permalink)
lpxxfaintxx Senior Member Join Date: May 2006 Location: Irvine, CA Posts: 1,082	1) Get a book. I recomment PHP and MySQL - For Dynamic Websites 2nd Edition 2) After you get the basics, just start looking at tutorials, taking notes 3) Build a portfolio, slowly, adding every php script you've made. 4) You'll be surprised how much you learned. __________________ han(sup) yoon - internet entrepreneur

06-22-2006, 06:41 PM	#3 (permalink)
Kadenz Resistance is Futile Join Date: Apr 2006 Location: Montreal, Canada Posts: 1,094 Follow @MitchKadenz	My favorite book is Sams Teach yourself PHP, MySQL and Apache All In One, only book I have and very useful. __________________ Freelance Web Developer PHP, MySQL, XHTML, CSS, Javascript, jQuery, Wordpress Portfolio: www.bundy.ca

06-23-2006, 04:04 AM	THREAD STARTER #5 (permalink)
spacetrain NamePros Member Join Date: May 2006 Posts: 133	Thanks, Ill check out some books now I think ive got like 4 months to become a master of php EDIT: Ive ordered PHP and MYSQL Web Development 3rd Edition Its got alot of 5 star ratings over at amazon and it looks like the one for me Last edited by spacetrain; 06-23-2006 at 04:19 AM.

06-28-2006, 12:30 PM	#9 (permalink)
aaronfalloon NamePros Regular Join Date: May 2005 Location: Northern Ireland Posts: 756	I'm currently learning from a book, PHP and MySQL Web Development. My advice is to take your time, I’ve tried to rush it and I’ve got frustrated and fed up. __________________ A young web developerâ€™s journey to financial freedom - aaronfalloon.com

06-22-2006, 07:14 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	www.php.net If their description doesn't help you, read the comments for each function. People post the functions they make and are normally EXACTLY what I want.

06-26-2006, 07:40 AM	#6 (permalink)
NonProphet NamePros Member Join Date: Apr 2006 Location: Central PA Posts: 101	http://www.php-mysql-tutorial.com/ thats a great site to learn PHP/MySQL, starts you off with the basic and walks you through several nice projects.

06-28-2006, 09:43 AM	#7 (permalink)
lee101 NamePros Regular Join Date: Mar 2006 Location: United Kingdom Posts: 413 Follow @leefindlow	I have learnt everything I know from here: http://www.freewebmasterhelp.com/tutorials/php (php) and here: http://www.freewebmasterhelp.com/tutorials/phpmysql and once i knew the basics I used the php.net site to look up functions, and that also has a lot of code snippets which you can learn from

06-28-2006, 10:04 AM	#8 (permalink)
LeetPCUser Account Suspended Join Date: May 2005 Location: Whitewater, WI Posts: 3,710	I learned from books too. The best are the ones that come with the cd with all the files so you can go threw it. There are books out there that teach both together in one.

06-28-2006, 03:58 PM	#10 (permalink)
daworm First Time Poster! Join Date: Jun 2006 Posts: 1	After you've studied the basics the fastest way to learn is to look at other people's source code. Look at Joomla , Drupal, Codeigniter etc... source codes and you will learn a lot easier and you got to know the how the pros does it. PS Though sugarCRM is very good at the outside , I really dont like the way they organized their codes. Tooo messyyy......

06-29-2006, 04:04 AM	#11 (permalink)
firecubes NamePros Member Join Date: Jun 2006 Location: Wales Posts: 38	2 words for dummies. They are great books.

06-29-2006, 04:08 AM	#12 (permalink)
BillyConnite Join Date: Jul 2005 Location: Coffs H, Australia Posts: 3,456	Hey spacetrain, the best way to learn is by example. About a years ago somebody made a very simply php page that simply extracted some data from a mysql database. I just tweaked around with it for ages, and then you get the hang of it and learn as you go. php and mysql are very easy languages to learn, you'll see once you get the basics . Especially when php.net is at your side __________________ Free Forums / GoDaddy Coupon Codes (NEW DOMAIN!) / Free Arcade Script / <?='Your computer is '.(1?fine:broken).'.'?>

06-29-2006, 05:24 AM	#13 (permalink)
dongan Senior Member Join Date: Nov 2005 Location: www.mercuryminds.com Posts: 2,044	My best practise is to work out some examples and will start to learn things then and there. It will be suitable for PHP expecailly. __________________ MercuryMinds - Professional X-Cart Design, X-Cart Development, X-Cart Customization Services MercuryMinds - X-Cart addons, modules

06-29-2006, 05:34 PM	#14 (permalink)
chronic NamePros Member Join Date: Dec 2005 Posts: 186	Honestly, I wouldn't learn PHP from a book, because the book includes code and practices that were used when the book was published, and half the time, there have been updates or new uses of code that are taught differently in a book. Also, a book just teaches you conventional methods of how to do stuff, however not always bad if you are just a beginner. I recommend look through some tutorials on tutorial sites, download PHP scripts and have a look at their way of making the script functional and finally, looking at PHP.net for any help you may need with a specific function. Good luck with your PHP coding. __________________ DNFind.net - For sale, PM me.

06-30-2006, 11:02 AM	#15 (permalink)
dkr Respect My Authority! Join Date: Jul 2005 Location: Canada Posts: 2,236 Follow @donnyouyang	The best way to learn PHP is to get a PHP guru to tutor you, just like what I am doing right now . I recommend John (jescripts[at]gmail[dot]com), as he is doing a very good job teaching me . Good luck. __________________ Follow Me (new!): @donnyouyang Founder @ Rayku \| Kinkarso Tech

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)