model view controller - handling forms in PHP MVC architecture

Question

I'm trying to learn MVC architecture in PHP. this is what I've got so far: (there are more views such as login,...)

this is my Database.php :

class Database {

    public static $host="127.0.0.1";
    public static $dbName= "db6";
    public static $username = "username";
    public static $password = "password";

    private static function connect() {
            $pdo = new PDO("mysql:host=".self::$host.";dbname=".self::$dbName.";charset=utf8", self::$username, self::$password);
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            return $pdo;
    }

    public static function query($query, $params = array()) {
            $statement = self::connect()->prepare($query);
            $statement->execute($params);

            if (explode(' ', $query)[0] == 'SELECT') {
            $data = $statement->fetchAll();
            return $data;
            }

            
    }

}

and Controller.php:

class Controller extends Database {

public static function CreateView($viewName){
    require_once("./view/$viewName.php");
    static::doSomething();
}

}

and Route.php :

class Route {
public static $validRoutes = array();

public static function set($route, $function){
    self::$validRoutes[] = $route;
    //print_r(self::$validRoutes);
    if($_GET['url'] == $route) {
        $function->__invoke();
    }

}

}

in view/login.php I have a form for user login:

<form _lpchecked="1" method="POST">
      <div class="form-group">
         User Name:<input type="text" class="form-control" id="loguser" placeholder="User Name" name="loguser">
      </div>                       
      <div class="form-group">
        Password:<input type="password" class="form-control" id="password" placeholder="Password" name="logpass">
      </div>
      <div class="d-flex flex-row align-items-center justify-content-between">
        <a href="jhl.php">Cancel</a>
        <button class="btn btn-primary">Login</button>
      </div>
   </form>

How can I handle the form? and also how can I complete my db class since it's only working for SELECT queries? thanks inadvance

question from:https://stackoverflow.com/questions/65940976/handling-forms-in-php-mvc-architecture

Answer 1

Waitting for answers