fxr Posted February 4, 2009 Share Posted February 4, 2009 ok i have some php code embedded in my html that populates a dropdown list with entries from a mysql. now i need to think how i am going to repopulate that list [i.e pretty much rerun that segment of php code to update the dropdown list] when an ajax enabled action occurs. i have the ajax sorted for other types of updates, but i cant think through the logic for how i am going to update that list after these other events happen. [the dropdown list options need to change after these updates occur] i am using the prototypejs library i will post relevant sections of code.. <script type="text/javascript"> function sendRequestClose() { new Ajax.Request("sendmailclose.php", { method: 'post', postBody: "tradeID="+$F("tradeID")+"&closeprice="+$F("closeprice"), onLoading: showLoading, //have to add alert onSuccess: function(transport){ var response = transport.responseText || "no response text"; alert("Success! \n\n" + response); }, onFailure: function(){ alert('NO EMAILS SENT - NO RESPONSE FROM SERVER') }, onComplete: hideLoading } ); } </script> .... <p> CLOSE TRADE : <!-- PHP --> <?php // Make a MySQL Connection mysql_connect("localhost", "ssss", "sssss")or die(mysql_error()); mysql_select_db("db")or die(mysql_error()); $result = @mysql_query("SELECT ID,open_time,pair,open_price,LS FROM log_open"); print "<select name=\"tradeID\" id=\"tradeID\">"; while ($row = mysql_fetch_assoc($result)) { $tradeID = $row['ID']; $opentime = $row['open_time']; $pair = $row['pair']; $price = $row['open_price']; if ($pair == "eu") {$price = round($price,4);} else {$price = round($price,2);} $LS = $row['LS']; print "<option value=$tradeID id=$tradeID>$tradeID $LS $pair $price $opentime";} print "</select>"; ?> price <input name="closeprice" id="closeprice" type="text" size ="7"> <input type="submit" value="CLOSE" name="submit" onClick="javascript: sendRequestClose();"> </p> I need that dropdown list generated by the php to be recreated after the sendRequestClose javascript is called. Can anyone point me in the right direction please? i am a relative newbie at this and i am struggling to get a grasp of the logic what i have to do here. Thhnaks. Quote Link to comment https://forums.phpfreaks.com/topic/143832-solved-updating-a-dropdown-list-after-ajax-enabled-event/ Share on other sites More sharing options...
RichardRotterdam Posted February 5, 2009 Share Posted February 5, 2009 Looks like you're using a javascript framework. Is that mootools? Quote Link to comment https://forums.phpfreaks.com/topic/143832-solved-updating-a-dropdown-list-after-ajax-enabled-event/#findComment-755144 Share on other sites More sharing options...
fxr Posted February 5, 2009 Author Share Posted February 5, 2009 Looks like you're using a javascript framework. Is that mootools? yeah its prototype.. i have worked on this overnight and worked out that using innerHTML was my avenue to success. ll post my code for anyone who may stumble on this or be interested. Relevant snippets of code. <script type="text/javascript"> function DLChange(newHTML){ document.getElementById('tradeID').innerHTML = newHTML; } function sendRequestClose() { new Ajax.Request("sendmailclose.php", { method: 'post', postBody: "tradeID="+$F("tradeID")+"&closeprice="+$F("closeprice"), onLoading: showLoading, //have to add alert onSuccess: function(transport){ var response = transport.responseText || "no response text"; var responder=response.split("<!-- DL -->"); alert("Success! \n\n" + responder[0]); DLChange(responder[1]); }, onFailure: function(){ alert('NO EMAILS SENT - NO RESPONSE FROM SERVER') }, onComplete: hideLoading } ); } </script> .... CLOSE TRADE : <select name="tradeID" id="tradeID"> <!-- PHP --> <?php include 'opentrades.php'; ?> opentrades.php looks like this and is included at the bottom of my sendmailclose.php script. <?php // Make a MySQL Connection mysql_connect("localhost", "ssss", "sssss")or die(mysql_error()); mysql_select_db("db")or die(mysql_error()); $result = @mysql_query("SELECT ID,opentime,pair,openprice,LS FROM logopen"); print "<!-- DL -->"; while ($row = mysql_fetch_assoc($result)) { $tradeID = $row['ID']; $opentime = $row['open_time']; $pair = $row['pair']; $price = $row['open_price'];} $LS = $row['LS']; print "<option value=$tradeID id=$tradeID>$tradeID $LS $pair $price $opentime";} print "</select>"; ?> Quote Link to comment https://forums.phpfreaks.com/topic/143832-solved-updating-a-dropdown-list-after-ajax-enabled-event/#findComment-755167 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.