PHP/MySQL Newbie

[ezkim0x]

I know there are tons of tutorials out there especially on google. but every coder has their own way.. and it may not be the most efficient.

I'm a total newbie to php/mysql.. where should I start?

the first thing I'm wanting to create is a register/login script.

 

[Unheard]

Do you have any past experience in scripting languages such as PHP? How about for SQL, have you ever used other versions?

 

[ezkim0x]

no, I'm a total newbie.. the only thing I've done is moved php around in already configured forum/blogging scripts.

 

[George P Burdell]

You could start with a book, but the best way is to Google for examples.

 

[Aikouka]

Well, unfortunately, I can't show you what I used. There used to be excerpts from a book available online and I thought they were pretty good, but they were taken down after time (note they were up legally by the author). Just try to find a good tutorial that goes over the basics and then some.

 

[f1sh3r]

phpfreaks.com is usually my source for php know-how. they have some good tutorials on setting up an account systems.

 

[ezkim0x]

thanks..

so far I have: hudzilla.org ^ , phpfreaks.com ^ , tizag.com, w3schools.com.. and of course php.net for reference.

I'm going to try running through all of them.. probably a couple of times.. and then try finding a tutorial on phpfreaks for the account system tut.

 

[troytime]

You have no other programming experience?

http://evolt.org/PHP-Login-Sys...0&comments_per_page=50

 

[clamum]

I was in the same boat as you and started with "How to Do Everything in PHP and MySQL" and another book, I think it was like a PHP and MySQL Cookbook. Those were helpful because they give you a project (like for instance a login script like you're talking about) and then go through each step involved.

Other than that, I used php.net for function reference and miscellaneous tutorials I found on Google.

 

[Kur]

Look for a new book, don't get the "PHP in 24 hours" or "PHP over the weekend" They quickly go through the basics and sometimes miss some concepts you'll need later on.

I started a spoono.com with their PHP and mySQL tutorials then moved to books.

 

[stndn]

Programming languages are always easiest to be learned by doing projects.
Start small, and slowly work your way up. Register and login script is a huge project, so let's put that off for a while.

Start with something as simple as Hello World program.
Then move to something more complicated, but skip over the MySQL things first.
Let's say, something like entering form data in one page, and displaying it in another.

Once you're more comfortable with doing PHP stuffs, start looking into MySQL.
It's easier to learn how to read data, than to enter data. So, use something like PHPMyAdmin to fake your data entry, then use PHP to read and print out their data.
After that, try to make pages where you can enter data on one page, store it in MySQL, and read it on another page.

After that, you can start working on bigger projects, and you can start working on your register/login page.


-stndn.

 

[Ka0t1x]

http://www.freewebmasterhelp.com/tutorials/phpmysql

That's where I started.. its a good mix of PHP/MySQL and how they work together... ... Though you can do some of it much better..

When you start getting better with MySQL.. pickup some stuff on Relational Databases .. this is key for anything DB.


Also, there's a huge amount on the internet as far as tutorials/discussions.. Google is your friend for this.

 

[alpha88]

Learn Cold Fusion instead of php.

Everyone knows php, and you'll pick it up just by being around it or learning any one of the other languages that use C syntax.

Nobody knows Cold Fusion, but there are tons of websites and projects that do use it.

Since there are so few programmers, it's easy to get paid for it. (whereas, it's easy to find college students who will do php for free, just for the experience/resume)

 

[troytime]

Originally posted by: alpha88
Learn Cold Fusion instead of php.

Everyone knows php, and you'll pick it up just by being around it or learning any one of the other languages that use C syntax.

Nobody knows Cold Fusion, but there are tons of websites and projects that do use it.

Since there are so few programmers, it's easy to get paid for it. (whereas, it's easy to find college students who will do php for free, just for the experience/resume)

thats funny.
every cold fusion developer i know moved on to something else (1 management, 4 php, 1 .net)

 

[alpha88]

I should clarify that I didn't mean only learn Coldfusion. I just think it's a good place to start learning web basics.

At the beginner level, you can do Coldfusion work and get paid. With beginner skills in php, you have no chance to get any work.

Once you learn Coldfusion and actually do some "real" work, it's the perfect time to learn the more popular languages (ie, php, .NET, ruby). You'll also have the benefit of learning the important languages once you already know how to program, rather than starting with php and learning tons of bad habits.

 

[troytime]

Originally posted by: alpha88
I should clarify that I didn't mean only learn Coldfusion. I just think it's a good place to start learning web basics.

At the beginner level, you can do Coldfusion work and get paid. With beginner skills in php, you have no chance to get any work.

Once you learn Coldfusion and actually do some "real" work, it's the perfect time to learn the more popular languages (ie, php, .NET, ruby). You'll also have the benefit of learning the important languages once you already know how to program, rather than starting with php and learning tons of bad habits.

absolutely true!
although i landed my current php job before ever seeing php

 

[Brazen]

Originally posted by: troytime
<blockquote>quote:
Originally posted by: alpha88
Learn Cold Fusion instead of php.

Everyone knows php, and you'll pick it up just by being around it or learning any one of the other languages that use C syntax.

Nobody knows Cold Fusion, but there are tons of websites and projects that do use it.

Since there are so few programmers, it's easy to get paid for it. (whereas, it's easy to find college students who will do php for free, just for the experience/resume)</blockquote>

thats funny.
every cold fusion developer i know moved on to something else (1 management, 4 php, 1 .net)

yeah, I've known tons of Cold Fusion developers. They just aren't known as Cold Fusion developers because they had to learn something else when everyone jumped ship from CF to PHP.

 

[hooflung]

Reading examples is fine and dandy but honestly you should spend a lot of time in the PHP Online Manual learning the core functions.