WordPress database error: [Table './www@002ehuoyue@002eorg/huoyue_useronline' is marked as crashed and should be repaired]
DELETE FROM huoyue_useronline WHERE user_ip = '54.87.61.215' OR timestamp < DATE_SUB('2019-05-19 18:19:29', INTERVAL 300 SECOND)

WordPress database error: [Table './www@002ehuoyue@002eorg/huoyue_useronline' is marked as crashed and should be repaired]
REPLACE INTO `huoyue_useronline` (`timestamp`,`user_type`,`user_id`,`user_name`,`user_ip`,`user_agent`,`page_title`,`page_url`,`referral`) VALUES ('2019-05-19 18:19:29','guest','0','Guest','54.87.61.215','CCBot/2.0 (https://commoncrawl.org/faq/)','火跃工作室 &raquo; discuz 数据库-火跃工作室','/tag/discuz-%E6%95%B0%E6%8D%AE%E5%BA%93','')

WordPress database error: [Table './www@002ehuoyue@002eorg/huoyue_useronline' is marked as crashed and should be repaired]
SELECT COUNT( * ) FROM huoyue_useronline

专注于discuz,uchome,dedecms等各类PHP程序仿站(二次开发和模板制作)。

标签类目:discuz 数据库

2012-09-28 10:30
discuz,PHP+mysql
没有评论3,494 阅读

discuz数据库操作常用代码

标签:

  • 查询某一个字段的或者数量时:

$classs = DB::result_first(“SELECT count(*) FROM “.DB::table(‘brand_category’));
$classs就是表中的数据条数!

  • 当不知道数据库是是否存在数据时增加或更新数据:
  • [......]

Read more