hvordan for jeg udbygget dette script
hej eksperterhvordan for jeg udbygget dette script så jeg kan få en mulighed for at upload et billed af en ret hvor billedet ligger i en mappe of stien bliver skrevet i mysql, er ved at lave et opskrift system
******************************* min table ser således ud
CREATE TABLE `recipe` (
`recipeID` int(11) NOT NULL auto_increment,
`recipe_title` varchar(200) NOT NULL default '',
`recipe_ingredients` text NOT NULL,
`recipe_portioner` text NOT NULL,
`recipe_images` text NOT NULL,
`recipe_method` text NOT NULL,
`recipe_note` text NOT NULL,
`catID` int(11) NOT NULL default '0',
PRIMARY KEY (`recipeID`)
) TYPE=MyISAM AUTO_INCREMENT=125 ;
******************************* mit script der viser retten
<?php
include ('useall.php');
if (!isset($catID))
$catID = "";
if (!isset($recID))
$recID = "";
if (!isset($act))
$act = "";
if ($act == "save" && !empty($recID))
{
$title = htmlspecialchars ($title);
$ingredients = htmlspecialchars ($ingredients);
$method = htmlspecialchars ($method);
$note = htmlspecialchars ($note);
$q = "UPDATE recipe SET catID = '$catID', recipe_title = '$title', recipe_ingredients = '$ingredients', recipe_method = '$method', recipe_note = '$note' WHERE recipeID = '$recID'";
mysql_query ($q);
}
echo "<table width=50% align=center class=h4>\n";
$cat_title = "";
$q = "SELECT cat_title FROM catrecipe WHERE catID = '$catID'";
mysql_first_data ($q, "cat_title");
echo "<tr><td colspan=2 class=h3><b><a href='index.php'>Opskrift Kategori</a> >> <a href='cat_view.php?catID=$catID'>$cat_title</a></b></td></tr>\n";
$recipe_title = "";
$recipe_ingredients = "";
$recipe_method = "";
$recipe_note = "";
$q = "SELECT * FROM recipe WHERE catID = '$catID' AND recipeID = '$recID'";
mysql_first_data ($q, "recipe_title|recipe_ingredients|recipe_method|recipe_note");
echo "<tr><td colspan=2 class=h2><br><b>$image</b></td></tr>\n";
echo "<tr><td colspan=2 class=h2><br><b>$recipe_title</b></td></tr>\n";
echo "<tr><td colspan=2 class=h4_brown><br><b>Ingredienser</b></td></tr>\n";
echo "<tr><td colspan=2 class=h4>". nl2br($recipe_ingredients) ."</td></tr>\n";
echo "<tr><td colspan=2 class=h4_brown><br><b>Fremgangsmåde</b></td></tr>\n";
echo "<tr><td colspan=2 class=h4>". nl2br($recipe_method) ."</td></tr>\n";
if (!empty($recipe_note))
{
echo "<tr><td colspan=2 class=h4_brown><br><b>Noter</b></td></tr>\n";
echo "<tr><td colspan=2 class=h4>". nl2br($recipe_note) ."</td></tr>\n";
}
$txt = "<script type='text/javascript' language='javascript'>\n";
$txt .= "function pop(url, nama)\n {";
$txt .= "window.open(url, nama, 'toolbars=no,scrollbars=yes,location=no,directories=no,status=no,menubar=yes,top=10,left=10,width=560,height=450');";
$txt .= "}\n</script>\n";
$txt .= "<a href=\"make_indeks.php?recID=$recID&size=4x6\" target=_blank><img border=0 src='images/4x6.gif' align=center alt='Adobe Reader 4x6'></a> \n";
$txt .= "<a href=\"make_indeks.php?recID=$recID&size=5x8\" target=_blank><img border=0 src='images/5x8.gif' align=center alt='Adobe Reader 5x8'></a> \n";
$txt .= "<a href=\"java script:pop('printer_friendly.php?recID=$recID', 'printer');\"><img border=0 src='images/print.jpg' align=center alt='Printer venlig udskrift'></a> \n";
$txt .= "<a href='rec_edit.php?catID=$catID&recID=$recID'><img border=0 src='images/edit.jpg' align=center alt='Rediger denne Opskrift'></a> \n";
echo "<tr><td colspan=2><br>$txt</td></tr>\n";
echo "</table>\n";
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='add_new.php?catID=$catID'>Lav Ny opskrift i denne Katagori</a></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
?>
og det ville jeg gerne have indsat et billed som tidligere er blevet oprettet sammen med retten eller er blevet opdateret senere
delen der skal bygges ind er mit eks. her
<?php
$qry = "SELECT * FROM recipe WHERE catID = '$catID' AND recipeID = '$recID'";
$query = mysql_query($qry) or die(mysql_error());
while ($row = mysql_fetch_assoc($query)) {
echo empty($row['image']) ? '' : '<img src=files/'.$row['image'].' class="image">';
}
?>
******************************* opskrift oprettelse script
<?php
include ('useall.php');
if (!isset($catID))
$catID = "";
echo "<table width=50% align=center class=h4>\n";
$cat_title = "";
$q = "SELECT cat_title FROM catrecipe WHERE catID = '$catID'";
mysql_first_data ($q, "cat_title");
echo "<tr><td colspan=3 class=h3><b><a href='index.php'>Opskrift Kategori</a> >> Opret Ny Opskrift</b><br> </td></tr>\n";
echo "<form method=post action='cat_view.php'>\n";
echo "<input type=hidden name=act value=save>\n";
$select_category = "<select name=catID class=textfield>\n";
$q = "SELECT * FROM catrecipe ORDER BY cat_title ASC";
$result = mysql_query($q);
while ($row = mysql_fetch_object($result))
{
if ($catID == $row->catID)
$SELECTED = "SELECTED";
else
$SELECTED = "";
$select_category .= "<option value='$row->catID' $SELECTED>$row->cat_title</option>\n";
}
$select_category .= "</select>\n";
echo "<tr><td>Kategori </td><td>:</td><td>$select_category</td></tr>\n";
echo "<tr><td>Title </td><td>:</td><td><input type=text name=title class=textfield></td></tr>\n";
echo "<tr valign=top><td>Ingredienser </td><td>:</td><td><textarea name=ingredients cols=40 rows=6></textarea></td></tr>\n";
echo "<tr valign=top><td>Fremgangsmetode </td><td>:</td><td><textarea name=method cols=40 rows=6></textarea></td></tr>\n";
echo "<tr valign=top><td>Noter </td><td>:</td><td><textarea name=note cols=40 rows=6></textarea></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 "<tr><td height=30 align=center><a href='java script:history.back();'><< Tilbage</a></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
?>
