PHP User::loadFromDb Examples

Programming Language: PHP

Class/Type: User

Method/Function: loadFromDb

Examples at hotexamples.com: 5

loadFromDB is a method in PHP that is used to load user data from a database. It is commonly used in web applications that require user authentication and management.

Example 1:

class User {
  private $db;

  public function __construct($db) {
    $this->db = $db;
  }

  public function loadFromDB($id) {
    $result = $this->db->query("SELECT * FROM users WHERE id = $id");
    $user = $result->fetch_assoc();
    $this->name = $user['name'];
    $this->email = $user['email'];
    $this->password = $user['password'];
  }
}

// create new user object
$user = new User($db);

// load user data from database based on id
$user->loadFromDB(1);

// user data is now available to be used in the application
echo $user->name; // prints user's name
echo $user->email; // prints user's email

In this example, the loadFromDB method is used to load user data from the database based on the user's ID. The data is then stored in the user object's properties, which can be accessed by the application.

This example does not specify a specific package library as it is a bare-bones implementation of loadFromDB.

Example 2:

require_once 'vendor/autoload.php';

use MyPackage\DBConnection;
use MyPackage\User;

// create new database connection
$db = new DBConnection('localhost', 'user', 'password', 'my_db');

// create new user object
$user = new User($db);

// load user data from database based on id
$user->loadFromDB(1);

// user data is now available to be used in the application
echo $user->name; // prints user's name
echo $user->email; // prints user's email

In this example, loadFromDB is part of a package library (MyPackage) that includes a DBConnection class. The DBConnection class is used to establish a connection to a database, and the User class is used to manage user data. The loadFromDB method in this example is similar to the first example, but the User class is part of a larger package that includes other functionality related to database management and user authentication. This approach promotes code organization and modularity, making it easier to maintain and scale the application.

PHP User::loadFromDb - 5 examples found. These are the top rated real world PHP examples of User::loadFromDb extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

addUser(30)

data(30)

dropdown(30)

create(30)

findFirst(30)

fetch(30)

getAll(30)

factory(30)

getCanonicalName(30)

__construct(30)

auth(30)

getAllGroups(30)

find_all(30)

authenticate(30)

authorise(30)

findById(30)

getErrors(30)

first(30)

getAllUsers(30)

findByUsername(30)

exists(30)

getEmail(30)

find_by_id(30)

errors(30)

deleteUser(30)

add(30)

find_by_username(30)

delete(30)

getAuthorisedViewLevels(30)

current(30)

findOrFail(30)

all(30)

getCurrentUser(30)

getDefaultOption(30)

get(30)

createUser(30)

getById(30)

findOne(30)

find(30)

format(30)

getByUsername(30)

checkPassword(30)

count(30)

destroy(30)

checkName(30)

csrf_cookie(30)

can(29)

encryptPassword(29)

checkEmail(29)

User Class Documentation

Example #1

Show file

File: myMessages.php Project: Witoso/twitter_app

    $message->showShort();
    echo "</li>";
}
echo "</ul>";
?>


<h3>Sent messages</h3>

<?php 
$userId = $id;
// id from a cookie
$db = Database::getInstance();
$conn = $db->getConnection();
$user = new User($conn);
$user->loadFromDb($userId);
$arraySent = $user->loadAllSent();
echo "<ul>";
foreach ($arraySent as $message) {
    echo "<li>";
    $message->showShort();
    echo "</li>";
}
echo "</ul>";
?>

</body>


</html>

Example #2

Show file

File: renderTweets.php Project: Witoso/twitter_app

require_once ROOT_NAME . "/classes/Tweet.php";
require_once ROOT_NAME . "/classes/User.php";
require_once ROOT_NAME . "/classes/TweetsLoader.php";
require_once ROOT_NAME . "/classes/Database.php";
$db = Database::getInstance();
$conn = $db->getConnection();
$loader = new TweetsLoader($conn);
$loader->loadTweets();
$tweetArray = $loader->getArrayWithTweets();
foreach ($tweetArray as $tweet) {
    $userId = $tweet->getUserId();
    $user = new User($conn);
    $user->loadFromDb($userId);
    $tweetId = $tweet->getId();
    $comments = $tweet->loadAllComments();
    echo "<div class='col-md-12 container tweet-block'>";
    $user->show();
    $tweet->show();
    require ROOT_NAME . "/includes/commentForm.php";
    echo "<ul class='comments'>";
    foreach ($comments as $comment) {
        echo "<li>";
        $comment->show();
        $commenter = new User($conn);
        $commenter->loadFromDb($comment->getUserId());
        $commenter->show();
        echo "</li>";
    }
    echo "</ul>";
    echo "</div>";
}

Example #3

Show file

File: showMessage.php Project: Witoso/twitter_app

</head>

<body>

<a class="btn btn-default" href="index.php">Go to the main page</a>
<a class="btn btn-default" href='myMessages.php'>My Messages</a>
<?php 
if (isset($_GET["message"])) {
    $messageId = $_GET["message"];
    $db = Database::getInstance();
    $conn = $db->getConnection();
    $message = new Message($conn);
    $message->loadFromDb($messageId);
    $senderId = $message->getSenderId();
    $sender = new User($conn);
    $sender->loadFromDb($senderId);
    $senderNick = $sender->getNick();
    $receiverId = $message->getReceiverId();
    $cookieId = $id;
    if ($cookieId == $senderId) {
        $message->showLong();
    } elseif ($cookieId == $receiverId) {
        $message->showLong();
        $message->markAsRead();
        echo "\n        <form method=\"GET\" action=\"createMessage.php\">\n            <input type=\"hidden\" value=\"{$senderId}\" name=\"receiver_id\" />\n            <input type=\"hidden\" value=\"{$senderNick}\" name=\"receiver_nick\" />\n            <button class=\"btn btn-default\" type=\"submint\">Send a reply!</button>\n        </form>\n        ";
    } else {
        header("location: index.php");
    }
}
?>

Example #4

Show file

File: Message.php Project: Witoso/twitter_app

 public function showLong()
 {
     $receiver = new User($this->connection);
     $receiver->loadFromDb($this->receiverId);
     $sender = new User($this->connection);
     $sender->loadFromDb($this->senderId);
     $dateFormatted = substr($this->createdAt, 0, 16);
     echo "<h3>From: " . $sender->getNick() . " To: " . $receiver->getNick() . "</h3>";
     echo "<p>{$dateFormatted}</p>";
     echo "<p>{$this->text}</p>";
 }

Example #5

Show file

File: users_list_all.php Project: HubertAdamus/Pure_PHP

<?php

include "header.php";
$loggedUser = new User();
$loggedUser->loadFromDB($conn, $_SESSION["user_id"]);
$sql = 'SELECT id FROM Users';
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $tempUser = new User();
        $tempUser->loadFromDb($conn, $row["id"]);
        echo $tempUser->generateLinkToMyPage();
        echo "<br>";
    }
}
include "footer.php";