fckeditor naar MySQL (Opgelost)
arneman
Nieuw lid
Volgende code zou de HTML van mijn FCKEditor moeten doorsturen naar mijn MySQL database. Maar hij geeft een fout op die laatste variabele. In de database is deze van het type Text, dus ik denk dat er typecasting problemen zijn. Iemand een idee?
if (isset($_POST['newspost'])) {
$postArray = &$_POST ;
foreach ( $postArray as $sForm => $value ) {
if ( get_magic_quotes_gpc() )
$postedValue = htmlspecialchars( stripslashes( $value ) ) ;
else
$postedValue = htmlspecialchars( $value ) ;
$date = date("Y-m-d");
$time = date("H:i");
$query='INSERT INTO news_comment (post, user, date, time, text) VALUES ("'.$_GET['id'].'",
"'.$_COOKIE['id'].'",
"'.$date.'",
"'.$time.'",
"'.$postedValue.'"';
mysql_query($query) or die (mysql_error());
}
}
if ( isset ( $_POST [ 'newspost' ] ) ) {
$postArray = & $_POST ;
foreach ( $postArray as $sForm => $value ) {
else
$query = 'INSERT INTO news_comment (post, user, date, time, text) VALUES ("' . $_GET [ 'id' ] . '",
"' . $_COOKIE [ 'id' ] . '",
"' . $date . '",
"' . $time . '",
"' . $postedValue . '"' ;
}
}
6 antwoorden
Bart
PHP expert Dacht je niet toen je aan het schrijven was dat het handig zou zijn om die beruchte foutmelding waar je het over hebt ook hier te posten?
arneman
Nieuw lid Query ziet er nu zo uit
$query='INSERT INTO news_comment (post, user, date, time, text) VALUES ("'.$_GET['id'].'", "'.$_COOKIE['id'].'", "'.$date.'", "'.$time.'", "'.$postedValue.'"';
$query = 'INSERT INTO news_comment (post, user, date, time, text) VALUES ("' . $_GET [ 'id' ] . '", "' . $_COOKIE [ 'id' ] . '", "' . $date . '", "' . $time . '", "' . $postedValue . '"' ;
Citaat:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Bart
PHP expert
$query='INSERT INTO news_comment (post, user, date, time, text) VALUES ("'.$_GET['id'].'", "'.$_COOKIE['id'].'", "'.$date.'", "'.$time.'", "'.$postedValue.'")';
$query = 'INSERT INTO news_comment (post, user, date, time, text) VALUES ("' . $_GET [ 'id' ] . '", "' . $_COOKIE [ 'id' ] . '", "' . $date . '", "' . $time . '", "' . $postedValue . '")' ;
Je was ")" vergeten aan het einde
SvenP (laatste wijziging 21/06/2009 17:31)
PHP interesse
$query='INSERT INTO news_comment (post, user, date, time, text) VALUES ("'.$_GET['id'].'", "'.$_COOKIE['id'].'", "'.$date.'", "'.$time.'", "'.$postedValue.'")';
$query = 'INSERT INTO news_comment (post, user, date, time, text) VALUES ("' . $_GET [ 'id' ] . '", "' . $_COOKIE [ 'id' ] . '", "' . $date . '", "' . $time . '", "' . $postedValue . '")' ;
arneman (laatste wijziging 30/06/2009 14:33)
Nieuw lid OK, dit is opgelost (ik schaam me diep) maar nu wordt blijkbaar alles dubbel weggeschreven.
if (isset($_POST['newspost'])) {
$postArray = $_POST ;
foreach ( $postArray as $sForm => $value ) {
if ( get_magic_quotes_gpc() )
$postedValue = ( stripslashes( $value ) ) ;
else
$postedValue = ( $value ) ;
$date = date("Y-m-d");
$time = date("H:i");
$query='INSERT INTO news_comment (post, user, date, time, text) VALUES ("'.$_GET['id'].'", "'.$_COOKIE['userid'].'", "'.$date.'", "'.$time.'", "'.$postedValue.'")';
mysql_query($query) or die (mysql_error());
}
}
if ( isset ( $_POST [ 'newspost' ] ) ) {
$postArray = $_POST ;
foreach ( $postArray as $sForm => $value ) {
else
$postedValue = ( $value ) ;
$query = 'INSERT INTO news_comment (post, user, date, time, text) VALUES ("' . $_GET [ 'id' ] . '", "' . $_COOKIE [ 'userid' ] . '", "' . $date . '", "' . $time . '", "' . $postedValue . '")' ;
}
}
Dit onderwerp is gesloten .
Wat is jouw favoriete javascript framework? (S: 18, R: 2)
Gesponsorde links
Actiefste leden van de maand
