MySQL Queries using Doctrine & CodeIgniter
- by 01010011
Hi,
How do I write plane SQL queries using Doctrine connection object and display the results? For example, how do I perform:
SELECT * FROM table_name WHERE column_name LIKE '%anything_similar_to_this%';
using Doctrine something like this (this example does not work)
$search_key = 'search_for_this';
$conn = Doctrine_Manager::connection();
$conn->execute('SELECT * FROM table_name WHERE column_name LIKE ?)', $search_key);
echo $conn;