I’m having a problem making a database and a table. The code I have works, but I am getting warnings that the variables have not been initialzsed. I commented that part of the code out after I created everything and it works fine. It does need to be in there since what I am writing will be used by someone that is not familiar with this type of code.
Here is the code, Please help!:
[php]
<?php /* $time = time(); $con = mysql_connect("localhost","root","ka3pmw"); mysql_query("CREATE DATABASE my_setup",$con); mysql_select_db("my_setup", $con); $sql= "CREATE TABLE myinfo (id INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(id),dupe varchar(10),band varchar(5),mode varchar(5),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 varchar(10),cata varchar(10),pow varchar(10),xmit varchar(10),cscore varchar(30),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 varchar(10), cb varchar(30),class varchar(10),logrstsnd varchar(1),logrstrcv varchar(1),logsect varchar(1),logclass varchar(1),logzone varchar(1),logregion varchar(1),loggrid varchar(1),logdate varchar(1),logtime varchar(1) )"; mysql_query($sql,$con); mysql_close($con); $con = mysql_connect("localhost","root","ka3pmw"); mysql_select_db("my_setup", $con); $sql = ("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]')"); if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con); */ // Make a MySQL Connection $con = mysql_connect("localhost", "root", "ka3pmw") or die(mysql_error()); mysql_select_db("my_setup", $con) or die(mysql_error()); // Get a specific result from the "example" table $result = mysql_query("SELECT * FROM myinfo") or die(mysql_error()); // get the first (and hopefully only) entry from the result $row = mysql_fetch_object( $result ); ?> KA3PMW Logger Setup KA3PMW Logger V 3.0
General Setup
<label> KA3PMW Logger V 3.0 </label><input type="text" name="cb" id="cb" value="KA3PMW Logger V 3.0 " size="30" />
<label> UTC Offset: </label><input type="text" name="utc" value="<?php echo $row->utc; ?>" size="3" />
<label> 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> 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> My Call: </label><input type="text" name="mycall" value="<?php echo $row->mycall; ?>" size="10" />
<label> ARRL Sect: </label><input type="text" name="sect" value="<?php echo $row->sect; ?>" size="6" />
<br/><br />
<label> Class: </label><input type="text" name="class" value="<?php echo $row->class; ?>" size="10" />
<label> ITU Zone: </label><input type="text" name="zone" value="<?php echo $row->zone; ?>" size="4" />
<label> ITU Region: </label><input type="text" name="region" value="<?php echo $row->region; ?>" size="4" />
<label> Grid: </label><input type="text" name="grid" value="<?php echo $row->grid; ?>" size="10" />
<label> Contest: </label><input type="text" name="contest" value="<?php echo $row->contest; ?>" size="25" />
<label> Log Name: </label><input type="text" name="logname" value="<?php echo $row->logname; ?>" size="12" />
<br/><br />
<label> Cross Mode: </label><input type="text" name="CM" value="<?php echo $row->CM; ?>" size="12" />
<label> Transmitter # (0 or 1): </label><input type="text" name="tn" value="<?php echo $row->tn; ?>" size="1" />
<label> # 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> 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> 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> # 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> 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> Claimed Score: </label><input type="text" name="cscore" value="<?php echo $row->cscore; ?>" size="7" />
<Label> 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> Club Name: </label><input type="text" name="club" value="<?php echo $row->club; ?>" size="30" />
<br /><br />
<label> Email: </label><input type="text" name="email" value="<?php echo $row->email; ?>" size="30" />
<label> Name: </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>