12. februar 2006 - 17:35
Der er
1 kommentar og 1 løsning
Redigere i en annonce
Nedenstående viser en annonce. Er det ikke muligt at få det viste udskrevet i nogle felter som man kan redigere i? Man skal kunne rette i sin annonce. <?php require_once("../members/common.php"); $Id = $_GET[id]; $hent = mysql_query("SELECT * FROM salgAfProdukt left join postnr on salgAfProdukt.postNr = postnr.postnr WHERE id = '$Id'") or die(mysql_error()); $raekke = mysql_fetch_assoc($hent); echo "<div align=\"center\"><table width=\"auto\" border=\"0\" cellspacing=\"\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"><tr><td width=\"75\" valign=\"top\"><span class=\"mellem\"> "; echo "<a href=\"java script:history.go(-1)\"><div align=\"center\"><font color=\"#0000cd\">< Tilbage</font></div></a><br>"; echo "</span></td></tr></table></div>"; echo " <table width=\"560\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"> <tr> <td width=\"490\" valign=\"top\"><span class=\"mellem\">".$raekke['produkt']."</span> <br><span class=\"lille\">".$raekke['supplerendeTekst']."</span></td> </tr></table> <table width=\"490\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\"bgcolor=\"#FFFFFF\"> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Pris:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\">".$raekke['pris']." Kr.<br><br></span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 1:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\">".$raekke['tlf1']."</span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 2:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\">".$raekke['tlf2']."</span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">E-mail:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\">".$raekke['email']."</span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">By:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\">".$raekke['bynavn']."</span></td> </tr> </table> <tr> <td colspan=\"2\">"; require_once("../members/common.php"); $imgID = mysql_real_escape_string($_GET['id']); $imgquery = mysql_query("SELECT * FROM billeder_salgAfProdukt WHERE artikelid = '".$imgID."' LIMIT 5") or die(mysql_error()); while($imgrow = mysql_fetch_assoc($imgquery)) { echo "<div align=\"center\"><img src=\"imageSalgsannoncer.php?id=".$imgrow[id]."\"></div><br><br>"; } echo " </td> </tr> "; ?>
Annonceindlæg fra Cognizant
Agentic AI kræver mere end teknologi
De fleste virksomheder har efterhånden bevist, at AI virker.
Pilotprojekter leverer resultater. Medarbejdere bruger generative AI-værktøjer. Nye use cases dukker op på tværs af organisationen.
12. februar 2006 - 20:02
#1
Jeg har nu fået lavet nedenstående, hvor data bliver vist i felter som man kan redigere i.. men den vil stadig ikke opdatere.. er her nogle som kan se hvad som er galt? <form action="<?=$_SERVER['PHP_SELF'];?>" method="get" name="FormName"> <?php require_once("../members/common.php"); $Id = $_GET[id]; $hent = mysql_query("SELECT * FROM salgAfProdukt left join postnr on salgAfProdukt.postNr = postnr.postnr WHERE id = '$Id'") or die(mysql_error()); $raekke = mysql_fetch_assoc($hent); echo "<div align=\"center\"><table width=\"auto\" border=\"0\" cellspacing=\"\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"><tr><td width=\"75\" valign=\"top\"><span class=\"mellem\"> "; echo "<a href=\"java script:history.go(-1)\"><div align=\"center\"><font color=\"#0000cd\">< Tilbage</font></div></a><br>"; echo "</span></td></tr></table></div>"; echo " <table width=\"560\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"> <tr> <td width=\"490\" valign=\"top\"><span class=\"mellem\"><input type='text' name='produkt' value='$raekke[produkt]'></span> <br><span class=\"lille\"><textarea name='supplerendeTekst' rows='6' cols='50'>".$raekke['supplerendeTekst']." </textarea></span></td> </tr></table> <table width=\"490\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\"bgcolor=\"#FFFFFF\"> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Pris:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='pris' value='$raekke[pris]'> Kr.<br><br></span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 1:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf1' value='$raekke[tlf1]'></span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 2:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf2' value='$raekke[tlf2]'></span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">E-mail:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='email' value='$raekke[email]'></span></td> </tr> <tr> <td width=\"55\" valign=\"top\"><span class=\"mellem\">By:</span></td> <td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='bynavn' value='$raekke[bynavn]' readonly></span></td> </tr> </table> <tr> <td colspan=\"2\">"; require_once("../members/common.php"); $imgID = mysql_real_escape_string($_GET['id']); $imgquery = mysql_query("SELECT * FROM billeder_salgAfProdukt WHERE artikelid = '".$imgID."' LIMIT 5") or die(mysql_error()); while($imgrow = mysql_fetch_assoc($imgquery)) { echo "<div align=\"center\"><img src=\"imageSalgsannoncer.php?id=".$imgrow[id]."\"></div><br><br>"; } echo " </td> </tr> "; mysql_query("update salgAfProdukt set produkt = " . $_POST['produkt'] . " , supplerendeTekst = " . $_POST['supplerendeTekst'] . " , pris = " . $_POST['pris'] . ", tlf1 = " . $_POST['tlf1'] . ", tlf2 = " . $_POST['tlf2'] . ", email = " . $_POST['email'] . "WHERE id = '$Id' LIMIT 1"); echo 'Annoncen er opdateret!'; ?> <input type="submit" name="submitButtonName" value="Opdater annonce" border="0"> </form>