PHP want not write in Database
| From: | Silvio Siefke | Date: | Mon, 16 May 2011 00:55:04 +0000 |
| Subject: | PHP want not write in Database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-312798@lists.php.net to get a copy of this message | ||
Hello,
i have a Blog Script for my private Website. Normal i write new Articles
direct with phpmyadmin, but this is not comfortable. I has no errors in Log
for the script and the mysql query log write the correct insert SQL code, but
nothing would be write in the database. I really understand not where is the
mistake. Can someone help me?
Thank You! Wish nice day at all!
Regards
Silvio
My PHP Code:
<start>
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
require ("inc/db.html");
var_dump($_POST);
// Check the Fields
if (isset ($_POST['submit']) &&
isset ($_POST['autor']) &&
isset ($_POST['title']) &&
isset ($_POST['teaser']) &&
isset ($_POST['content']) &&
isset ($_POST['category']) &&
isset ($_POST['bild']) &&
$_POST['autor'] != '' &&
$_POST['title'] != '' &&
$_POST['teaser'] != '' &&
$_POST['content'] != '' &&
$_POST['category'] != '' &&
$_POST['bild'] != '') {
try {
$sql = "INSERT INTO
test (autor, title, teaser, content, category, bild)
VALUES
(:autor, :title, :teaser, :teaser, :content, :category, :bild)";
$write = $db->prepare($sql);
$write->bindValue(':autor', $_POST['autor']);
$write->bindValue(':title', $_POST['title']);
$write->bindValue(':teaser', $_POST['teaser']);
$write->bindValue(':content', $_POST['content']);
$write->bindValue(':category', $_POST['category']);
$write->bindValue(':bild', $_POST['bild']);
$write->execute();
echo "<h1>Artikel ist eingetragen!</h1>";
} catch (PDOException $ex) {
echo $ex->getMessage();
}
}
?>
</end>
The HTML Tags:
<start>
<div class="entry">
<form method="post" action="" />
<fieldset>
<label>Autor</label>
<input type="text" class="text" name="autor" />
<label>Title</label>
<input type="text" class="text" name="title" />
<label>Teaser</label>
<textarea cols="80" rows="10" class="textarea"
name="teaser"></textarea>
<label>Content</label>
<textarea cols="80" rows="10" class="textarea"
name="content"></textarea>
<label>Kategorie</label>
<input type="text" class="text" name="category" />
<label>Bild</label>
<input type="text" class="text" name="bild" />
<input type="submit" class="submit" name="submit"
value="Posten" />
</fieldset>
</form>
</div>
</end>
The Mysql Query Log:
<start>
110516 2:44:29 187 Connect root@localhost on bloggen
187 Query INSERT INTO test (autor, title, teaser,
content, category, bild) VALUES ('Silvio Siefke', 'Test', 'We try we can
write in database with the script.', 'We try we can write in database with
the script.', 'When not then i not know what is the problem with the
script.', 'Freizeit', 'content.png') 187 Quit
<end>
The var_dump give me:
<start>
array(7) { ["autor"]=> string(13) "Silvio Siefke" ["title"]=>
string(4)
"Test" ["teaser"]=> string(48) "We try we can write in database with the
script." ["content"]=> string(61) "When not then i not know what is the
problem with the script." ["category"]=> string(8) "Freizeit"
["bild"]=>
string(11) "content.png" ["submit"]=> string(6) "Posten" }
<end>