Checkboxes values not getting saved

General PHP Help
#1

I have several checkboxes and none of them are getting saved. It has to be something simple that I am doing wrone but after a day of looking I can’t find it.

Here is the code:

<?php $dupe = 0; $band = 0; $mode = 0; $zone =" "; $sect =" "; $region =" "; $grid =" "; $utc =" "; $mycall =" "; $contest =" "; $logname =" "; $CM =" "; $tn =" "; $catop = 0; $cata = 0; $pow = 0; $xmit = 0; $cscore = 0; $club =" "; $email =" "; $name =" "; $add1 =" "; $add2 =" "; $city =" "; $state =" "; $zip =" "; $country =" "; $op1 =" "; $op2 =" "; $op3 =" "; $op4 =" "; $op5 =" "; $op6 =" "; $op7 =" "; $op8 =" "; $op9 =" "; $co = 0; $cb =" "; $class =" "; $rsts =" "; $rstr =" "; $logrstsnd = 0; $logrstrcv = 0; $logsect = 0; $logclass = 0; $logzone = 0; $logregion = 0; $loggrid = 0; $logdate = 0; $logtime = 0; $time = time(); /* $con = mysql_connect("localhost","root","ka3pmw"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_query("CREATE DATABASE my_setup",$con); mysql_select_db("my_setup", $con); mysql_query ("CREATE TABLE myinfo ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), dupe int, band int, mode int, zone varchar(10), sect varchar(5), region varchar(10), grid varchar(10), utc varchar(5), mycall varchar(10), contest varchar (30), logname varchar(10), CM varchar(10), tn varchar(2), catop int, cata int, pow int, xmit int, cscore int, club varchar(30), email varchar(30), name varchar(30), add1 varchar(45), add2 varchar(45), city varchar(30), state varchar(3), zip varchar(10), country varchar(30), op1 varchar(10), op2 varchar(10), op3 varchar(10), op4 varchar(10), op5 varchar(10), op6 varchar(10), op7 varchar(10), op8 varchar(10), op9 varchar(10), co int, cb varchar(30), class varchar(10), logrstsnd int(1) unsigned not null default '0', logrstrcv int(1) unsigned not null default '0', logsect int(1) unsigned not null default '0', logclass int(1) unsigned not null default '0', logzone int(1) unsigned not null default '0', logregion int(1) unsigned not null default '0', loggrid int(1) unsigned not null default '0', logdate int(1) unsigned not null default '0', logtime int(1) unsigned not null default '0' )"); $con = mysql_connect("localhost","root","ka3pmw"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_setup", $con) or die("Unable to select"); mysql_query ("INSERT INTO myinfo( cb,dupe,band,mode,zone,sect,region,grid,utc,mycall,contest,logname,CM,tn,catop,cata,pow,xmit,cscore,club,email,name,add1,add2,city,state,zip,country,op1,op2,op3,op4,op5,op6,op7,op8,op9,co,class,logrstsnd,logrstrcv,logsect,logclass,logzone,logregion,loggrid,logdate,logtime)VALUES('$_POST[cb]','$_POST[dupe]','$_POST[band]','$_POST[mode]','$_POST[zone]','$_POST[sect]','$_POST[region]','$_POST[grid]','$_POST[utc]','$_POST[mycall]','$_POST[contest]','$_POST[logname]','$_POST[CM]','$_POST[tn]','$_POST[catop]','$_POST[cata]','$_POST[pow]','$_POST[xmit]','$_POST[cscore]','$_POST[club]','$_POST[email]','$_POST[name]','$_POST[add1]','$_POST[add2]','$_POST[city]','$_POST[state]','$_POST[zip]','$_POST[country]','$_POST[op1]','$_POST[op2]','$_POST[op3]','$_POST[op4]','$_POST[op5]','$_POST[op6]','$_POST[op7]','$_POST[op8]','$_POST[op9]','$_POST[co]','$_POST[class]','$_POST[logrstsnd]','$_POST[logrstrcv]','$_POST[logsect]','$_POST[logclass]','$_POST[logzone]','$_POST[logregion]','$_POST[loggrid]','$_POST[logdate]','$_POST[logtime]')") or die (mysql_error()); mysql_close($con); ?>

/
/
}
else
{
$con = mysql_connect(“localhost”,“root”,“ka3pmw”);
if (!$con)
{
die('Could not connect: ’ . mysql_error());
}

mysql_select_db(“my_setup”, $con);

$result = mysql_query(“SELECT * FROM myinfo
WHERE id=‘1’”);
}
// Execute query
if($submit)
{
$con = mysql_connect(“localhost”,“root”,“ka3pmw”);
if (!$con)
{
die('Could not connect: ’ . mysql_error());
}

mysql_select_db(“my_setup”, $con) or die(“Unable to select”);
mysql_query (“INSERT INTO myinfo( cb,dupe,band,mode,zone,sect,region,grid,utc,mycall,contest,logname,CM,tn,catop,cata,pow,xmit,cscore,club,email,name,add1,add2,city,state,zip,country,op1,op2,op3,op4,op5,op6,op7,op8,op9,co,class,logrstsnd,logrstrcv,logsect,logclass,logzone,logregion,loggrid,logdate,logtime)VALUES(’$_POST[cb]’,’$_POST[dupe]’,’$_POST[band]’,’$_POST[mode]’,’$_POST[zone]’,’$_POST[sect]’,’$_POST[region]’,’$_POST[grid]’,’$_POST[utc]’,’$_POST[mycall]’,’$_POST[contest]’,’$_POST[logname]’,’$_POST[CM]’,’$_POST[tn]’,’$_POST[catop]’,’$_POST[cata]’,’$_POST[pow]’,’$_POST[xmit]’,’$_POST[cscore]’,’$_POST[club]’,’$_POST[email]’,’$_POST[name]’,’$_POST[add1]’,’$_POST[add2]’,’$_POST[city]’,’$_POST[state]’,’$_POST[zip]’,’$_POST[country]’,’$_POST[op1]’,’$_POST[op2]’,’$_POST[op3]’,’$_POST[op4]’,’$_POST[op5]’,’$_POST[op6]’,’$_POST[op7]’,’$_POST[op8]’,’$_POST[op9]’,’$_POST[co]’,’$_POST[class]’,’$_POST[logrstsnd]’,’$_POST[logrstrcv]’,’$_POST[logsect]’,’$_POST[logclass]’,’$_POST[logzone]’,’$_POST[logregion]’,’$_POST[loggrid]’,’$_POST[logdate]’,’$_POST[logtime]’)WHERE id=‘1’”) or die (mysql_error());
mysql_close($con);
}

?>
*/

// Make a MySQL Connection
mysql_connect(“localhost”, “root”, “ka3pmw”) or die(mysql_error());
mysql_select_db(“my_setup”) or die(mysql_error());

// Get a specific result from the “example” table
$result = mysql_query(“SELECT * FROM myinfo WHERE id=‘1’”) or die(mysql_error());
// get the first (and hopefully only) entry from the result
$row = mysql_fetch_object( $result );
/* This is an example of what one input in your phone will look like*/

?>

KA3PMW Logger Setup

 KA3PMW Logger V 3.0
General Setup

    <label>&nbsp;KA3PMW Logger V 3.0 </label><input type="text" name="cb" id="cb" value="KA3PMW Logger V 3.0 " size="30" /> 
    <label>&nbsp;&nbsp;&nbsp;&nbsp;UTC Offset:&nbsp;</label><input type="text" name="utc" value="<?php echo $row->utc; ?>" size="3" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Band:
            <select name="band" id="band">               
            <option value="<?php echo $row->band; ?>"><?php echo $row->band; ?></option>                              
            <option value=" ">    </option>        	
            <option value="All">ALL</option>            
            <option value="160M">160M</option>            
            <option value="80M">80M</option>            
            <option value="40M">40M</option>            
            <option value="20m">20M</option>            
            <option value="15m">15M</option>	    
            <option value="10M">10M</option>          
            </select></label>
     <label>&nbsp;&nbsp;&nbsp;&nbsp;Mode:
     <select name="mode" id="mode">         
            <option value="<?php echo $row->mode; ?>"><?php echo $row->mode; ?></option>                
    	<option value=" ">     </option>
    	<option value="CW">CW</option>
        <option value="SSB">SSB</option>
        <option value="RTTY">RTTY</option>
        <option value="PSK">PSK</option>
        <option value="SSTV">SSTV</option>
       </select></label>
    <label>&nbsp;&nbsp;&nbsp;&nbsp;My Call:&nbsp;</label><input type="text" name="mycall" value="<?php echo $row->mycall; ?>" size="10" /> 
    <label>&nbsp;&nbsp;&nbsp;&nbsp;ARRL Sect:&nbsp;</label><input type="text" name="sect" value="<?php echo $row->sect; ?>" size="6" />
     <br/><br /> 
    <label>&nbsp;Class:&nbsp;</label><input type="text" name="class" value="<?php echo $row->class; ?>" size="10" /> 
    <label>&nbsp;&nbsp;&nbsp;&nbsp;ITU Zone:&nbsp;</label><input type="text" name="zone" value="<?php echo $row->zone; ?>" size="4" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;ITU Region:&nbsp;</label><input type="text" name="region" value="<?php echo $row->region; ?>" size="4" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Grid:&nbsp;</label><input type="text" name="grid" value="<?php echo $row->grid; ?>" size="10" />
	<label>&nbsp;&nbsp;&nbsp;&nbsp;Contest:&nbsp;</label><input type="text" name="contest" value="<?php echo $row->contest; ?>" size="25" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Log Name:&nbsp;</label><input type="text" name="logname" value="<?php echo $row->logname; ?>" size="12" />
    <br/><br />
    <label>&nbsp;Cross Mode:&nbsp;</label><input type="text" name="CM" value="<?php echo $row->CM; ?>" size="12" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Transmitter # (0 or 1):&nbsp;</label><input type="text" name="tn" value="<?php echo $row->tn; ?>" size="1" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;# Operators:
    <select name="catop" id="catop">        
            <option value="<?php echo $row->catop; ?>"><?php echo $row->catop; ?></option>             
		<option value=" ">  </option>
        <option value="Single-Op">Single-Op</option>
        <option value="Multi-Op">Multi-Op</option>
        <option value="Checklog">Checklog</option>
   	 </select></label> 
     <Label>&nbsp;Assisted:
        <select name="cata" id="cata">
        <option value="<?php echo $row->cata; ?>"><?php echo $row->cata; ?></option>
        <option value=" ">       </option>
        <option value="1">Un-Assisted</option>
        <option value="2">Assisted</option>
        </select></Label>
     <Label>&nbsp;&nbsp;&nbsp;&nbsp;Power:
       <select name="pow" id="pow">
       <option value="<?php echo $row->pow; ?>"><?php echo $row->pow; ?></option>
        <option value="0">   </option>
        <option value="QRP">QRP</option>
        <option value="Low">Low</option>
        <option value="High">High</option>
       </select></Label>
        <br /><br />
     <label>&nbsp;# Overlay:
    	<select name="co" id="co">
        <option value="<?php echo $row->co; ?>"><?php echo $row->co; ?></option>
        <option value=" ">        </option>
        <option value="ROOKIE">ROOKIE </option>
        <option value="TB-WIRES">TB-WIRES </option>
        <option value="NOVICE-TECH">NOVICE-TECH</option>
        <option value="OVER-50">OVER-50</option>
       </select></label>
     <Label>&nbsp;&nbsp;&nbsp;&nbsp;Transmitters: 
        <select name="xmit" id="xmit">
        <option value="<?php echo $row->xmit; ?>"><?php echo $row->xmit; ?></option>
        <option value=" ">    </option>
        <option value="One">One</option>
        <option value="Two">Two</option>
        <option value="Unlimited">Unlimited</option>
        </select> </Label> 
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Claimed Score:&nbsp;</label><input type="text" name="cscore" value="<?php echo $row->cscore; ?>" size="7" />
     <Label>&nbsp;&nbsp;&nbsp;&nbsp;Dupes: 
        <select name="dupe" id="dupe">
        <option value="<?php echo $row->dupe; ?>"><?php echo $row->dupe; ?></option>
        <option value=" ">    </option>
        <option value="Don't Allow">Don't Allow</option>
        <option value="Warn Only">Warn Only</option>
        <option value="Warn and Allow">Warn and Allow</option>
        </select></Label>  
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Club Name:&nbsp;</label><input type="text" name="club" value="<?php echo $row->club; ?>" size="30" />
     <br /><br />
    <label> &nbsp;Email:&nbsp;</label><input type="text" name="email" value="<?php echo $row->email; ?>" size="30" />
    <label>&nbsp;&nbsp;&nbsp;&nbsp;Name:&nbsp;</label><input type="text" name="name" value="<?php echo $row->name; ?>" size="30" />

    Address 1: 



 Address 2: 
    City: 
 State-Province: 
    Postal Code: 



 Country: 



 Operator 1: 
 Operator 2: 
 Operator 3: 
 Operator 4: 
 Operator 5: 
 Operator 6: 


 Operator 7: 
 Operator 8: 
 Operator 9: 


Fields You Want To Log



    RST Send: 
    RST Get: 
    ARRL Sect: 
    Class: 
    ITU Zone: 
    ITU Region: 
    Grid: 
    Date: 
    Time: 




<?php
$con = mysql_connect(“localhost”,“root”,“ka3pmw”);
if (!$con)
{
die('Could not connect: ’ . mysql_error());
}
$db = mysql_select_db(‘my_setup’, $con);
if (!$db) {
die ('Can not select : ’ . mysql_error());
}

mysql_query(“UPDATE myinfo SET cb=’$_POST[cb]’,dupe=’$_POST[dupe]’,band=’$_POST[band]’,mode=’$_POST[mode]’,zone=’$_POST[zone]’,sect=’$_POST[sect]’,region=’$_POST[region]’,grid=’$_POST[grid]’,utc=’$_POST[utc]’,mycall=’$_POST[mycall]’,contest=’$_POST[contest]’,logname=’$_POST[logname]’,CM=’$_POST[CM]’,tn=’$_POST[tn]’,catop=’$_POST[catop]’,cata=’$_POST[cata]’,pow=’$_POST[pow]’,xmit=’$_POST[xmit]’,cscore=’$_POST[cscore]’,club=’$_POST[club]’,email=’$_POST[email]’,name=’$_POST[name]’,add1=’$_POST[add1]’,add2=’$_POST[add2]’,city=’$_POST[city]’,state=’$_POST[state]’,zip=’$_POST[zip]’,country=’$_POST[country]’,op1=’$_POST[op1]’,op2=’$_POST[op2]’,op3=’$_POST[op3]’,op4=’$_POST[op4]’,op5=’$_POST[op5]’,op6=’$_POST[op6]’,op7=’$_POST[op7]’,op8=’$_POST[op8]’,op9=’$_POST[op9]’,co=’$_POST[co]’,class=’$_POST[class]’,logrstsnd=’$_POST[logrstsnd]’,logrstrcv=’$_POST[logrstrcv]’,logsect=’$_POST[logsect]’,logclass=’$_POST[logclass]’,logzone=’$_POST[logzone]’,logregion=’$_POST[logregion]’,loggrid=’$_POST[loggrid]’,logdate=’$_POST[logdate]’,logtime=’$_POST[logtime]’
WHERE id=‘1’”);

mysql_close($con);

?>

	</center></div></form>
[php] [/php]
#2

I don’t see any $_POST values for one. I’m assuming this is your UPDATE page and not your ADD NEW page? If it’s for adding a new record I only see mysql_query("UPDATE myinfo SET as opposed to INSERT INTO.

Just guessing

$zone =" “;
$sect =” “;
$region =” “;
$grid =” ";

should be

$zone =$_POST[‘zone’];
$sect =$_POST[‘sect’];
$region =$_POST[‘region’];
$grid =$_POST[‘grid’];

#3

That’s right. At the start those were there to prevent it from erroring not founds all over the place.
The $_POST statement does have them in it and is located just below the checkboxes. You are right. there is supposed to be onlt 1 record in that database so it would be update.

That it a configuration database and will always have only 1 record.

Any ideas??

#4

OK, since apparently checkbox values can not be saved, I changed them to text and it works well enough to do what I want.

Thanks

Sponsor our Newsletter | Privacy Policy | Terms of Service