php - CodeIgniter not fetching entire field data -
i'm using codeigniter contact old mssql 6.5 database via unixodbc , freetds. connection works fine , can run queries, problem id doesn't return entire field data.
ex. ["frame9val"]=> string(3) "13"
-> should show 135
["frame1bval"]=> string(3) "2�"
-> should show 255
any idea why happening , how fix it?
made test-php pdo , works fine.
$this->db->select('tblscore.sessionnum, tblscore.gamenum, tblscore.laneid, tblscore.playercnt, tblplayerscore.bowlername, tblframescore.frame1val, tblframescore.frame2val, tblframescore.frame3val, tblframescore.frame4val, tblframescore.frame5val, tblframescore.frame6val, tblframescore.frame7val, tblframescore.frame8val, tblframescore.frame9val, tblframescore.frame10val, tblpinfall.frame1aval, tblpinfall.frame1bval, tblpinfall.frame2aval, tblpinfall.frame2bval, tblpinfall.frame3aval, tblpinfall.frame3bval, tblpinfall.frame4aval, tblpinfall.frame4bval, tblpinfall.frame5aval, tblpinfall.frame5bval, tblpinfall.frame6aval, tblpinfall.frame6bval, tblpinfall.frame7aval, tblpinfall.frame7bval, tblpinfall.frame8aval, tblpinfall.frame8bval, tblpinfall.frame9aval, tblpinfall.frame9bval, tblpinfall.frame10aval, tblpinfall.frame10bval, tblpinfall.frame11aval'); $this->db->from('tblscore, tblplayerscore, tblpinfall, tblframescore'); $this->db->where('tblscore.sessionnum = tblplayerscore.sessionnum'); $this->db->where('tblscore.laneid = tblplayerscore.laneid'); $this->db->where('tblscore.gamenum = tblplayerscore.gamenum'); $this->db->where('tblplayerscore.sessionnum = tblframescore.sessionnum'); $this->db->where('tblplayerscore.laneid = tblframescore.laneid'); $this->db->where('tblplayerscore.gamenum = tblframescore.gamenum'); $this->db->where('tblplayerscore.bowlernum = tblframescore.bowlernum'); $this->db->where('tblplayerscore.sessionnum = tblpinfall.sessionnum'); $this->db->where('tblplayerscore.laneid = tblpinfall.laneid'); $this->db->where('tblplayerscore.gamenum = tblpinfall.gamenum'); $this->db->where('tblplayerscore.bowlernum = tblpinfall.bowlernum'); $this->db->where('tblscore.sessionnum', intval($sessionnum)); $this->db->where('tblscore.laneid', intval($laneid)); $this->db->where('tblscore.gamenum', intval($gamenum)); $query = $this->db->get(); echo '<pre>';var_dump($query->result());echo'</pre>'; return $query->result_array();
Comments
Post a Comment