Prepared Statements, if sætning virker ikke

if ($admindata = $mysqli->prepare("SELECT id, user FROM veight_admin WHERE sim = ?") ){
    $admindata->bind_param('s', $sim);
    $sim = $_GET['id'];
    $admindata->execute();
    $admindata->bind_result($adminid, $adminuser);
    
    
    while ($admindata->fetch() ) {
        echo "id = " . $adminid . " user = " . $adminuser . '<br>';
    }    
    
    $admindata->close();
    
}
else{
    /* Der er opstået en fejl */
    echo 'Der opstod en fejl i erklæringen: ' . $mysqli->error;
}

$stmt = $mysqli->prepare("INSERT INTO testtable VALUES (?,?,?)");
// prepare() can fail because of syntax errors, missing privileges, ....
if ( false===$stmt ) {
  // and since all the following operations need a valid/ready statement object
  // it doesn't make sense to go on
  // you might want to use a more sophisticated mechanism than die()
  // but's it's only an example
  die('prepare() failed: ' . htmlspecialchars($mysqli->error));
}

$rc = $stmt->bind_param('iii', $x, $y, $z);
// bind_param() can fail because the number of parameter doesn't match the placeholders in the statement
// or there's a type conflict(?), or ....
if ( false===$rc ) {
  // again execute() is useless if you can't bind the parameters. Bail out somehow.
  die('bind_param() failed: ' . htmlspecialchars($stmt->error));
}

$rc = $stmt->execute();
// execute() can fail for various reasons. And may it be as stupid as someone tripping over the network cable
// 2006 "server gone away" is always an option
if ( false===$rc ) {
  die('execute() failed: ' . htmlspecialchars($stmt->error));
}

$stmt->close();

if ($numberofrows_sim > 0) {
    if ($updatedata = $mysqli->prepare('UPDATE veight_admin SET imei=? WHERE id=?')) {

 
if ($numberofrows > 0) {
    if ($updatedata = $mysqli->prepare('UPDATE veight_admin SET imei=? WHERE id=?')) {

<?php
// det er ikke alvorligt hvis filen mangler, tilgengæld må den KUN indlæsses 1 gang pga define('IN_DEBUG_MODE', true);
include_once("debugheader.php");
// conection SKAL indlæsses
require_once('connection.php');


// test om simnummer findes i databasen
if ($admindata = $mysqli->prepare("SELECT id, user, count(id) AS num_of_rows  FROM veight_admin WHERE sim = ?")) {
    $admindata->bind_param('s', $sim);
    $sim = $_GET['id'];    
    $admindata->execute();
    $admindata->bind_result($adminid, $adminuser, $numberofrows_sim);    
    $admindata->fetch();    
    $admindata->close();    
    if ($numberofrows_sim > 0) {
        // test om imei findes i databasen
        if ($imeidata = $mysqli->prepare("SELECT id,noload, scale, count(id) AS num_of_rows FROM veight_imei WHERE imei = ?")) {
            $imeidata->bind_param('s', $imei);
            $imei = $_GET['imei'];            
            $imeidata->execute();
            $imeidata->bind_result($imeiid, $noload, $scale, $numberofrows);            
            $imeidata->fetch();             
            $imeidata->close();
            
            // if ($numberofrows_sim > 0) {
            if ($numberofrows > 0) {
                if ($updatedata = $mysqli->prepare('UPDATE veight_admin SET imei=? WHERE id=?')) {
                    $updatedata->bind_param('ss', $imei, $id);
                    $imei = $imeiid;
                    $id = $adminid;
                    $updatedata->execute();
                    $updatedata->close();
                } else {
                    // manglende connection, forkerte kollonne navne, tabel navn
                    echo '1.2 Noget gik galt...' . $mysqli->error;
                }
            } else {                
                echo "numberofrows er 0";
            }
        } else {
            // manglende connection, forkerte kollonne navne, tabel navn
            echo '1.1 Noget gik galt...' . $mysqli->error;
        }
    } else {        
        echo "sim værdien findes ikke, numberofrows_sim er 0";
    }
} else {
    // manglende connection, forkerte kollonne navne, tabel navn
    echo '1 Noget gik galt...' . $mysqli->error;
}
?>