Solved

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

Posted on 2008-06-25
6
405 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
Comment Utility
<\!--
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
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 10

Expert Comment

by:margajet24
Comment Utility
it is a javascript..
0
 
LVL 10

Expert Comment

by:margajet24
Comment Utility
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
Comment Utility
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

Easy Project Management (No User Manual Required)

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

743 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

15 Experts available now in Live!

Get 1:1 Help Now