maof14 / database
基本的PHP PDO数据库封装
dev-master
2015-05-22 11:10 UTC
This package is not auto-updated.
Last update: 2024-10-02 09:16:10 UTC
README
基本的PHP PDO数据库封装。
示例
初始化类
初始化类并获取一些数据库记录
<?php // Include config file or create own containing DSN connection details. include __DIR__."../../src/config.php"; // Init the database class using the DSN variable $db = new CDatabase($database); // Some SQL string and query parameters. $sql = "SELECT * FROM table WHERE someColumn = ? LIMIT 0, 10"; $params[] = 'parameter'; // Execute function that returns the results as array. $results = $db->executeSelectQueryAndFetchAll($sql, $params); ?>
输出结果
例如,在HTML中输出它们
<ul> <?php foreach($results as $result): ?> <li><?=$result->column;?></li> <?php endforeach;?> </ul>
不包括数据库。(:)) 提供的示例仅供示例使用。
MIT许可证
© Mattias Olsson 2015