Slet id med mysqli
HejJeg prøver at slette et id med mysqli men der sker ikke noget.
Her er min kode.
<?php
require_once("mysqli_toolbox.php"); // GetSQLValueString
$mysqli = mysqli_connect("localhost","root","","mysqli");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// mysqli_select_db($mysqli, $database_mysqli ); // gøres i mysqli_connect
if ((isset($_POST['id'])) && ($_POST['id'] != "")) {
$deleteSQL = sprintf("DELETE FROM test WHERE id=%s",
GetSQLValueString($_POST['id'], "int"));
mysqli_select_db($mysqli, $database_mysqli);
$Result1 = mysqli_query($mysqli, $deleteSQL) or die(mysql_error());
$deleteGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
$query_rsOplysninger = "SELECT * FROM test";
$rsOplysninger = mysqli_query($mysqli, $query_rsOplysninger) or die(mysql_error());
$row_rsOplysninger = mysqli_fetch_assoc($rsOplysninger);
$totalRows_rsOplysninger = mysqli_num_rows($rsOplysninger);
?>