3380-group-project-server-code

server code for group project app
All code on server and backups are located in this repo.
Setting up the server for use with the app located bellow

How to build the LAMP server

• use any machine that has a ubuntu partition on it
  

  • Video link to setting up Ubuntu partition for reference
    
    • boot into a usb flash drive that has been formated with ubuntu and follow instructions to install
      

• set up a LAMP(Linux Apache MySQL Php) server on the machine that is hosted on localhost
  

  • Video link to setting up LAMP server for reference
    
  • summary of video
    
    • open terminal and update to latest Ubuntu packages
      
      • sudo apt-get update
        
      • sudo apt-get upgrade
        
    • install tasksel
      
      • sudo apt-get install tasksel
        
    • run tasksel and select the 'Basic Ubuntu server,' 'LAMP server," and 'print server' options and hit 'ok'
      
      • follow prompts to set up passwords while tasksel sets up and installs the packages
        
    • install phpMyAdmin
      
      • sudo apt-get install phpmyadmin
        
    • give your user (Ubuntu user) all rights to edit the /var/www/html/ directory
      
      • sudo chown -R %UbuntuUser%:www-data /var/www/html/
        
      • sudo chmod 775 /var/www/html/
        
      • sudo chmod g+s /var/www/html/
        
      • switch to /var/www/html/ directory and run umask
        
        • cd /var/www/html/
          
        • umask
          
          • if you get 0002 back permissions are set up correctly
            

• add the function calls to the server

  • copy the files from this github repo into the /var/www/html/ directory
  • edit the $connection vars in all files to the login info you created for your MySQL admin

How to set up MySQL tables

• open firefox on the server
  • go to localhost/phpmyadmin
    • login and select import table
    • import the MySQLBuild.sql file