Jeg får fejlen.
Hvor går det mon galt.
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
global $kurv;
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($kurv, $theValue) : mysqli_escape_string($kurv, $theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$kurv = mysqli_connect("localhost","root","","t65463_webshop");
// 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
$colname_rsVarer = "-1";
if (isset($_GET['id'])) {
$colname_rsVarer = $_GET['id'];
}
mysqli_select_db($kurv, "SELECT * FROM vare WHERE id = %s");
$query_rsVarer = sprintf("SELECT * FROM vare WHERE id = %s", GetSQLValueString($colname_rsVarer, "int"));
$rsVarer = mysqli_query($kurv, $query_rsVarer) or die(mysqli_error($kurv));
$row_rsVarer = mysqli_fetch_assoc($rsVarer);
$totalRows_rsVarer = mysqli_num_rows($rsVarer);
session_start();
function vare_Read($kurv, $id) {
$sql = "SELECT * FROM vare WHERE id = " . $id;
// $rs = $conn->query($sql);
// $ar = $rs->fetch_assoc();
$rs = mysqli_query($kurv, $sql) or die ('Unable to execute query. '. mysqli_error($kurv));
}
function vare_ReadAll($kurv) {
$sql = "SELECT * FROM vare";
//$rs = mysqli_query($conn, $sql);
$rs = $kurv->query($sql);
$ar = array();
//while ($row = mysqli_fetch_assoc($rs) ){
while ($row = $rs->fetch_assoc()) {
$ar[] = $row;
}
return $ar;
}
?>
<table style="width:100%">
<tr>
<th>navn</th>
<th>antal</th>
<th>pris</th>
</tr>
<?php
// udskrivning af kurven
$pris_total = 0;
$antal_vare = 0;
$str = "";
foreach ($_SESSION['kurv'] as $varer => $vare) {
$item = vare_Read($kurv, $vare['id']);
$varepris = $item['pris'] * $vare['antal'];
$pris_total += $varepris;
$antal_vare += $vare['antal'];
$str.= "<tr>";
$str.= "<td>" . $item['vare'] . "</td>";
$str.= "<td>" . $vare['antal'] . "</td>";
$str.= "<td>" . $varepris . "</td>";
$str.= "</tr>";
}
$str.= "<tr>";
$str.= "<td>.</td>";
$str.= "<td>.</td>";
$str.= "<td>.</td>";
$str.= "</tr>";
$str.= "<tr>";
$str.= "<td>total pris</td>";
$str.= "<td></td>";
$str.= "<td>" . $pris_total . "</td>";
$str.= "</tr>";
$str.= "<tr>";
$str.= "<td>total antal vare</td>";
$str.= "<td></td>";
$str.= "<td>" . $antal_vare . "</td>";
$str.= "</tr>";
echo $str;
?>
</table>
alle vare
<div>
<span>navn</span>
<span>beskrivelse</span>
<span>antal</span>
<span>pris</span>
<span>tilføj</span>
</div>
<?php
$str = "";
$liste = vare_ReadAll($kurv);
for ($i = 0, $lng = count($liste); $i < $lng; $i++) {
$str.="\n";
$str.='<div>';
$str.='<form action="' . $_SERVER['PHP_SELF'] . '" method="post">';
$id = $liste[$i]['id'];
$str.='<input type="hidden" name="id" value="' . $id . '" >';
$str.='<span>' . $liste[$i]['vare'] . '</span>';
$str.='<span>' . $liste[$i]['tekst'] . '</span>';
$str.='<span><input type="number" name="quantity" min="1" max="5"></span>';
$str.='<span>' . $liste[$i]['pris'] . '</span>';
$str.='<span><input type="submit" name="action" value="add"></span>';
$str.="</form>";
$str.='</div>';
}
echo $str;
?>
rediger kurven
<table style="width:100%">
<tr>
<th>navn</th>
<th>beskrivelse</th>
<th>antal</th>
<th>pris</th>
<th>1 mere</th>
<th>1 mindre</th>
<th>slet</th>
</tr>
<?php
$str = "";
foreach ($_SESSION['kurv'] as $varer => $vare) {
$id = $vare['id'];
$item = vare_Read($kurv, $id);
$str.='<tr>';
$str.='<td>' . $item['vare'] . '</td>';
$str.='<td>' . $item['tekst'] . '</td>';
$str.='<td>' . $vare['antal'] . '</td>';
$str.='<td>' . $vare['antal'] * $item['pris'] . '</td>';
$str.='<td><a href="' . $_SERVER['PHP_SELF'] . '?id=' . $id . '&action=up">mere</a></td>';
$str.='<td><a href="' . $_SERVER['PHP_SELF'] . '?id=' . $id . '&action=down">mindre</a></td>';
$str.='<td><a href="' . $_SERVER['PHP_SELF'] . '?id=' . $id . '&action=delete">Slet</a></td>';
$str.='</tr>';
}
echo $str;
?>
</table>
<?php
mysqli_free_result($rsVarer);
?>
