auth(); $return = array('error' => false, 'errorText' => ''); $user = $_SESSION['user_id']; $tem_id = intval($_POST['tem_id']); $q = new myQuery("SELECT name FROM tem WHERE id=" . $tem_id); $return['name'] = $q->get_one(); $q = new myQuery("SELECT n as i, name, x, y FROM point WHERE tem_id=" . $tem_id . " ORDER BY n"); $return['defaultTem'] = $q->get_assoc(); $q = new myQuery("SELECT points FROM line WHERE tem_id=" . $tem_id . " ORDER BY n"); $return['defaultLines'] = array_map(function ($a) { return explode(',', $a['points']); }, $q->get_assoc()); $q = new myQuery("SELECT n, color FROM line WHERE tem_id=" . $tem_id . " ORDER BY n"); $return['lineColors'] = $q->get_assoc(false, false, 'color'); $q = new myQuery("SELECT 3ptdelin1, 3ptdelin2, 3ptdelin3 FROM tem WHERE id=" . $tem_id); $pts = $q->get_row(); $return['fitPoints'] = array($pts['3ptdelin1'], $pts['3ptdelin2'], $pts['3ptdelin3']); scriptReturn($return); exit; /* CREATE TABLE tem ( id INT(11) NOT NULL AUTO_INCREMENT, user_id INT(4) NOT NULL, name VARCHAR(255) NOT NULL, notes TEXT, public BOOL DEFAULT 0, 3ptdelin1 INT(4), 3ptdelin2 INT(4), 3ptdelin3 INT(4), PRIMARY KEY (id) );
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()); 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">