Currently I am stuck when i click edit icon my page goes to
http://localhost/robinzonlucica/public/includes/evidencija.inc.php?edit=3
It should insert data into my form
if(isset($_GET["edit"])){
$id = $_GET["edit"];
require_once $_SERVER['DOCUMENT_ROOT'].'/robinzonlucica/public/includes/dbh.inc.php';
require_once $_SERVER['DOCUMENT_ROOT'].'/robinzonlucica/public/includes/funkcije.inc.php';
izmijeniEvidenciju($conn,$id);
}
This form should call function izmijeniEvidenciju($conn,$id);
This is function code
function izmijeniEvidenciju($conn, $id) {
$sql = "SELECT * FROM evidencija WHERE evidencijaId = ?;";
$stmt = mysqli_stmt_init($conn);
if(!mysqli_stmt_prepare($stmt, $sql)){
header("location: http://localhost/robinzonlucica/public/evidencija.php?error=stmtgreska");
exit();
}
mysqli_stmt_bind_param($stmt, "s", $id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
return $row;
mysqli_stmt_close($stmt);
}
And this is my html part form that values should be written in after clicking edit but when i click icon to edit it goes on blank page and stays like that
<?php
include_once 'header.php';
require_once 'includes/funkcije.inc.php';
require_once 'includes/dbh.inc.php';
?>
<section class="evidencija">
<?php
if(isset($_SESSION["username"])) {
$editrow = izmijeniEvidenciju($conn, $id);
echo '<h2 class ="center-align evidencijanaslov">Evidencija</h2>
<div class="row">
<form action="http://localhost/robinzonlucica/public/includes/evidencija.inc.php" class="col s12 registerforma" method="post">
<div class="row">
<div class="input-field col s6">
<input id="ime" type="text" class="validate" name="ime" value="'.$editrow['evidencijaTuristIme'].'">
<label for="last_name">Ime Turista</label>
</div>
</div>
<div class="row">
<div class="input-field col s6">
<input id="ime" type="text" class="validate" name="prezime" value="'.$editrow['evidencijaTuristPrezime'].' ">
<label for="last_name">Prezime turista</label>
</div>
</div>
<div class="row">
<div class="input-field col s6">
<input id="ime" type="text" class="validate" name="oib" value="'.$editrow['evidencijaTuristOIB'].'">
<label for="last_name">OIB Turista</label>
</div>
</div>
<div class="row">
<div class="input-field col s6">
<input type=text name="datum" id="datum" class="datepicker" value="'.$editrow['evidencijaTuristDatumOdlaska'].'">
<label for="datum">Datum odlaska</label>
</div>
</div>
<button class="btn waves-effect waves-light gumbsalji" type="submit" name="submit">Upiši</button>
</div>
</form>';
}
else {
echo '<h1>Prijavite se kako bi vidjeli evidenciju</h1>';
}
I am getting that $id variable is not declared too don't know where I went wrong PS hardcoding $id with id from table inputs values into form :/