PHP5 - AJAX help


Posted on 16th Feb 2014 07:03 pm by admin

I've been following the tutorial on w2schools (http://www.w3schools.com/php/php_ajax_database.asp) about using AJAX and a database. It's my first time actually using AJAX and I've run into a problem. Nothing seems to be happening

What i'm trying to do is when a user changes on drop down, another is filled out depending on the first

This is the form
Code: <!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=iso-8859-1" /> <title>Scouts DB - Members</title> <link href="../css.css" rel="stylesheet" type="text/css" /> <link href="addmem.css" rel="stylesheet" type="text/css" /> </head> <body> <script type="text/javascript" src="packsix.js"></script> <?php include('menu.php'); ?> <p align="center">Fill out below to add a member</p> <form id="addmem" name="addmem" method="post" action="/admin/addmem_process.php"> <div id="Personal"> <p align="center">Personal Information</p> <table width="100%" border="0"> <tr> <th width="50%" scope="col">First Name </th> <td width="50%" scope="col"><input name="first_name" type="text" id="first_name" /></td> </tr> <tr> <th>Last Name </th> <td><input name="last_name" type="text" id="last_name" /></td> </tr> <tr> <th>Membership No. </th> <td><input name="memebrship_no" type="text" id="memebrship_no" /></td> </tr> <tr> <th>Section</th> <td><select name="section" id="section" onchange="packsix(this.value)"> <option value="0" selected="selected"> </option> <option value="1">Beavers</option> <option value="2">Cubs</option> <option value="3">Scouts</option> </select> </td> </tr> <tr> <th>Date of Birth </th> <td><input name="dob" type="text" id="dob" /></td> </tr> <tr> <th>Gender</th> <td><select name="gender" id="gender"> <option value="male" selected="selected">Male</option> <option value="female">Female</option> </select> </td> </tr> <tr> <th>Religion</th> <td><input name="riligion" type="text" id="riligion" /></td> </tr> <tr> <th>School</th> <td><input name="school" type="text" id="school" /></td> </tr> <tr> <th>Ethnicity</th> <td><input name="ethnicity" type="text" id="ethnicity" /></td> </tr> </table> <br /> </div> <div id="Contact"> <p align="center">Contact Details</p> <table width="100%" border="0"> <tr> <th width="34%" scope="col">Address</th> <td width="66%" scope="col"><input name="address1" type="text" id="address1" /></td> </tr> <tr> <th>&nbsp;</th> <td><input name="address2" type="text" id="address2" /></td> </tr> <tr> <th>Town</th> <td><select name="town" id="town"> <option value="Welwyn Garden City">Welwyn Garden City</option> <option value="Hatfield">Hatfield</option> </select> </td> </tr> <tr> <th>County</th> <td><input name="county" type="text" id="county" /></td> </tr> <tr> <th>Post Code </th> <td><input name="postcode" type="text" id="postcode" value="AL7 " /></td> </tr> <tr> <th>Home Tel. No. </th> <td><input name="home_tel" type="text" id="home_tel" /></td> </tr> </table> </div> <div id="NOK"> <p align="center">Next of Kin</p> <table width="100%" border="0"> <tr> <th width="50%" scope="col">Mother's Name </th> <td width="50%" scope="col"><input name="mother" type="text" id="mother" /></td> </tr> <tr> <th>Mobile</th> <td><input name="m_mobile" type="text" id="m_mobile" /></td> </tr> <tr> <th>Father's Name </th> <td><input name="father" type="text" id="father" /></td> </tr> <tr> <th>Mobile</th> <td><input name="f_mobile" type="text" id="f_mobile" /></td> </tr> <tr> <th>Other's Name </th> <td><input name="other" type="text" id="other" /></td> </tr> <tr> <th>Relationship</th> <td><input name="relationship" type="text" id="relationship" /></td> </tr> <tr> <th>Mobile</th> <td><input name="o_mobile" type="text" id="o_mobile" /></td> </tr> <tr> <th>Email</th> <td><input name="email" type="text" id="email" /></td> </tr> <tr> <th>Email</th> <td><input name="email2" type="text" id="email2" /></td> </tr> </table> </div> <div id="doc"> <p align="center">Doctor / Medical</p> <table width="100%" border="0"> <tr> <th width="34%" scope="col">Doctor</th> <td width="66%" scope="col"><input name="doctor" type="text" id="doctor" /></td> </tr> <tr> <th>Surgery</th> <td><input name="daddress" type="text" id="daddress" /></td> </tr> <tr> <th>Tel No. </th> <td><input name="dtelno" type="text" id="dtelno" /></td> </tr> <tr> <th>Allergies &</th> <td rowspan="2" valign="top"><textarea name="allergies" id="allergies"></textarea></td> </tr> <tr> <th>Medical</th> </tr> <tr> <th>Special Needs &</th> <td rowspan="2" valign="top"><textarea name="specialneeds" id="specialneeds"></textarea></td> </tr> <tr> <th> Behavioural Problems </th> </tr> </table> </div> <div id="scouting"> <p align="center">Scouting Details </p> <table width="100%" border="0"> <tr> <th width="47%" scope="row"><span id="pack">Colony / Pack / Troop</span></th> <td width="53%"><span id="packs">N/A</span></td> </tr> <tr> <th scope="row"><span id="six">Six / Patrol</span></th> <td><span id="sixes">N/A</span></td> </tr> <tr> <th scope="row">Joined Scouting </th> <td><input name="joined_scouting" type="text" id="joined_scouting" /></td> </tr> <tr> <th scope="row">Joined Section </th> <td><input name="joined_section" type="text" id="joined_section" /></td> </tr> </table> </div> <div id="submit"> <input name="Submit" type="submit" value="Add Member" /> </div> </form> </body> </html>

This is the packsix.js file
Code: var xmlhttp function packsix(int) { pack(int) } function pack(int) { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Browser does not support HTTP Request"); return; } var url="pack.php"; url=url+"?q="+str; url=url+"&sid="+Math.random(); xmlhttp.onreadystatechange=stateChanged; xmlhttp.open("GET",url,true); xmlhttp.send(null); } function stateChanged() { if (xmlhttp.readyState==4) { document.getElementById("txtHint").innerHTML=xmlhttp.responseText; } } function GetXmlHttpObject() { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari return new XMLHttpRequest(); } if (window.ActiveXObject) { // code for IE6, IE5 return new ActiveXObject("Microsoft.XMLHTTP"); } return null; } }

and this is the pack.php file
PHP Code: // JavaScript Document


var xmlhttp

function packsix(int)
{
pack(int)
}

function pack(int)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var url="pack.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}

function stateChanged()
{
if (xmlhttp.readyState==4)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}

function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
{
// code for IE7+, Firefox, Chrome, Opera, Safari
return new XMLHttpRequest();
}
if (window.ActiveXObject)
{
// code for IE6, IE5
return new ActiveXObject("Microsoft.XMLHTTP");
}
return null;
}
}


knowing my luck it'll be something simple

Anyone any ideas?

No comments posted yet

Your Answer:

Login to answer
116 Like 6 Dislike
Previous forums Next forums
Other forums

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

RadioButtonList data selection
view plaincopy to clipboardprint?

PHP hyperlinks generator - HELP plz
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Automatically Detect Phone Model for WAP Jar Deployment
Making a wap site is fairly simple, but I'd like to know if there's a way to make it so that the wap

Dynamically allocating the number of rows in a table based on a variable value
Hi,
I have situation here which i cannot resolve, I have a variable temp which stores the num

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash