如何将值插入MYSQL

Question

I'm trying to add value to database when each voter will vote with his ID. My db get the value but it goes one row down and i want that the db to get the value 1 to ID row not one row down.

Any solution about this please!!!

This is my code

$before1    = $row['vote_one_before'];
$after1     = $row['vote_one_after'];
$before2    = $row['vote_two_before'];
$after2     = $row['vote_two_before'];
$before3    = $row['vote_three_before'];
$after3     = $row['vote_three_after'];

$vote = 1;

if(($before1 == 0) and ($after1 == 0) and ($before2 == 0) and ($after2 == 0) and ($before3 == 0) and ($after3 == 0)){
    $stmt = $conn->prepare("INSERT INTO DB (vote_one_before) VALUES(':vote_one_before')");
    $stmt->execute(array(':vote_one_before'=> $vote));
}

Answer 1

Issue 1: If/Else

AND is not an operator that can be used in an IF/ELSE function - you need &&. Change your IF line to:

if(($before1 == 0)&&($after1 == 0)&&($before2 == 0)&&($after2 == 0)&&($before3 == 0)&&($after3 == 0)){

---

Issue 2: Query

Your query is also incorrect. For INSERT, the format is:

INSERT INTO `table_name` (`column_name`) VALUES (`new_value`);

Unless "DB" is your table name, you'll need to amend your query to something like this:

    $stmt = $conn->prepare("INSERT INTO `table_name` (vote_one_before) VALUES (:vote_one_before)");

Also note that when using placeholders you don't need single or double quotes - so ':vote_one_before' becomes :vote_one_before.