Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jul 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sql data base with a php interface question

    I have an sql data base with a php interface I want to change a couple things on it like for state instead of having someone type in IN or KY I want a dropdown menu for IN or KY and also the Yes Or No Questions I want Check Boxes Or Bullets I have no clue I am very novice at this you can view it at www.jx2solutions.com/kprdbase

    username is kprdataentry and password is kpr206199

  • #2
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,172
    Thanks
    19
    Thanked 65 Times in 64 Posts
    This isnt really a php issue. The data the php recieves at the other end should be the same regardless of how the information is captured.
    Your issue is purely how to interface with the user. You probably want to look into a javascript solution for modifying the input box depending on the selection.

    eg.
    Code:
    //onChange for field dropdown
    
    function changeInput()
    {
      field = document.getElementById('ctlSearchField');
      switch(field[field.selectedIndex].value)
       {
          case "State:":
               document.getElementById('search').innerHTML = statedropdown;
               break;
          case "Surrendered A Pug Before? (Yes/No)":
               document.getElementById('search').innerHTML = yesno;
               break;
           default:
                document.getElementById('search').innerHTML = standardtextinput;
        }
    }
    Obviously this assumes you have a span or other container with an id of 'search' to put the search box into and that statedropdown, yesno and standardtextinput have already been set as the html that you want to use


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •