UPDATE date in PHP function

Question

I have this from on my index file:

<form action="index.php#updateMatch" method="post">
    <?php
        Some select option
        echo '&nbsp;&nbsp;Date: (AAAA-MM-JJ) <input type="date" name="datematch">';
    ?>
    <input type="submit" value="do somthing" />
</form>

And if I some $_POST[xxx] I call this function:

function updateMatch($id,
    $winner_id, 
    $looser_id,
    $character_winner_id, 
    $character_looser_id, 
    $date) {
    database conection......
    $updatematch="UPDATE `match` SET manythings and date=$_POST[datematch] WHERE id=$_POST[id];";
    echo 'match.... N°'.$_POST['id'];
    mysql_close($db);
    }
    else 
        {echo "<span style='color: red'>blablabla</span>";}
}

But for date, the update dont work, the function set date to: 0000-00-00. How can i update date to ? Thanks

It's many others columns – user3414480 Mar 19 '14 at 16:04 — user3414480, Mar 19 '14 at 16:04

score 2 · Accepted Answer · edited May 23 '17 at 11:57

2

For starters you are missing quotes around your date:

$updatematch="UPDATE `match` SET manythings and date=$_POST[datematch] WHERE id=$_POST[id];";

should be:

$updatematch="UPDATE `match` SET manythings and date='$_POST[datematch]' WHERE id=$_POST[id];";

You also have an unecessary column in your statement (manythings). Remove it or fix it (I removed it because I don't know of a valid value to use):

$updatematch="UPDATE `match` SET date='$_POST[datematch]' WHERE id=$_POST[id];";

You are wide open to SQL injections

edited May 23 '17 at 11:57

Community

1
1

answered Mar 19 '14 at 16:00

John Conde

217,595
99
455
496

1

You should be careful when direct use of $_POST, you are allowing sql injection attacks – Olvathar Mar 19 '14 at 16:01
1

I know, that's why I mentioned sql injections. – John Conde Mar 19 '14 at 16:01
It's for school, no hacking, don't be worrying – user3414480 Mar 19 '14 at 16:03
Thanks, work with the quote: date='$_POST[datematch]' – user3414480 Mar 19 '14 at 16:06
2

@user3414480: _It's for school..._ That's not the point, practice good coding now rather than later. – The Blue Dog Mar 19 '14 at 16:52

UPDATE date in PHP function

1 Answers1