Codeigniter mysql where not equal to query [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed last month.

Improve this question

Mysql codeigniter query is not working properly. Suppose if mysql table looks like this:

 user_id|user_name
       1|john
       2|alex
       3|sam

Here user_name is unique

The following query should return false if user_name=john and user_id=1 and true if say user_name=john and user_id=2.

$this->db->get_where('user', array('user_name' => $name,'user_id !=' => $userid));

But it returns true in the case user_name=john and user_id=1.

Can anyone suggest me an alternative way of querying not equal to.

print($this->db->last_query()) gives:

SELECT * FROM (user) WHERE user_name = 'john' AND user_id != '1'

Any chance you have any additional users with first name john? That would return true as well. — sgeddes
– sgeddes, Commented Feb 1, 2013 at 5:03
try this and check what query is been executed print "SQL Query: ".$this->db->last_query(); — Mahavir Munot
– Mahavir Munot, Commented Feb 1, 2013 at 5:10
ok this is how it looks like SELECT * FROM (user) WHERE user_name = 'john' AND user_id != '1'. The 1 was the no of rows returned. — Avinash
– Avinash, Commented Feb 1, 2013 at 5:19
that was correct it will return true only you are checking whether user_id!= or not obviously user_id is not equal because 1 != 2 so it will return true — Venkata Krishna
– Venkata Krishna, Commented Feb 1, 2013 at 5:42
This will help you [same question][1] [1]: stackoverflow.com/questions/5226261/… — Micheal Mouner Mikhail Youssif
– Micheal Mouner Mikhail Youssif, Commented Dec 24, 2013 at 21:49

rohitarora · Accepted Answer · 2013-02-01 05:25:09Z

3

Why dont you use simple $this->db->query('your query');

answered Feb 1, 2013 at 5:25

rohitarora

1,3752 gold badges13 silver badges22 bronze badges

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

2 Comments

rohitarora Over a year ago

i would suggest you to use procedures as they are pre parsed and complied and use $this->db->query('call yourprocedure('your parms')');

mickmackusa Over a year ago

I am amazed that this is the accepted answer. It makes no attempt to resolve the specific question asked and there is absolutely no intent to educate the OP or future researchers. Very low value on Stack Overflow.

Ameen Maheen · Accepted Answer · 2020-08-25 07:22:34Z

3

Simply try this, Add the desired condition in the where function.

$this -> db -> where('invitee_phone !=', $user_phone);

edited Aug 25, 2020 at 7:22

answered Nov 4, 2015 at 4:40

Ameen Maheen

2,7571 gold badge31 silver badges30 bronze badges

1 Comment

mickmackusa Over a year ago

This entirely unexplained answer bears no resemblance to the question asked and fails to respect the actual challenge that the OP is facing. Very low quality.

Sachin · Accepted Answer · 2015-02-05 09:36:13Z

1

You can go follwoing way too. It work for me

$total = 5;
$CI = get_instance();
$CI->load->database();
$CI->db->order_by('id','asc');
$topusers = $CI->db->get_where('users',array('user_type != 1  && `status` =' => 1),$total,0);
echo $CI ->db ->last_query();
die;

and if still not work for you can go with @rohit suggest: $this->db->query('your query');

answered Feb 5, 2015 at 9:36

Sachin

486 bronze badges

1 Comment

mickmackusa Over a year ago

Is && valid sql syntax for your db driver? What is the point of using order_by? Why is there an arbitrary limit of 5 imposed? Why did you invent new/unmentioned table columns in your query? last_query() doesn't produce a result set, it displays the rendered query. This answer isn't much of an answer. Not only is it doing bad/unnecessary things, there isn't a shred of explanation.

Aravindh Gopi · Accepted Answer · 2017-03-21 12:24:17Z

1

Type 1:

Using ->where("column_name !=",$columnname) is fine for one column.

But if you want to check multi columns, you have to form an array inside where clause.

Like this

$whereArray = array(
                "employee_name" => $name,
                "employee_id !=" => $id,
        );

$this->db->select('*')->from('employee')->where($whereArray);

Type 2:

We can just write exactly what we want inside where.

Like

$thi->db->where(("employee_id =1 AND employee name != 'Gopi') OR designation_name='leader@gopis clan'");

Type 2 is good for working with combining queries, i mean paranthesis "()"

edited Mar 21, 2017 at 12:24

answered Feb 21, 2017 at 6:54

Aravindh Gopi

2,17630 silver badges36 bronze badges

2 Comments

mickmackusa Over a year ago

The OP doesn't actually need to select any data into a result set; only a count is needed. You are not fully embracing CI's query builder methods -- this makes your suggestion less portable. Assuming variables would be involved in the where values, this technique will be unstable/insecure because there will be no automatic escaping.

gumuruh Over a year ago

anyway thanks for the != mark inside the string of array, that helps me alot to customize the Where statements... @AravidhGopi

Gaurav · Accepted Answer · 2017-03-23 04:09:48Z

0

you can follow this code:

$query = $this->db->select('*')->from('employee')->where('user_name', $name)->where('user_id !=', $userid)->get();
$last_query = $this->db->last_query();
$result = $query->result_array();

if you pass $name = 'john' and $userid = '1' then it return empty array.

answered Mar 23, 2017 at 4:09

Gaurav

7135 silver badges14 bronze badges

1 Comment

mickmackusa Over a year ago

Not only do I believe the where logic is incorrect on this answer, the OP doesn't actually need to generate a result set of data from the query. Only the count is required. This is doing more than it needs to and there are more concise methods that can be used.

Collectives™ on Stack Overflow

Codeigniter mysql where not equal to query [closed]

5 Answers 5

2 Comments

1 Comment

1 Comment

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

1 Comment

2 Comments

1 Comment

Linked

Related