Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Web Server development suggestions, please.

  1. #1
    Join Date
    Sep 2013
    Beans
    18

    Web Server development suggestions, please.

    I am new to web server dev. I set up a local server with ubutnu server. I've installed LAMP settings with phpmyadmin and webmin. My goal is to have a nice environment to practice programming, hosting, and protocol. Now that I have my server set up, where do I go from here? What are some suggestions? I would like to start learning how to write apps, web pages, and how to manage data on the backend. Specifically, among other things, I would like to focus on programming a sql database and being able to query it from a php app on the server. How do I get started doing this and what additional software will I need? Any other suggetions regarding server development for beginners would be appreciated.

  2. #2
    Join Date
    Feb 2008
    Location
    ɹǝpun uʍop
    Beans
    Hidden!
    Distro
    Xubuntu

    Re: Web Server development suggestions, please.

    Thread moved to Server Platforms.

    Welcome. You may well have more luck here for the moment as you are looking for server directions for now rather than programming support directly.

    All the best with it.

  3. #3
    Join Date
    Oct 2009
    Beans
    Hidden!
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Web Server development suggestions, please.

    What sort of code do you want to learn? I took a class on HTML5 and CSS in school, but I've been using this site: http://www.codecademy.com/ to learn some more PHP and JavaScript.
    Come to #ubuntuforums! We have cookies! | Basic Ubuntu Security Guide

    Tomorrow's an illusion and yesterday's a dream, today is a solution...

  4. #4
    Join Date
    Jun 2006
    Location
    Houston, TX
    Beans
    1,198
    Distro
    Ubuntu 6.06

    Re: Web Server development suggestions, please.

    First, if this is Internet facing, either remove phpmyadmin, or change the path. Look in your access and error logs to see why...

    Next, build a website. Break it a few times and fix it.

  5. #5
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    10,101
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: Web Server development suggestions, please.

    Your question is much too broad to be answerable here, but my first suggestion is to find a specific task that you would like to try to implement. The first time I used PHP and an SQL database (PostgreSQL for me), I was building an address directory to attach to a web site I had previously written for my college reunion class. Having a specific project helped to focus my mind on what was involved.

    However I strongly recommend you dump phpmyadmin and start teaching yourself how to write SQL using the mysql or psql command-line clients. If you want to understand how to write SQL-based applications, you need to learn SQL and not have some graphical client generate the code for you. I'd start by creating a small database in a spreadsheet program, then saving the data and loading it into an SQL database. Then teach yourself how to run SELECT queries with WHERE clauses like this:

    Code:
    select * from myfriends where lastname='Jones' and firstname='Shirley';
    Then try some INSERT and UPDATE commands. After that you can write a couple of simple PHP scripts to run those queries and display the results.

    Expect to spend at least a few person-weeks on just simple tasks like these if you have no experience with SQL or programming. If you've written programs in a procedural language like Python or perl before, you'll find the PHP part less daunting than the SQL part. If you're starting from scratch, I suggest using PostgreSQL rather than MySQL. Postgres conforms more closely to the SQL standards than MySQL, so what you learn will be more transferable to other SQL databases like Oracle or MS-SQL. I once had to write an application that queried an Oracle DB and found the syntax pretty similar to what I was used to from using Postgres.
    Last edited by SeijiSensei; September 7th, 2013 at 05:38 AM.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  6. #6
    Join Date
    Oct 2009
    Beans
    Hidden!
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Web Server development suggestions, please.

    I did my SQL class using MSSQL, but I prefer MySQL/MariaDB (but PostgreSQL is good too!). I've found the syntax is similar between MS SQL and MySQL, but they are a little bit different when it comes to actually working with them.
    Come to #ubuntuforums! We have cookies! | Basic Ubuntu Security Guide

    Tomorrow's an illusion and yesterday's a dream, today is a solution...

  7. #7
    Join Date
    Sep 2013
    Beans
    18

    Re: Web Server development suggestions, please.

    Quote Originally Posted by SeijiSensei View Post
    Your question is much too broad to be answerable here, but my first suggestion is to find a specific task that you would like to try to implement. The first time I used PHP and an SQL database (PostgreSQL for me), I was building an address directory to attach to a web site I had previously written for my college reunion class. Having a specific project helped to focus my mind on what was involved.
    That is sort of my dilemma. My local server doubles as a lab. I haven't an actual reason for a server, I don't plan to make it live. I just need an environment to write the code, dissect it, understand how it works. I was asking for ideas because I lack the creativity to develop anything of my own. I was hoping someone could offer up some ideas on what to do.

  8. #8
    Join Date
    Sep 2013
    Beans
    18

    Re: Web Server development suggestions, please.

    Quote Originally Posted by CharlesA View Post
    What sort of code do you want to learn? I took a class on HTML5 and CSS in school, but I've been using this site: http://www.codecademy.com/ to learn some more PHP and JavaScript.
    Well I've mastered the markup languages and client-side scripting. I sort of skipped programming- C and Assembly. I am trying to move in to server-side langages and app languages now but I honestly don't know how to get started. I lack the "vision" to undertake an original project. Creating a database and php apps to query it was the only thing I could think of to get started with.

  9. #9
    Join Date
    Sep 2013
    Beans
    18

    Re: Web Server development suggestions, please.

    I don't believe it is. My server is hosted on VM, no ports forwarded on the router. I don't believe it is accessbile outside of my network. I will remove phpadmin but I am new to this so I owe it to myself to ask why?

  10. #10
    Join Date
    Feb 2007
    Location
    West Hills CA
    Beans
    9,373
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: Web Server development suggestions, please.

    There are vulnerabilities to leaving PHP open to the outside world. As a next step, install a Content Management System (like Drupal). Understand how it works and dig into the programming. http://drupal.org

    Put on some white gloves if you want to practice protocol.
    -------------------------------------
    Oooh Shiny: PopularPages

    Unumquodque potest reparantur. Patientia sit virtus.

Page 1 of 2 12 LastLast

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
  •