douzi1986 2018-11-19 10:54
浏览 85
已采纳

如何将数据库中的ip地址值拆分为CodeIgniter中的数组格式

I'm working on the CodeIgniter application where I want to split IP address into the array format. Actually, I'm getting values from the database column but unable to create the array from the dynamic values which are getting from the database?

Controller Code

Getting Values from the database 

$system = $this->Xin_model->read_enter_allow_ip_address_info(1);
$allowlist =  array($system[0]->enter_allow_ip_address);
$finalipallow = nl2br($allowlist);

if(!in_array($_SERVER['REMOTE_ADDR'],$finalipallow)){
$Return['error'] = 'Login Failed';  
$this->output($Return); 
}

Models Query

public function read_enter_allow_ip_address_info($id) {

    $condition = "setting_id =" . "'" . $id . "'";
    $this->db->select('enter_allow_ip_address');
    $this->db->from('xin_system_setting');
    $this->db->where($condition);
    $this->db->limit(1);
    $query = $this->db->get();      
    return $query->result();
}

Dynamic Values From The Database Column

'10.0.0.1','10.0.0.2','10.0.0.3','::1'

how do I split IP address values from database into the array format like this static array

$finalipallow = array(
        '10.0.0.1',
        '10.0.0.2',
        '10.0.0.3',
        '::1'
);

I have a static array which is working with if condition but I want to convert dynamic values into the array like the static array?

Working now here the solution of it

$system = $this->Xin_model->read_enter_allow_ip_address_info(1);
$allowlist =  $system[0]->enter_allow_ip_address;

$finalipallow = str_getcsv($allowlist, ",", "'");

if(!in_array($_SERVER['REMOTE_ADDR'],$finalipallow)){
   $Return['error'] = 'Login Failed';   
   $this->output($Return);  
}
  • 写回答

2条回答 默认 最新

  • duangouhui0446 2018-11-19 10:58
    关注

    You can use str_getcsv() to process it as a CSV record...

    $data = "'10.0.0.1','10.0.0.2','10.0.0.3','::1'";
    $finalipallow = str_getcsv($data, ",", "'");
    
    print_r($finalipallow);
    

    which outputs...

    Array
    (
        [0] => 10.0.0.1
        [1] => 10.0.0.2
        [2] => 10.0.0.3
        [3] => ::1
    )
    

    Just change $data to the value from the database. Using the deimter and the optional enclosed parameters allows it to strip off the extra quotes from the data.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 关于#r语言#rda分析作图的问题,请各位专家解答!
  • ¥50 找回 股票行情系统的资源问题
  • ¥15 gwas 分析-plink 检查人口分层出现下面问题
  • ¥15 关于#matlab#的问题:需要 MATLAB 运行程序,对比四个多址通信方式(TDMA,FDMA,CDMA,OFDMA)的抗噪声性能
  • ¥15 有没有复现过PFENet的,如何解决?
  • ¥15 vue3使用swiper轮播图循环失败
  • ¥15 FDMA,OFDMA,TDMA 和 CDMA 系统容量对比仿真
  • ¥15 图神经网络的入侵检测
  • ¥15 工业数据采集技术+存储架构推荐
  • ¥15 GPT-SOVITS如何训练少数民族语言支持合成语音