Ad:

JavaScript / DHTML / AJAX Discussion Thread
Unsolved
Views: 436

Aug 10th, 2010

AJAX PHP Function

Expand Post »

Hey guys, I'm having some AJAX troubles that hopefully someone can help me with. I have some PHP code, which works fine. And I'm trying to call the PHP function with AJAX. But I've never used AJAX at all so I'm a little confused. I've tried to fiddle around with some code but it's just not working. Wondered if anyone could help. The code is bellow:

PHP:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<?php
 
if($_GET['act'] == "generate_quotes") {
 
$db = mysql_connect("*", "*", "*") or die ("Unable to connect to database.");
mysql_select_db("quote") or die ("Unable to select database.");
 
$result = mysql_query( " SELECT * FROM `quote`  ORDER BY RAND() LIMIT 0,1 " );
$fetch = mysql_fetch_array($result); 
 
echo "<blockquote>".$fetch['q_quote']."</blockquote>";
mysql_close($db);
 
} else { 
 
echo "<img src=\"1.png\">";
 
}
?>
<?php
 
if($_GET['act'] == "generate_quotes") {

$db = mysql_connect("*", "*", "*") or die ("Unable to connect to database.");
mysql_select_db("quote") or die ("Unable to select database.");

$result = mysql_query( " SELECT * FROM `quote`  ORDER BY RAND() LIMIT 0,1 " );
$fetch = mysql_fetch_array($result); 

echo "<blockquote>".$fetch['q_quote']."</blockquote>";
mysql_close($db);

} else { 

echo "<img src=\"1.png\">";

}
?>

The link which I want to call the function:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<div id="ajaxlink"><a href='gengen.php?act=generate_quotes'>Generate</a></div>
<div id="ajaxlink"><a href='gengen.php?act=generate_quotes'>Generate</a></div>

The AJAX:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
function loadurl(dest) {
try {
("Microsoft.XMLHTTP");
} catch (e) {
}
xmlhttp.onreadystatechange = triggered;
xmlhttp.open("GET", dest);
xmlhttp.send("null");
}
function triggered() {
if ((xmlhttp.readyState == 4) (xmlhttp.status == 200)) {
document.getElementById("ajaxlink").innerHTML = xmlhttp.responseText;
}
}
function loadurl(dest) {
try {
("Microsoft.XMLHTTP");
} catch (e) {
}
xmlhttp.onreadystatechange = triggered;
xmlhttp.open("GET", dest);
xmlhttp.send("null");
}
function triggered() {
if ((xmlhttp.readyState == 4) (xmlhttp.status == 200)) {
document.getElementById("ajaxlink").innerHTML = xmlhttp.responseText;
}
}

The AJAX maybe completley wrong, I'm really not sure, but if so could somone show me how to go about doing this?

Thanks alot for any help

Similar Threads

onClick event to trigger PHP function for Simplepie feeds in JavaScript / DHTML / AJAX
Call a specific PHP function with AJAX? in JavaScript / DHTML / AJAX
Calling a PHP function with Ajax in JavaScript / DHTML / AJAX
Ajax php function callback? in JavaScript / DHTML / AJAX
Ajax PHP Forms - Willing to pay :) in JavaScript / DHTML / AJAX

ello

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

66 posts
since Aug 2010

Permalink

Aug 10th, 2010

Re: AJAX PHP Function

Well the AJAX is completely wrong

, let me explain how AJAX works:

- You create a XMLHTTP request object
- You define a function that is triggered when the readystate is changed of the XMLHTTP object
- You open a url using the XMLHTTP object
- You send some data via the XMLHTTP object
- Everytime the readystate and status change, the function you defined at step 2 is called

Here is an example of an AJAX function (that loads the url):

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
function loadurl(url) {
 
var ajax = false;
 
// Create the object:
 
// Choose the objecttype, depending on what is supported:
if (window.XMLHttpRequest) {
 
    // IE 7, Mozilla, Safari, Firefox, Opera, most browsers:
    ajax = new XMLHttpRequest();
 
} else if (window.ActiveXObject) { // Old IE-browsers
 
    // Make the type Msxml2.XMLHTTP, if possible:
    try {
        ajax = new ActiveXObject("Msxml2.XMLHTTP");
    } catch (e1) { // Else use the other type:
        try {
            ajax = new ActiveXObject("Microsoft.XMLHTTP");
        } catch (e2) { }
    }
 
}
 
// Retrieving the data from the page
 
 if (ajax) {
 
   alert("url: " + url);
 
   ajax.open('GET', url);
 
   // Sends request
   ajax.send(null);
 
   // Function that handles response
   ajax.onreadystatechange=function(){
    // If everything is OK:
     if ( (ajax.readyState == 4) && (ajax.status == 200) ) {
          // Returns the value to the document
          alert(ajax.responseText);
	 }
    }
 
 
 } else { // AJAX is not useable
     alert('It is not possible to connect, please update your browser.');
 }
 
}
function loadurl(url) {

var ajax = false;

// Create the object:

// Choose the objecttype, depending on what is supported:
if (window.XMLHttpRequest) {

    // IE 7, Mozilla, Safari, Firefox, Opera, most browsers:
    ajax = new XMLHttpRequest();

} else if (window.ActiveXObject) { // Old IE-browsers

    // Make the type Msxml2.XMLHTTP, if possible:
    try {
        ajax = new ActiveXObject("Msxml2.XMLHTTP");
    } catch (e1) { // Else use the other type:
        try {
            ajax = new ActiveXObject("Microsoft.XMLHTTP");
        } catch (e2) { }
    }

}

// Retrieving the data from the page

 if (ajax) {

   alert("url: " + url);

   ajax.open('GET', url);

   // Sends request
   ajax.send(null);
   
   // Function that handles response
   ajax.onreadystatechange=function(){
    // If everything is OK:
     if ( (ajax.readyState == 4) && (ajax.status == 200) ) {
          // Returns the value to the document
          alert(ajax.responseText);
	 }
    }


 } else { // AJAX is not useable
     alert('It is not possible to connect, please update your browser.');
 }

}

Graphix

Reputation Points: 82

Solved Threads: 74

Posting Pro in Training

Offline

400 posts
since Aug 2009

Permalink

Aug 10th, 2010

Re: AJAX PHP Function

Hey thanks so much, I would have put money on that code being wrong, but thanks alot, clears it up wonderfully. But would the link remain the same on the HTML side of things?

E.g:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<div id="ajaxlink"><a href='gengen.php?act=generate_quotes'>Generate</a></div>
<div id="ajaxlink"><a href='gengen.php?act=generate_quotes'>Generate</a></div>

?

Or would you need something more like:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)

<div id="ajaxlink" onclick="loadurl('ajax_function.php')">Click Here</div>

Last edited by ello; Aug 10th, 2010 at 1:52 pm.

ello

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

66 posts
since Aug 2010

Permalink

Aug 10th, 2010

Re: AJAX PHP Function

You need the second one, the href isn't going to work. However when a <a> element is clicked the page is reloaded. But not if you do it like the following example:

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<div id="ajaxlink"><a onclick="loadurl('ajax_function.php'); return false;">Click Here</a></div>
<div id="ajaxlink"><a onclick="loadurl('ajax_function.php'); return false;">Click Here</a></div>

Graphix

Reputation Points: 82

Solved Threads: 74

Posting Pro in Training

Offline

400 posts
since Aug 2009

Permalink

Aug 10th, 2010

Re: AJAX PHP Function

Thanks alot for all your help, worked a treat

Last edited by ello; Aug 10th, 2010 at 3:06 pm.

ello

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

66 posts
since Aug 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JavaScript / DHTML / AJAX Forum Timeline: POST vs GET i cant get either to work

Next Thread in JavaScript / DHTML / AJAX Forum Timeline: Edit selected text in textarea.

DaniWeb Message

Cancel Changes

User Name
Password