I want to learn PHP & MySQL to be a pro in web development (& I have good several ideas I wanna to achieve) . so I have just read the first 5 chapters in “PHP & MYSQL NOVICE TO NINJA BY KEVIN YANK” but I think , in the later chapter he’s focusing at the CMS !!!
I believe in learning with doing, so I need some project tutorials in developing website with PHP & MySQL to work with it .
Because I have to be ready for my final project in the university “Classified ads website” .
So I need a guide to achieve that level “A good web developer” , Thanks so much
So you’re already studying computer science? What are you learning? Web programming languages or more “standard” programming languages (like C, C++) that are run by command lines?
Starting directly with PHP & mySQL is not the best way to be a “pro in web development” and build web applications IMO. Do you know HTML enough? Do you know CSS? JavaScript? Do you understand the difference between server-side and client-side? Do you know how HTTP works (for example, could you explain it to me in 2-3 sentences)?
In my experience, “general” CS programs are not adapted well to teach web programming. They start too quick in the server-side programming “block”. Like: “Now you know how “for” and “if” works, go make a web app”.
I know that’s not the best way because I learned it that way and a couple of years when working I really realized how HTTP worked, that it’s important to understand how cookies are used, sessions, etc.
Here’s what I already suggested to another user today:
Learn general programming concepts (it seems like you already know that)
Learn the HTTP protocol (seems complicated but it’s not, shouldn’t take you more than 2 hours for the first read) : http://www.jmarshall.com/easy/http/
Learn how sessions and cookies are working.
Learn the basics of website development (HTML, CSS and a little bit of JavaScript + Ajax). You already know HTML and CSS, that’s good. Just try some JavaScript, it’s crucial that you understand what you can do with JavaScript and Ajax VS what you can do on the server-side with PHP.
Then, go with PHP (a beginner book)
Try to build 2-3 really small apps… like a contact form, something that writes stuff into a file, etc.
Then, you can try some PHP frameworks like Laravel, CodeIgniter, etc.
Then you can go with mySQL, a noSQL database, etc.
Okay’ , I know HTML, CSS and JavaScript well . I have just did some webpages as training … ect
And now I need where to begin learning Php & Mysql , actually I’m with “Php & Mysql from nive to ninja - Kevin Yank, SitePoint.com”, But this book and starting from the 6th chapter he’s focusing on CMS and templates !! so what I need is learning for my final project first.
So xMog , I need a good pathway like my previous pathways in learning the other languages like JS (Javascriptissexy.com (y) ) .
I just wanna a good book, tutorial … anything to teach me PHP & MySQL well , I just don’t want a book which have a chapter just for the loops and a chapter for the variables -_- .
A powerful resource to learn from it good knowledge , and I will be okay
Well, I can’t really help you about books because I didn’t read any books on PHP & mySQL. My first programming books were about ASP, DHTML and that kind of stuff 10 years ago
Now, you want to learn PHP AND mySQL? Do you already know PHP? mySQL? Do you know how databases works?
If you already know PHP I would just find articles about PDO (this is one of the way to query a database). And I would get a mySQL book for beginners.
I think you would have more chance on getting 2 specific books for your own need. You already know some programming? Look for “PHP book for programmers” for example like this. Don’t forget to check the table of content.
If you know nothing about databases, start with something like “mySQL book for beginners” or something similar.
Also, if you buy a big book on Amazon, you’ll probably get stuff you don’t need to read like how to install your environment, how to use X or Y (like frameworks) etc… Often, publishers forces authors to include this kind of stuff. Just read the TOC to be certain that it’s not totally irrelevant to your need. And you can also read Amazon reviews on the book(s) you want to purchase too.
Yeah , I know how database works , and PHP , I’m good . I have just learned that from the of Kevin Yank .
I think I need some scripts tutorials such as : Register form (I found it) , adding articles, how to make comments on your websites, tips in users management … ect
Just going to put my 2 cents in. I’m not a PHP guru, but try to stray from the old MySQL libraries. It’s deprecated and probably will be removed later in the near future. You should use PDO(As recommended) or the new [URL=“http://us1.php.net/mysqli”]MySQLi libraries. I myself love the MySQLi libraries so I tend to use those more.
But I wanna a pathway in learning , good resources to achieve the most of common tricks of php & mysql in web development ! to help me creating my website which is a classified ads (without paypal … ) .
