I have a customer (local cigarette shop) that needs a DB driven site to keep customer blend info. I figured it would be a great opportunity to learn PHP / mySQL. I'm in over my head. I know more than you avg Joe about HTML. but it's been years!!
i set up the tables in mySQL (ver. 5.1.47) on my test server using PHPmySQL
using Dw i have this :
<!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>Customer Submit</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="212">
<tr>
<td width="204"><div align="center"> <u>Customer Info:</u>
<table width="200">
<tr>
<td width="48"><div align="right">First:</div></td>
<td width="140"><input name="name_first" type="text" id="name_first" value="" /></td>
</tr>
<tr>
<td><div align="right">Last: </div></td>
<td><input type="text" name="name_last" id="name_last" /></td>
</tr>
</table>
</div>
<div align="center"> <u>Tube Style: </u>
<table width="86">
<tr>
<td width="78"><label>
<input type="checkbox" name="tube_type" value="regular" id="tube_type_0" />
Regular
</label></td>
</tr>
<tr>
<td><label>
<input type="checkbox" name="tube_type" value="menthol" id="tube_type_1" />
Menthol
</label></td>
</tr>
<tr>
<td><label>
<input type="checkbox" name="tube_type" value="light" id="tube_type_2" />
Light
</label></td>
</tr>
</table>
</div>
<div align="center">
<p><u>Blend Info:</u></p>
<table width="194">
<tr>
<td width="18"><input name="weight_1" type="text" id="weight_1" size="3" maxlength="5" /></td>
<td width="14">oz</td>
<td width="146"><input name="blend_1" type="text" id="blend_1" size="25" /></td>
</tr>
<tr>
<td><input name="weight_2" type="text" id="weight_2" size="3" maxlength="5" /></td>
<td>oz</td>
<td><input name="blend_2" type="text" id="blend_2" size="25" maxlength="30" /></td>
</tr>
<tr>
<td><input name="weight_3" type="text" id="weight_3" size="3" maxlength="5" /></td>
<td>oz</td>
<td><input name="blend_3" type="text" id="blend_3" size="25" /></td>
</tr>
</table>
</div></td>
</tr>
</table>
<br>
<table width="200">
<tr>
<td><input type="reset" name="reset" id="reset" value="Reset" /></td>
<td><div align="right">
<input type="submit" name="submit" id="submit" value="Submit" />
</div></td>
</tr>
</table>
<p>
<label> </label>
</p>
</form>
</body>
</html>
how do i submit this info into the DB table?
or direct me to a tut thats easy to follow...
Thanks ~DK
