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());