Overføring af værdier til INSERT kommando virker ikke
Hvordan kan det være at den ikke læser det korrekt i INSERT og VALUES kommandoen.Jeg har sakset en lille del af hele koden ud....
--------------------
$henrik = $ho;
$henrika = $hoo;
mysql_query("INSERT INTO `bil_udstyr` ( `id`, $henrik )
VALUES ('', $henrika )");
------------------------------
Når jeg echo'er $ho $hoo samt $henrik og $henrika får jeg det output som jeg skal bruge! (det har jeg gjort lidt længere nede i koden. Værdien stammer fra bunden af koden!
Men den indsætter det ikke i INSERT og VALUES delen......
Kan det ikke lade sig gøre.
<?
if($up==ja){
session_start();
$_SESSION['nummer'] = $nummer;
$konfiguration["upload_bibliotek"] = "./upload";
$konfiguration["max_stoerrelse"] = "1000";
/* Hvor flytter vi fra og til */
$fra = $_FILES["upfil"]["tmp_name"];
$ext = strtolower(end(explode(".", $_FILES['upfil']['name'])));
$name = "$id.$ext";
$til = $konfiguration["upload_bibliotek"] . "/" . $name;
/* Check PHP-version */
list($major, $minor, $rev) = explode(".", phpversion());
if($major < 4) {
die("Jeg kan kun arbejde med PHP 4.0.0 eller derover");
}
/* Skab de "moderne" arrays hvis vi arbejder med en aeldre PHP */
if($minor < 1) {
$_FILES = $HTTP_POST_FILES;
$_POST = $HTTP_POST_VARS;
$_SERVER = $HTTP_SERVER_VARS;
}
/* Accepterer vi filens stoerrelse? */
$fil_stoerrelse = filesize($fra)/1024;
if($fil_stoerrelse > $konfiguration["max_stoerrelse"]) {
die("Desværre - filen er for stor. Jeg accepterer kun " .
$konfiguration["max_stoerrelse"] . "kb, og din fil fylder " .
ceil($fil_stoerrelse, 1) . " kb");
}
/* Saa koerer vi */
if(function_exists("move_uploaded_file")) {
move_uploaded_file($fra, $til);
$billede = basename($til);
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$henrik = $ho;
$henrika = $hoo;
mysql_query("SELECT id, udstyr, udstyra FROM bil_udstyra");
$dato = date("j/n - Y");
mysql_query("INSERT INTO `bil_bil` ( `id` , `kategori`, `maerke`, `model`, `variant`, `type`, `bstof`, `farve`, `aar`, `km`, `pris`, `afgift`, `billede`)
VALUES ('', '$kategori', '$maerke', '$model', '$variant', '$type', '$bstof', '$farve', '$aar', '$km', '$pris', '$afgift', '$billede')");
mysql_query("INSERT INTO `bil_udstyr` ( `id`, $henrik )
VALUES ('', $henrika )");
echo "Møblet er oprettet! $ho $hoo<br>$henrik<br>$henrika";
echo "<a href='abil.php'>Retur</a><br>";
session_destroy();
}
else {
copy($fra, $til);
}
}else{
?>
<center>Opret ny bil<HR width="400">
<br>
<FORM METHOD=POST ACTION='opretbil.php?up=ja' ENCTYPE="multipart/form-data">
Kateogori:<br>
<select name="kategori">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT kategori, id FROM bil_kategori ORDER BY kategori ");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br><br>
Bilmærke:<br>
<select name="maerke">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT maerke, id FROM bil_maerke ORDER BY maerke");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>
Bilmodel:<br>
<select name="model">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT model, id FROM bil_model ORDER BY model");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select>
<br>Variant (motorstørrelse):<br>
<select name="variant">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT variant, id FROM bil_variant ORDER BY variant");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select>
<br>
<br>Biltype:<br>
<select name="type">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT type, id FROM bil_type ORDER BY type");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>Brændstof:<br>
<select name="bstof">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT bstof, id FROM bil_bstof ORDER BY bstof");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>
Farve:<br>
<select name="farve">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT farve, id FROM bil_farve ORDER BY farve");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>
Årgang:<br>
<select name="aar">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT aar, id FROM bil_aar ORDER BY aar");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>
Pris:<br>
<INPUT TYPE=text NAME=pris><br>
Km:<br>
<INPUT TYPE=text NAME=km><br><br>
Afgift:<br>
<select name="afgift">
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT afgift, id FROM bil_afgift ORDER BY afgift");
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
while ($data = mysql_fetch_row($foresp)){
echo "<option value='$data[1]'>$data[0]</option>";
}
?>
</select><br>
<br>
Vælg billedfil :<br> <input type="file" name="upfil" />
<p>
<?php
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT id FROM bil_bil");
while ($data = mysql_fetch_row($foresp)){
$id = $data[0];
}?>
<table>
<tr valign="top"><td valign="top"><?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT id, udstyr, udstyra FROM bil_udstyra ORDER BY udstyr");
while ($data = mysql_fetch_row($foresp)){
echo "$data[1]<br>";
}
?>
</td><td>
<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$foresp = mysql_query("SELECT id, udstyr, udstyra FROM bil_udstyra ORDER BY udstyr");
while ($data = mysql_fetch_row($foresp)){
echo "<input type='checkbox' name='$data[1]' value='1'><br>";
}
?>
</td></tr>
</table>
<p>
<INPUT TYPE="hidden" NAME="id" VALUE=<? echo $id; ?>>
<INPUT TYPE="hidden" NAME="ho" VALUE=<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$forespa = mysql_query("SELECT id, udstyr, udstyra FROM bil_udstyra");
while ($dataa = mysql_fetch_row($forespa)){
echo ",`$dataa[1]`"; }
?> >
<INPUT TYPE="hidden" NAME="hoo" VALUE=<?
include("config.php");
$db = mysql_connect($server, $user, $pass);
mysql_select_db($database, $db);
$forespb = mysql_query("SELECT id, udstyr, udstyra FROM bil_udstyra");
while ($datab = mysql_fetch_row($forespb)){
echo ",`$$datab[1]`"; }
?>>
<INPUT TYPE=submit VALUE=upload>
</form>
<?
}
?></center>
