MYSQLI: insert into tabel, array, fungerer ikke?
Hej Eksperter.Jeg har det problem at jeg skal sætte data ind i to tabeller i min database - her er min kode:
<?php
header("Content-type: charset=UTF-8");
$mysqli = new mysqli("mmmm, "jmmm");
mysqli_set_charset($mysqli, "utf8");
$mysqli->query("SET NAMES utf8");
$mysqli->query('SET character_set_client="utf8",character_set_connection="utf8",character_set_results="utf8"; ');
ini_set('default_charset', 'UTF-8');
require_once 'simple_html_dom.php';
function getStock($get_rss_feed){
$html = file_get_html($get_rss_feed);
$tmp = array();
$result = array();
$row = array();
$i = 0;
foreach ($html->find("items") as $items){
foreach($items->find("item") as $item){
$i++;
foreach($item->find("itemno") as $itemno){
$val = trim($itemno->plaintext);
$tmp[($i == 1 ? "keys" : "values")][] = $val;
}
foreach($item->find("description") as $description){
$val = trim($description->plaintext);
$tmp[($i == 1 ? "keys" : "values")][] = $val;
}
foreach($item->find("brand") as $brand){
$val = trim($brand->plaintext);
$tmp[($i == 1 ? "keys" : "values")][] = $val;
}
foreach($item->find("retailprice") as $retailprice){
$val = trim($retailprice->plaintext);
$tmp[($i == 1 ? "keys" : "values")][] = $val;
}
foreach($item->find("onstock") as $onstock){
$val = trim($onstock->plaintext);
$tmp[($i == 1 ? "keys" : "values")][] = $val;
}
if($i != 1){
$result[] = $tmp;
$tmp = array();
}
}
}
return $result;
}
$get_the_rss_feed_url = getStock("url");
if ($stmt = $mysqli->prepare("INSERT INTO ps_product_lang (description, name) values (?, ?)")) {
/* Bind our params */
$stmt->bind_param('ss',$descrption, $reference);
foreach ($get_the_rss_feed_url as $aktie) {
$reference = $aktie["values"][0];
$descrption = $aktie["values"][1];
$stmt->execute();
}
print "Updated data";
$stmt->close();
var_dump($descrption);
} else {
echo 'Der opstod en fejl i erklæringen ';
}
if ($stmt = $mysqli->prepare("INSERT INTO ps_product (id_manufacturer, quantity, price, reference) values (?, ?, ?, ?)")) {
/* Bind our params */
$stmt->bind_param('iiis', $brand, $instock, $price, $reference);
foreach ($get_the_rss_feed_url as $aktie) {
$reference = $aktie["values"][0];
$descrption = $aktie["values"][1];
$brand = $aktie["values"][2];
$price = $aktie["values"][4];
$instock = $aktie["values"][5];
if ($brand == "D&G")
{
$brand = 5;
}
else if ($brand == "casio")
{
$brand = 4;
}
else if ($brand == "levi")
{
$brand = 9;
}
else if ($brand == "guess")
{
$brand = 7;
}
else if ($brand == "seiko")
{
$brand = 13;
}
else if ($brand == "timex")
{
$brand = 15;
}
if ($instock == 0)
{
$shopinstock = 1;
}
else if ($instock == 1)
{
$shopinstock = 0;
}
$stmt->execute();
var_dump($reference);
}
$stmt->close();
} else {
echo 'Der opstod en fejl i erklæringen ';
}
?>
der meldes ingen fejl - hvad kan fejlen være?
På forhånd tak