使用单选按钮使用php插入数据库表

Question

I have this code and i want to insert the items inside the database but it is not inserting. HTML5 code:

<form action="simple.php" method="post">
<input type="radio" name="games" value="1" size="20"<?php print $itemname;?
>Buy It</br>
<input type="Submit"name="Submit1" value="Add to cart"></center></a></div> 
</div></td></form>

php:

if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['games'];

if ($selected_radio == '1') {

 $un ='checked';

if ($un='checked')

$value="whatever value";
$sql="INSERT INTO cartorders(id,item,price) VALUES ('$id','$value',250)";
$res=mysqli_query($dbhandle,$sql);

Answer 1

Use id as an Auto Increment ID

   <?php

    if (isset($_POST['Submit1'])) {
        $selected_radio = $_POST['games'];
        if ($selected_radio == '1') {
            $value = "whatever value";
            $sql   = "INSERT INTO cartorders(item,price) VALUES ('" . $value . "',250)";
            $res   = mysqli_query($dbhandle,$sql);
        }
    }
     ?>