parismollo / equipo Goto Github PK

Create main file to set MySQL tables and user admin accounts (login and password)

• main file (php) to generate database table (tous)
• create admin account
• create tags

• gender (male or female)
• age (date de naissance)
• mail

Reference

• update project creation form css

• Logging errors in PHP

Error output

Warning: Undefined array key "pseudo" in C:\Users\paris\XAMPP\htdocs\Projet_universite\Equipo2.0\database\user.php on line 45

Replicate error

1. Log with a existant account
2. Once you are in the welcome page, change the get param on the url to ?action=login. It will output the error showed above.

Expected behavior

• If user is logged, and if he tries to access log in page he will be redirected to his welcome page. Need to check if there is a session and if there is, the "switch" from the signup.php need to be ready for every case.

• table with user connection

• project name
• tag
• description
• collaborators
• upvotes
• status

• redirect user after login to profile not to "welcome page"

• tags (trop compliqué?)
• mot de passe not required

Create Logout flow

• write function that allow admins to delete projects accounts

• Sign up form
• Login form
• errors in form
• something went wrong
• duplicate entry
• Disconnected

• User can create project from profile page (later will in home page)

• Handle login form data
• login SQL (connection, query, find user, handle error)
• Start session
• logout

• update password

Details at image

• home page (html and css) @Mojigot7
• user page (other user page)
• project page (other user page)
• If no interests show button to add interests
• query - select projects that have the same you add in update profile @Mojigot7

Refactor login and sign in cases in switch

• Refactor signup.php and login.php
• check form validations
• check database connection and query generation
• saving user
• error handling
• Session and session check in all pages
• logout

Currrent state

• bit messy
• not very modular
• too much code
  // signup.php

  .........
  if(isset($_GET["action"])){
    $param = $_GET["action"];
    switch ($param) {
      case 'signup':
        $errors = validate_data($_POST, $errors);
        if (empty($errors)){
          form_validation($_POST);
          if(save_user($_POST)){
            login_form($errors, "");
          }  
        }else{
          signup_form($errors);
        }
        break;
      case 'login':
        $errors = validate_data2($_POST, $errors);
        if (empty($errors)){
          form_validation($_POST);
          if(login_user($_POST)){
            header('Location: signup.php?action=welcome');
          } else{
            login_form($errors, $wrong);
          }
        } else{
          login_form($errors,"");
        }
        break;
      case 'signin':
        login_form($errors,"");
        break;  
      case 'welcome':
        echo "Welcome ".$_SESSION['pseudo'];
        break;    
      default:
        signup_form($errors); // display fonctions
        break;
    }
  }else {
    signup_form($errors);
  }
     .......

Refactoring Proposal

• easier to read
• modular
• easy to debbug

The following is an example based on the code from the IO2 homework's that I did.
//signup.php

if (isset($_GET["action"])){
    $param = $_GET['action'];
    switch ($param) {
      case 'validate_data':
        $bool = verify_form_data($_POST);
        redirect_user($bool, $_POST);
        break;
      default:
        display_form();
    }
  }else {
    display_form();
  }

// login.php

<?php
  session_start();
  require_once("display_functions.php"); require_once("handle_input_data.php");
  if (isset($_GET["action"])){
    $param = $_GET["action"];
    switch ($param) {
      case 'login':
        if (handle_login_data($_POST)){
          redirect_login($_POST);
        }else {
          echo "Missing fields...<br>";
          echo "<a href=\"login.php\">Try again</a>";
        }
        break;
      case 'reset':
        $_SESSION = array();
        session_destroy();
        header("Location: login.php");
        break;
      default:
        display_login();
        break;
    }
  }else{
    if (isset($_SESSION["user"])){
      echo "Yeah what's up ", $_SESSION["user"], "?";
      echo "<br><a href=\"login.php?action=reset\">Reset Session</a>";
    }else {
      display_login();
    }
  }
?>

• Query (search projects with specific username, tag, project title)
• user same html that the home page one

• Show user interests (tags) in profile page
• on update profile - allow user to follow "tags"

• update profile CSS
• Button to create project

• mettre liens dans navbar
• mettre lien pour creer projet
• mettre lien pour ajouter interet

• Add logo
• fix gender radiobox

• Show project collaborators
• Show project tags
• display general form errors
• validate user data
• cant' create duplicate project error display
• allow user to delete project - fix css button
• add upvotes
• add collaborator method

• show followers
• follow button

• add logout button

Login workflow

• login form
• error handling
• redirection
• session creation

if you run twice the script the app crash
possible solution: always drop the tables and create it once the script is called

• fix bug above
• fix link "go back" in case of error

CSS + Figma form design and implementation

• Sign up form
• Login form
• Error displays
• Success displays

• allow user to follow a tag (add in table userLabels)

• add projects in profile

Review

• Form
• Sign up
• Database
• Login
• Validation

• Create Project Post

• add logo