Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.16.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u226437350

Directory:

/home/u226437350/domains/perlct.in/public_html/erp/ERP & CRM/sales/models

Free Space:

8.52 TB

🔧 Quick Actions

✏️ Editing: users.model.php

<?php

require_once "connection.php";

class UsersModel {

/*=============================================
    SHOW USER 
    =============================================*/

static public function MdlShowUsers($tableUsers, $item, $value) {

$connection = new Connection(); // Create an instance of the Connection class

if ($item != null) {

$stmt = $connection->connect()->prepare("SELECT * FROM $tableUsers WHERE $item = :$item");

$stmt->bindParam(":".$item, $value, PDO::PARAM_STR);

$stmt->execute();

return $stmt->fetch();

} else {
            $stmt = $connection->connect()->prepare("SELECT * FROM $tableUsers");

$stmt->execute();

return $stmt->fetchAll();
        }

$stmt->close();
        $stmt = null;

}

/*=============================================
    ADD USER 
    ==============================================*/

static public function mdlAddUser($table, $data) {

$stmt = Connection::connect()->prepare("INSERT INTO $table(name, user, password, profile, photo) VALUES (:name, :user, :password, :profile, :photo)");

$stmt->bindParam(":name", $data["name"], PDO::PARAM_STR);
        $stmt->bindParam(":user", $data["user"], PDO::PARAM_STR);
        $stmt->bindParam(":password", $data["password"], PDO::PARAM_STR);
        $stmt->bindParam(":profile", $data["profile"], PDO::PARAM_STR);
        $stmt->bindParam(":photo", $data["photo"], PDO::PARAM_STR);

if ($stmt->execute()) {
            return 'ok';
        } else {
            return 'error';
        }

$stmt->close();
        $stmt = null;
    }

/*=============================================
    EDIT USER 
    ==============================================*/

static public function mdlEditUser($table, $data) {

$stmt = Connection::connect()->prepare("UPDATE $table set name = :name, password = :password, profile = :profile, photo = :photo WHERE user = :user");

if ($stmt->execute()) {

return 'ok';

} else {

return 'error';

}

$stmt->close();

$stmt = null;
    }

/*=============================================
    UPDATE USER 
    ==============================================*/

static public function mdlUpdateUser($table, $item1, $value1, $item2, $value2) {

$stmt = Connection::connect()->prepare("UPDATE $table set $item1 = :$item1 WHERE $item2 = :$item2");

$stmt->bindParam(":".$item1, $value1, PDO::PARAM_STR);
        $stmt->bindParam(":".$item2, $value2, PDO::PARAM_STR);

if ($stmt->execute()) {

return 'ok';

} else {

return 'error';

}

$stmt->close();

$stmt = null;
    }

/*=============================================
    DELETE USER 
    ==============================================*/

static public function mdlDeleteUser($table, $data) {

$stmt = Connection::connect()->prepare("DELETE FROM $table WHERE id = :id");

$stmt->bindParam(":id", $data, PDO::PARAM_STR);

if ($stmt->execute()) {

return 'ok';

} else {

return 'error';

}

$stmt->close();

$stmt = null;
    }

} 
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: users.model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation