php - Post from HTML form to DB getting UNDEFINED INDEX error -
i have html form formatted using css.
<form action="wwinsert.php" method="post"> <fieldset> <legend>weekly work</legend> <p><label class="lab1" for="storenumber">store:</label><input type="text" name="storenumber" class="textbox-300"></p> <p><label class="lab1" for="weekendingdate">week ending:</label><input type="date" name="weekendingdate" class="textbox-300"></p> <p><label class="lab1" for="actualsales">actual sales:</label><input type="number" name="actualsales" class="textbox-300"></p> <p><label class="lab1" for="salesonlastyear">sales% on last year:</label><input type="number" name="salesonlastyear" class="textbox-300"></p> <p><label class="lab1" for="projectedsales">projected sales:</label><input type="number" name="projectedsales" class="textbox-300"></p> <p><label class="lab1" for="salesvsprojections">sales% vs projections:</label><input type="number" name="salesvsprojections" class="textbox-300"></p> <p><label class="lab1" for="guestcount">guest count:</label><input type="number" name="guestcount" class="textbox-300"></p> <p><label class="lab1" for="guestcountvslastyear">guest count % vs last year:</label><input type="number" name="guestcountvslastyear" class="textbox-300"></p> <p><label class="lab1" for="actuallabour">actual labour:</label><input type="number" name="actuallabour" class="textbox-300"></p> <p><label class="lab1" for="projectedlabour">projected labour:</label><input type="number" name="projectedlabour" class="textbox-300"></p> <p><label class="lab1" for="basefoodcost">base food cost:</label><input type="number" name="basefoodcost" class="textbox-300"></p> <p><label class="lab1" for="actualfoodcost">actual food cost:</label><input type="number" name="actualfoodcost" class="textbox-300"></p> <p><label class="lab1" for="fullwaste">full waste %:</label><input type="number" name="fullwaste" class="textbox-300"></p> <p><label class="lab1" for="rawwaste">raw waste %:</label><input type="number" name="rawwaste" class="textbox-300"></p> <p><label class="lab1" for="emeals">e-meals %:</label><input type="number" name="emeals" class="textbox-300"></p> <p><label class="lab1" for="promo">promo %:</label><input type="number" name="promo" class="textbox-300"></p> <p><label class="lab1" for="nonrecipe">non recipe %:</label><input type="number" name="nonrecipe" class="textbox-300"></p> <p><label class="lab1" for="deviation">deviation %:</label><input type="number" name="deviation" class="textbox-300"></p> <p><label class="lab1" for="fryyield">fry yield:</label><input type="number" name="fryyeild" class="textbox-300"></p> <p><label class="lab1" for="lettuceyield">lettuce yield:</label><input type="number" name="lettuceyeild" class="textbox-300"></p> <p><label class="lab1" for="sundaeyield">sundae yield:</label><input type="number" name="sundaeyeild" class="textbox-300"></p> <p><label class="lab1" for="shakeyield">shake yield:</label><input type="number" name="shakeyeild" class="textbox-300"></p> <p><label class="lab1" for="cash">cash +/-:</label><input type="number" name="cash+/-" class="textbox-300"></p> <p><label class="lab1" for="numberoftotalrefunds">number of total refunds:</label><input type="number" name="numberoftotalrefunds" class="textbox-300"></p> <p><label class="lab1" for="refundstotal">refunds total:</label><input type="number" name="refundstotal" class="textbox-300"></p> <p><label class="lab1" for="tredsbeforetotal">t/reds before total:</label><input type="number" name="t/redsbeforetotal" class="textbox-300"></p> <p><label class="lab1" for="tredsbeforetotalvalue">t/reds before total pounds:</label><input type="number" name="tredsbeforetotalvalue" class="textbox-300"></p> <p><label class="lab1" for="weeklykwusage">weekly kw usage:</label><input type="number" name="weeklykwusage" class="textbox-300"></p> <p><label class="lab1" for="energycost">energy cost:</label><input type="number" name="energycost" class="textbox-300"></p> <p><label class="lab1" for="trainingauditdate">training audit date:</label><input type="date" name="trainingauditdate" class="textbox-300"></p> <p><label class="lab1" for="trainingauditscore">training audit score:</label><input type="number" name="trainingauditscore" class="textbox-300"></p> <p><label class="lab2" for="plprojectedsales">p&l projected sales:</label><input type="number" name="p&lprojectedsales" class="textbox-300"></p> <p><label class="lab2" for="plprojectedlabour">p&l projected labour:</label><input type="number" name="p&lprojectedlabour" class="textbox-300"></p> <p><label class="lab2" for="plprojectedfoodcost">p&l projected food cost:</label><input type="number" name="p&lprojectedfoodcost" class="textbox-300"></p> <p><label class="lab3" for="monthlyactualsales">monthly actual sales:</label><input type="number" name="monthlyactualsales" class="textbox-300"></p> <p><label class="lab3" for="monthlysalesonlastyear">monthly sales% on last year:</label><input type="number" name="monthlysales%onlastyear" class="textbox-300"></p> <p><label class="lab3" for="monthlyactuallabour">monthly actual labour:</label><input type="number" name="monthlyactuallabour" class="textbox-300"></p> <p><label class="lab3" for="monthlybasefoodcost">monthly base food cost:</label><input type="number" name="monthlybasefoodcost" class="textbox-300"></p> <p><label class="lab3" for="monthlyactualfoodcost">monthly actual food cost:</label><input type="number" name="monthlyactualfoodcost" class="textbox-300"></p> <p><label class="lab3" for="monthlycash">monthly cash +/-:</label><input type="number" name="monthlycash+/-" class="textbox-300"></p> <p><label class="lab3" for="highestbreakfasthour">highest breakfast hour:</label><input type="number" name="highestbreakfasthour" class="textbox-300"></p> <p><label class="lab3" for="highesthour">highest hour:</label><input type="number" name="highestbreakfastshift" class="textbox-300"></p> <p><label class="lab3" for="recordcars">record cars:</label><input type="number" name="highesthour" class="textbox-300"></p> <p><label class="lab3" for="drivethru">drive thru %:</label><input type="number" name="drivethru" class="textbox-300"></p> <input type="submit" value="submit"> </fieldset> </form> when complete fields , run every entry.
notice: undefined index: storenumber in c:\xampp\htdocs\toolbox\wwinsert.php on line 9
can point me in right direction on fixing error?
sorry forgot wwinsert.php code
<?php $con=mysql_connect("login details here"); $sql="insert weeklywork(storenumber, weekendingdate, actualsales, sales%onlastyear, projectedsales, sales%vsprojections, guestcount, guestcount%vslastyear, actuallabour, projectedlabour, basefoodcost, actualfoodcost, fullwaste, rawwaste, emeals, promo, nonrecipe, deviation, fryyeild, lettuceyeild, sundaeyeild, shakeyeild, cash+/-, numberoftotalrefunds, refundstotal, t/redsbeforetotal, t/redsbeforetotalvalue, weeklykwusage, energycost, trainingauditdate, trainingauditscore, plprojectedsales, plprojectedlabour, plprojectedfoodcost, monthlyactualsales, monthlysalesonlastyear, monthlyactuallabour, monthlybasefoodcost, monthlyactualfoodcost, monthlycash, highestbreakfasthour, highestbreakfastshift, highesthour, recordcarsthismonth, drivethru) values ('$_post[storenumber]','$_post[weekendingdate]','$_post[actualsales]','$_post[salesonlastyear]','$_post[projectedsales]','$_post[salesvsprojections]','$_post[guestcount]','$_post[guestcountvslastyear]','$_post[actuallabour]','$_post[projectedlabour]','$_post[basefoodcost]','$_post[actualfoodcost]','$_post[fullwaste]','$_post[rawwaste]','$_post[emeals]','$_post[promo]','$_post[nonrecipe]','$_post[deviation]','$_post[fryyeild]','$_post[lettuceyeild]','$_post[sundaeyeild]','$_post[shakeyeild]','$post[cash]','$_post[numberoftotalrefunds]','$_post[refundstotal]','$_post[tredsbeforetotal]','$_post[tredsbeforetotalvalue]','$_post[weeklykwusage]','$_post[energycost]','$_post[trainingauditdate]','$_post[trainingauditscore]','$_post[plprojectedsales]','$_post[plprojectedlabour]','$_post[plprojectedfoodcost]','$_post[monthlyactualsales]','$_post[monthlysalesonlastyear]','$_post[monthlyactuallabour]','$_post[monthlybasefoodcost]','$_post[monthlyactualfoodcost]','$_post[monthlycash]','$_post[highestbreakfasthour]','$_post[highestbreakfastshift]','$_post[highesthour]','$_post[recordcarsthismonth]','$_post[drivethru]')"; if (mysql_query($con,$sql)) { die('error: ' . mysql_error($con)); } echo "1 record added"; ?>
whether have quotes around posted data or not depends on db expecting datatype (is string or number?).
this '$_post["storenumber"]' sends storenumber string of text db, may or may not accept if db field requires integer of sort. db engine automatically interpret string number integer, you're taking chance @ either having db accept data or storing in proper format.
you should have true strings (text, varchar, etc) quoted way posted above, , have integers without external quotes $_post["storenumber"].
Comments
Post a Comment