src/Database/TSQLQueryBuilderBasic.php 16

Type Line Description
14 SQL dialect for a certain database
15 The query built
16 Prefix to attach to all table names
18 Columns to select
19 From part
20 Join part
21 Where part
22 Group by part
23 Order by part
24 Limit by part
25 Offset by part
118 stackoverflow.com/questions/173400/php-arrays-a-good-way-to-check-if-an-array-is-associative-or-sequential/4254008#4254008
213 If $values is null, then use $columns to build it up
218 Incoming is associative array, split it up in two
224 Create an array of '?' to match number of columns
301 If $values is string, then move that to $where

webroot/testMySQL.php 14

Type Line Description
3
4 Set the error reporting.
5
6 Report all type of errors
7 Do not buffer outputs, write directly
10
11 Get required files
12
19
20 Read config file
21
26
27 Carry out som tests
28

src/Database/CDatabaseBasic.php 8

Type Line Description
19 Options used when creating the PDO object
20 The PDO object
21 The latest statement used to execute a query
22 Count all queries made
23 Save all queries for debugging purpose
24 Save all parameters for debugging purpose
101 For debug purpose, shows all connection details
104 Hide connection details.

webroot/config_mysql.php 4

Type Line Description
4 Set up details on how to connect to the database
11 Display details on what happens
14 Throw a more verbose exception when failing to connect
15 'debug_connect' => 'true',

webroot/testSQLite.php 20

Type Line Description
3
4 Set the error reporting.
5
6 Report all type of errors
7 Display all errors
10
11 Get required files
12
19
20 Precondition
21
22 if (!is_writable(__DIR__)) {
23 die("This directory must be writable to create the SQLite database file.");
24 }
27
28 Read config file
29
34
35 Carry out som tests
36

webroot/testDatabaseQueries.php 68

Type Line Description
2
3 Carry out som tests, db must exist
4
7 $db->connect('debug');
10
11 Drop a table if it exists
12
17
18 Create a table
19
33
34 Rows to test with
35
42
43 Insert a single row into table using key => value
44
59
60 Insert a single row into table using two arrays
61
74
75 Insert a single row into table using single array
76
90
91 Select from database
92
107
108 Update a single row using key => value
109
123
124 Select from database
125
134
135 Update a single row using one arrays
136
147
148 Select from database
149
158
159 Select from database
160
179
180 Select from database
181
192
193 Select and group by
194
206
207 Select, limit and offset
208
238
239 Select and join from database
240
271 www.sqlite.org/omitted.html";
287
288 Delete a single row
289
299
300 Select from database
301
308
309 Delete all row
310
317
318 Select from database
319
325
326 Drop a table
327

webroot/testSQLQueryBuilderBasic.php 39

Type Line Description
10
11 Create a table
12
29
30 Insert a single row into table using key => value
31
45
46 Insert a single row into table using two arrays
47
58
59 Insert a single row into table using one array (rest will be sent as parameters)
60
70
71 Update a single row using key => value
72
87
88 Update a single row using two arrays
89
101
102 Update a single row into table using one array (rest will be sent as parameters)
103
114
115 Select from database
116
137
138 Select and join from database
139
171
172 Select, limit and offset
173
197
198 Delete a single row
199
209
210 Delete all row
211
220
221 Drop a table
222

webroot/test/testUserPasswordMD5.php 38

Type Line Description
3
4 Set the error reporting.
5
6 Report all type of errors
7 Do not buffer outputs, write directly
10
11 Get required files
12
19
20 Read config file
21
26
27 Carry out som tests, db must exist
28
35
36 Drop a table if it exists
37
43
44 Create a table
45
58
59 Add some users to test with
60
72
73 Add some users, two steps since must use salt as created before.
74
89
90 Check whats in the db
91
101
102 Check password for each user
103
114
115 Check password for each user
116
128
129 Check (wrong) password for user
130

webroot/config_sqlite.php 4

Type Line Description
4 Its best to add an absolute path to the dsn
7 Display details on what happens
10 Throw a more verbose exception when failing to connect
11 'debug_connect' => 'true',