SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face Best way to learn Php & Mysql !

    Hi,

    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

  2. #2
    SitePoint Zealot bronze trophy xMog's Avatar
    Join Date
    Mar 2011
    Posts
    151
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Hi dinoucs!

    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.

  3. #3
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks xMog .

    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) ) .

    Thanks .

  4. #4
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

    + How about "Head First PHP and MySQL", eh ?

    Thanks .

  5. #5
    SitePoint Zealot bronze trophy xMog's Avatar
    Join Date
    Mar 2011
    Posts
    151
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    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.

  6. #6
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you so mych xMog ♥

    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

  7. #7
    SitePoint Enthusiast
    Join Date
    Dec 2013
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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 MySQLi libraries. I myself love the MySQLi libraries so I tend to use those more.

  8. #8
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @therockers

    Thanks for your advice !

    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 .. ) .

  9. #9
    SitePoint Addict bronze trophy Hall of Famer's Avatar
    Join Date
    Apr 2013
    Location
    Ithaca
    Posts
    368
    Mentioned
    6 Post(s)
    Tagged
    2 Thread(s)
    The best way to learn a programming language is always through practice, thus its the same for PHP and MySQL.

  10. #10
    SitePoint Member
    Join Date
    Mar 2014
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @Hall of Famer

    Yeah , you're right . But at least you have to take a book or course to begin , then you can to make some practice !


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •