$query = Doctrine_Query::create()
->from('User u')
->where('u.username LIKE ?', 'john%');
$query->select('u.id, u.username')
->orderBy('u.created_at DESC')
->setMaxResults(10);
This adds more conditions to the query, including selecting only the "id" and "username" columns, ordering the results by the "created_at" column in descending order, and limiting the results to 10 records.
3. Package library:
The Doctrine_Query component is part of the Doctrine ORM package. Other components in the package include the following:
- Doctrine\DBAL: Provides a database abstraction layer that allows you to connect to different database systems and execute SQL queries.
- Doctrine\Common: Provides common classes and utilities used by other Doctrine components.
- Doctrine\ORM: Provides the core functionality for mapping PHP objects to database tables and persisting them.
In conclusion, the Doctrine_Query component of the Doctrine ORM provides an easy and convenient way to create and execute SQL queries in PHP applications. By combining it with other components in the Doctrine package, you can build powerful and scalable systems that interact with relational databases. public function listCategory()
{
$q = Doctrine_Query::CREATE()->from('Model_Category c');
return $q->fetchArray();
}
public function listProducts()
{
$q = Doctrine_Query::CREATE()->from('Model_Product p');
return $q->fetchArray();
}
