PHP PDO wont update database

Question

i try to use PDO but i get 1,1,1 for result but database wont updated. I dont know whats wrong with my code.

try {$db = new PDO("mysql:dbname=$db_name;host=$db_host", $db_user, $db_pass );}
catch(PDOException $e){echo $e->getMessage();}

$title_insert = $db->prepare("UPDATE topics SET topic_title = ? WHERE id = ?");
$title_insert->bindParam(1, $id);
$title_insert->bindParam(2, $topic_title);

$tag_insert = $db->prepare("UPDATE topics SET topic_tags = ? WHERE id = ?");
$tag_insert->bindParam(1, $id);
$tag_insert->bindParam(2, $topic_tags);

$story_insert = $db->prepare("UPDATE topics SET topic_story = ? WHERE id = ?");
$story_insert->bindParam(1, $id);
$story_insert->bindParam(2, $topic_story);


$id = 1;
$topic_title = "title";
$topic_tags = "tags";
$topic_story = "story";

$result_title = $title_insert->execute();
echo $sonuc_title.',';

$sonuc_tag = $tag_insert->execute();
echo $sonuc_tag.',';

$result_story = $story_insert->execute();
echo $result_story;

Thanks for answers...

Do you really need 3 UPDATE's on 1 record?

david strachan
– david strachan

2014-01-08 12:01:02 +00:00
Commented Jan 8, 2014 at 12:01 — david strachan
– david strachan, Commented Jan 8, 2014 at 12:01

Community · Accepted Answer · 2023-11-17 20:08:53Z

2

Have you tried switching the param numbers?

$title_insert = $db->prepare("UPDATE topics SET topic_title = ? WHERE id = ?");
$title_insert->bindParam(1, $topic_title);
$title_insert->bindParam(2, $id);

Good luck!

PDO Bind param

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Jan 8, 2014 at 11:29

Fyntasia

1,1436 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ylerjen · Accepted Answer · 2014-01-08 11:31:29Z

you should affect your variable before the bind statement :

$id = 1;
$topic_title = "title";
$topic_tags = "tags";
$topic_story = "story";

$title_insert = $db->prepare("UPDATE topics SET topic_title = ? WHERE id = ?");
$title_insert->bindParam(1, $id);
$title_insert->bindParam(2, $topic_title);

$tag_insert = $db->prepare("UPDATE topics SET topic_tags = ? WHERE id = ?");
$tag_insert->bindParam(1, $id);
$tag_insert->bindParam(2, $topic_tags);

$story_insert = $db->prepare("UPDATE topics SET topic_story = ? WHERE id = ?");
$story_insert->bindParam(1, $id);
$story_insert->bindParam(2, $topic_story);


$result_title = $title_insert->execute();
echo $sonuc_title.',';

$sonuc_tag = $tag_insert->execute();
echo $sonuc_tag.',';

$result_story = $story_insert->execute();
echo $result_story;

Collectives™ on Stack Overflow

PHP PDO wont update database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related