dqlb38410 2015-03-27 06:57
浏览 23

检查MySQL是否有效,然后返回。 如果没有,生成令牌

I have this table:

CREATE TABLE wp_tokens (
   ID int(12) NOT NULL AUTO_INCREMENT,
   USER varchar(128) NOT NULL COMMENT 'User name',
   TS timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   IP varchar(64) NOT NULL,
   TOKEN varchar(128) NOT NULL COMMENT 'Hashed tokens',
   VALID (12),
   PRIMARY KEY (`ID`) 
)

And I want to check if a token exists for a user. If it exists, then it should return the token. If not, it should generate one.

Here is my PHP:

<?php
  global $wpdb;
  global $user_login;
  $token = uniqid();
  $hashedtoken = md5($token);
  $user = $user_login;
  $ip = $_SERVER['REMOTE_ADDR'];
  $valid = "1";
  $chkdb = mysql_query("SELECT valid FROM wp_tokens WHERE user=$user");

if(mysql_num_rows($chkdb) == 1)
{
    echo $hashedtoken;
}
else
    {
     $wpdb->insert('wp_tokens', 
     array('user' => $user, 'token' => $hashedtoken, 'ip' => $ip, 'valid' => $valid),
     array('%s','%s','%s'));    
    }
?>

It doesn't work and I cannot solve. It's being executed on Wordpress $wpdb should be working. Please help!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?