// Import Propel Configuration require_once '../vendor/autoload.php'; require_once '../generated-conf/config.php'; // Get the database instance $db = \Propel\Runtime\Propel::getDB(); // Use the PDO instance to run SQL queries $statement = $db->prepare("SELECT * FROM users"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); // Output the results var_dump($result);
// Import Propel Configuration require_once '../vendor/autoload.php'; require_once '../generated-conf/config.php'; // Create a new connection $database = [ 'driver' => 'pgsql', 'host' => 'localhost', 'dbname' => 'mydatabase', 'user' => 'myuser', 'password' => 'mypassword' ]; $db = \Propel\Runtime\Connection\ConnectionFactory::create($database); // Use the new connection to run SQL queries $statement = $db->prepare("SELECT * FROM users"); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); // Output the results var_dump($result);In this example, we create a new database connection using the ConnectionFactory class and pass in the necessary database settings. Then, we use the new connection to execute an SQL query and output the results. Based on the syntax used in the code examples, the Propel package library used is version 2.x.