emlog pro gid自增断号自动插入
emlog pro文章连接使用gid自增号作为文章的ID
由于后台有删除文章的功能,一旦删除文章,那么gid自增就会出现断号
其实断号问题解决很简单,只要在添加文章的时候判断gid之前的有没有断号问题,有的话直接插入,没有的话自增
打开文件:include/model/log_model.php,找到addlog
public function addlog($logData) {
$kItem = $dItem = [];
foreach ($logData as $key => $data) {
$kItem[] = $key;
$dItem[] = $data;
}
$field = implode(',', $kItem);
$values = "'" . implode("','", $dItem) . "'";
$this->db->query("INSERT INTO $this->table ($field) VALUES ($values)");
return $this->db->insert_id();
}
修改成
[lv]
public function addlog($logData) {
$kItem = $dItem = [];
foreach ($logData as $key => $data) {
$kItem[] = $key;
$dItem[] = $data;
}
$field = implode(',', $kItem);
$values = "'" . implode("','", $dItem) . "'";
$i = 0;
$res = $this->db->query("SELECT gid From $this->table ORDER BY gid ASC");
while ($row = $this->db->fetch_array($res)) {
$i++;
if ($i != $row['gid']) {
$field = 'gid,' . $field;
$values = "'" . $i . "'," . $values;
break;
}
}
$this->db->query("INSERT INTO $this->table ($field) VALUES ($values)");
return $this->db->insert_id();
}
[/lv]
