wwfc_barmy_army Posted June 9, 2008 Share Posted June 9, 2008 Hello. I have the following code for part of an ajax fuction: var a1 = document.getElementById('1').value; var b2 = document.getElementById('2').value; var queryString = "?a1=" + a1 + "&b2=" + b2; ajaxRequest.open("GET", "updatedetails.php" + queryString, true); ajaxRequest.send(null); } //--> </script> Although the problem is that i need to be able to change the variables. for example i have 1, 2, 3 fields in my database. For example this code would work in php: while ($i <= $rowcount){ $result = mysql_query("SELECT * FROM type WHERE type_id = $i") or die(mysql_error()); $qry = mysql_fetch_array($result); echo "the variable put here"; $i = $i + 1; } Something like that, but i don't know how to get it into the javascript file. Any ideas? Thanks. P.s. The full ajax code is here: <script language="javascript" type="text/javascript"> <!-- //Browser Support Code function ajaxFunction(){ var ajaxRequest; // The variable that makes Ajax possible! try{ // Opera 8.0+, Firefox, Safari ajaxRequest = new XMLHttpRequest(); } catch (e){ // Internet Explorer Browsers try{ ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try{ ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e){ // Something went wrong alert("Your browser broke!"); return false; } } } // Create a function that will receive data sent from the server ajaxRequest.onreadystatechange = function(){ if(ajaxRequest.readyState == 4){ var ajaxDisplay = document.getElementById('ajaxDiv'); ajaxDisplay.innerHTML = ajaxRequest.responseText; } } var MSN = document.getElementById('MSN').value; var Yahoo = document.getElementById('Yahoo').value; var queryString = "?MSN=" + MSN + "&Yahoo=" + Yahoo; ajaxRequest.open("GET", "updatedetails.php" + queryString, true); ajaxRequest.send(null); } //--> </script> Quote Link to comment Share on other sites More sharing options...
hansford Posted June 9, 2008 Share Posted June 9, 2008 let php store the values in an array and then at the end of your loop do: echo "<script language='javascript'>"; for($i = 0; $i < sizeof($myarray); $i++){ echo "var num" . $myarray[$i] . "=" . $myarray[$i] .";"; } echo "</srcipt>"; now javascript has global vars named like num1, num2 etc.. which holds the values you got from you DB Quote Link to comment Share on other sites More sharing options...
webent Posted June 9, 2008 Share Posted June 9, 2008 Told wwfc_barmy_army that yesterday when this post was made in the php help forum... http://www.phpfreaks.com/forums/index.php/topic,200988.msg908903.html#msg908903 Quote Link to comment Share on other sites More sharing options...
hansford Posted June 10, 2008 Share Posted June 10, 2008 Well, maybe he doesn't get what we're trying to say or we don't get what he's trying to accomplish. What variables are you trying to change? please post the varibale along with the relevant code thanks Quote Link to comment Share on other sites More sharing options...
wwfc_barmy_army Posted June 10, 2008 Author Share Posted June 10, 2008 Thanks guys! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.