Best place to learn MYSQL n PHP ?

by 20 replies
23
howdy
i have learned html and css fairly easily but im having a tough time learning mysql database building and php programming. i have searched lots of tutorials and youtube videos but still dont completely understand database building and php programming. so i want to know where did you go or what book / tutorial / video did you watch / read that helped you the most to really learn mysql and php?
to give you a better idea of what im trying to do is implement what is circled in red in the photos below
#programming #learn #mysql #php #place
  • html and css are the beginning, and very easy to master. When you get into the programming languages it get's a little bit more difficult - it's easy to be able to 'do it', however unlike html and css there are security implications for everything you do. It amazes me how many supposed 'developers' inject raw user input right into their sql code (as just a small example).

    You need to start from the basics and build your way up. PHP and MySQL go hand in hand when developing and there are many books out there that will train you.

    If you not big in to reading I would recommend a subscription at lynda.com
  • You should know bit of html and css then you can jump for php and mysql remember if you take help of professionals and if you have creativity then you can make good script. You cannot learn just by copy paste others script. You should think and make script yourself if you really want to learn
  • thanks for the great info. whats better to learn first php or mysql?
  • Hi dude ,

    Watching YouTube videos will not work until you know the basic of programming language. any programming language is some how similar to language like English, Spanish and etc. So to master the language you must know basic things like a b c d of that programming language. Programming languages like PHP is high level language which are human readable. it will too much easy if you start from basic level. As far as the tutorials concern start from PHP Tutorial then go to PHP official site PHP: Language Reference - Manual and learn each language reference and then go to PHP: Function Reference - Manual .Next step is STOP there.

    PRACTICE PRACTICE PRACTICE PRACTICE PRACTICE PRACTICE...........

    Next to work with MYSQL you need to learn SQL at SQL Tutorial . Complete everything here.

    As i told before

    PRACTICE PRACTICE PRACTICE PRACTICE PRACTICE PRACTICE...........

    Now you need to learn the PHP functions and other stuffs to work with MySQL Go to PHP MySQL Introduction and it will help to learn step by step. next you need to look at PHP official site for this too at PHP: Mysql - Manual and PHP: MySQL Functions - Manual. That's all You need practice practice and practice.

    If you need some basic advance video tutorials you can check VTC, lynda, tree house, nettut+ and other sites .These sites are paid..

    Thanks a lot of. have fun And Happy programming

  • Hello
    Their are various online material available for learning web development.
    If you are new to web development start from W3Schools Online Web Tutorials and PHP: Hypertext Preprocessor
  • Banned
    [DELETED]
  • For the short tutorial, you can try w3schools.com
    If you like know detail about different PHP sections, you can try PHP tutorials on lynda. I found those good. These are paid.

    But, if you look for full explanation of each php topic that is suitable for beginners, then, Schools of Web is fantastic. Its Free at this moment.

    Hope it helps
  • As people said above a good way to start learning php is with lynda.com
    you would have in there screenshot tutorials that would teach you the basic for php and with php you always learn something new so lynda.com alone won't be enough.
  • I'd suggest VTC and Lynda. Video courses work a lot better than ebooks.
  • Banned
    [DELETED]
  • Here is my suggestion: W3Schools Online Web Tutorials

    Google it U will find more..
  • PHP: Hypertext Preprocessor
    MySQL :: The world's most popular open source database
    W3Schools Online Web Tutorials
    Good PHP Tutorials - Beginner To Advanced PHP Programming Tutorials
    Stack Overflow

    Try some of them,
    Stackoverflow has enormous community that can answer your questions
    php.net && w3schools - has tutorials and explanations on php functions
    mysql - it shows how to use its queries
  • Although, there are lots of websites and free video tutorials available to learn php and my sql. But i learned all from w3school. It is the best learning based website.
    • [1] reply
    • I would also recommend this website:
      bobby-tables.com

      It helps you with using parameterized SQL calls. I used to be the kind of developer who would try to sanitize things myself... Now I also look at bobby-tables as a reference sheet when doing SQL calls in different layers/connectors.
    • [1] reply
    • I learnt PHP from "PHP Beginners" - clear explanation.
      For video tutorials, you can try check lynda.

      Hope it is helpful to someone.
  • You need to more knowledge about html or css.
  • PHP and MySQL tutorial video course is narrated by robert tucker. A long time trainer lecturer and consultant who specialized in helping people learn how to use technology to solve real world problems.
  • In my opinion code academy is the best way to learn mySql. My second suggestion for is w3schools.com .You need to do more and more practice to strong your MySql .

Next Topics on Trending Feed

  • 23

    howdy i have learned html and css fairly easily but im having a tough time learning mysql database building and php programming. i have searched lots of tutorials and youtube videos but still dont completely understand database building and php programming. so i want to know where did you go or what book / tutorial / video did you watch / read that helped you the most to really learn mysql and php? to give you a better idea of what im trying to do is implement what is circled in red in the photos below