$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>';
