PHP - Radio Button And Textbox Value To Mysql Dataase, Please Help.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=350859.0

I'm in the process of making a network for investors and entrepreneurs. When they access their profile page, select edit and go to editprofile.php a problem arises with the data base submission. I have the data they have previously inputted being echoed back out to the user. This lets the user see what they have inputted so that they can make changes to their profile. Unfortunately, with my radio buttons, if no changes are made and the user hits submit, the radio buttons return a value of 'unchecked'. I need them to maintain the value previously submitted to the database if the radio button isn't 'checked'. I'm not sure exactly how to do this.

You can test it out yourself by going to http://network.jasonbiondo.com

Code is below:

Code: [Select]
?php

session_start();

require ('connect.php');

include ('header.php');

$savechanges = $_POST['savechanges'];

$firstname = strip_tags($_POST['firstname']);
$lastname = strip_tags($_POST['lastname']);
$username = strtolower(strip_tags($_POST['username']));
$email = strip_tags($_POST['email']);
$password = strip_tags($_POST['password']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$entrepreneur = 'unchecked';
$investor = 'unchecked';
$date = date("Y-m-d");
$companyname = strip_tags($_POST['companyname']);
$companywebsite = strip_tags($_POST['companywebsite']);
$founder = strip_tags($_POST['founder']);
$phone = strip_tags($_POST['phone']);
$address = strip_tags($_POST['address']);
$city = strip_tags($_POST['city']);
$state = strip_tags($_POST['state']);
$zipcode = strip_tags($_POST['zipcode']);
$country = strip_tags($_POST['country']);
$development = strip_tags($_POST['development']);
$capitalamount = strip_tags($_POST['capitalamount']);
$companydo = strip_tags($_POST['companydo']);
$founderbuilt = strip_tags($_POST['founderbuilt']);
$whatsnew = strip_tags($_POST['whatsnew']);
$understand = strip_tags($_POST['understand']);
$competition = strip_tags($_POST['competition']);
$money = strip_tags($_POST['money']);
$demo = strip_tags($_POST['demo']);
$incorporation = strip_tags($_POST['incorporation']);
$companynameinv = strip_tags($_POST['companynameinv']);
$phoneinv = strip_tags($_POST['phoneinv']);
$addressinv = strip_tags($_POST['addressinv']);
$cityinv = strip_tags($_POST['cityinv']);
$stateinv = strip_tags($_POST['stateinv']);
$zipcodeinv = strip_tags($_POST['zipcodeinv']);
$countryinv = strip_tags($_POST['countryinv']);
$angel = strip_tags($_POST['angel']);
$vc = strip_tags($_POST['vc']);
$capital = strip_tags($_POST['capital']);

if ($savechanges)

{

$queryreg = mysql_query("UPDATE users SET

   `firstname` = '$firstname',
   `lastname` = '$lastname',
   `email` = '$email',
   `entrepreneur` = '$entrepreneur',
   `investor` = '$investor',
   `companyname` = '$companyname',
   `companywebsite` = '$companywebsite',
   `founder` = '$founder',
   `phone` = '$phone',
   `address` = '$address',
   `city` = '$city',
   `state` = '$state',
   `zipcode` = '$zipcode',
   `country` = '$country',
   `development` = '$development',
   `capitalamount` = '$capitalamount',
   `companydo` ='$companydo',
   `founderbuilt` = '$founderbuilt',
   `whatsnew` = '$whatsnew',
   `understand` = '$understand',
   `competition` = '$competition',
   `money` = '$money',
   `demo` = '$demo',
   `incorporation` = '$incorporation',
   `companynameinv` = '$companynameinv',
   `phoneinv` = '$phoneinv',
   `addressinv` = '$addressinv',
   `cityinv` = '$cityinv',
   `stateinv` = '$stateinv',
   `zipcodeinv` = '$zipcodeinv',
   `countryinv` = '$countryinv',
   `angel` = '$angel',
   `vc` = '$vc',
   `capital` = '$capital'
   
   WHERE username=  '" . $_SESSION['username'] . "'
   
   ");
   
   $selected_radio_selector = $_POST['selector'];
    $selected_radio_invtype = $_POST['invtype'];
     
   if ($selected_radio_selector == 'entrepreneur')
      {
         $entrepreneur = 'checked';
         
      }
      else if ($selected_radio_selector == 'investor')
      {
         $investor = 'checked';
         
         if ($selected_radio_invtype == 'angel')
         {
            $angel = 'checked';
            $vc = 'unchecked';
         
         }
         else if ($selected_radio_invtype == 'vc')
         {
            $vc = 'checked';
            $angel = 'unchecked';
         }
         else
         {
         die("Please select what type of investor you are!");
         }
      }
   
}

$q = mysql_query("SELECT `firstname`, `lastname`, `firstname`, `lastname`, `email`, `entrepreneur`, `investor`, `companyname`, `companywebsite`, `founder`, `phone`, `address`, `city`, `state`, `zipcode`, `country`, `development`, `capitalamount`, `companydo`, `founderbuilt`, `whatsnew`, `understand`, `competition`, `money`, `demo`, `incorporation`, `companynameinv`, `phoneinv`, `addressinv`, `cityinv`, `stateinv`, `zipcodeinv`, `countryinv`, `angel`, `vc`, `capital` FROM `users` WHERE username=  '" . $_SESSION['username'] . "'");

$r = mysql_fetch_assoc($q);

?>

<script type="text/javascript" src="../assets/js/editprofile.js"></script>

<form action='editprofile.php' method="POST" id="form">

   <fieldset>

      <p id="required"> * Required Fields</p>

      <p class="fieldSpacing">

         <label for="firstname" class="leftcolalign">First Name *</label>

         <input id="firstname" class="rightcolalign" name="firstname" value='<?php echo $r['firstname']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="lastname" class="leftcolalign">Last Name *</label>

         <input id="lastname" class="rightcolalign" name="lastname" value='<?php echo $r['lastname'];?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="username" class="leftcolalign">User Name *</label>

         <?php echo $_SESSION['username']; ?>

      </p>

      <p class="fieldSpacing">

         <label for="email" class="leftcolalign">Email *</label>

         <input id="email" class="rightcolalign" name="email" value='<?php echo $r['email']; ?>''/>

      </p>

      <p class="fieldSpacing">

         <label for="selector" class="leftcolalign">What am I? *</label>

         <input id="entButton" class="radioalign" type="radio" name="selector" value="entrepreneur"<?php echo $r['entrepreneur']; ?>/>

         <label for="entrepreneur" id="entrepreneur">Entrepreneur</label>

         <input id="invButton" class="radioalign" type="radio" name="selector" value="investor"<?php echo $r['investor']; ?>/>

         <label for="investor" id="investor">Investor</label>

      </p>

   </fieldset>

   <fieldset id="entForm">

      <p class="fieldSpacing">

         <label for="companyname" class="leftcolalign">Company Name: *</label>

         <input id="companyname" class="rightcolalign" name="companyname" value='<?php echo $r['companyname']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="companywebsite" class="leftcolalign">Company Website:</label>

         <input id="companywebsite" class="rightcolalign" name="companywebsite" value='<?php echo $r['companywebsite']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="founder" class="leftcolalign">Founder(s): *</label>

         <input id="founder" class="rightcolalign" name="founder" value='<?php echo $r['founder']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="phone" class="leftcolalign">Phone Number(s): *</label>

         <input id="phone" class="rightcolalign" name="phone" value='<?php echo $r['phone']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="address" class="leftcolalign">Address: *</label>

         <input id="address" class="rightcolalign" name="address" value='<?php echo $r['address']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="city" class="leftcolalign">City: *</label>

         <input id="city" class="rightcolalign" name="city" value='<?php echo $r['city']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="state" class="leftcolalign">State:</label>

         <input id="state" class="rightcolalign" name="state" value='<?php echo $r['state']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="zipcode" class="leftcolalign">Zip Code:</label>

         <input id="zipcode" class="rightcolalign" name="zipcode" value='<?php echo $r['zipcode']; ?>'/>

      </p>

Hello!

I am designing a user registration form which has some radio buttons for people to select. I am confused as to how I should store the value selected by the user into the database.

Here is my code, just in case.
<li id="li_2" >
<label class="description" for="element_2">I am a  </label>
<span>
<input id="element_2_1" name="element_2" class="element radio" type="radio" value="1" />
<label class="choice" for="element_2_1">Student</label>
<input id="element_2_2" name="element_2" class="element radio" type="radio" value="2" />
<label class="choice" for="element_2_2">Staff</label>
<input id="element_2_3" name="element_2" class="element radio" type="radio" value="3" />
<label class="choice" for="element_2_3">Member</label>
<input id="element_2_4" name="element_2" class="element radio" type="radio" value="4" />
<label class="choice" for="element_2_4">Other</label>
</span>
</li>   

hello friend,

I use these code for update my database with radio button checked or unchecked through array but my code could not update the server data please help me :::

my code is :::

<?php
                            //include configuration file for connection
                            include_once('config.php');
                            $sql = "select * from ATTENDANCE";
                            $result=mysql_query($sql);
                            $count=mysql_num_rows($result);
                         ?>
                         <form name="form1" method="post" action="<? echo $_SERVER['REQUEST_URI']; ?>">
                            <table style="text-align: left; padding: 5px;" cellpadding="0px" cellspacing="0px">
                           <tbody>
                              <tr>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student ID</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Name</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Present</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Absent</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Comment</th>
                              </tr>
                              <?php
                                 while($rows=mysql_fetch_array($result))
                                 {
                              ?>                                                   
                              <tr>
                                 <td class="table1">
                                    <? $id[] = $rows['STUDENT_ID']; ?><? echo $rows['STUDENT_ID']; ?>
                                 </td>
                                 <td class="table1">
                                    <? echo $rows['STUDENT_NAME']; ?>
                                 </td>                                                      
                                 <td id="present">
                                    <input type="radio" name="present<? echo $rows['STUDENT_ID']; ?>" checked="checked" value="PRESENT">Present            
                                 </td>
                                 <td id="absent">                                    
                                    <input type="radio" name="present<? echo $rows['STUDENT_ID']; ?>" value="ABSENT">Absent
                                 </td>                              
                                 <td style="text-align: left; padding: 5px; border: 1px #000000 solid; height: 33px;">
                                    <? echo $rows['COMMENT']; ?>
                                 </td>                                                   
                              </tr>
                              <?php }?>
                              <tr>
                                 <td colspan="5" style="vertical-align:middle; text-align: center;"><br><br>
                                    <input id="Submit" type="submit" name="Submit" value="Submit" style="text-align: center; background-color: #000000; color: #ffffff; border: 1px #000000 solid;">
                                 </td>
                              </tr>                                                                                 
                           </tbody>
                        </table>
                     </form>   
                     <?php
                        if($_POST['$Submit'])
                        {
                           foreach($_POST['STUDENT_ID'] as $id)
                           {                               
                              $sql = "UPDATE ATTENDANCE SET STUDENT_PRESENT = '".$_POST["present".$id]."' WHERE STUDENT_ID = '".$id."' ";
                              $result = mysql_query($sql);
                           }
                        }
                        if($result)
                        {    print_r ($_POST);                        
                           header("location:report.php");                           
                        }
                        else
                        {
                           echo "Your entry is not completed at this time.............";
                        }
                     ?>

Hey in my edit page i have 2 radio buttons in my form and i need to make sure the same value is still selected how can i do that?

thanks