Login   Register  
PHP Classes
elePHPant
Icontem

File: sample_output.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nemeth Zoltan  >  IDatabase class  >  sample_output.txt  >  Download  
File: sample_output.txt
Role: Sample output
Content type: text/plain
Description: Sample output
Class: IDatabase class
MySQL Database access wrapper using MySQLi
Author: By
Last change:
Date: 9 months ago
Size: 3,713 bytes
 

Contents

Class file image Download
Connection successful.
SELECT ALL ROWS

Array
(
    [0] => Array
        (
            [id] => 1
            [date] => 2014-03-06 16:45:11
            [name] => test1
            [counter] => 13
        )

    [1] => Array
        (
            [id] => 2
            [date] => 2014-03-06 16:45:16
            [name] => test2
            [counter] => 13
        )

    [2] => Array
        (
            [id] => 3
            [date] => 2014-03-06 16:45:21
            [name] => tester1
            [counter] => 13
        )

    [3] => Array
        (
            [id] => 4
            [date] => 2014-03-06 16:45:27
            [name] => tester2
            [counter] => 13
        )

    [4] => Array
        (
            [id] => 5
            [date] => 2014-03-06 16:45:34
            [name] => tester3
            [counter] => 13
        )

    [5] => Array
        (
            [id] => 6
            [date] => 2014-03-06 16:55:47
            [name] => tester4255
            [counter] => 7
        )

    [6] => Array
        (
            [id] => 7
            [date] => 2014-03-06 16:56:15
            [name] => tester8213
            [counter] => 6
        )

    [7] => Array
        (
            [id] => 8
            [date] => 2014-03-06 16:56:26
            [name] => tester9304
            [counter] => 5
        )

    [8] => Array
        (
            [id] => 9
            [date] => 2014-03-06 16:57:59
            [name] => tester7947
            [counter] => 4
        )

    [9] => Array
        (
            [id] => 10
            [date] => 2014-03-06 16:58:30
            [name] => tester5615
            [counter] => 3
        )

)
UPDATE ALL ROWS

Affected rows: 10
Array
(
    [0] => Array
        (
            [id] => 1
            [date] => 2014-03-06 16:45:11
            [name] => test1
            [counter] => 14
        )

    [1] => Array
        (
            [id] => 2
            [date] => 2014-03-06 16:45:16
            [name] => test2
            [counter] => 14
        )

    [2] => Array
        (
            [id] => 3
            [date] => 2014-03-06 16:45:21
            [name] => tester1
            [counter] => 14
        )

    [3] => Array
        (
            [id] => 4
            [date] => 2014-03-06 16:45:27
            [name] => tester2
            [counter] => 14
        )

    [4] => Array
        (
            [id] => 5
            [date] => 2014-03-06 16:45:34
            [name] => tester3
            [counter] => 14
        )

    [5] => Array
        (
            [id] => 6
            [date] => 2014-03-06 16:55:47
            [name] => tester4255
            [counter] => 8
        )

    [6] => Array
        (
            [id] => 7
            [date] => 2014-03-06 16:56:15
            [name] => tester8213
            [counter] => 7
        )

    [7] => Array
        (
            [id] => 8
            [date] => 2014-03-06 16:56:26
            [name] => tester9304
            [counter] => 6
        )

    [8] => Array
        (
            [id] => 9
            [date] => 2014-03-06 16:57:59
            [name] => tester7947
            [counter] => 5
        )

    [9] => Array
        (
            [id] => 10
            [date] => 2014-03-06 16:58:30
            [name] => tester5615
            [counter] => 4
        )

)
INSERT RANDOM tester AND print last query string

Inserted ID: 14
Insert Query: INSERT INTO sample(name,counter) VALUES('tester9714','0')
DELETE last inserted row (id: 14)

Query: DELETE FROM sample WHERE id=14Affected rows: 1