What did i missed in code? PHP calculating

Question

I want to send data to database, but if result = 1 status=plusone, result = 2 status=plustwo, etc.. It should work like that.. But no, it work like this: result = 2 status=plusone .

What did i missed? Help me..

I've tried this:

$item = '0';

$result = $item + $points;

and:

$result = $points + 0;

Here is rest (part of) code:

if($result = 1){

 $Sql_Query  ="INSERT INTO points SET unique_id = '$id', description = '$Description', points = '$points', status= 'plusone'";
 if(mysqli_query($con,$Sql_Query)) {
 echo 'Succcess!';

 }
}elseif($result = 2){

 $Sql_Query  ="INSERT INTO points SET unique_id = '$id', description = ' $Description', points = '$points', status= 'plustwo'";
  if(mysqli_query($con,$Sql_Query)) {

  echo 'Succcess!';

 }
}

use `==` for comparison in `if($result = 1)` and `elseif($result = 2)`, `=` is an assignment operator — lovelace, Jul 04 '18 at 20:14
Try adding an alert script in php to alret the value of result before executing the query — Tudor, Jul 04 '18 at 20:15
Possible duplicate of [The 3 different equals](https://stackoverflow.com/questions/2063480/the-3-different-equals) — Qirel, Jul 04 '18 at 20:16
@Master: Also take care of possible SQL injections. Just saying. — Daniel Bürckner, Jul 05 '18 at 04:40

score 2 · Accepted Answer · edited Jul 05 '18 at 04:34

2

= and == are different; = is for assignment, and == is to compare statement

edited Jul 05 '18 at 04:34

Isaac

10,467
12
39
97

answered Jul 05 '18 at 00:32

Dimas Adi Suyikno

36
3

What did i missed in code? PHP calculating

1 Answers1