Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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

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
Jeff
Asked:
Jeff
  • 4
  • 2
1 Solution
 
margajet24IT Business AnalystCommented:
<\!--
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
 
margajet24IT Business AnalystCommented:
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
 
JeffAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
margajet24IT Business AnalystCommented:
it is a javascript..
0
 
margajet24IT Business AnalystCommented:
treat it like a part of the html codes..

ex
<html>
<body>

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

</script>
</body>
</html>
0
 
JeffAuthor Commented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now