How to save radio button data in a database and extract it?

Remco

Hello,

I'm designing a simple website for my football team where we can tell each other if we're able to play next weekend.

For this website I designed a page with radio buttons with the options: Attending, Not Attending, Unknown (standard option). But i'm not sure how to save the information from the radio buttons to the database and how to extract it again.

The code for the radio button page:
(Just for 2 players atm, will extend when I know how to complete the whole idea):

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>

</head>
 
<body>

 <p>Vink aan of je er bij bent of niet: </p>

 <table width="600" border="0">

   <tr>

     <th scope="col">Naam</th>

     <th scope="col">&nbsp;</th>

   </tr>

   <tr>

     <td>Ale</td>

     <td><form id="form2" name="form2" method="post" action="">

         <label>

           <input type="radio" name="Ale" value="Ja" id="Ale_0" />

           Aanwezig</label>

         <label>

           <input type="radio" name="Ale" value="Nee" id="Ale_1" />

           Afwezig</label>

         <label>

           <input type="radio" name="Ale" value="Geen" id="Ale_2" />

           Onbekend</label>

     </form></td>

   </tr>

   <tr>

     <td>Andy</td>

     <td><form id="form1" name="form1" method="post" action="">

         <label>

           <input type="radio" name="Andy" value="Ja" id="Andy_0" />

           Aanwezig</label>

         <label>

           <input type="radio" name="Andy" value="Nee" id="Andy_1" />

           Afwezig</label>

         <label>

           <input type="radio" name="Andy" value="Geen" id="Andy_2" />

           Onbekend</label>

     </form></td>

   </tr>

 </table>

 <p>&nbsp;</p>

</body>

</html>

My idea was that the people can change their options, press a save button and the view for the other players will be altered accordingly. I hope this is enough information, else just ask what you need :)

Nov 2 '10 #1

Subscribe Post Reply

4181

dlite922

1,584

Expert 1GB

So what are you asking? You need to be able to connect to a database using PHP and parse the data from the page and insert it into the database.

Note, you have multiple people on the same page, what stops Ale from changing Andy's status?

There are tutorials online if you don't know how to use PHP to insert and update records in a database.

You'll need to know SQL as well.

Dan

Nov 5 '10 #2

Remco

Thanks for the reply dan, I know how to use SQL, just didn't know how to combine it with php as it's my first website with php, but i've fixed it already with using lists instead of radio buttons.

And for the multiple people on the same page, it's a page based on trust.

Nov 6 '10 #3

by: Renie83 | last post by:

Hi all! I was wondering does anyone have any ideas on how I can send info to a SQL database by choosing a radio button. What I want to do is set one radio button to "Max" and one to type "Avg"....

ASP / Active Server Pages

Radio Button and Combo Box Dynamic Data Retrieval

by: David | last post by:

Hi, May I know how to create data dynamically in a combo box after clicking on a radio button ? Data are retrieved using a store procedure from a SQL Server. For example : Click Radio Button...

ASP / Active Server Pages

autofil a radio button

by: Jay | last post by:

I have a form used to submit data (no surprises there!). I'd like to be able to populate the same form with previously submitted data. The data lives in a database once submitted and using ASP I...

Javascript

Deselect a Radio Button at Lotus Note

by: Orchid | last post by:

I have 2 fields with Radio button Data Type, and both fields with more than one options. On Field1, I want the user to select option1, then Field2 is shown and able to select. If the user selects...

Microsoft Access / VBA

storing radio button values in database - binary, int or varchar??

by: Hazzard | last post by:

What is the best way to do this? Binary with 0 representing off and 1 on? Int16 with 1 representing first button, 2 the second, 3 ... varchar with a character values at certain positions in the...

ASP.NET

input through radio button in php

by: sanjay123456 | last post by:

Dear Sir If i am working on sql.php and i am taking radio button forr option of question the i donot understand that when a user click any radio button then how i compre to answer ...

PHP

php and Javascript call to change radio button

by: IchBin | last post by:

I am trying to set the state of a radio button. I do not see what I am doing wrong. Sorry, I am new at this.. I need another set of eyes to look at this snip of code. I am trying to set the radio...

Javascript

retrieve record from access into radio button in form (classic asp)

by: puT3 | last post by:

I have Customer table where there is a field called Company Type which store corporate or private. I want to retrieve the value in the table so it is diplayed on classic asp file in radio button. Im...

ASP / Active Server Pages

How to insert radio button data into mysql

by: pavithraj | last post by:

i m getting error. its not at all inserting into database.showing error like as below Notice: Undefined index: franchise_hours in...

PHP

Radio button data failing to be inserted into MySQL.

by: Louloul | last post by:

I have an urgent question please if any one could answer me now coz my representetion for my project is tommorrow. this my code <html> <head> <title>Register</title> <script...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

How to save radio button data in a database and extract it?

Similar topics