Greetings!
I have a script that allows me to upload a XML file, the script then picks out some of the values and echoes them (this works fine). I am now trying to insert the values into a database. However, I get an error: error: Unknown column 'blah blah' in 'field list'
I really don't see that there are anything wrong with my sql line:
$sql = "INSERT INTO rorligt (id, arende, rumsnr, besk, adress, ejfakt, avslutad, best, rikt, listid) VALUES (NULL, $arende[$x],
$rumsnr[$x], `$beskrivning[$x]`, `$adress[$x]`, `$ejfakturerat[$x]`, `$avslutad[$x]`, `best`, `$rikt`, `$listid`)";
I tried it out with other variables and it worked, seems that only variables that are tied to the xml are not working... Where did I go wrong? :'(
Entire code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="description" content="Das Test">
<meta name="keywords" content="test">
<title>test</title>
</head>
<?php
error_reporting(0);
include "cfg.php";
$filnamn = $_POST["filnamn"];
$filnamn2 = "uploads/$filnamn";
if (file_exists($filnamn2)) { //Kontroll om fil existerar
$xml = file_get_contents($filnamn2);
$xml = new SimpleXMLElement($xml);
$arende = array();
$beskrivning = array();
$adress = array();
$ejfakturerat = array();
$avslutad = array();
$rumsnr = array();
$rikt = "";
$listid = "";
foreach($xml->lstResults->lstResults_Details_Group as $textbox1){
$arende[] = (string)$textbox1['textbox22'];
}
foreach($xml->lstResults->lstResults_Details_Group as $textbox2){
$beskrivning[] = (string)$textbox2['textbox42'];
}
foreach($xml->lstResults->lstResults_Details_Group as $textbox3){
$adress[] = (string)$textbox3['textbox30'];
}
foreach($xml->lstResults->lstResults_Details_Group as $textbox4){
$ejfakturerat[] = (string)$textbox4['textbox28'];
}
foreach($xml->lstResults->lstResults_Details_Group as $textbox5){
$avslutad[] = (string)$textbox5['textbox24'];
}
foreach($xml->lstResults->lstResults_Details_Group as $textbox6){
$rumsnr[] = (string)$textbox6['textbox26'];
}
?>
<table border="0">
<tr><td bgcolor="#FFFF00"><b>Ärende</b></td>
<td bgcolor="#FFFF00"><b>Rumsnummer</b></td>
<td bgcolor="#FFFF00"><b>Beskrivning</b></td>
<td bgcolor="#FFFF00"><b>Adress</b></td>
<td bgcolor="#FFFF00"><b>Ej fakturerat</b></td>
<td bgcolor="#FFFF00"><b>Avslutad</b></td>
<td bgcolor="#FFFF00"><b>Beställningsnr</b></td>
<td bgcolor="#FFFF00"><b>Riktkostnad</b></td>
<td bgcolor="#FFFF00"><b>Sign</b></td>
</tr>
<?php
for($x=0;$x<count($arende);$x++){
echo "<tr><td>";
echo (empty($arende[$x])) ? "Saknas..." : $arende[$x];
echo "</td><td>";
echo (empty($rumsnr[$x])) ? "Saknas..." : $rumsnr[$x];
echo "</td><td>";
echo (empty($beskrivning[$x])) ? "Saknas..." : $beskrivning[$x];
echo "</td><td>";
echo (empty($adress[$x])) ? "Saknas..." : $adress[$x];
echo "</td><td>";
echo (empty($ejfakturerat[$x])) ? "Saknas..." : $ejfakturerat[$x];
echo "</td><td>";
echo (empty($avslutad[$x])) ? "Saknas..." : $avslutad[$x];
echo "</td><td>";
echo "</td><td>";
echo "</td><td>";
echo "</td></tr>";
//Lägg in i databasen
mysql_connect ($servername, $dbusr, $dbpw) or die ('error: ' . mysql_error());
mysql_select_db($db);
$sql = "INSERT INTO rorligt (id, arende, rumsnr, besk, adress, ejfakt, avslutad, best, rikt, listid) VALUES (NULL, $arende[$x],
$rumsnr[$x], `$beskrivning[$x]`, `$adress[$x]`, `$ejfakturerat[$x]`, `$avslutad[$x]`, `best`, `$rikt`, `$listid`)";
mysql_query($sql) or die ('error: ' . mysql_error());
//-------------------
/*
$test1 = "bleh";
$test2 = "bleh";
$test3 = "123,5";
$test4 = "2011-01-01";
//Lägg in i databasen
mysql_connect ($servername, $dbusr, $dbpw) or die ('error: ' . mysql_error());
mysql_select_db($db);
$sql = "INSERT INTO rorligt (id, arende, rumsnr, besk, adress, ejfakt, avslutad, best, rikt, listid) VALUES (NULL, '123N',
'123-12', '$test1', '$test2', '$test3', '$test4', 'best', '456', '1')";
mysql_query($sql) or die ('error: ' . mysql_error());
*/
//-------------------
}
} else {
echo "Finns ingen sådan fil! Gör om, gör rätt!";
}
?>
</table>
