Kód: Vybrať všetko

$mysqli = new mysqli ("localhost","root","","test1");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}



$id=7;

$vys =  vyber($id);

echo $vys;


$mysqli->close();



function vyber($user){

global $mysqli;

$a = $user;

if(!($stmt=$mysqli->prepare("SELECT p FROM user WHERE id=? "))){
 echo "Chyba!";
}


$stmt->bind_param("i",$a);

$stmt->execute();

$hrac = $stmt->bind_result($p);



return $hrac;

}

Kód: Vybrať všetko

 $stmt->bind_result($p); 
    $hrac= $stmt -> $fetch();] 

Kód: Vybrať všetko

$hrac= $stmt->$fetch();

Kód: Vybrať všetko

function vyber($user){

     global $mysqli;

     if(!($stmt=$mysqli->prepare("SELECT p FROM user WHERE id=? "))){
          echo "Chyba!";
     }

     $stmt->bind_param("i",$user);
     $stmt->execute();
     $stmt->bind_result($p);
     $stmt->fetch();
     
     return $p;
}