Php , Javascript And Sql Code Mix Up

Hi I have this code that will pull the client name and address from the database. It echo's out the client name for each entry into a dropdown (

Solution 1:

You created the function to populate the div element. However, at this time, that function is only defined, it is never being executed.

you need to setup an onchange handler for the select box to call your javascript function.

Also, the php that is being output into your javascript is outside of your while loop.

Solution 2:

You are missing a semi-colon in the words <?php echo "$client" ?>. It should be <?php echo "$client"; ?>. EDIT: This is actually not needed, the ending ?> automatically closes the statement.

To add some more, as @Witty said you are not storing the $client variable outside of your loop so you cannot access it! Change that!

Solution 3:

By the time the Javascript is executed (Client), PHP already finished (Server). You will need to build the Javascript from PHP inside the While-Loop and send it to the browser later in the page:

// in while$javascript .= "case $client:
document.getElementById('content').innerHTML = '<h2>$client</h2>
    <b>Postal Address:</b>$postal_add'
break;"// later in pageswitch (document.getElementById("combobox").value)
{    
<?phpecho$javascript; ?>
}

Solution 4:

use ajax to update your div on th ebasis of the selected option from dropdown

 $('#dropdown').change(function() {
                    var id = $("#option").val();
                    var url = ajax action from where u will get the data for the selected option 
                    var data = {OptionID:id};
                    $.ajax({
                        type: 'POST',
                        url: url,
                        data: data,
                        success: function(data) 
                        { 
                            append the values in div here using div.innerhtml
                    });
            });

Share

You may like these posts

• 
  How To Send User Input To Php, Excute Sql Command And Display Output From Php
• 
  Fetch Value From Database And Fill All Textbox If Dropdown Value Change
• 
  Web Sql Drop/delete Table Not Working
• 
  How To Write A Parameterized Sql Query In Javascript?