| | |
how to receive data from html form...?
Please support our HTML and CSS advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
well i have been doing quite lot a research on web stuff (still naive)
i have got various templates for my site and then finally a seminar form which i have downloaded from http://www.wufoo.com
now i want to accept the data entered from the form and store it in my database. i have no idea on how to proceed on that.
i would be glad if you guys can help me out.
i have got various templates for my site and then finally a seminar form which i have downloaded from http://www.wufoo.com
now i want to accept the data entered from the form and store it in my database. i have no idea on how to proceed on that.
i would be glad if you guys can help me out.
<?php
$data = $_POST['data'];
if(empty($data)) {
echo "byte me" ; }
?>
$data = $_POST['data'];
if(empty($data)) {
echo "byte me" ; }
?>
•
•
Join Date: Apr 2009
Posts: 27
Reputation:
Solved Threads: 1
•
•
•
•
well i have been doing quite lot a research on web stuff (still naive)
i have got various templates for my site and then finally a seminar form which i have downloaded from http://www.wufoo.com
now i want to accept the data entered from the form and store it in my database. i have no idea on how to proceed on that.
i would be glad if you guys can help me out.
You are going to have to establish a connection from your MySQL database to your HTML form using a scripting language. Personally i recommend PHP but you can use ASP, ASP.Net...whatever is easiest for you.
If you choose PHP you create a connection string like this:
$dbc = mysqli_connect('IP address of location of MySQL database', 'Usernam', 'Password', 'Database Name')
or die('Error connecting to MySQL server.');Once you have that written you need to write a query string that inserts data into the database such as this:
$query = "INSERT INTO email_list (first_name, last_name, email) VALUES ('$first_name', '$last_name', '$email')";Hope this helps
•
•
Join Date: Apr 2009
Posts: 27
Reputation:
Solved Threads: 1
•
•
•
•
well i am supposed to write this in the script file of the form which i got ..? if yes then where am i supposed to write ( i guess it follows some structure or pattern of witting ) .
tags.
so you would have in your index.html or whatever file
HTML and CSS Syntax (Toggle Plain Text)
<html> <body> <?php ?> <form> </form> </body> </html>
This would be a lot easier if you would post your code
Another thing that you can do is just do a simple form email system.
Or just host the page.
For a form though, you can POST or GET data. POSTing data sends it through the connection, and GETting data sends it through the url.
POSTs are much better for larger amounts of data.
Forms typically use the name attribute to send data to the server with the name attribute for that element.
Take note that the database accessed by PHP is on the server, not your computer, so you'll need to view it on the server somehow. (using your PHP program or a prebuilt one like phpmyadmin)
Remember to validate and filter your input so the database (or your webserver), isn't hacked.
Or just host the page.
For a form though, you can POST or GET data. POSTing data sends it through the connection, and GETting data sends it through the url.
POSTs are much better for larger amounts of data.
Forms typically use the name attribute to send data to the server with the name attribute for that element.
Take note that the database accessed by PHP is on the server, not your computer, so you'll need to view it on the server somehow. (using your PHP program or a prebuilt one like phpmyadmin)
Remember to validate and filter your input so the database (or your webserver), isn't hacked.
well here is the code
well the code is not written by me , as i have said it before i have taken it from the website wufoo.com so it also contains css and other image stuffs.(i guess that doesnt matter )
>-codejoust :
well the website i have to develop , will have to cater both displaying the database (for members for which i have created a login page ) and
accept the data to store it in mysql .
HTML and CSS Syntax (Toggle Plain Text)
<!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> <title> Seminar Form </title> <!-- Meta Tags --> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <!-- CSS --> <link rel="stylesheet" href="css/structure.css" type="text/css" /> <link rel="stylesheet" href="css/form.css" type="text/css" /> <!-- JavaScript --> <script type="text/javascript" src="scripts/wufoo.js"></script> </head> <body id="public"> <img id="top" src="images/top.png" alt="" /> <div id="container"> <h1 id="logo"><a>Wufoo</a></h1> <form id="form71" name="form71" class="wufoo topLabel" autocomplete="off" enctype="multipart/form-data" method="post" action="#public"> <div class="info"> <h2>Seminar Form</h2> <div>Please fill in the details for registration</div> </div> <ul> <li id="foli0" class=" "> <label class="desc" id="title0" for="Field0"> Name </label> <span> <input id="Field0" name="Field0" type="text" class="field text" value="" size="8" tabindex="1" /> <label for="Field0">First</label> </span> <span> <input id="Field1" name="Field1" type="text" class="field text" value="" size="14" tabindex="2" /> <label for="Field1">Last</label> </span> </li> <li id="foli2" class=" "> <label class="desc" id="title2" for="Field2"> Position </label> <div> <input id="Field2" name="Field2" type="text" class="field text medium" value="" maxlength="255" tabindex="3" /> </div> </li> <li id="foli3" class=" "> <label class="desc" id="title3" for="Field3"> Home Institution </label> <div> <input id="Field3" name="Field3" type="text" class="field text medium" value="" maxlength="255" tabindex="4" /> </div> </li> <li id="foli4" class=" "> <label class="desc" id="title4" for="Field4"> </label> <div> <input id="Field4" name="Field4" type="text" class="field text medium" value="" maxlength="255" tabindex="5" /> </div> </li> <li id="foli5" class=" "> <label class="desc" id="title5" for="Field5"> Phone </label> <span> <input id="Field5" name="Field5" type="text" class="field text" value="" size="3" maxlength="3" tabindex="6" /> - <label for="Field5">(###)</label> </span> <span> <input id="Field5-1" name="Field5-1" type="text" class="field text" value="" size="8" maxlength="8" tabindex="7" /> - <label for="Field5-1">###</label> </span> </li> <li id="foli10" class=" "> <label class="desc" id="title10" for="Field10"> Format of Presentation </label> <div class="column"> <input id="radioDefault_10" name="Field10" type="hidden" value="" /> <input id="Field10_0" name="Field10" type="radio" class="field radio" value="Lecture" tabindex="9" checked="checked" /> <label class="choice" for="Field10_0" > Lecture</label> <input id="Field10_1" name="Field10" type="radio" class="field radio" value="Seminar" tabindex="10" /> <label class="choice" for="Field10_1" > Seminar</label> <input id="Field10_2" name="Field10" type="radio" class="field radio" value="Colloquium" tabindex="11" /> <label class="choice" for="Field10_2" > Colloquium</label> </div> </li> <li id="foli6" class=" "> <label class="desc" id="title6" for="Field6"> Date of Your Seminar </label> <span> <input id="Field6-1" name="Field6-1" type="text" class="field text" value="" size="2" maxlength="2" tabindex="12" /> / <label for="Field6-1">DD</label> </span> <span> <input id="Field6-2" name="Field6-2" type="text" class="field text" value="" size="2" maxlength="2" tabindex="13" /> / <label for="Field6-2">MM</label> </span> <span> <input id="Field6" name="Field6" type="text" class="field text" value="" size="4" maxlength="4" tabindex="14" /> <label for="Field6">YYYY</label> </span> <span id="cal6"> <img id="pick6" class="datepicker" src="images/calendar.png" alt="Pick a date." /> </span> <script type="text/javascript"> Calendar.setup({ inputField : "Field6", displayArea : "cal6", button : "pick6", ifFormat : "%B %e, %Y", onSelect : selectDate }); </script> </li> <li id="foli7" class=" "> <label class="desc" id="title7" for="Field7"> Arrival Date </label> <span> <input id="Field7-1" name="Field7-1" type="text" class="field text" value="" size="2" maxlength="2" tabindex="15" /> / <label for="Field7-1">DD</label> </span> <span> <input id="Field7-2" name="Field7-2" type="text" class="field text" value="" size="2" maxlength="2" tabindex="16" /> / <label for="Field7-2">MM</label> </span> <span> <input id="Field7" name="Field7" type="text" class="field text" value="" size="4" maxlength="4" tabindex="17" /> <label for="Field7">YYYY</label> </span> <span id="cal7"> <img id="pick7" class="datepicker" src="images/calendar.png" alt="Pick a date." /> </span> <script type="text/javascript"> Calendar.setup({ inputField : "Field7", displayArea : "cal7", button : "pick7", ifFormat : "%B %e, %Y", onSelect : selectDate }); </script> </li> <li id="foli8" class=" "> <label class="desc" id="title8" for="Field8"> Departure Date </label> <span> <input id="Field8-1" name="Field8-1" type="text" class="field text" value="" size="2" maxlength="2" tabindex="18" /> / <label for="Field8-1">DD</label> </span> <span> <input id="Field8-2" name="Field8-2" type="text" class="field text" value="" size="2" maxlength="2" tabindex="19" /> / <label for="Field8-2">MM</label> </span> <span> <input id="Field8" name="Field8" type="text" class="field text" value="" size="4" maxlength="4" tabindex="20" /> <label for="Field8">YYYY</label> </span> <span id="cal8"> <img id="pick8" class="datepicker" src="images/calendar.png" alt="Pick a date." /> </span> <script type="text/javascript"> Calendar.setup({ inputField : "Field8", displayArea : "cal8", button : "pick8", ifFormat : "%B %e, %Y", onSelect : selectDate }); </script> </li> <li id="foli9" class=" "> <label class="desc" id="title9" for="Field9"> Enter the Demand Draft (DD) No. </label> <div> <input id="Field9" name="Field9" type="text" class="field text medium" value="" maxlength="255" tabindex="21" /> </div> </li> <li class="buttons"> <input id="saveForm" class="btTxt" type="submit" value="Submit" /> </li> <li style="display:none"> <label for="comment">Do Not Fill This Out</label> <textarea name="comment" id="comment" rows="1" cols="1"></textarea> </li> </ul> </form> </div><!--container--> <img id="bottom" src="images/bottom.png" alt="" /> </body> </html>
well the code is not written by me , as i have said it before i have taken it from the website wufoo.com so it also contains css and other image stuffs.(i guess that doesnt matter )
>-codejoust :
well the website i have to develop , will have to cater both displaying the database (for members for which i have created a login page ) and
accept the data to store it in mysql .
<?php
$data = $_POST['data'];
if(empty($data)) {
echo "byte me" ; }
?>
$data = $_POST['data'];
if(empty($data)) {
echo "byte me" ; }
?>
![]() |
Similar Threads
- html form to php mysql db insert for image (PHP)
- extracting table field to html form then inserting values back in database (PHP)
- Php page containing html form to sql database (PHP)
- receive data from users (Python)
- get data from HTML form (Java)
- Retrving data from database to form (PHP)
- [urgent] HTML form => XML file (JSP)
- PC receive data via Bluetooth using JAVA (Java)
Other Threads in the HTML and CSS Forum
- Previous Thread: adding mutliple images to an CSS background
- Next Thread: Security issues around publishing email addresses on webpages
| Thread Tools | Search this Thread |
appointments asp background backgroundcolor beta browser bug calendar cart cgi code codeinjection corporateidentity css design development displayimageinsteadofflash dreamweaver emailmarketing epilepsy explorer firefox flash form google griefers hackers hitcounter hover html ie7 ie8 iframe image images internet intranet iphone javascript jpeg layout macbook maps mozilla multimedia navigationbars news offshoreoutsourcingcompany opacity opera optimization pnginie6 positioning scroll seo shopping swf swf. textcolor timecolor titletags url urlseparatedwords visualization web webdevelopment webform website windows7





