Jump to content

jQtouch MySql Database request


rilana

Recommended Posts

Hi guyes... getting pretty frustrated. I am trying to make a little webApp with jqTouch. Hopefully someone can help me.

I got a div that has a form in it. it looks like that:

<div id="admin" class="current">
            <div class="toolbar">
                <h1>smarte jobs für smarte leute</h1>
                <a class="button slideup" id="infoButton" href="#home">Home</a>
            </div>

            <div id="test">Test</div>

            <form action="test.php" method="POST" class="form">
           
            <ul>
           <li>
           <select name="kaufm" id="kaufm">
		<option value="adminAll">Alle kaufmännische Stellen</option>
             <option value="admin">Administration/HR/Consulting/CEO</option>
              <option value="5" >CEO/Geschäftsführung</option>
              <option value="2" >Assistenz/Sekretariat/Empfang/Sachbearbeitung</option>
              <option value="8" >Personalwesen/‐entwicklung</option>        
            </select>
                    </li>
              <li>
<select name="region" id="region">
<option value="100">Ganze Schweiz</option>
<option value="2" />Rechtes Seeufer</option>
<option value="6" />Graubünden</option>
<option value="5" />Zürich</option>
<option value="1" />Linkes Seeufer</option>
<option value="3" />Glarus</option>
<option value="4" />Zürich Oberland</option>
<option value="7" />Zentralschweiz</option>
<option value="8" />Kanton Zug</option>
<option value="9" />Ostschweiz</option>
<option value="10" />Deutschschweiz</option>
<option value="11" />Welschland / Französische Schweiz</option>
<option value="12" />Südschweiz / Italienische Schweiz</option>
</select>
              </li>   
              
                    <li><select name="anstellung" id="anstellung">
<option value="100">Alle Anstellungen</option>
<option value="temp" />Temporäre Anstellung</option>
<option value="try" />Try and Hire</option>
<option value="fest" />Feste Anstellung</option>
<option value="festTemp" />Fest und Temporäre Anstellung</option>

</select></li>
                  </ul>
            <a style="margin:0 10px;color:rgba(0,0,0,.9)" href="#" class="submit whiteButton">Suche starten</a>
        </form>                            
    
              </li>
            </ul>

            <div class="info">
                <p>Add this page to your home screen to view the custom icon, startup screen, and full screen mode.</p>
            </div>
        </div>  

 

And it is hooked up to a php that looks like that without the query...

<div id="liste">
    <div class="toolbar">
     
<?

echo "<h1>$adminList</h1>";
echo "<a href='#' class='button back'>Back</a>";
echo " </div><ul class='edgetoedge'>";





$result = mysql_query($sql);


$r = mysql_fetch_row($result);  
$numrows = $r[0];  
$numrows = mysql_num_rows ($result);

// makes shoure that the output is not -1
$resultOutput = mysql_query($sql);



//print table
echo "<span class='suche'>Ihre Suche ergab <span class='zahl'>$numrows</span> Treffer</span>";

echo "<ul class='paging'>";



while($row = mysql_fetch_array($resultOutput)) {

$id=($row['stelleID']);
$datumsanzeige=($row['stelleDatumsanzeige']);
$datum=(date("d.m.y", strtotime($row["stelleDatum"])));
$today = date("d.m.y");

if($datumsanzeige == "fake")
    {
    $datumDef = "$today";
    }
  else
    {
    $datumDef = "$datum";
    }


// Print out the contents of each row into a table
echo "<li><span class='stellen'>";
echo $row['stellePosition'];

echo "</span>";
echo "<br>";


$stelleIDDetail = $row['stelleID'];

$text=strip_tags (html_entity_decode($row['stelleStellenbeschrieb']));
// 0,100 show 100 Zeichen
echo substr($text,0,150);
echo "... ";
echo "<a href='#$stelleIDDetail'>|weiter > </a>";
echo "</li>";
	echo "<div id='$stelleIDDetail'>Detail</div>"; 

} 


echo "</ul>";

echo mysql_error();
mysql_close($con);



?> 

    </ul>
</div>

 

it seems to work, it lists the request, but it also shows the <div id='$stelleIDDetail'>Detail</div> Tag. And I want it to be hidden till the details are requested by klicking on |weiter > in jqtouch all the div id's are supposed to be hidden till they are called with an <a href='#.

Can anyone help me please? Maby I am evan on the wrong path and there is a much easier way to do this. Thanks for any help, Rilana

 

Link to comment
https://forums.phpfreaks.com/topic/234678-jqtouch-mysql-database-request/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.