if ($func == 'copy') {
$q = new myQuery("INSERT INTO img (user_id, dt, name) VALUES ('{$_SESSION['user_id']}', NOW(), '{$newname}')");
} else {
if ($func == 'rename') {
$q = new myQuery("UPDATE img SET name='{$newname}' WHERE name='{$oldname}' AND user_id='{$_SESSION['user_id']}'");
}
}
} else {
if ($is_dir) {
$olddir = str_replace(IMAGEBASEDIR, '', $source);
$newdir = str_replace(IMAGEBASEDIR, '', $destination);
if ($func == 'copy') {
$q = new myQuery("INSERT INTO img (user_id, dt, name) SELECT '{$_SESSION['user_id']}', NOW(), REPLACE(name, '{$olddir}', '{$newdir}/') FROM img WHERE user_id='{$_SESSION['user_id']}' AND name REGEXP '^{$olddir}[^/]+\$'");
} else {
if ($func == 'rename') {
$q = new myQuery("UPDATE img SET name = REPLACE(name, '{$olddir}', '{$newdir}/') WHERE user_id='{$_SESSION['user_id']}' AND name REGEXP '^{$olddir}[^/]+\$'");
}
}
$return['query'] = $q->get_query();
}
}
}
}
}
}
}
$return['errorText'] .= '</ol>';
}
}
scriptReturn($return);
exit;
<?php
echo "<h3>Last PHP Error</h3>";
htmlArray(debug_backtrace());
htmlArray(error_get_last());
// session Variables
$_SESSION['debug'] = true;
echo "<h3>\$_SESSION Variables</h3>\n";
htmlArray($_SESSION);
$php_time = date('Y-m-d H:i:s');
$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());
