javascript/ajax to mysql db

[anfetienne]

could anyone tell me the mthod to use javascript/ajax to post to a sql database? or could someone point me to a tutorial?

[anfetienne]

ok will do a test and let you know the results

[anfetienne]

ok will do a test and let you know the results

[anfetienne]

i can't get this to work on submit.....

how many functions can i have on one action?

[acoder]

As many as you want; you must be returning from one of the functions. Post your code.

[anfetienne]

its the same code as what i posted earlier there is no change.....id just like to know how many functions i can run in a onclick and how.

do i seperate with commas? eg onclick="func1 , func2"

[Markus]

@anfetienne
You separate them, like you would normal statements in the language, i.e. with semi-colons.

<a href="#" onclick="alert('hi'); func1(); func2(); return false;">...</a>
 

[anfetienne]

is it possible to do the same using onclick within a form? sorry, i should of phrased myself properly before

[Markus]

@anfetienne
It's possible with any element. Learn by trying, anfetienne. ;)

[anfetienne]

lol i know the saying.....just needed to know if it was possible

thanks for the help

[anfetienne]

I've tested this and it does not work....i have tried using onsubmit, onclick, onmousedown, onmouseup and it still doesn't do anything.

i.e. onsubmit="makeRequest('data.php')"

here is my coding....am i doing something incorrectly?

<script type="text/javascript" language="javascript">
    function makeRequest(url) {
        var httpRequest;
 
        if (window.XMLHttpRequest) { // Mozilla, Safari, ...
            httpRequest = new XMLHttpRequest();
            if (httpRequest.overrideMimeType) {
                httpRequest.overrideMimeType('text/xml');
                // See note below about this line
            }
        } 
        else if (window.ActiveXObject) { // IE
            try {
                httpRequest = new ActiveXObject("Msxml2.XMLHTTP");
            } 
            catch (e) {
                try {
                    httpRequest = new ActiveXObject("Microsoft.XMLHTTP");
                } 
                catch (e) {}
            }
        }
 
        if (!httpRequest) {
            alert('Giving up :( Cannot create an XMLHTTP instance');
            return false;
        }
 
        //enter var details for fields here
        var urlparams = "first_name=" + encodeURIComponent(document.getElementById("first_name").value);
        urlparams += "&last_name=" + encodeURIComponent(document.getElementById("last_name").value);
        urlparams += "&address1=" + encodeURIComponent(document.getElementById("address1").value);
        urlparams += "&address2=" + encodeURIComponent(document.getElementById("address2").value);
        urlparams += "&city=" + encodeURIComponent(document.getElementById("city").value);
        urlparams += "&state=" + encodeURIComponent(document.getElementById("state").value);
        urlparams += "&zip=" + encodeURIComponent(document.getElementById("zip").value);
        urlparams += "&os0=" + encodeURIComponent(document.getElementById("os0").value);
        urlparams += "&email=" + encodeURIComponent(document.getElementById("email").value);
 
 
        httpRequest.onreadystatechange = function() { alertContents(httpRequest); };
        httpRequest.open('POST', url, true);
        httpRequest.send('urlparams');
 
    }
 
    function alertContents(httpRequest) {
 
        if (httpRequest.readyState == 4) {
            if (httpRequest.status == 200) {
                alert(httpRequest.responseText);
            } else {
                alert('There was a problem with the request.');
            }
        }
 
    }
</script>
 

[anfetienne]

hi, i have solved this problem myself.....

the best way to do it is to make your file tht saves data to a DB and then use this java code to load a 2nd page.

<script type="text/javascript">
<!--
function dbSubmit(f)
{
    // submit to action in form
    f.submit();
 
    // set second action and submit
    f.target="_self";
    f.action="data.php";
    f.submit();
    return false;
}
//-->
</script>
 

then on your form just add onsubmit="dbSubmit(this)"

[acoder]

Line 43 should have been:

httpRequest.send(urlparams);

i.e. urlparams (the variable) instead of 'urlparams' (the string).