php - Find prefix cms in mysql DB -
i want prefix db of cms.
make code, not work when if in db more cms(joomla, opencart, wordpress) or make backup. can access prefix more gracefully?
$this->connectdb(); $result = mysql_query("show tables;"); while($row = mysql_fetch_row($result)){ $allrows[] = $row[0]; } $index = preg_grep("/^.+_user$/", $allrows); $pieces = explode("_", array_pop($index)); $this->_prefix=$pieces[0]."_"
;
try follow
$this->connectdb(); $result = mysql_query("show tables;"); while($row = mysql_fetch_row($result)){ $allrows[] = $row; } $index = preg_grep("/^.+_user$/", $allrows); $pieces = explode("_", array_pop($index)); $this->_prefix=$pieces[0]."_"
Comments
Post a Comment