Hallo,
I am trying to make a survey page on my website using html, JavaScript and php then transferring the data to a MySQL, but i can't get the information from the page to the mysql if anyone could help me out in anyway i would be so grateful.
HTML and Javascript for the questions.
The PHP codeCode:<!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>Internet Survey - Section 1</title> <script type="text/javascript"> function ajaxFunction(){ var ajaxRequest; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP"); }else{ ajaxRequest = new XMLHttpRequest(); } return ajaxRequest; var data = 'Name=' + escape(document.getElementById("Name").value) +',Location='+ escape(document.getElementById("Location").value) +',Age='+ escape(document.getElementById("Age").value)+',Job='+escape(document.getElementById("Job").value) +',Job1='+ escape(document.getElementById("Job1").value) +',CompOwn='+ escape(document.getElementById("CompOwn").value) +',InternetAc='+ escape(document.getElementById("InternetAc").value); var string = data; ajaxRequest.open("get", "php_s1_addrow.php" + string, true); ajaxRequest.send(null); } </script> </head> <body> <h1><strong>Section 1 - Personal Information</strong></h1> <blockquote> <p>Please fill out as much information in this section as you want.</p> <form method="post" action="php_s1_addrow.php"> <p> <label for="Name">Name</label> <input name="Name" type="text" id="Name" size="50" /> (This can be any name you want, eg username)</p> <p> <label for="Location">Location</label> <input name="Location" type="text" id="Location" size="47" /> city, country </p> <p> <label for="Age">Age</label> <input name="Age" type="text" id="Age" size="10" /> Age</p> <p>Sex <label> <input type="radio" name="Sex" value="male" id="Sex" /> Male</label> <label> <input type="radio" name="Sex" value="female" id="Sex" /> Female</label> <br /> <br /> </p> <p>Are you employed?</p> <table width="200"> <tr> <td align="center" valign="middle"><label> <input type="radio" name="Job" value="yes" id="Job" /> Yes </label></td> </tr> <tr> <td align="center" valign="middle"><blockquote> <p> <input type="radio" name="Job" value="no" id="Job" /> No</p> </blockquote></td> </tr> </table> <p> <label for="Job1">If 'Yes' please say what type of job you do.</label> <input name="Job1" type="text" id="Job1" size="35" /> </p> <p>Do you own a computer?</p> <table width="200"> <tr> <td align="center"><label> <input type="radio" name="CompOwn" value="yes" id="CompOwn" /> Yes </label></td> </tr> <tr> <td align="center"><label> <input type="radio" name="CompOwn" value="no" id="CompOwn" /> No </label></td> </tr> </table> <p>Do you own any devise other than a computer that can access the internet?</p> <table width="200"> <tr> <td align="center" valign="middle"><blockquote> <p> <input type="radio" name="InternetAc" value="yes" id="InternetAc" /> Yes</p> </blockquote></td> </tr> <tr> <td align="center" valign="middle"><blockquote> <p> <input type="radio" name="InternetAc" value="no" id="InternetAc" /> No</p> </blockquote></td> </tr> </table> <p> </p> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <p> <a href="s2_computer.html"> <input type="submit" name="Next_1" id="Next_1" value="Next" onclick='ajaxFunction()'/> </a> </p> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> <p> </p> </form> <p> </p> </blockquote> </body> </html>
Thank YouCode:<? //initilize PHP $dbhost = "localhost"; $username = "215756"; $password = "lcar1990"; if($_POST['ajaxFunction()']) //If submit is hit { //then connect as user //change user and password to your mySQL name and password mysql_connect("localhost","$username","$password"); //select which database you want to edit mysql_select_db("$username"); //find out how many rows $query="SELECT * FROM S1"; $result=mysql_query($query); $num=mysql_numrows($result); $id = $num++ ; //convert all the posts to variables: $Name = $_REQUEST['Name']; $Location = $_REQUEST['Location']; $Age = $_REQUEST['Age']; $Employed = $_REQUEST['Job']; $Job = $_REQUEST['Job1']; $Computer = $_REQUEST['CompOwn']; $Dives = $_REQUEST['InternetAc']; //Insert the values into the correct database with the right fields //mysql table = markers //table columns = id, name, address, lat, long, type //post variables = $title, $address, '$lat, $long, $type $result=MYSQL_QUERY("INSERT INTO S1(ID,Name,Location,Age,Employed,Job,Computer,Dives)". "VALUES ('NULL', '$Name', '$Location', '$Age, '$Employed', '$Job', '$Computer', '$Dives')"); //confirm echo "Query Finished"; } ?>


Reply With Quote
Bookmarks