所以我将一些XML存储在一个表中,并使用MySQL的"COMPRESS"函数,如下所示:
$query = "SELECT UNCOMPRESS(table_row) FROM database WHERE this = 'that'";
$mysqli = $this->ConnectDB();
$result = $mysqli->query($query);
$task_result = $task->fetch_assoc();
这当然有效,但它将返回的关联数组中的键从'table_row'
重命名为'UNCOMPRESS(table_row)'
。
有没有办法阻止这种重命名?
$query = "SELECT UNCOMPRESS(table_row) AS table_row
FROM database WHERE this = 'that'";