Language: javascript (GeSHi-highlighted) var url2 = "getExchrate.php?param1="; function getExchrate() { var transcrncy = document.moneytrans.transcrncy.value; var paycrncy = document.moneytrans.paycrncy.value; //var trancurcode = transcrncy + paycrncy; alert(transcrncy); alert(paycrncy); http.open("GET", url2 + escape(transcrncy) + "¶m2=" + escape(paycrncy), true); http.onreadystatechange = handleHttpResponse2; http.send(null); function handleHttpResponse2() { if (http.readyState == 4) { //Split the comma delimited response into an array var results2 = http.responseText; alert(results2[0]); //alert(results2[1]); document.moneytrans.exchrate.value = results2; } } }
Language: php (GeSHi-highlighted) function db_connect() { $database_name = 'globalexpat'; // Set this to your Database Name $database_username = '*****'; // Set this to your MySQL username $database_password = '*****'; // Set this to your MySQL password $result = mysql_pconnect('localhost', $database_username, $database_password); if (!$result) return false; if (!mysql_select_db($database_name)) return false; return $result; } $conn = db_connect(); // Connect to databaseif ($conn) { $ltranscur = $_GET['param1']; $lpaycur = $_GET['param2']; //echo $_GET['param1']; //echo $_GET['param2']; //return; //echo $trecurcode; $query = "select midrate from fxrate where transcurcode = '$ltranscur' and recevcurcode = '$lpaycur'"; $result = mysql_query($query, $conn); $count = mysql_num_rows($result); if ($count > 0) { $transcrncy = mysql_result($result, 0, 'transcurcode'); $midrate = mysql_result($result, 0, 'midrate'); $midrate = stripslashes($row['$midrate']); }} if (isset($midrate)) { $return_value = $midrate;}else { $return_value = "invalid".",".$_GET['param']; // Include Zip for debugging purposes}//echo $return_value; // This will become the response value for the XMLHttpRequest object
Language: php (GeSHi-highlighted) objRequest.onreadystatechange = handleHttpResponse2; objRequest.open("GET", url2, false); objRequest.send('param1='+escape(transcrncy)+'¶m2='+escape(paycrncy));
Language: php (GeSHi-highlighted) echo $_GET['param1']; echo $_GET['param2'];
Language: php (GeSHi-highlighted)<?PHP$ltranscur = $_GET["param1"];$lpaycur = $_GET["param2"];$xrate = $ltranscur * $lpaycur;echo $ltranscur.",".$lpaycur.",".$xrate;?>
Language: gml (GeSHi-highlighted)<?PHP/********************** PAGE HEADERS *********************/// no browser caching of this page !! to be used on all pages// Date in the pastheader("Expires: Mon, 26 Jul 1997 05:00:00 GMT");// always modifiedheader("Last-Modified: " . gmdate("D, d M y H:i:s") . " GMT");// HTTP/1.1header("Cache-Control: no-store, no-cache, must-revalidate");header("Cache-Control: post-check=0, pre-check=0", false);// HTTP/1.0header("Pragma: no-cache");/*********************************************************/?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html lang="en"> <head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Preacher AJAX</title><script type="text/javascript"><!--var url2 = "http://www.cafesong.com/ert/getExchrate.php";var objRequest; function getExchrate() { var transcrncy = document.moneytrans.transcrncy.value; var paycrncy = document.moneytrans.paycrncy.value; if (window.XMLHttpRequest) { // Mozilla, Safari, ... objRequest = new XMLHttpRequest(); if (objRequest.overrideMimeType) { objRequest.overrideMimeType('text/xml'); } } else if (window.ActiveXObject) { // II objRequest = new ActiveXObject("Microsoft.XMLHTTP"); } if (!objRequest) { alert('Giving up :( Cannot create an XMLHTTP instance'); return false; } objRequest.onreadystatechange = handleHttpResponse2; var params = '?param1='+transcrncy+'¶m2='+paycrncy; objRequest.open("GET", url2+params, true); objRequest.send(null);} function handleHttpResponse2() { if (objRequest.readyState == 4) { if (objRequest.status == 200) { var results2 = objRequest.responseText; objRequest=null; var arr=results2.split(','); // arr[0] is param1 // arr[1] is param2 // alert(results2) document.moneytrans.exchrate.value = arr[2]; document.moneytrans.rawResults.value = results2; } }} //--></script><style><!--.code { font-family: monospace; font-size: 10pt; color: #000000; border: 1px dashed #000000; padding: 5px; background-color: #FFFFCC }--></style></head> <body><form name="moneytrans"> <p>Trans Currency <input type="text" name="transcrncy" value="10"></p> <p>Pay Currency <input type="text" name="paycrncy" value="121"></p> <p>Exchange Rate <input type="text" name="exchrate"></p> <p>Raw Results <input type="text" name="rawResults"></p> <p><input type="button" value="Get Exchange Rate" name="b1" onclick="getExchrate();"></p></form><p>AJAX Code</p><div class="code"><?PHP<br>/********************** PAGE HEADERS *********************/<br>// no browser caching of this page !! to be used on all pages<br>// Date in the past<br>header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");<br>// always modified<br>header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");<br>// HTTP/1.1<br>header("Cache-Control: no-store, no-cache, must-revalidate");<br>header("Cache-Control: post-check=0, pre-check=0", false);<br>// HTTP/1.0<br>header("Pragma: no-cache");<br>/*********************************************************/<br>?><br><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><br><html lang="en"><br><br><head><br><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><br><title>Preacher AJAX</title><br><script type="text/javascript"><br><!--<br>var url2 = "http://www.cafesong.com/ert/getExchrate.php";<br>var objRequest;<br><br>function getExchrate() {<br> var transcrncy = document.moneytrans.transcrncy.value;<br> var paycrncy = document.moneytrans.paycrncy.value;<br> <br> if (window.XMLHttpRequest) { // Mozilla, Safari, ...<br> objRequest = new XMLHttpRequest();<br> if (objRequest.overrideMimeType) {<br> objRequest.overrideMimeType('text/xml');<br> }<br> } <br> else if (window.ActiveXObject) { // II<br> objRequest = new ActiveXObject("Microsoft.XMLHTTP");<br> } <br><br> if (!objRequest) {<br> alert('Giving up :( Cannot create an XMLHTTP instance');<br> return false;<br> }<br> objRequest.onreadystatechange = handleHttpResponse2;<br> var params = '?param1='+transcrncy+'¶m2='+paycrncy;<br> objRequest.open("GET", url2+params, true);<br> objRequest.send(null);<br>}<br> <br>function handleHttpResponse2() {<br> if (objRequest.readyState == 4) {<br> if (objRequest.status == 200) {<br> var results2 = objRequest.responseText;<br> objRequest=null;<br> var arr=results2.split(',');<br> // arr[0] is param1<br> // arr[1] is param2<br> // alert(results2)<br> document.moneytrans.exchrate.value = arr[2];<br> document.moneytrans.rawResults.value = results2;<br> }<br> }<br>} <br>//--><br></script><br></head><br><br><body><br><a href="javascript:void(0);" onclick="getExchrate();">Click Me</a><br><form name="moneytrans"><br> <p>Trans Currency <input type="text" name="transcrncy" value="10"></p><br> <p>Pay Currency <input type="text" name="paycrncy" value="121"></p><br> <p>Exchange Rate <input type="text" name="exchrate"></p><br> <p>Raw Results <input type="text" name="rawResults"></p><br></form><br><div class="code"><br><br></div><br></body><br><br></html><br></div><p>PHP</p><div class="code"><?PHP<br>$ltranscur = $_GET["param1"];<br>$lpaycur = $_GET["param2"];<br>$xrate = $ltranscur * $lpaycur;<br>echo $ltranscur.",".$lpaycur.",".$xrate;<br>?></div></body> </html>