Execute raw SQL using Doctrine 2

by

Here’s an example of a raw query in Doctrine 2 that I’m doing:

public function getAuthoritativeSportsRecords()
{   
    $sql = " 
        SELECT name,
               event_type,
               sport_type,
               level
          FROM vnn_sport
    ";

    $em = $this->getDoctrine()->getManager();
    $stmt = $em->getConnection()->prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
}

More Related Contents:

  1. to delete 14 row by 1 click
  2. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  3. how to get client’s IP address in sql database [closed]
  4. Combine multiple sql / mysql queries in one query
  5. Cleansing User Passwords
  6. Commands out of sync; you can’t run this command now
  7. Cannot simply use PostgreSQL table name (“relation does not exist”)
  8. SELECT COUNT(*) AS count – How to use this count
  9. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  10. Get table column names in MySQL?
  11. How to resolve ambiguous column names when retrieving results?
  12. selecting unique values from a column
  13. Simple PHP Pagination script [closed]
  14. Use bound parameter multiple times
  15. Create a dynamic mysql query using php variables
  16. How to separate DATE and TIME from DATETIME in MySQL?
  17. PHPUnit Mock Objects and Static Methods
  18. Symfony error The class XXX was not found in the chain configured namespaces XXX
  19. MySQL skipping first row
  20. How to reverse order output of a MySQL query
  21. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  22. How to generate unique id in MySQL?
  23. Pass array literal to PostgreSQL function
  24. How to force Doctrine to update array type fields?
  25. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  26. looping a SQL insert statement with dates
  27. Display an array in a readable/hierarchical format [duplicate]
  28. UNION syntax in Cakephp
  29. How do i search from serialize field in mysql database?
  30. PDO Exception Questions – How to Catch Them

Leave a Comment