PHP从无线电选择数据中获取输入并插入到MySQL表中

Question

I need a little help here with grabbing data from radio buttons selected by the user and entering the info to a table in my database.

My purpose is trying to create a dynamic website that grabs new tables entered in with data on it and posting it on the home page automatically. It will be a type of bidding/auction type of website.

First problem is I'm trying to get it to check if there are errors (entered in purposely or not purposely by the user)

If possible can the info below be entered into an array for storage as well? (not sure if I'm asking this right)

<form action="" method="post">
<ul>
<li>
Assault Ships:<br>
<input type="radio" name="item_ship" value="item_cruiser">Cruiser<br>
<input type="radio" name="item_ship" value="item_carrier">Carrier<br>
</li>
<li>
Pick a ticket:<br>
<input type="radio" name="item_tickets" value="ticket_one">One<br>
<input type="radio" name="item_tickets" value="ticket_two">Two<br>
<input type="radio" name="item_tickets" value="ticket_three">Three<br>
<input type="radio" name="item_tickets" value="ticket_four">Four<br>
<input type="radio" name="item_tickets" value="ticket_five">Five<br>
<input type="radio" name="item_tickets" value="ticket_six">Six<br>
<input type="radio" name="item_tickets" value="ticket_seven">Seven<br>
<input type="radio" name="item_tickets" value="ticket_eight">Eight<br>
</li>
<li>
<input type="submit" value="List Item">
</li>
</ul>
</form>

So what will happen when finished, is the user will select what item they want to list, and then choose what ticket they would like to purchase, this data is entered into my db_table and then my other script will display it on the home page where other people will buy the remaining tickets.

If I'm missing anything, please ask... kinda new to this. Looking forward to some great minds on these boards!!

Answer 1

Here is an example considering you have a radio button with a name attribute of radio_name -

HTML:

<input type="radio" checked="checked" name="radio_name" />

Get POST value:

if(isset($_POST['radio_name']) && !empty($_POST['radio_name'])){
    $radioContent= $_POST['radio_name'];
}

Insert into database (using mysqli prepared statements):

$sql = "INSERT INTO yourTable(
        rowName
        ) 
        VALUES (?)";

if($stmt = $mysqli->prepare($sql)){
    $stmt->bind_param("i", $radioContent);
    $stmt->execute();
    $stmt->close();
}
else{
    error_log($mysqli->error);
}

Resources to use:

Insert into (MYSQL)

Radio button POST