php increment field value in mysql

Question

<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 
    <ul> 
        <input type="radio" name="team" id="1" value="Real Madrid" size='5'><font size='5'><u> Real Madrid<br> 
        <input type="radio" name="team" id="2" value="Chelsea"> Chelsea<br> 
        <input type="radio" name="team" id="3" value="Milan"> Milan<br>
        <input type="button" id="submit" name="submit" value="VOTE" >

</form>

this is my button in html

if(isset($_POST['submit'])){
   $selected_radio = $_POST['id'];
   $query = "UPDATE favourite_team SET likes = likes + 1 WHERE id = '" .  $selected_radio . "'";
   $q = mysqli_query($conn, $query);}

this is my code in php

Your question is not so clear. What's the error? What you are expecting? — AnkiiG
– AnkiiG, Commented Jan 20, 2016 at 12:07
What is the issue? Please specify your question so one can able to give proper answer. — Keyur Mistry
– Keyur Mistry, Commented Jan 20, 2016 at 12:11
I expect when click the button to increase likes with 1. When I click the button nothing happen — Димитър Захариев
– Димитър Захариев, Commented Jan 20, 2016 at 12:12
Show your complete form along with your database connection!! — Saty
– Saty, Commented Jan 20, 2016 at 12:13

Nana Partykar · Accepted Answer · 2016-01-20 12:26:07Z

1

Name is 'team'. Not, 'id'. Use this code. Give id value to value attribute

<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> 
    <ul> 
        <input type="radio" name="team" value="1" size='5'><font size='5'><u> Real Madrid<br> 
        <input type="radio" name="team" value="2" > Chelsea<br> 
        <input type="radio" name="team" value="3" > Milan<br>
        <input type="button" id="submit" name="submit" value="VOTE" >

</form>

<?
if(isset($_POST['submit'])){
   $selected_radio = $_POST['team'];
   $query = "UPDATE favourite_team SET likes = likes + 1 WHERE id = '" .  $selected_radio . "'";
   $q = mysqli_query($conn, $query);}
?>

answered Jan 20, 2016 at 12:26

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

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

Comments

Ravi Hirani · Accepted Answer · 2016-01-20 12:31:32Z

0

You need to write $_POST['team']. Try this code:-

 $selected_radio = $_POST['team'];
 $query = "UPDATE favourite_team SET likes = likes + 1 WHERE id = '" .  $selected_radio . "'";
 $q = mysqli_query($conn, $query);

Check this link for more detail.

answered Jan 20, 2016 at 12:31

Ravi Hirani

6,5341 gold badge31 silver badges43 bronze badges

Comments

Mohammed Bani Melhem · Accepted Answer · 2016-01-20 13:09:14Z

0

you need to change the value of the radio to be the id this mean value='1'

and need to change $selected_radio = $_POST['id']; to $selected_radio = $_POST['team'];

and change input type to submit type='submit'

<input type='submit' id='submit' name='submit' value='VOTE'>

i hope this will fix your problem

edited Jan 20, 2016 at 13:09

answered Jan 20, 2016 at 12:24

Mohammed Bani Melhem

395 bronze badges

Collectives™ on Stack Overflow

php increment field value in mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related