Execute() statement in the if else doesnt work , PHP Mysql

Asked Jul 13 '17 at 09:17

Active Jul 13 '17 at 14:25

Viewed 19 times

i want to check if item named 'BUC test' is already in the database or not, but suddenly my $stmt->execute(); is not working

$cek_name=mysql_num_rows(mysql_query("SELECT name FROM equipment WHERE id='$_GET[bie]' and name='BUC test'"));
    if ($cek_name > 0)
    {
      $duplicate = "Equipment Name is already in use.";
    }
    else
    {
      echo 'this will execute';
      $stmt1->bind_param('ssssss',$id,$type, $name, $qty, $usd, $idr);
      $stmt1->execute();
    }
$type = 'BUC';
  $name = 'BUC test';
  $qty = '1';
  $usd = '0';
  $idr = '0';
  $id= $_GET['bie'];

if i put the $stmt->execute(); outside if else its work, does anyone have a clue? fyi : echo 'this will execute'; is displayed.

please help! thanks!

edited Jul 13 '17 at 14:25

Dileep Kumar

1,077
9
14

asked Jul 13 '17 at 09:17

Christian Anthony

You cannot use `mysql_` and `mysqli_` API's interchangably. Stick to `mysqli` – RiggsFolly Jul 13 '17 at 09:21
which one is mysqli_ API? @RiggsFolly – Christian Anthony Jul 13 '17 at 09:24
How did you connect to the database? Did you use `mysql_connect()` or `mysqli_connect()` – RiggsFolly Jul 13 '17 at 09:25
@RiggsFolly $connection = mysql_connect($host, $user_db, $pass_db); – Christian Anthony Jul 13 '17 at 09:27
Then you cannot just magically start using `$stmt1->bind_param()` which is `mysqli_` API code, anyway, you dont prepare a query to generate a valid `$stmt` anyway – RiggsFolly Jul 13 '17 at 09:28
@RiggsFolly oh , i see.. so i should change it to mysqli? query already exist and prepared, i just dont show it – Christian Anthony Jul 13 '17 at 09:33
and also if i put execute it in the outside of if esle , bind param and execute works.. – Christian Anthony Jul 13 '17 at 09:35
Then I cannot help as you do not show us enough of your code and we try not to make guesses – RiggsFolly Jul 13 '17 at 09:37
$stmt1 = $mysqli -> prepare ("INSERT INTO bom_equipment(id,type, name, qty, usd, idr) VALUES (?,?,?,?,?,?)"); @RiggsFolly – Christian Anthony Jul 13 '17 at 09:37
there is my prepare query @RiggsFolly – Christian Anthony Jul 13 '17 at 09:39

Execute() statement in the if else doesnt work , PHP Mysql

0 Answers0