I have "user" class with "post()" return all post this

Question

PHP

Jesús

I have "user" class with "post()" return all post this

user. I have to connect it with mysql. How i can do it?

0

06.11.2017

2 ответов

9 просмотров

O

I do this with MVC, here is an example: A model called UserModel.php: class UserModel { public static function getAllPosts() { $database = DatabaseFactory::getFactory()->getConnection(); $sql = "SELECT user_id, user_name FROM users "; $query = $database->prepare($sql); $query->execute(array(':user_id' => Session::get('user_id'))); // fetchAll() is the PDO method that gets all result rows return $query->fetchAll(); } } Call the controller simply with UsersModel::getAllUsers()

0

06.11.2017

🐴 · Accepted Answer

🐴

use ORM, e.g. Doctrine

0

06.11.2017

Похожие чаты

I have "user" class with "post()" return all post this

2 ответов

Похожие вопросы