dette burde ligge tættere på sandheden, der var nogle fejl med "
(utested)
<?php
function hent_id($mysqli, $tabel_navn, $aar = "", $bruger = "") {
$sql = "SELECT id FROM " . $tabel_navn . " WHERE 1=1";
if ($aar != "") {
$sql .= " && aar = '" . $aar ."'";
}
if ($bruger != "") {
$sql .= " && bruger = '" . $bruger. "'";
}
if (!($stmt = $mysqli->prepare($sql))) {
echo "<br>Prepare failed i HENT_ID SQL_SKAT:<br>:(" . $mysqli->errno . ")" . $mysqli->error;
return 0;
}
if (!$stmt->execute()) {
echo "<br>execute failed i HENT_ID SQL_SKAT:(" . $mysqli->errno . ")" . $mysqli->error;
}
if (!($res = $stmt->get_result())) {
echo "<br>Getting result set failed i HENT_ID SQL_SKAT:(" . $mysqli->errno . ")" . $mysqli->error;
}
while ($row = mysqli_fetch_array($res)) {
$data['id'] = $row['id'];
}
return $data;
}
// hent_id($conn,"tbl_test", 2016, "ronols");
/*
$tabel_id = hent_id($mysqli,$tabel_navn);
$tabel_id = hent_id($mysqli,$tabel_navn,$aar);
$tabel_id = hent_id($mysqli,$tabel_navn,$aar,$bruger);
*/
?>
med Prepare Statement
(utested)
<?php
function hent_id($mysqli, $tabel_navn, $aar = "", $bruger = "") {
$sql = 'SELECT id FROM ? WHERE 1=1';
$type="s";
$value="".$tabel_navn;
if ($aar != "") {
$sql .= ' && aar = ? ';
$type .= "i";
$value .= ", ".$aar;
}
if ($bruger != "") {
$sql .= ' && bruger = ?';
$type .= "s";
$value .= ", ".$bruger;
}
if (!($stmt = $mysqli->prepare($sql))) {
echo "<br>Prepare failed i HENT_ID SQL_SKAT:<br>:(" . $mysqli->errno . ")" . $mysqli->error;
return 0;
}
// Bind parametre
// $stmt->bind_param('s', $tabel_navn);
// $stmt->bind_param("'".$type."'", $value);
$stmt->bind_param($type, $value);
if (!$stmt->execute()) {
echo "<br>execute failed i HENT_ID SQL_SKAT:(" . $mysqli->errno . ")" . $mysqli->error;
}
if (!($res = $stmt->get_result())) {
echo "<br>Getting result set failed i HENT_ID SQL_SKAT:(" . $mysqli->errno . ")" . $mysqli->error;
}
while ($row = $res->fetch_array(MYSQLI_ASSOC)) {
$data['id'] = $row['id'];
}
return $data;
}
// $tabel_id = hent_id($conn,"tbl_test", "2016", "ronols");
/*
$tabel_id = hent_id($mysqli,$tabel_navn);
$tabel_id = hent_id($mysqli,$tabel_navn,$aar);
$tabel_id = hent_id($mysqli,$tabel_navn,$aar,$bruger);
*/
?>
ron
olds -> jeg føler mig ikke gammel :)
ronols uden d