ajax problem - Javascript

Hi I'm new to ajax, I've already created a drop down menu using php and loads my provinces dynamically from my database, now what is supposed to do is, if you click on any province in the drop down menu the cities have to appear on another page which are also in my database

heres my php code that loads my drop down menu.

Expand|Select|Wrap|Line Numbers

 [<html>]
 
[<head>][<title>]<?php echo $title;?>[</title>]
 
[<h1>][<?php echo $heading;?>][</h1>]
 
[</head>]
 
[<body>]
 
[<?]

    function writeCities($id)

    {        

        $con = mysql_connect("localhost","root","");

        if (!$con) die('Could not connect: ' . mysql_error());

          mysql_select_db("msansi", $con);

        $query  = "SELECT cities FROM provinces WHERE id =";

        $query .= $id;

        $result = mysql_query($query);            
 
        $row = mysql_fetch_array($result);

        echo $row[0];        

    }
 
    function populateDropBox()

    {

        $con = mysql_connect("localhost","root","");

        if (!$con) die('Could not connect: ' . mysql_error());

          mysql_select_db("msansi", $con);

        $result = mysql_query("SELECT id,title,cities FROM provinces");
 
        while($row = mysql_fetch_array($result))

        {    

            echo "<option value=$row[0]>" . $row['1']."</option>";

        }

    }

[?>]
 
function onChangeDropBox()
 
    {

        var selected =0;

        selected = document.myform.province.value;                    
 
        var t = "<? writeCities(9);?>";

        document.myform.submit.value = t;
 
        }
 
        [<form name="myform">]

    [<script type="text/javascript">]

        [<select name = "province" onChange="onChangeDropBox();"/>] 

        [<? populateDropBox(); ?>]     

        [<input type ="submit" value="submit" onClick="showcities";/>]    

        [</form>]          
 
[</script>]       
 
[</body>]

{</html>]

would you please shed some light on how I'm going to go about tackling this problem using ajax because I cant seem to find anything helpful over the net.

thanxxx in advance!!!!

Mar 8 '11 #1

Subscribe Post Reply

✓ answered by JKing

If you are sending the user to another page, just post your province id variable and it will be available to your next page.

You can do this by setting the action attribute of your form to the page you want the user sent to and set the method attribute to post.

Expand|Select|Wrap|Line Numbers

<form name="your_form_name" action="your_next_page.php" method="post">

Then on your next page call your writeCities function but pass in the province id for your parameter.

It will be almost the exact same as the provinces form you created but instead with your writeCities function in place of your populateDropBox function.

954

JKing

1,206

Expert 1GB

Expand|Select|Wrap|Line Numbers

<form name="your_form_name" action="your_next_page.php" method="post">

Mar 8 '11 #2

kagiso boikanyo

k thanxx jking it worked wonders i was using a wrong concept of trying to open a new window, now I've got this php parameter inside a script which requires me to put the id no of the province in order to show the cities which is not what i want, i need an effective way to pass php variables in javascript, heres the code

function onChangeDropBox()

{
var selected =0;
selected = document.myform.province.value;

var t = ["<? writeCities(9);?>"];
document.myform.submit.value = t;

}

Mar 9 '11 #3

Similar topics

Minor AJAX Problem

by: Joel Byrd | last post by:

I am making an AJAX call when any one of a number of inputs in a form (search criteria) are clicked, checked, changed, etc. When the user clicks, checks, whatever, I am trying to display a...

Javascript

AJAX problem with firefox (no readyState == 3 ????)

by: Eric Wallstedt | last post by:

I have a page that "logs" changes made to input fields using ajax to pass data to a cgi. I use POST and it works fine most of the time (all the time in IE). But it fails when I get the data from...

Javascript

ajax problem: "Object Expected" error when submitting form

by: monudjn | last post by:

Hi I am implementing ajax in portal. Using ajax i am able to updating the content of portlets asynchronously. However i am facing a problem The Problem: While submitting the form i am getting...

Javascript

ajax problem

by: K. | last post by:

Hello! I have the following problem. I have form div which is replaced by ajax event. Unofrtunately all the ajax inputs are null after posting the form (method="post") in Firefox, but on...

Javascript

Javascript/Ajax problem in FF

by: JohnnieTech | last post by:

I am using some javascript/ajax to load content into a main div. The problem I am running into is that it will work in IE but not in FF. In FF I don't get any sort of load at all. I have a 1...

Javascript

(Scroll Bar + Ajax)Problem

by: Eyeinstyin | last post by:

Basic Problem is Every scroll of scrollbar makes an ajax call.So if user play with scrollbar say 100 times 100 ajax calls go and server starts processing 100 calls.So abort won't help.The last time...

Javascript

VisualStudio 2008 and AJAX problem when using IIS

by: mazdotnet | last post by:

Hi guys, On my work computer I had VisualStudio 2005, AJAX 1.0 and AJAX toolkit installed. 2 days ago I installed VisualStudio 2008 and every AJAX test that I do (IIS), does a postback. When I...

ASP.NET

AJAX Problem - Firefox and IE6 issue

by: violinandviola | last post by:

I have just put 4 different ajax bits on this page: http://jimpix.co.uk/default-ajax.asp The ajax spits out chunks of images / news content, and users can view the chunks via next / prev links....

Javascript

AJAX problem with php

by: sheldonlg | last post by:

I haven't received an answer with my other post, so I am rephrasing it here. In php I have a 2D array which I "print". The headers force it to be a file on the user's system. The user receives...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing