23 {{ upvoteCount | shortNum }}
23 {{ upvoteCount | shortNum }}

Best place to learn MYSQL n PHP ?

by learnalot
20 replies
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
#learn #mysql #php #place
  • Profile picture of the author Andrew H
    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
    Signature
    "You shouldn't come here and set yourself up as the resident wizard of oz."
    {{ DiscussionBoard.errors[8312191].message }}
  • Profile picture of the author skillboyz
    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
    {{ DiscussionBoard.errors[8312340].message }}
  • Profile picture of the author learnalot
    thanks for the great info. whats better to learn first php or mysql?
    {{ DiscussionBoard.errors[8312499].message }}
  • Profile picture of the author Mrsubh
    Originally Posted by learnalot View Post

    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 you tube 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
    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

    Signature
    {{ DiscussionBoard.errors[8312705].message }}
  • Profile picture of the author sktthemes
    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
    Signature
    SKT WordPress Themes
    {{ DiscussionBoard.errors[8313377].message }}
  • Profile picture of the author ishanr
    Learn to code | Codecademy
    Signature
    Read my latest book - How to build an authority site in 7 days and beat Google!
    {{ DiscussionBoard.errors[8318226].message }}
  • Profile picture of the author webn
    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
    {{ DiscussionBoard.errors[8362092].message }}
  • Profile picture of the author OaldDesign
    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.
    Signature

    Graphic Design & Web Development Services: http://www.oalddesign.com
    Banner Design Services: http://bannercheapdesign.com

    {{ DiscussionBoard.errors[8693535].message }}
  • Profile picture of the author Tekno
    I'd suggest VTC and Lynda. Video courses work a lot better than ebooks.
    {{ DiscussionBoard.errors[8693587].message }}
  • Profile picture of the author StillSEO
    Here is my suggestion: W3Schools Online Web Tutorials

    Google it U will find more..
    Signature
    {{ DiscussionBoard.errors[8699843].message }}
  • Profile picture of the author CMRaper
    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
    {{ DiscussionBoard.errors[8699891].message }}
  • Profile picture of the author azhar
    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.
    Signature
    Hire me for web site design and development.
    {{ DiscussionBoard.errors[8705688].message }}
    • Profile picture of the author BrandByApi
      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.
      {{ DiscussionBoard.errors[8711662].message }}
  • Profile picture of the author Ramy31
    You can check out
    Free Online Tutorial PHP - PAGE - PHPEveryDay
    {{ DiscussionBoard.errors[8988987].message }}
  • Profile picture of the author mutant9
    for PHP try: How to Learn PHP for Free | How to Learn

    for MySQL try: http://howtolearn.me/how-learn-mysql-free/
    {{ DiscussionBoard.errors[9033223].message }}
    • Profile picture of the author webn
      I learnt PHP from "PHP Beginners" - clear explanation.
      For video tutorials, you can try check lynda.

      Hope it is helpful to someone.
      {{ DiscussionBoard.errors[9035207].message }}
  • Profile picture of the author tojamulali45
    You need to more knowledge about html or css.
    {{ DiscussionBoard.errors[9035246].message }}
  • Profile picture of the author samimahamed45
    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.
    {{ DiscussionBoard.errors[9035257].message }}
  • Profile picture of the author sham2
    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 .
    {{ DiscussionBoard.errors[9037597].message }}

Trending Topics