How to add SQL where and limit query in PHP?

Question

I want to show table order where status = 'confirmed', but my code doesn't work:

public function getdataorderconfirmed($limit, $offset){
    if($offset == '') {
        $sql = $this->db->query**("SELECT * FROM orderan where status = 'confirmed' LIMIT '.$limit.' 
            OFFSET 0 ");**
    return $sql->result();
    }
    else{
        **$sql = $this->db->query("SELECT * FROM orderan where status = 'confirmed' LIMIT '.$limit.' 
        OFFSET '.$offset.'");**
    return $sql->result();
    }
}

Because you're mixing single and double quotes.

u_mulder
– u_mulder

2018-05-17 06:19:12 +00:00
Commented May 17, 2018 at 6:19 — u_mulder
– u_mulder, Commented May 17, 2018 at 6:19

Racil Hilan · Accepted Answer · 2018-05-17 06:21:11Z

2

The LIMIT and OFFSET don't need their values quoted because they're numbers, so remove the single quotes around them here:

$sql = $this->db->query("SELECT * FROM orderan where status = 'confirmed'
                         LIMIT $limit OFFSET 0");

And here:

$sql = $this->db->query("SELECT * FROM orderan where status = 'confirmed'
                         LIMIT $limit OFFSET $offset");

answered May 17, 2018 at 6:21

Racil Hilan

25.4k13 gold badges56 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kawaljeet Singh · Accepted Answer · 2018-05-17 06:23:17Z

1

Change the query as following, you can use PHP variables as it is if in double quotes, there is no need to concat:

public function getdataorderconfirmed($limit, $offset){
            if($offset == '') {
                $sql = $this->db->query**("SELECT * FROM orderan where status = 'confirmed' LIMIT $limit OFFSET 0");**
            return $sql->result();
            }
            else{
                **$sql = $this->db->query("SELECT * FROM orderan where status = 'confirmed' LIMIT $limit OFFSET $offset");**
            return $sql->result();
            }
        }

answered May 17, 2018 at 6:23

Kawaljeet Singh

3571 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to add SQL where and limit query in PHP?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related