Codeigniter PHP:我如何在Codeigniter中使用爆炸来找到2个整数之间 - Codeigniter PHP: How do I use explode in codeigniter to find between 2 integers

Codeigniter PHP: How do I use explode in codeigniter to find between 2 integers

本文关键字：Codeigniter 之间整数 2个 PHP | 更新日期: 2023-09-27

我有一个选择框，选择"非常低"，"低"，"中"，"高"answers"非常高"，可以在0-19,20-39等之间选择，直到100。

模型:

if  ($this->input->post('interest_rating') != "")  
{
    $range = explode($this->input->post(' ','interest_rating'));
    $this->db->where('webinar_event.interest_rating >= ', $range[0]);
    $this->db->where('webinar_event.interest_rating <= ', $range[1]);
}

我得到两个独立的错误
1)

A PHP Error was encountered
Severity: Warning
Message: Wrong parameter count for explode()
Filename: models/hp_model.php
Line Number: 128
A Database Error Occurred
Error Number: 1064

你的SQL语法有错误;检查与你的MySQL服务器版本对应的手册，以便在'AND webinar_event . interest_rating <=' at line 5附近使用正确的语法

SELECT * FROM (`health_professional`) JOIN `webinar_event` ON `webinar_event`.`hpid` = `health_professional`.`hpid` WHERE `webinar_event`.`interest_rating` >= AND `webinar_event`.`interest_rating` <=

文件名:D: '开发' PfizerWebinar ' web数据库' system ' ' DB_driver.php

行号:330

任何帮助将非常感激，谢谢

错误编号1

explode()函数必须给出2个参数第一个必须是删除量，第二个必须是字符串如explode(delemeter,string)

所以你的爆炸一定是$range = explode(' ', $this->input->post('interest_rating'));错误号2

SELECT * FROM (`health_professional`) JOIN `webinar_event` ON `webinar_event`.`hpid` = `health_professional`.`hpid` WHERE `webinar_event`.`interest_rating` >= 'somevalue' AND `webinar_event`.`interest_rating` <= 'somevalue'

查询条件中没有关联的值