Forum Moderators: coopster
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<title>eol</title>
<head><link href="../common_css/eol.css" rel="stylesheet" type="text/css" media ="screen">
</head>
<body>
<?php
$link = mysql_connect('localhost', 'EOL', 'RK1RK1')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('EOL') or die('Could not select database');
mysql_query($query);
$query = "INSERT INTO EOL VALUES ($_POST'assettag')";
?>
<div class="con">
<div class="banbox">new record</div>
<div class="navbox">
<a href="/eol/cser_home.php">home</a> 
<a href="/eol/cser_allrec.php">allrecords</a> 
<a href="/eol/cser_search.php">search</a> 
<a href="/eol/cser_inser.php">new record</a> 
</div>
<div class="footerbox"></div>
<div class="datcon">
<form name ="form1" method="post">
<div class="formbox1">asset tag # <input type="text"
name="assettag" action=" "></div>
<div class="formbox1">serial #  <input type="text" name="assettag" action=" "></div>
<div class="formbox1">location  <input type="text" name="assettag" action=" "></div>
<div class="formbox1">department  <input type="text" name="assettag" action=" "></div>
<div class="formbox1">office  <input type="text" name="assettag" action=" "></div>
<div class="textformbox">issues  <textarea rows="1" cols="13"></textarea></div>
<div class="formbox1">collected?   yes <input type="checkbox" name="assettag"></div>
<div class="buttbox">
<INPUT TYPE="image" SRC="../common_images/insert.jpg" VALUE="Submit" name = "submit">
</form>
<a href="search.php"><img border="0" src="../common_images/bak.jpg"></a>
<a href="search.php"><img border="0" src="../common_images/can.jpg"></a>
</div>
</div>
</div>
</body>
</html>
First, you need to define your
$querySecond, note the correct
$_POSTThird, it's a good idea to assign a
$_POST<?php$link = mysql_connect('localhost', 'EOL', 'RK1RK1') or die('Could not connect: ' . mysql_error());echo 'Connected successfully';mysql_select_db('EOL') or die('Could not select database');$assettag=[b]$_POST['assettag'][/b];$query = "INSERT INTO EOL VALUES ('$assettag')";mysql_query($query);?>
