dtxooq1020
2013-06-23 19:08
浏览 50
已采纳

Codeigniter - MySQL变量错误[关闭]

When I try to add a column in codeigniter, I add this column correctly but the value is not the value at the variable...

When I define:

<?php
$hwid = "123893944";
?>

The Hardware-ID in the Database: "2147483647"

I dont know why... Please help me!

Model:

<?php
class Prometheus_model extends CI_Model {

    var $tables = array(
        'bots' => 'bots',
        'users' => 'users'
    );

    function __construct() {
        parent::__construct();
    }

    public function tablename($table = NULL) {
        if(! isset($table)) return FALSE;
        return $this->tables[$table];
    }

    public function insert($table, $data) {
        $this->db->insert($this->tablename($table),$data);
        return $this->db->insert_id();
    }

    public function num_rows($table, $where = NULL) {
        if(isset($where)){
        $this->db->where($where);
        }
        $q = $this->db->get($table);
        return $q->num_rows();
    }

}

?>

Controller:

public function add_bot()
{

    $bot_data = json_decode($this->input->post('bot_data'));

    if($this->prometheus_model->num_rows('bots', array('bot_ip' => $_SERVER['REMOTE_ADDR'])) == 0){

        $to_insert = array(  
           'bot_id' => NULL,
           'bot_add_date' => time(),
           'bot_last_update' => time(), 
           'bot_os' => $bot_data->{'bot_os'},
           'bot_architecture' => $bot_data->{'bot_architecture'},
           'bot_ip' => $_SERVER['REMOTE_ADDR'],
           'bot_port' => $_SERVER['REMOTE_PORT'], 
           'bot_version' => $bot_data->{'bot_version'},
           'bot_name' => $bot_data->{'bot_name'},
           'bot_hw_id' => $bot_data->{'bot_hw_id'}
        );

        echo $to_insert['bot_hw_id']; //HERE IT IS CORRECT, BUT WRONG IN DATABASE! 
        $this->prometheus_model->insert('bots', $to_insert);  

    }
}
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • doulu4534 2013-06-24 09:01
    已采纳

    You are facing "issue" that your ID is larger than your table can store see here.

    INT -2147483648 - 2147483647

    To solve this please change your bot_hw_id structure to unsigned that gives you even more "range" (in a positive values only), since IDs arent negative so often.

    (Or change it to BIGINT)

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题