aophp Posted December 14, 2009 Share Posted December 14, 2009 I am trying to submit the following form data to a My SQL database, I have it sent to submit to an email in this example. 1. How do I do I submit it to a My SQL database. 2. I am having trouble getting the js stuff to submit even to my email Any help would be greatly appreciated. <html> <head> <title>Planting</title> <h><b><font size="5">Lippy Brothers Inc. Planting Record</font></b> </h><br /><br /> <SCRIPT LANGUAGE="JavaScript" SRC="CalendarPopup.js"></SCRIPT> <SCRIPT LANGUAGE="JavaScript"> var cal = new CalendarPopup(); </SCRIPT> </head> <body> <form name="planting" method="post" action="mailto:adam@lippybrothersinc.com"> <b>Date:</b> <INPUT TYPE="text" NAME="date" VALUE="" SIZE=25> <A HREF="#" onClick="cal.select(document.forms['planting'].date1,'anchor1','MM/dd/yyyy'); return false;" NAME="anchor1" ID="anchor1">select</A><br /><br /> <b>Employee:</b> <select name="employee"> <option value="Wes">Wes</option> <option value="Adam">Adam</option> <option value="Marshall">Marshall</option></select><br /><br /> <b>Farm:</b> <select name="farm" > <option value="Bauerlein">Bauerlein</option> <option value="Boog">Boog</option> <option value="Boring">Boring</option></select><br /><br /> <b>Crop:</b><br /> <script type="text/javascript"> function change(arr) { var el = document.getElementById('variety'); el.options.length = 0; for(var i = 0; i< arr.length; i++ ) { el.options[el.options.length] = new Option( arr[i], arr[i]); } } </script> <label for="r0">Corn </label><input type="radio" name="rad" id="r0" onclick='change(["P35F44", "DK6544", "P33N58"]) '><br /> <label for="r1">Soybeans </label><input type="radio" name="rad" id="r1" onclick='change(["AG3905", "AG2802", "P93M61"]) '><br /> <label for="r2">Wheat </label><input type="radio" name="rad" id="r2" onclick='change(["P25R56", "P25R39", "P25R78"]) '><br /> <label for="r3">Barley </label><input type="radio" name="rad" id="r3" onclick='change(["Thoroughbred", "Price", "Barsoy"]) '><br /> <label for="r4">Snapbeans </label><input type="radio" name="rad" id="r4" onclick='change(["Titan", "Envy", "Labrador"]) '><br /><br /> <b>Variety:</b><br /> <select id="variety"></select><br /><br /> <b>Seeding Rate:</b> <INPUT TYPE="text" NAME="seedingrate" VALUE="" SIZE=5><br /><br /> <b>Units:</b><br /> lbs/acre:<input type="radio" value="lbs" name="units"> plants/acre:<input type="radio" value="plants" name="units"><br /><br /> <b>Field Conditions:</b><br /> Excessively Wet:<input type="radio" value="excessively wet" name="fc"> Wet:<input type="radio" value="wet" name="fc"> Optimum:<input type="radio" value="optimumt" name="fc"> Dry:<input type="radio" value="dry" name="fc"> Excessively Dry:<input type="radio" value="excessively dry" name="fc"><br /><br /> <b>Total Planter Acreage:</b> <INPUT TYPE="text" NAME="tpacre" VALUE="" SIZE=5><br /><br /> <b>Total Map Acreage:</b> <INPUT TYPE="text" NAME="tmacre" VALUE="" SIZE=5><br /><br /> <b>Comments:</b><br /> <textarea rows="5" cols="20" wrap="physical" name="comments"> </textarea><br /><br /> <input type="submit" value="Email"><br /><br /> </form> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/185131-need-help-with-form-mysql-and-javascript/ Share on other sites More sharing options...
Brian W Posted December 14, 2009 Share Posted December 14, 2009 Please use code tags... if you don't know what that is, you need to read the forum rules before posting. Quote Link to comment https://forums.phpfreaks.com/topic/185131-need-help-with-form-mysql-and-javascript/#findComment-977253 Share on other sites More sharing options...
fenway Posted December 15, 2009 Share Posted December 15, 2009 You'll need a php script to do the work. Quote Link to comment https://forums.phpfreaks.com/topic/185131-need-help-with-form-mysql-and-javascript/#findComment-977935 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.