doukongpao0903 2014-04-03 09:20
浏览 42
已采纳

PHP插入条件

I need to have some if conditions for some special characters. So what I basically want is to add some kind of 'if letter is oe make letter = "ø"' statement. How can I achieve this?

public function letter_get($letter)
    {
        $this->load->database();

        if($letter == '0-9')
        {
            $where = "formated_name LIKE '0%' OR formated_name LIKE '1%' OR formated_name LIKE '2%' 
            OR formated_name LIKE '3%' OR formated_name LIKE '4%' OR formated_name LIKE '5%' OR formated_name LIKE '6%' OR formated_name LIKE '7%' OR formated_name LIKE '8%' OR formated_name LIKE '9%' OR formated_name LIKE '#%'";
        }
        else  
        {
            $where = "formated_name LIKE '".$letter."%'";
        }

        $sql = "SELECT artist_id, formated_name FROM artists WHERE ".$where;
        $query = $this->db->query($sql);
        $data = $query->result();

        if($data) {
            $this->response($data, 200); 
        } else {
            $this->response(array('error' => 'Couldn\'t find any artists with this letter!'), 404);
        }
    }

So can anyone help me out? That would be great! Thanks in advance...

  • 写回答

1条回答 默认 最新

  • doushouxie7064 2014-04-03 09:42
    关注

    You can replace the special characters with str_replace:

    $letter = str_replace(array('oe', ... more inputs),
                          array('ø', ... more replacements),
                          $letter);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 CSAPPattacklab
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图
  • ¥15 关于大棚监测的pcb板设计
  • ¥15 stm32开发clion时遇到的编译问题
  • ¥15 lna设计 源简并电感型共源放大器
  • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
  • ¥15 Vue3地图和异步函数使用
  • ¥15 C++ yoloV5改写遇到的问题