Solved

How do I send a request (post or get) without leaving the page?

Posted on 2008-06-25
6
406 Views
Last Modified: 2013-12-12
I am querying a MySQL database for events that need to be run on another server. When an event time comes up I need to send a request (either post or get) to the other server to start that event. There may be more than one event to be started at the same time. I need to check for events to be run up to 15 minutes prior to the event time.

Here is what I have so far:
// Check for events to be run

	$strSQL = "SELECT * from tblque WHERE EventDate = CURDATE() AND EventRun = '0' AND (EventTime >= CURTIME() AND EventTime <= ADDTIME(CURTIME(), '15:00'))";

//	echo $strSQL;

	$resultr = mysql_query($strSQL);

	while ($rowRun = mysql_fetch_array($resultr)) {

	

		if  (mysql_num_rows($resultr) > 0) {

			echo "RUN EVENT"; //HTTP request here

			

//			echo "<meta http-equiv=\"refresh\" content=\"0;URL=http://test.php?action=edit&EventID=" . $rowRun['EventID'] . "\">";

			

		}

		else {

			echo "NO EVENTS";

		}

	}

Open in new window

0
Comment
Question by:jeffey48
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:margajet24
ID: 21871751
<\!--
function ajaxFunction(){
        var ajaxRequest;
       
        try{
                ajaxRequest = new XMLHttpRequest();
        } catch (e){
                try{
                        ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
                } catch (e) {
                        try{
                                ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
                        } catch (e){
                                alert(\"Your browser broke\!\");
                                return false;
                        }
                }
        }
        ajaxRequest.onreadystatechange = function(){
                if(ajaxRequest.readyState == 4){
                         var temp;
                         temp = ajaxRequest.responseText;
                        ‘ results from the page
                }
        }
        ajaxRequest.open(\"GET\", \"serverTime2.cgi?abc=2&def=3\", true);
                                                                 ‘ put here the php page youre trying to access passing also
                                                                    the values you want to pass
        ajaxRequest.send(null);
}
//-->
0
 
LVL 10

Expert Comment

by:margajet24
ID: 21871763
you can execute a script / somewhat like activate "submit" without leaving the page using AJAX

please see this..

http://www.w3schools.com/ajax/default.asp
0
 

Author Comment

by:jeffey48
ID: 21878877
Thanks for the quick response. I am an intermediate, at best, with php and can barely fumble my way through java, so you may need to hold my hand a bit.

The code you wrote, is that java? if so, how do I include it in the php code?

<?php 

if  (mysql_num_rows($resultr) > 0) {

// end PHP here

?>
 

<\!-- 

function ajaxFunction(){

        var ajaxRequest;

        

        try{

                ajaxRequest = new XMLHttpRequest();

        } catch (e){

                try{

                        ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");

                } catch (e) {

                        try{

                                ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");

                        } catch (e){

                                alert(\"Your browser broke\!\");

                                return false;

                        }

                }

        }

        ajaxRequest.onreadystatechange = function(){

                if(ajaxRequest.readyState == 4){

                         var temp;

                         temp = ajaxRequest.responseText;

                        ‘ results from the page

                }

        }

        ajaxRequest.open(\"GET\", \"serverTime2.cgi?abc=2&def=3\", true);

                                                                 ‘ put here the php page youre trying to access passing also

                                                                    the values you want to pass

        ajaxRequest.send(null); 

}

//-->

			

<?php			

// Start PHP here

}

Open in new window

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 10

Expert Comment

by:margajet24
ID: 21879877
it is a javascript..
0
 
LVL 10

Expert Comment

by:margajet24
ID: 21879952
treat it like a part of the html codes..

ex
<html>
<body>

<script type="text/javascript">
// java script

</script>
</body>
</html>
0
 

Accepted Solution

by:
jeffey48 earned 0 total points
ID: 21888110
Thanks for the help, margajet24. I found the exact solution here:
http://www.askapache.com/htaccess/sending-post-form-data-with-php-curl.html

<?php
 

 $ch = curl_init('http://www.mysite.com/index.php?option=com_content&task=blogcategory&id=24&Itemid=55');

 curl_exec ($ch);

 curl_close ($ch);
 

?>

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now