1
Now we dont have any function/class in xoops to do alter/change/show functionality on database.
i suggest to add some of them ASAP in xoops 26 like this:
public function changeField($field = null, $structure = null)
{
$sql = "ALTER TABLE {$this->table} CHANGE {$field} {$field} {$structure}";
if (!$result = $this->db->queryF($sql)) {
xoops_error($this->db->error().'<br />'.$sql);
return false;
}
return true;
}
public function showFields($field = null)
{
$sql = "SHOW FIELDS FROM {$this->table}";
if (isset($field)) {
$sql .= " LIKE '{$field}'";
}
if (!$result = $this->db->queryF($sql)) {
xoops_error($this->db->error().'<br />'.$sql);
return false;
}
$ret = array();
while ($myrow = $this->db->fetchArray($result)) {
$ret[$myrow["Field"]] = $myrow;
}
return $ret;
}
do you think it needs more functionality eg: WHERE
please discuss then we can add it to sf.net feature request.
