Jump to content


Photo

#SOLVED# dynamic self call


  • Please log in to reply
No replies to this topic

#1 hphimmel

hphimmel
  • New Members
  • Pip
  • Newbie
  • 6 posts
  • LocationAustria, Oslip

Posted 12 June 2006 - 06:54 AM

[img src=\"style_emoticons/[#EMO_DIR#]/huh.gif\" style=\"vertical-align:middle\" emoid=\":huh:\" border=\"0\" alt=\"huh.gif\" /]
First of all: I am Austrian and my English is bad for sure. I apologize, but I try.
Second: on behalf of PHP I am a newbie. Do not have probs with databases (normally).

What I am trying to do:
I would like to generate a filter for database sql script (which is no prob for me); this filter is a dynamic dropdown (I THINK, this is no problem for me), which should react on user action. Oh - You guess right - now my problem begins.

It would be good, to get rid of all javascript-parts, as some guys do have javascript off (as I do, for instance [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /] ).

In a later version I will make this page available for a choice of database-lists.

<?php
    session_start(); #normal php start
#here I guess a possible creation or passing of the subquery-Part
    if (isset($_SESSION['subquery'])) {
    
        $_SESSION['subquery'] = $_SESSION['subquery'].' testet';
        echo "<a href='option_select.php?filter='".$supquery.">filtertest</a>";
    }
    ?>
<html>
<head>
<title>Dynamic Choice</title>
</head>
<body>
# here I would like to give You an idea, how I would create the filters;
# the main part of the query is of the sort "SELECT * FROM xtable"
<script language="javascript" type="text/javascript">
    function process(Filter)
    {
        if (Filter=="FN") {
        subquery=" ORDER BY Name";        
        }
        if (Filter=="FP") {
        subquery=" ORDER BY PLZ";
        }
        //und so weiter
        Filter = subquery; 
        //location.reload();
    }
</script>

  <?php
# here i tried to find out, if the $Filtertext got some value; will be cleaned off
      if (!empty($_SESSION['$Filtertext'])) {
        $_SESSION['$Filtertext']="neu";
    } 
      echo $Filtertext; ?>
      <p>
# Filter- or orderby part
    <?php
    $filterarten = array(
        "FL"=>"",
           "FN"=>"Familienname",
         "FP"=>"Postleitzahl",
        "FR"=>"Fachrichtung",
        "FM"=>"Mitglieder",
        "FI"=>"Mitglieder Inland",
        "FA"=>"Mitglieder Ausland",
        "FE"=>"Ehrenmitglieder",
        "FD"=>"Diplomierte"
        );
      ?>
    <form name="filterform" action=<?php echo $_SERVER['PHP_SELF']; ?> method="post" >      
    <select name="Filter[]" size="1" onChange="process(<?php echo $element ?>)">

    <?php
        foreach ($filterarten as $key=>$element) {
        echo "<option value=$key>$element</option>";
        }
      ?>
    </select>
      </p>
     <p>
        <input type="submit" name="Submit" value="Submit">
      </p>
    </form>

# again - I try to find out, is there anything, anyone - hallo????
<?php
    if ($filter) {
        echo "following filter was choiced:<br>";
        foreach($filter as $element) {
            echo "$element<br>";
        }
    }
    echo "$Filter<br>";
#here always the last element is shown. But is clear to me. Just for test if ANYTHING is writte by this program.
    echo "$element<br>";
?>
</body>
</html>

I am thankfull for every hint.

I want to get rid of the submit-knob - as I mentioned before.
Thanks for reading, thanks for hopefully helping.

Henry




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users