public function getFields()
{
$table = MijosqlHelper::getVar('tbl');
if (MijosqlHelper::is30()) {
$fields = $this->_db->getTableColumns($table);
} else {
$fields = $this->_db->getTableFields(array($table));
}
return $fields;
}
public function delete($table)
{
$sql = MijosqlHelper::getVar('qry');
$key = JRequest::getString('key', null, 'get');
if (!is_null($sql) && !is_null($key)) {
$id = JRequest::getCmd('id', null, 'get');
$this->_db->setQuery("DELETE FROM {$table} WHERE {$key} = '{$id}'");
$this->_db->query();
if (!empty($this->_db->_errorMsg)) {
echo '<small style="color:red;">' . $this->_db->_errorMsg . '</small><br/>';
return false;
} else {
return true;
}
}
}
public function display($tpl = null)
{
$db = JFactory::getDbo();
$task = JRequest::getCmd('task');
$table = MijosqlHelper::getVar('tbl');
$query = MijosqlHelper::getVar('qry');
$id = JRequest::getInt('id', JRequest::getInt('id', null, 'post'), 'get');
$key = JRequest::getCmd('key', JRequest::getCmd('key', null, 'post'), 'get');
$document =& JFactory::getDocument();
$document->addStyleSheet('components/com_mijosql/assets/css/mijosql.css');
// Toolbar
JToolBarHelper::title(JText::_('MijoSQL') . ': <small><small> ' . $table . ' [ ' . $key . ' = ' . $id . ' ]' . ' </small></small>', 'mijosql');
JToolBarHelper::apply();
JToolBarHelper::save();
JToolBarHelper::divider();
JToolBarHelper::cancel();
if ($task == 'edit') {
$fld_value = '$value = $this->rows[$this->id][$field];';
} else {
$fld_value = '$value = "";';
}
list($rows, $last_key_vol) = $this->get('Data');
$this->task = $task;
$this->id = $id;
$this->key = $key;
$this->table = $table;
$this->query = $query;
$this->fld_value = $fld_value;
$this->last_key_vol = $last_key_vol;
$this->rows = $rows;
$fields = $this->get('Fields');
if (!MijosqlHelper::is30()) {
$fields = $fields[$this->table];
}
$this->fields = $fields;
parent::display($tpl);
}
?>
</select>
<?php
echo JText::_('COM_MIJOSQL_RECORDS') . ': ';
?>
<input class="text_area" type="text" size="3" id="ja_lim_p" name="ja_lim_p" value="<?php
echo JRequest::getInt('ja_lim_p', 10, 'post');
?>
" style="width:30px;" onchange="changeQuery(this);">
</td>
</tr>
<tr>
<td>
<textarea class="text_area" id="ja_qry_p" name="ja_qry_p" style="width:100%;height:70px;"><?php
echo MijosqlHelper::getVar('qry');
?>
</textarea>
</td>
</tr>
</table>
<?php
echo $this->data;
?>
<input type="hidden" name="option" value="com_mijosql" />
<input type="hidden" name="controller" value="mijosql" />
<input type="hidden" name="task" value="">
<?php
echo JHTML::_('form.token');
