jquery change function

jquery change function

Basically the idea I want to accomplish here is to kill the defaultCharID and defaultCharacterName session variables and when a new choice is made from the dropdown then create a new sessions with those new data.

  1. <?php

    session_start

    (); // Access the existing session

    // Include the database page


    include ('inc/dbconfig.php');


    // Include the variables page
    include ('inc/variables.php');


    $userID = $_SESSION['userID'];
    $isAdmin = $_SESSION['isAdmin'];
    $defaultCharID = $_SESSION['defaultCharID'];
    $defaultCharacterName = $_SESSION['defaultCharacterName'];
    $firstName = $_SESSION['firstName'];
    $lastName = $_SESSION['lastName'];


    ?>
  2. <script>
    $(document).ready(function() {
     $('#newDefaultCharID').change(function() {
     var newDefaultCharID = $('#newDefaultCharID option:selected').val();
     $('#characterID').val(newDefaultCharID);
     $.ajax({
     type: "POST"
     
     }); 
     });
    });
    </script>










  3. <div id="headerCharacter">   
            <?php
                
    if ($isAdmin == "Yes") {
                    
    $query = "SELECT
                            characters.ID
                        FROM
                            characters"


    ;
                    
    $result = mysqli_query ($dbc,$query);
                    
    $totalNumCharacters = mysqli_num_rows($result);
            
                    

    $query = "SELECT
                            handlercharacters.ID
                        FROM
                            handlercharacters
                        INNER JOIN
                            handlers
                            ON handlers.ID = handlercharacters.handlerID"





    ;
                } else {    
                    

    $query = "SELECT
                            handlercharacters.id
                        FROM
                            handlercharacters
                        INNER JOIN
                            handlers
                            ON handlers.ID = handlercharacters.handlerID
                        WHERE
                            handlers.ID = '"







    .$userID."'";
                }
                

    $result = mysqli_query ($dbc,$query);
                
    $numAvailableCharacters = mysqli_num_rows($result);
                if ((
    $numAvailableCharacters > "1") || (($isAdmin == "Yes") && (isset($totalNumCharacters)) && ($totalNumCharacters > "0"))) {
                
    ?>
                    <input type="hidden" name="characterID" id="characterID" value="0" />
                    <select class="dropdown" name="newDefaultCharID" id="newDefaultCharID" title="Select Character">                
                <?php
        
                    

    if ($defaultCharID > "0") {
                        print
    "<option value=".$defaultCharID.">".$defaultCharacterName;
                    } else {
                        print

    "<option value=0>- Select -";
                    }
                    if (

    $isAdmin == "Yes") {
                        
    $query = "SELECT
                                characters.ID,
                                characters.characterName
                            FROM
                                characters
                            WHERE
                                characters.ID <> '"





    .$defaultCharID."' AND
                                characters.statusID = '1'
                            ORDER BY
                                characters.characterName"


    ;
                    } else {
                        

    $query = "SELECT
                                characters.ID,
                                characters.characterName
                            FROM
                                characters
                            INNER JOIN
                                handlercharacters
                                ON characters.ID = handlercharacters.characterID                        
                            INNER JOIN
                                handlers
                                ON handlers.ID = handlercharacters.handlerID
                            WHERE
                                handlers.ID = '"











    .$userID."' AND
                                handlercharacters.characterID <> '"
    .$defaultCharID."' AND
                                characters.statusID = '1'
                            ORDER BY
                                characters.characterName"


    ;
                    }
                    

    $result = mysqli_query ($dbc,$query);
                    
    $numRows = mysqli_num_rows ($result);
                    if (
    $numRows > 0) {
                        if (
    $isAdmin == "Yes") {
                            print
    "<optgroup label=\"** Active Characters **\">";
                        }
                        while (

    $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) {
                            print
    "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                        }
                    }
                    if (


    $isAdmin == "Yes") {
                        
    $query = "SELECT
                                characters.ID,
                                characters.characterName
                            FROM
                                characters
                            WHERE
                                characters.ID <> '"





    .$defaultCharID."' AND
                                characters.statusID = '2'
                            ORDER BY
                                characters.characterName"


    ;
                    } else {
                        

    $query = "SELECT
                                characters.ID,
                                characters.characterName
                            FROM
                                characters
                            LEFT JOIN
                                handlercharacters
                                ON characters.ID = handlercharacters.characterID                        
                            LEFT JOIN
                                handlers
                                ON handlers.ID = handlercharacters.handlerID
                            WHERE
                                handlers.ID = '"











    .$userID."' AND
                                handlercharacters.characterID <> '"
    .$defaultCharID."' AND
                                characters.statusID = '2'
                            ORDER BY
                                characters.characterName"


    ;
                    }
                    

    $result = mysqli_query ($dbc,$query);
                    
    $numRows = mysqli_num_rows($result);
                    if (
    $numRows > "0") {
                        print
    "<optgroup label=\"** Inactive Characters **\">";    
                        while (
    $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) {
                            print
    "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";    
                        }
                    }
                    


    ?>
                    </select>
                <?php
                
    } else {
                    print
    "<h1>".$defaultCharacterName."</h1>\n";
                }
                

    ?>
                </div>