Results 1 to 6 of 6

Thread: Resources for PHP and MySQL

  1. #1
    Join Date
    Jan 2005
    Lithia Springs, GA USA

    Resources for PHP and MySQL

    These questions seem to be asked a lot here in the PHP section of the Web Developer Forums.

    “Where can I find more information about PHP?” and “Where can I learn about PHP?” etc…

    One would think that a simple search would turn up many results on this topic, and it does, but after someone said “why doesn't someone just post a pinned topic with alot of places to learn it if its being asked so much”[sic] Well I don’t know! I agree there should be. So hopefully maybe this will be stickyfied... maybe not... I can only hope

    Here are some of the most informative places to learn all about PHP/MySQL on the web

    PHP -

    http://php.net or http://php.net/manual
    php.net has made it so it is easy to search for various functions within there website. All you have to do is append the function name to the end of the URL and it will take you there. So for instance if you wanted to learn more about how the function explode() works then all you have to do is type http://php.net/explode and it will take you there (you don’t even have to type ‘manual’
    Of course, you can also use their search feature in the top right hand corner.

    Tutorials of what you will need to get started with PHP. Very handy for those who will be installing and/or using PHP for the first time!

    zend.net however does not have the same ease of use URL that php.net has. Their main feature that is extremely helpful though is that they have many tutorials written by the “PHP Gods” themselves! This is very nice if you are looking for top-grade expert knowledge on how to do something. For example, if you are looking for tutorials that are designed for absolute beginners this is a fantastic place to visit http://www.zend.com/php/beginners/index.php
    They also have more advanced articles if you need them

    Both of the main websites above (php.net & zend.com) are extremely handy as reference resources! I highly recommend keeping them in a place that is easy to get to such as your bookmarks. I keep them in a bookmark folder on my FireFox toolbar.

    MySQL –

    Naturally http://mysql.com is the place to go for all things MySQL. Unfortunatly it can be kinda confusing navigating their site. So here are links straight to what I think would be the most used resources.

    This is the “Developer’s Manual” for MySQL. It contains just about everything you would want to know about using MySQL. It has a lot of information, but don’t feel overwhelmed there are key links to follow
    Installing MySQL on Windows OS platforms

    Here is a good area to visit if you are looking for a “tutorial” on how to use MySQL

    Nice index of all the statements used in MySQL such as GROUP BY (http://dev.mysql.com/doc/mysql/en/gr...imization.html)

    Tools for PHP & MySQL –

    Here you will find handy tools that make programming with PHP and MySQL easy and efficient.

    MySQL 4.0 download page. If you scroll down about 40% of the way down you will find “Windows Downloads” click the link ‘pick a mirror’ and download the installation. I recommend using the version with the installer.

    MySQL Administrator GUI client. This comes in handy for administrating your MySQL installation. It is pretty straight forward to use.

    MySQL Query Browser graphical client. This tool can help you create SQL statements.

    For those people who need an quick and painless sever package I highly recommend AppServ http://www.appservnetwork.com/
    This install package is about as hard to install as double clicking the file you download! Here is a pretty quick little tutorial on how to install it http://www.webdeveloper.com/forum/sh...731#post412731
    It is an all inclusive package.
    It contains all of the following (basically all you will need to get a full fledged server up and running locally):
    • Apache 1.3.33
    • PHP 4.3.11
    • MySQL 4.0.24
    • phpMyAdmin-2.5.7-pl1
    • MyODBC-3.51.11-2

    If you must install PHP only then you can find the installation packages here:
    PHP 4.4.0

    PHP 5.0.4

    The very best place that I have found to date that runs you through installing php on Windows is http://www.peterguy.com/php/install_IIS6.html (note: this is for PHP 5.x but can be applied to PHP 4.x)

    I am sure that there are many more places and products that could and should be added here but these are the ones that I could think of off the top of my head.

    I hope this helps in your quest to become a PHP Master

    Enjoy and happy coding and most importantly HAVE FUN !


    p.s. I just noticed that this post happened to be exactly my 800th post WOOT!
    Last edited by BeachSide; 08-04-2005 at 10:11 PM. Reason: Added link to my post about how to setup AppServ

  2. #2
    Join Date
    May 2004
    chennai, tamil nadu, India
    Great resources

    and if you still get stuck up, you could ask the experts out here

    Chris, Senior Developer,
    Php laravel developers,

  3. #3
    Join Date
    Jan 2005
    Lithia Springs, GA USA
    Thank you

    Yeah but you have to pay for that. The spirit of this post was to show people where to get the best resources for the lowest out of pocket cost... free.

  4. #4
    Join Date
    Aug 2005
    lol, yea. Another very helpful site is http://www.w3schools.com/php/default.asp.
    I have some experience in PHP, HTML, Javascript, and Java.



    AIMForum.com - Ready, AIM, Chat! | Google Talk Forum - Where the world talks about Google! | GIGMAX : YOUR SPACE, YOUR STORAGE

  5. #5
    Join Date
    May 2004
    chennai, tamil nadu, India

    Talking spirit of the post

    Quote Originally Posted by BeachSide
    Thank you

    Yeah but you have to pay for that. The spirit of this post was to show people where to get the best resources for the lowest out of pocket cost... free.
    Sorry for misunderstanding !

    I thought once you learn php you are NOT going to do php projects for free

    FOr example you are not going to say to your clients "I learnt php for free" so I am going to do all your projects for free ! So I thought learning php was for fun AND for making money

    Again Sorry for my misunderstanding !

    Chris, Senior Developer,
    Php laravel developers,

  6. #6
    Join Date
    Jan 2005
    Lithia Springs, GA USA
    I agree that one is not going to do a majority of their work for free. But when you are first starting out trying to learn PHP/MySQL then it is nice that you don't have to spend a wad of cash trying to learn it. Someone could go to these places I've listed above and get a taste of PHP/MySQL then see if it is for them. If they find that it is indeed for them then they can go and spend loads of cash buying books and what-not
    Last edited by BeachSide; 08-10-2005 at 05:50 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.11562 seconds
  • Memory Usage 2,920KB
  • Queries Executed 13 (?)
More Information
Template Usage (33):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (70):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates