MySQL Queries using Doctrine & CodeIgniter

Posted by 01010011 on Stack Overflow See other posts from Stack Overflow or by 01010011
Published on 2010-04-24T13:23:47Z Indexed on 2010/04/24 13:33 UTC
Read the original article Hit count: 192

Filed under:
|
|

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;  

© Stack Overflow or respective owner

Related posts about mysql

Related posts about doctrine