Update only checked rows php mysql

Question

I am trying to update only checked rows in the table but nothing is happening Here is my code

<?php
    //database connect select
    $result=mysql_query("Select * from ticket_reservation WHERE 
    validate_status='No'") or die(mysql_error());
    while($row=mysql_fetch_array($result))
    {
        echo "<tr><td><input type='checkbox' id='name'  name='name[]'value=".$row['id']."</td><td>".$row['userid']."</td> <td>".$row['busid']."</td><td>".$row['numberofseats']."</td></tr>";
        echo "<br>"; 
    }
    echo"<tr><td><input type='submit' name='submit' Value='Validate Tickets'>    </td></tr>";
    if(isset($_POST['submit']))
    {
        if(is_array($_POST['name']))
        {
            $qry = "UPDATE ticket_reservation SET validate_status='Yes' WHERE id IN (".implode(',', $_POST['name']).")";
            // echo $qry; // For checking the generated sql statement; can be removed
            mysql_query($qry);
        }
    }

?>
</table>
</form>

you're missing an underscore here `$POST` – Funk Forty Niner Sep 07 '15 at 13:39 — Funk Forty Niner, Sep 07 '15 at 13:39

score 2 · Answer 1 · answered Sep 07 '15 at 11:29

2

$checkbox=$_POST['name'];
for($i=0;$i<count($checkbox);$i++)
{
    $id = $checkbox[$i];

    $sql1 = "UPDATE ticket_reservation set     validate_status='Yes' where id = '".$id."' ";
    mysql_query($sql1);
}

answered Sep 07 '15 at 11:29

Shailesh Katarmal

2,757
1
12
15

I have checked this answer but does not work – Bilal Zia Sep 07 '15 at 12:06

score 1 · Answer 2 · edited Sep 07 '15 at 11:30

1

You got also a typo here: is_array($POST['name']) should be is_array($_POST['name']).

edited Sep 07 '15 at 11:30

mario.van.zadel

2,919
14
23

answered Sep 07 '15 at 11:25

user098

89
6

mario.van.zadel · Answer 3 · 2015-09-07T11:54:45.220

0

You can use MySQL IN function to update all datasets in one query. So you don't need to iterate over all IDs using foreach loop.

if(isset($_POST['submit']))
{
    if(is_array($_POST['name']))
    {
        $qry = "UPDATE ticket_reservation SET validate_status='Yes' WHERE id IN (".implode(',', $_POST['name']).")";
        echo $qry; // For checking the generated sql statement; can be removed
        mysql_query($qry);
    }
}

To prevent SQL Injection you should use prepared statements (see PDO)

You should also add a space between your HTML attributes: name='name[]' value= instead of name='name[]'value=.

edited Sep 07 '15 at 11:54

answered Sep 07 '15 at 11:19

mario.van.zadel

2,919
14
23

I have added spaces and I have also added the above line but nothing is happening The validate status field does not change values in the database – Bilal Zia Sep 07 '15 at 11:35
Could you please add `echo $qry;` to your code and check the generated query in e.g. `phpMyAdmin`? – mario.van.zadel Sep 07 '15 at 11:39
I am trying to iterate because I want to update multiple rows at a time does that make sense? – Bilal Zia Sep 07 '15 at 11:45
The code echo $qry doesn't generate any output... – Bilal Zia Sep 07 '15 at 11:48
@BilalZia My example will also update multiple rows. I've updated my answer so that you can see where you have to update the sql statement and where to add the `echo $qry;`. – mario.van.zadel Sep 07 '15 at 11:57
Unfortunately this time also no output is generated neither the fields in the database being changed – Bilal Zia Sep 07 '15 at 12:05
Please set the attribute `name` of your submit button to `submit` so that `if(isset($_POST['submit']))` will take effect. – mario.van.zadel Sep 07 '15 at 12:06
It generates the following output....UPDATE ticket_reservation SET validate_status='Yes' WHERE id IN ( – Bilal Zia Sep 07 '15 at 12:11
Please check your `php_error_log` for notices, warnings and fatal errors. – mario.van.zadel Sep 07 '15 at 12:27
I opened php error log from cpanel it says cannot find php error log – Bilal Zia Sep 07 '15 at 12:40

score 0 · Answer 4 · answered Sep 07 '15 at 14:02

0

if(isset($_POST['name']))
{
 $Name=$_POST['name'];
foreach($Name as $N)
{

$qry="Update ticket_reservation SET validate-status='Yes' Where id='$N'";       echo $qry; // For checking the generated sql statement; can be removed
 mysql_query($qry);



}

}

answered Sep 07 '15 at 14:02

Ethic Or Logics

111
1
13

What error are you getting? – Ethic Or Logics Sep 07 '15 at 14:28
There is no error sir I have tried it too many times checking for the typos... – Bilal Zia Sep 07 '15 at 16:02

Update only checked rows php mysql

4 Answers4