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