PHP - Using Show/hide With Multiple Results.. One At A Time

Hi,   I have some show/hide links like this:  

<a href="javascript:ReverseDisplay('content1')"  class="hide-show-button">show</a>


<a href="javascript:ReverseDisplay('content2')"  class="hide-show-button">show</a>


<a href="javascript:ReverseDisplay('content3')"  class="hide-show-button">show</a>


<a href="javascript:ReverseDisplay('content4')"  class="hide-show-button">show</a>

  using this code:  

var click = 0;

$('.hide-show-button').click(function() {

     if(click == 1)

     {

        $(this).html('show');

        $('.hide-show').hide();

        click--;

     }

     else

     {

        $(this).html('hide');

        $('.hide-show').show();

        click++;

     }


});

  If I click one link, it shows the content and then shows "hide" which is correct. However, if I click another link, it shows the content, but displays "show" until I click it again, so I end up in a strange loop.   Is there a way I can have each of the link always display "show" when not collapsed and "hide" when collapsed?   Thanks!

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=350146.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=325444.0

Hello

i have a fade in image on my home page id=1 but when i go to  about page id=2 i want it to go i have tryed to us

Code: [Select]
if($id == 1){

show rollover

}else{
do somthing
}
that works

but when i open the website up it gives me an error because i have not selected a page for the id is there away round this

any help would be great

thanks

Hello dear friends

Let say i've a huge database of 100,000 entries
Code: [Select]
my_table (id,name)
and i'd like to call all the entires to be shown by this code

Code: [Select]
$conn = mysql_connect('localhost','USER','PASS') or die(mysql_error());
mysql_select_db('my_table',$conn);

$sql = "SELECT * from my_table";
$result = mysql_query($sql,$conn);

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

$name = $row['name'];
$id = $row['id'];

echo $name;
echo "<br>(done)<br>";

}


The problem

The problem that makes me almost gonna cry,it takes long time to load then it will showing names (remember my_table of 100,000 entries) all at once  and sometimes it sudden shows huage amount once or even sometime it hang up.

My question

Is there any way that i can call it so that it showing me results one name by one name like streaming name1 (done),name2 (done),name3 (done),name4 (done),name5 (done),......etc not showing all at once

i'm afraid it may needs some ajax idea or somehow i really don't know but this is important to me so your help is very useful to me.

so anyone please helps me cause it would really save my hosting ram otherwise they would suspend me 

Greetings! I'm new in phpmysql.

Am making signup form with three users (Admin, office and student), that when student is selected there will be another form that need to fill up and the data is saved in different table. Below are my codes when the data of admin and office are submitted.
Code: [Select]
mysql_query("INSERT INTO tbl_user (user_Id,user_Password,user_Fname,user_Lname,user_Sex,user_Level,user_Program)
                VALUES               ('$userid','$password','$fname','$lname','$sex','$level','$program')");

these things here are codes for student when submitted
Code: [Select]
mysql_query("INSERT tbl_studenroll (user_Id, course_Id, ap_Id, se_Sem, se_Yearlevel)
VALUES     ('$userid','$course', '$acadyear', '$sem', '$year')") or die(mysql_error());

             $seID = mysql_query ("SELECT max(se_Id) AS mxSEid FROM tbl_studenroll")or die (mysql_error());
             $seID1 = mysql_fetch_assoc($seID);
             $seID = $seID1['mxSEid'];

             $offcourse = mysql_query("SELECT office_Id FROM tbl_offcourse WHERE course_Id = '$course'")or die (mysql_error());
             while ($row = mysql_fetch_array($offcourse))
             {
$off = $row['office_Id'];
          mysql_query("INSERT tbl_data (se_Id,office_Id,user_Id,course_Id) VALUES ('$seID','$off','$userID','$courseID')") or die(mysql_error());
             }

sEE that I am saving in three tables at the same time when student is selected.
How can I do it? I want to save only what for students and for other users..I tried my codes but when I submit data from office, it saves data to studenroll, but in 0 value. hope I am clear, help me guys! thank you in advace.

Hello,

i have a form with a dropdown selection with the values 1 to 8, on the submit page i have another form which has 8 divs, now i want to show only a number of those divs based on the selection of the dropdown from the previous page.

example:

1st page dropdown value is 4,  form gets submitted, on the next page show div 1 & 2 & 3 & 4, and so on.

Is this possible?

/Edit: i just thought about it again and i think i could use Code: [Select]
<?php $dropdown=$_POST['dropdown'];
if($dropdown=="1") { ?>  around the div tags, but then i would have to make 8 forms and take out 1 div one by one based on the dropdown selection, or is my thinking wrong?

Hi,   I want to set two expiration dates in a form.  Prior to the fall deadline, options A, B, C are displayed.  After the fall date has passed, only A and B will be displayed.  This works beautifully:

<?php
//SET THE TIME ZONE
date_default_timezone_set('America/New_York');
 
//CREATE TIMESTAMP VARIABLES
$current_ts  = time();
$fall_deadline_ts = mktime(0,0,0,9,1,2014);
$winter_deadline_ts = mktime(0,0,0,12,1,2014);
 
//IF THE FALL DEADLINE HAS PASSED
if($current_ts > $fall_deadline_ts) {
     echo "a, b";
} else {
     echo "a, b ,c";
}
?>

How can I tweak this so that after the Winter deadline has ALSO passed, it will only display A, rather than A, B?   Thanks!

Hello all,

I am making a database with all the Boeing deliveries sorted by month. I made a index with all the months and when you click on a month you will get a full list of the type and quantity of aircraft that has been deliverd.

I have two problems and I can't figure it out.
The first problem I have, is that I want to show the visitors which airline has bougt which type of aircraft and how many.
The second problem I have is a want to show them the total amount of deliveries, not just per type of aircraft, but a total number.

Here are some shots of my problem and what I have:

This is how my MYSQL-database lookes like. The columns I have a id, day, month, year, airline, aircraft, amount (just a simple translation of the Dutch words ).
As you can see, there are some airlines that received one type of aircraft two times (TUI Travel PLC has received 2x Boeing 737-800). Keep this in mind, I will get back to this.


This is the table on my website. The first column shows the type of aircraft. The secon column shows us how many of that type has been deliverd. In the last column I want to have all the airlines that has received that type of aircraft. As I mentioned above, TUI Travel PLC has received 2x B737-800, so in the row of B737-800 I want to have TUI Travel PLC (2x). If the airline received more then 1 aircraft, I would like to have (.....x) (and the amount on the dots --> TUI example: 2 aircraft, so 2x). So you will get TUI Travel PLC (2x).

This is the code I have so far (sorry I am a real noobie in PHP/MYSQL so my programming ain't that great )

Code: [Select]
<?php
mysql_connect(".....", ".....", ".....") or die(mysql_error());
mysql_select_db(".....") or die(mysql_error());

$maand = $_GET['maand'];
$jaar = $_GET['jaar'];


$query = "SELECT aircraft, jaar, maatschappij, COUNT(maatschappij) FROM deliveries_orders_boeing WHERE maand = '$maand' AND jaar = '$jaar' GROUP BY aircraft"; 
 
$result = mysql_query($query) or die(mysql_error());

// Print out result
echo "<br /><h3>Boeing deliveries ".$maand." ".$jaar."</h3><br />
<table border='0' width='700'>";
while($row = mysql_fetch_array($result)){

echo "<tr><td id='aircraft'>". $row['aircraft']. "</td><td id='aantal'>". $row['COUNT(maatschappij)'] ."</td><td id='maatschappijen'>different companies</td></tr>";
}
echo "<tr><td id='totaal'>Totaal</td><td id='totaal_aantal'>....</td><td></td></tr></table>";

?>
</td>
</tr>
</table>

Maybe a little confusing, but I hope someone can help me with this.

Kind regards,
Flyboeing

Hey all.

I have a query that selects data from a datbase based on a criteria.  Easy enough.   But now I am growing and the amount displaying is too much.

How can you, via php, have a queries result be displayed only so many at a time and auto create links that show the rest?  Like if query returns 82 results, I want it to display 25 immediately and create 3 links at the bottom.  The next link would show 26-50.  The next 51-75.  And the final 76-82.  etc

Example:
Code: [Select]
$result = mysql_query("SELECT * FROM pay");
$num_rows = mysql_num_rows($result);


while($row = mysql_fetch_array($result))
  {
echo $row['first_name'];
echo $row['last_name'];
echo $row['item_name'];
echo $row['option_selection1'];
echo $row['payment_date'];
echo $row['stat'];
}


This is simple.  But what happens when the results are 125?  I want to limit it to displaying 25 at a time.

Is the only way to manually create seperate pages and have each one show 1-25, then 26-50, etc?

Or is there a way to have the script do it, itself?  Any tutorials out there on this specifically?  Hopefully I am making sense.

Thanks!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=329323.0

hi guys

i am building a voting system for my gaming website

people sign up for matches, and those will be played at 3-5 different maps
people can vote for wich maps they want to play

each player can choose 3 maps, also 3 x the same map

now the results of that voting system are shown on the page like this

There is 1 vote for Map 1
There are 5 votes for Map 2
There is 1 vote for Map 3
There are 2 votes for Map 7
There is 1 vote for Map 4
There is 1 vote for Map 5
There are 8 votes for Map 8

now i want to make a script that picks the maps that will be played, so only show the 3-5 best results

in the example above it woud be 2 x map 8 and 1x map 2
but im not sure how to start on this

the db table of the votes is built like this

id    matchid    playerid    mapid    mapname
1    113    195    1    NukeTown
2    113    195    2    Grid
3    113    195    1    NukeTown
4    114    195    1    NukeTown
5    114    195    1    NukeTown

any advice or thoughts on this?

thanks

I know the php is basic and not completed yet, but I am working on that. My next step I want the result to show on index.php when a form is submitted to calculator2.php. I just cant seem to get it. Please help!

index.php
Code: [Select]
<div class="post">
        <h2 class="title">Calculator</h2>
<hr />
         <form method="post" action="calculator2.php">
Fireplace Front Width: <input type="text" name="fw">
<br />
Fireplace Back Width: <input type="text" name="bw">
<br />
Fireplace Depth: <input type="text" name="fd">
<br />
<input type="submit" name="Submit" value="Submit">
</form>
            Pounds Of Glass Needed: <?php echo $res1; ?>

      </div>

calculator2.php
Code: [Select]
<?php
$frontwidth = $_POST['fw'];
$backwidth = $_POST['bw'];
$firedepth = $_POST['fd'];
$x = $frontwidth + $backwidth+ $firedepth;
$y = ($x / 3) * .6667; 
$res1 = $y *2;
echo $res1;
?>

Hello,

Here's the weird thing, some of the pages shows the results, and some pages just won't show results at all, and I'm not getting any errors

here is the one that doesn't

Code: [Select]
<?
function display_mptt($user) {
global $db;
// retrieve the left and right value of the $root node

$sql2 = "SELECT * from mptt where id='25'";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Users List</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE 'left' BETWEEN '".$row2['left']."' AND '".$row2['right']."' ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)or die(mysql_error())) {
  // only check stack if there is one
  $count = mysql_num_rows($result);
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
 
 // add this node to the stack

 
  $var3 = '10';
    echo "<table width='589' border='1'>
<tr>
<th>ID</th>
<th>Name</th>
</tr>";
 
 echo  "<tr><td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>";
echo "<td>" . $row['title'] ." </td>";

echo   "</tr>";
 
 echo "</table>";
  $right[] = $row['right'];
  }
 }
 
 

   display_mptt(1);     ?> 

and here is the page that does

Code: [Select]
<?
function display_mptt($user) {
global $db;
$id = $_GET['id'];
// retrieve the left and right value of the $root node
$sql2 = "SELECT * from mptt where id= ".$id."";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Your Tree</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE `left` BETWEEN ".$row2['left']." AND ".$row2['right']." ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)) {
  // only check stack if there is one
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
  echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right)).$row['title']."<br>";
 // add this node to the stack
  $right[] = $row['right'];
  }
 }
 
  display_mptt(1);
  ?>

Hi All,   I need to get a small function working for a site I need to build for a group of friends.   I was able to get a login page, and a way to add data to the data base.   Now I am stuck on the search and show results fuctionalities.   I have found tens of scripts on the internet, but most of them are outdated, or I cant get them to work, either it sends me back a blank page, does nothing or sends me to an error page   The GOAL User Inputs text in a text box, clicks submit, the data in the text box is looked for in the second collumn of the DB, The information of the collumns 2 to 7 of the DB for the name search are displayed either on the same page or on a new page.   Is there any chance you could hel me with that, taken into account that I dont need the html part of the code, I only need help with the php part...   Thanks in advance to all the people reading this and the ones helping me...