PHP Connection::fetch方法代码示例

	/**
	 * Returns rows from database.
	 * @param string $query
	 * @param array $params
	 * @param int $limit
	 * @param int $offset
	 * @return array
	 */
	public function get($query, array $params = array(), $limit = false, $offset = 0) {
		if ($limit) {
			$query = $this->strategy->limit($query, $limit, $offset);
		}
		$return = array();
		$result = $this->connection->query($query, $params);
		if ($result) {
			while ($row = $this->connection->fetch($result)) {
				$return[] = $row;
			}
		}
		return $return;
	}

 public function testFetchEOF()
 {
     $this->createTable();
     $statement = $this->connection->query("SELECT * FROM cat");
     $this->connection->fetch($statement);
     // Simon's Cat
     $this->connection->fetch($statement);
     // Garfield
     $this->assertFalse($this->connection->fetch($statement));
 }

<?php

include 'db_connect.php';
//include the db_connect.php file
//Create and set a new connection
$get = new Connection("db1");
//"db1" is user defined in db_connect.php
//Create a query: $var->query("SQL_STATEMENT"); $var is the variable you created a connection with.
$selectusers = $get->query("SELECT * FROM users");
//Do whatever you would like with the query
echo mysql_num_rows($selectusers);
//Use built in functions to make one line queries.
echo $get->fetch($selectusers);
//fetch() fetches the associated rows.  More quick functions coming soon.

//Declaring $sameDate as an array.
if ($db->numRows($result) < 1) {
    //Checking if the result is smaller then 1.
    echo '<li class="day">';
    echo "<h4>" . getFullDate($date) . "<a href=\"#\" onClick=\"nextDate('{$date}')\" class=\"todoNav\">Next</a><a href=\"#\" onClick=\"previousDate('{$date}')\" class=\"todoNav\">Previous </a> </h4>";
    //Returns the date as a String.
    echo '<fieldset>';
    echo '<input class="ToDoInsert" type="text" value="Insert your ToDo here and hit the enter-key." name="ToDoInsert" />';
    echo '</fieldset>';
    echo '<ul>';
    echo '</ul>';
    echo '</li>';
    //End Of This Day.
} else {
    //Displaying the result.
    while ($row = $db->fetch($result)) {
        if (!in_array($row['todo_date'], $sameDate)) {
            echo '<li class="day">';
            echo "<h4>" . getFullDate($date) . "<a href=\"#\" onClick=\"nextDate('{$date}')\" class=\"todoNav\">Next</a><a href=\"#\" onClick=\"previousDate('{$date}')\" class=\"todoNav\">Previous </a> </h4>";
            //Returns the date as a String.
            echo '<fieldset>';
            echo '<input class="ToDoInsert" type="text" value="Insert your ToDo here and hit the enter-key." name="ToDoInsert" />';
            echo '</fieldset>';
            echo '<ul>';
            $resultList = $db->query('SELECT * FROM th_todo WHERE todo_userId = ' . $_SESSION['user']['id'] . ' AND `todo_date` =  "' . $row['todo_date'] . '"');
            while ($rowWhile = $db->fetch($resultList)) {
                echo '<li>';
                //Resetting the $done var.
                $done = '';
                if ($rowWhile['todo_done'] == 1) {
                    $done = 'done';

 /**
  * @param array $columnsToSelect
  * @return array|null
  */
 public function oneAsArray($columnsToSelect = ['*'])
 {
     $this->limit(1);
     return $this->connection->fetch($this->getSelectQuery($columnsToSelect), $this->getBindingValues());
 }

 * @version 0.2
 * @description Threads Login File
 * @author Joeri Hermans
 * @contact joeri.her@gmail.com
 * @license GNU
 */
require_once '../system/config.php';
require_once '../system/rewrite.php';
require_once '../system/classes.php';
$db = new Connection();
if (!empty($_SESSION['user']['username']) && !empty($_SESSION['user']['password'])) {
    $result = $db->query('SELECT * FROM th_users WHERE user_username = "' . $_SESSION['user']['username'] . '" AND user_password = "' . $_SESSION['user']['password'] . '"');
    //Retrieving result from MySQL
    if (mysql_num_rows($result) == 1) {
        //If MySQL returns 1 row.
        while ($row = $db->fetch($result)) {
            //You spin my head round baby round round.
            $_SESSION['user']['id'] = $row['user_id'];
            //Fetching User Id.
            $_SESSION['user']['name'] = $row['user_name'];
            //Fetching User Name.
            $_SESSION['user']['lastName'] = $row['user_lastName'];
            //Fetching User Lastname.
            $_SESSION['user']['perm'] = $row['user_permission'];
            //Fetching the users' permission.
        }
    }
}
if (isset($_POST['username'])) {
    $result = $db->query('SELECT * FROM th_users WHERE user_username = "' . $_POST['username'] . '" AND user_password = "' . md5($_POST['password']) . '"');
    if (mysql_num_rows($result) == 1) {

<?php

include 'db_connect.php';
//include the db_connect.php file
print "<HTML><BODY><H1>Showing the users of the sampledb that has been created in the RDS few seconds ago!</H1>\n";
//Create and set a new connection
$get = new Connection("db1");
//"db1" is user defined in db_connect.php
//Create a query: $var->query("SQL_STATEMENT"); $var is the variable you created a connection with.
$selectusers = $get->query("SELECT * FROM users");
//Do whatever you would like with the query
print "Total Number of user records: ";
print mysql_num_rows($selectusers);
print "\n\r";
//Use built in functions to make one line queries.
$rowarray = $get->fetch($selectusers);
//fetch() fetches the associated rows.
print "<table>\n\r";
foreach ($rowarray as $row) {
    print "<tr>\n\r";
    foreach ($row as $col) {
        print "\t<td>{$col}</td>\n\r";
    }
    print "</tr>\n\r";
}
print "</table></BODY></HTML>";