Request: MySQL login system!

well, that is exactly what i am waiting to learn, but there is only few php tutorials here, and its about the eCommerce. god only knows how this is supposed to be the basic tutorial.

Are you looking to do this in basic PHP or MVC format?

@Adam, I'm afraid that couldn't all be covered in a simple tutorial. :~) Signups, authentication, welcome emails, etc. are all pretty complicated. I would definitely recommend using a PHP framework to get something like that in place: I hope to cover that in a tutorial later this year.

@Mahad abdi, My PHP tutorials aren't really about ecommerce. I do build a simple ecommerce website, but all the ecommerce components are handled by simple PayPal buttons. The first few tutorials cover the very basics like what a PHP command looks like, how it is related to HTML in generating a web page, the basics of variables and conditionals, and so on. Have you tried them out and found them too advanced for a beginner? If so, I'd love to hear your feedback!

No i have not found them difficult at all. it is just that when i saw your advertise, it said that you would teach everything there was to know about web designing, anyway now i know what you guys teach, can you just let me know what you will be covering next, hopefully you will include things like mysql, login and logging out system, ftp, am sure all that cant be included in one tutorial but hopefully it will in the following tutorials...

By the way i like your way of teaching, especially when u joke, yea i think "i have learnt enough to be dangerous"

Hey @Mahad,

The next round of tutorials will be looking at intermediate PHP programming techniques. We'll be enhancing the Shirts 4 Mike site. I'm putting together the list of videos for this now, and we should have that up on the Roadmap soon. Here are some of the things we'll be covering:

• XSS attacks and escaping output
• htaccess files and rewrite rules
• more PHP functions like empty, strpos, array_reverse
• refactoring code and design patterns
• better code organization with separation of concerns and MVC
• reading the PHP manual
• data types
• searching products

I won't be looking at MySQL in this project, but that will be a major focus in the following one.

Randy:

I won't be looking at MySQL in this project...

Why's that? I learnt a bit of basic MySQL and it didn't seem advanced or anything, in fact some of the things you list seem even more advanced than MySQL.

MySQL would fit in well. Storing the catalog data in a database would make more sense than using an array. It seems like you chose to use the array to avoid having to cover MySQL, which is strange because as I said it doesn't seem that advanced.

Hey @Charles,

We'll definitely be connecting to MySQL in the third version of the Shirts 4 Mike site. You are right that it would fit in well: that's exactly how you'd do it for a real site once you had a handle on all the basics.

Here are the two reasons I'll be covering these other topics first:

(1) There are plenty of jobs that require writing PHP code but not writing SQL statements. Often a senior developer will set up the database structure and all the code that connects to the database, while a less-senior developer will write the code that displays the data from the database on a web page.

A developer in that less-senior role may be required to go fix a bug happening at the [/people/edit/12] web address; that developer will need to understand many of these topics (rewrite rules, MVC) to know to look in either the /controllers/people.php file or in the /views/people/edit.php file. They'll unlikely need to know any SQL for that.

(2) I suppose it's easy enough to create a database through a control panel, add data, and write a query. But it's tricky to do it correctly:

• keeping all your database connection code modularized for the whole app
• limiting queries for performance reasons
• understanding how to handle exceptions when integrating with another system

In the second Shirts 4 Mike project, we'll learn all about organizing code logically. Then when it's time to add the database, we'll have a good structure in place to build on.

We started at knowing absolute no PHP. We got a simple dynamic site working in the first version. We'll get it organized, modular, and extendable so we can easily add some features in the second version. Then we'll connect it to a database and a few other things in the third version.

Hi Randy,

I am also looking for a logon & registration system, will you be doing a tutorial on this any time soon?

If not do you have any suggestions or specific websites to learn this using php?