Results 1 to 5 of 5

Thread: Web Application Dev

Hybrid View

  1. #1
    Join Date
    Jun 2013

    Web Application Dev

    Hi all,

    I am new to programming but not new to the IT industry.

    I have been researching and training in a few areas, but seem to have landed on the PHP/MySQL track for what I would like to do.

    I would like to create web apps that users can create an account, enter data, have access to their own data, and also view reports based on the data they entered. They content would vary depending on the purpose of the application, but the concepts are the same. The goal is to be able to extract KPI's from the data that is entered over time and display dashboard type reporting, as well as the ability to download excel/pdf versions if a user would like to. I would also like the ability to allow "companies" with multiple users to access to the same data - but may vary depending on permissions within that organization.

    Am I going down the right path in choosing PHP and MySQL? I have looked at a few web based technologies and have determined that will be the most scalable and effective approach. Any advice on what to learn or focus on? I appreciate any help that you can offer.


  2. #2
    Join Date
    Aug 2004
    It is certainly a viable platform for this. You could just as well do it with pretty much any other web programming language and DBMS, such a .NET/C# and MS SQL or Ruby (with Rails) and PostgreSQL. A PHP/MySQL combo has the slight advantage of being available on pretty much any Linux web server as well as having a large user community that can give you support, but ultimately it comes down to what you are most comfortable working with or which one you want to learn.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Jun 2013
    Thanks for the reply NogDog. I had actually looked at the Rails/PostgreSQL option as well but opted for PHP simply based on the amount of community based support and content available.

    I am looking to develop commercial applications that are based in the cloud. In the beginning I will be primarily targeting SMB sized businesses that need Enterprise level solutions without the Enterprise level budget. None of this is shocking I am sure, but I at least want to make sure I am heading in the right direction.

    Based on the above scenario, should I be planning that each company would have their own DB, or am I ok to have multiple customers on the same DB but separated by permissions. If that was the situation, would it be done by a separate table for each customer within the database and assign permissions to users accordingly, or would they simply all use the same tables, but differentiated in a different way.

    Any advice is very much appreciated!


  4. #4
    Join Date
    Aug 2004
    I would opt for the single database with one set of tables. Include a "customer" table (or whatever makes sense as a name) that includes the static information about the customers, then add a "customer_id" column as a foreign key in each table that has items which are customer-specific. Any queries against that data can then be filtered in the where clause using the customer_id column.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  5. #5
    Join Date
    Jun 2013
    Thanks for the help NogDog. I will keep that in mind while planning the structure of the DB.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.11499 seconds
  • Memory Usage 3,011KB
  • Queries Executed 13 (?)
More Information
Template Usage (29):
  • (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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (27):
  • ./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
  • ./includes/functions_threadedmode.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 (72):
  • 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_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • 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