Button to update MySQL column not working

Question

I want to update my database with an SQL statement once someone clicks a button on the website. I've tried something, no success. Can you guys help me ? Here's the code: http://pastebin.com/D0S83Jgh
Don't know if I made this question correctly, I'm new here.

Answer 1

Your prepared statement is wrong.

The code I use with pdo to do a query is this:

$sqlUpd = $upd->prepare("UPDATE league_signups SET approved='1' WHERE id = :id");
$q->bindParam(':id', $id, PDO::PARAM_STR);
$q->execute();

Should work like a charm.

Answer 2

Get this code out of the main loop: while($row = $q->fetch(PDO::FETCH_ASSOC)) {}

<?php
include('pdoconnect.php');
$id = isset($row['id'];
if(isset($_REQUEST['approve']))
{
    $sqlUpd = "UPDATE league_signups SET approved='1' WHERE id=$id";
    $q = $upd->prepare($sqlUpd);
    $q->execute();
}
if(isset($_REQUEST['unapprove']))
{
    $sqlUpd = "UPDATE league_signups SET approved='0' WHERE id=$id";
    $q = $upd->prepare($sqlUpd);
    $q->execute();
}
?>

Put this code after the loop ending or the beginning of your code...

The data you want to update comes from the checkbox am I right? then you may want to make a loop to update all the values selected with checkbox to the corresponding action 'approve' or 'unapproved'

remove include('pdoconnect.php'); its utterly unnecessary if you are including this file from the beginning already

<?php

// checkbox[] it's an array...
$UpdateIDs = (isset($_REQUEST['checkbox'])) ? $_REQUEST['checkbox'] : [];
// check if $_REQUEST['approve'] is set else check if $_REQUEST['unapprove'] is set else set $approve to null;
$approved = (isset($_REQUEST['approve']) ? 
     $_REQUEST['approve'] : 
     (isset($_REQUEST['unapprove'])) ? $_REQUEST['unapprove'] : null;

if(!is_null($approved))
{
     try {
         foreach($UpdateIDs as $ID)
         {
             $stmt = $upd->prepare("UPDATE league_signups SET approved=:approved WHERE id=:id");
             $stmt->execute([
                 ':approved' => $approved,
                 ':id' => $ID
             ]);
         }
     } catch(PDOException $e) {
         echo 'ERROR: ' . $e->getMessage();
     }
}