StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<ol> <li>First approach I would try: <ul> <li>run the query</li> <li>check if there were results returned</li> <li>if yes, run Your <code>initialize()</code> and <code>displayHtmlTable</code></li> <li>if <strong>no</strong>, run Your <code>initializeEmptyResult()</code> that will run the next query and just fills <code>$this->columnNames[]</code>:</li> </ul></li> </ol> <pre class="lang-sql prettyprint-override"><code>SELECT column_name FROM information_schema.columns WHERE table_name = 'my_table_name' </code></pre> <p>The query is dependent on MySQL bu there should be more alternatives for other databases, or still You can run <code>DESCRIBE table</code> and parse columns names from the result (should be SQL DBMS undependent).</p> <ol> <li><p>Second that is I think easier to accomplish: if there are no results returned from the query, do not display a coulmn names nor table at all, just display a message: 'No results found.'. This could be achieved within Your <code>displayHtmlTable</code> method:</p> <pre><code> public function displayHtmlTable() { $r = ''; $r .= '<div class="sqlCommand">' . $this -> sql . '</div>'; if(count($this->records) > 0) { $r .= '<table>'; $r .= '<thead>'; $r .= '<tr>'; foreach ($this->columnNames as $columnName) { $r .= '<td>' . $columnName . '</td>'; } $r .= '</tr>'; $r .= '</thead>'; $r .= '<tbody>'; foreach ($this->records as $record) { $r .= '<tr>'; foreach ($record as $data) { $r .= '<td>' . $data . '</td>'; } $r .= '</tr>'; } $r .= '</tbody>'; $r .= '<table>'; } else { $r .= '<div class="no-results">No results found for query.</div>'; } return $r; } </code></pre></li> </ol> <p>And You do not have to bother with column names...</p> <p><strong>EDIT:</strong> For the first case found a query for SQLite that should do the same as <code>select * from information_schema.columns where table_name = 'xxx'</code>:</p> <pre><code>PRAGMA table_info(table-name); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload