$result[$filename] = $filename; } } } } ksort($result); return $result; } if ($_GET['project'] > 0) { // get one authorised project $q = new myQuery("SELECT project_id FROM project_user WHERE project_id='{$_GET['project']}' AND user_id='{$user}'"); $projects = $q->get_col("project_id"); } else { // get all authorised projects $q = new myQuery("SELECT project_id FROM project_user WHERE user_id='{$user}'"); $projects = $q->get_col("project_id"); } $dircontents = array(); foreach ($projects as $project_id) { $dir = IMAGEBASEDIR . $project_id; if (!is_dir($dir)) { $return['error'] = true; $return['errorText'] = 'Your user directory does not exist.'; } else { $dircontents = array_merge($dircontents, imageFiles($dir)); } } $proj_list = implode(",", $projects); $q = new myQuery("SELECT id, CONCAT(project_id, name) as path FROM img WHERE project_id IN ({$proj_list})"); $imglist = $q->get_assoc(false, 'id', 'path'); // delete missing images from the DB
<?php // get or set a user's read messages require_once $_SERVER['DOCUMENT_ROOT'] . '/include/main_func.php'; auth(); $return = array('error' => false, 'errorText' => '', 'read_msg_ids' => array()); $user = $_SESSION['user_id']; if (empty($user)) { $return['error'] = true; $return['errorText'] = "No user is logged in"; } else { if (array_key_exists('msg_id', $_POST)) { // mark a message as read $msg_id = my_clean($_POST['msg_id']); $q = new myQuery("INSERT INTO msg (id, user_id, dt) VALUES ('{$msg_id}', '{$user}', NOW())"); } // get all read messages for this user $q = new myQuery("SELECT id FROM msg WHERE user_id='{$user}'"); $return['read_msg_ids'] = $q->get_col('id'); } scriptReturn($return); exit; /* CREATE TABLE msg ( id VARCHAR(32), user_id INT(8) UNSIGNED, dt DATETIME, INDEX (user_id) ); */
$q = new myQuery('SELECT NOW()'); $mysql_time = $q->get_one(); echo "<h3>Time Comparison</h3>\n<ul>\n\t<li>MySQL time: {$mysql_time}</li>\n\t<li>PHP time: {$php_time}</li>\n</ul>"; echo "<h3>MySQLi Test</h3>"; $q = new myQuery("SELECT id, firstname FROM user LIMIT 3"); echo '<table><thead><tr><th></th><th>Answer</th><th>True Value</th></thead></tr><tbody>'; echo '<tr><td>Query</td><td>' . $q->get_query() . '</td><td>SELECT id, firstname FROM user LIMIT 3</td></tr>'; echo '<tr><td>N Rows</td><td>' . $q->get_num_rows() . '</td><td>3</td></tr>'; echo '<tr><td>get_row()</td><td>'; print_r($q->get_row()); echo '</td><td>Array ( [id] => 1 [firstname] => Lisa )</td></tr>'; echo '<tr><td>get_row(2)</td><td>'; print_r($q->get_row(2)); echo '</td><td>Array ( [id] => 3 [firstname] => Amanda )</td></tr>'; echo '<tr><td>get_col("id")</td><td>'; print_r($q->get_col('id')); echo '</td><td>Array ( [0] => 1 [1] => 2 [2] => 3 )</td></tr>'; echo '<tr><td>get_one()</td><td>' . $q->get_one() . '</td><td>1</td></tr>'; echo '<tr><td>get_one(2, "firstname")</td><td>' . $q->get_one(2, 'firstname') . '</td><td>Amanda</td></tr>'; echo '<tr><td>get_one(2, "error")</td><td>' . $q->get_one(2, 'error') . '</td><td>Column <code>error</code> does not exist in row <code>2</code></td></tr>'; echo '<tr><td>get_assoc()</td><td>'; print_r($q->get_assoc()); echo '</td><td>Array ( [0] => Array ( [id] => 1 [firstname] => Lisa ) [1] => Array ( [id] => 2 [firstname] => Ben ) [2] => Array ( [id] => 3 [firstname] => Amanda ) )</td></tr>'; echo '<tr><td>get_result_as_table()</td><td>' . $q->get_result_as_table() . '</td><td> <table class="query"> <thead><tr> <th>id</th><th>firstname</th></tr></thead><tbody> <tr><td>1</td> <td>Lisa</td></tr> <tr><td>2</td><td>Ben</td></tr> <tr><td>3</td><td>Amanda</td></tr> </tbody></table></td></tr>'; echo '<tr><td>prepare()</td><td>';