Siden giver en underlig fejlmelding om en form for update!
Kære Eksperter.Jeg søger en, der gider forklare mig hvorfor min kode giver denne fejlmelding i kan se herunder. Jeg har vedhæftet filen. Jeg synes det er meget underligt.
Har i forslag til rettelser så min admin blog virker?
MVH Michelle Nielsen
UPDATE blog SET dato= '2005-11-21', emne= 'Så virker blog\'en', skrevet= 'CTC ', Blog indlæg= 'Dette er det første indlæg i blog\'en og er her for at illustrere at blog\'en virker ' WHERE Id = 1
Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. in H:\Web Sites\Nelly\projects\admin\adminblog.php on line 34
<?php
/////////////////////////////////////////////////////
// C H E C K S T H E L O G I N S T A T U S //
/////////////////////////////////////////////////////
session_start();
if ($_SESSION['loggetind'] != "loggetind") {
header("Location: loginform.php");
}
////////////////////////////////////////////////////////////////////////////////////
/// E X E C U T E S T H E D A T A B A S E!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!//
////////////////////////////////////////////////////////////////////////////////////
$blogid = $_GET['blogid'];
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" . getcwd() . "//../../_rw_access/blog.mdb";
$db_connection->open( $db_connstr );
function htmlEncodeText($myHTML) {
$translation_table = get_html_translation_table( HTML_ENTITIES, ENT_QUOTES);
$translation_table[chr( 38)] = '&';
return preg_replace( "/&(?![A-Za-z]{0,4}\w{2,3};|#[0-9]{2,4};)/", "&" , strtr( $myHTML, $translation_table));
}
if ($_GET['mode'] == "update"){
$strSQL = "UPDATE blog SET dato= '" . date("Y-m-d") ."', emne= '" . htmlEncodeText($_POST["emne"]) ."', skrevet= '" . htmlEncodeText($_POST["navn"]) ."', Blog indlæg= '" . htmlEncodeText($_POST["blog"]) ."' WHERE Id = ".$blogid."";
echo $strSQL;
$db_connection->execute( $strSQL ) ;
} elseif ($blogid != "") {
$rs = $db_connection->execute( "select * from blog WHERE id= ". $blogid ."");
?>
<Form method="post" Action="adminblog.php?blogid=<?php echo $rs->Fields["Id"]->value; ?>&mode=update">
<textarea name="dato" cols="40"><?php echo date("d-m-Y",$rs->Fields["dato"]->value); ?></textarea><br>
<textarea name="emne" cols="40"><?php echo $rs->Fields["emne"]->value; ?></textarea><br>
<textarea name="navn" cols="40"><?php echo $rs->Fields["skrevet"]->value; ?> </textarea><br>
<textarea name="blog" rows="20" cols="40"><?php echo $rs->Fields["Blog indlæg"]->value; ?> </textarea><br>
<input type="submit" value="Opdater"><br>
<a href="adminblog.php">Tilbage</a>
</form>
<?php
} else {
$rs = $db_connection->execute( "select * from Blog ORDER BY dato ");
while ( ! $rs->EOF )
{
if ($rs->Fields["Id"]->value != $blogid) {
$date = $rs->Fields["dato"]->value;
$emne = $rs->Fields["Emne"]->value;
$tempid = $rs->Fields["Id"]->value;
echo "" . date("d-m-Y",$date) . " - <a href='". $PHP_SELF ."?blogid=". $tempid ."'>" . $emne . "</a><br><br>";
}
$rs->movenext();
}
}
$db_connection->close;
?>
