hvad er galdt i denne form
formen ser således ud og er i PHP, den oploader fint billed samt reziser det til mappen og skriver files navn i databasen men titel, text kommer der ikke noget af i databasen<?PHP
echo "<table width=50% align=center class=h4>\n";
echo "<form enctype='multipart/form-data' method=post action='changephotoparse.php'>\n";
echo "<tr><td>Billed Titel </td><td>:</td><td><input type=text name=titel class=textfield></td></tr>\n";
echo "<tr valign=top><td>Billed Informationen </td><td>:</td><td><textarea name=info cols=40 rows=6></textarea></td></tr>\n";
echo "<tr valign=top><td>Billede </td><td>:</td><td><input name=billede type=file></td></tr>\n";
echo "<tr valign=top><td> </td><td></td><td><input type=submit value=Save class=button></td></tr>\n";
echo "</table>";
echo "</form>\n";
echo "<form method=post>\n";
echo "<table width=100% align=center class=h4 bgcolor=#F2F2F2>\n";
echo "</table>\n";
echo "</form>\n";
?>
tablen i DB
CREATE TABLE olie (
id int(11) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
text text NOT NULL,
image varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
changephotoparse.php således
<?php
include("access.php");
{
$allowedExt = array("jpeg","jpg","jpe");
$title = htmlspecialchars ($titel);
$text = htmlspecialchars ($info);
$better_token = "";
//Har vi en fil?
if($_FILES['billede']['size'] > 0)
{
$ext = strtolower(end(explode(".",$_FILES['billede']['name'])));
//Er filen en godkendt type?
if(in_array($ext,$allowedExt))
{
$better_token = md5(uniqid(rand(), true)) . ".jpg";
echo "<hr>" . getcwd() . "<hr>";
resize($_FILES['billede']['tmp_name'],"/customers/fritids-mageren.dk/fritids-mageren.dk/httpd.www/oliemalerier/test/file/" . $better_token,200,133);
}
}
$q = "INSERT INTO `olie` (`id`, `title`, `text`, `image`) VALUES ('','$title','$text','$better_token')";
mysql_query ($q);
}
echo "<form method=post>\n";
echo "<table width=100% align=center class=h4 bgcolor=#F2F2F2>\n";
echo "<tr><td height=30 align=center><a href='index.php'>Opret Nyt billed</a></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
?>
