collapslable database driven rows

**dot_net_help** · May 7th, 2012, 08:32 PM

Please refer follwoing code

Code:

$result = mysql_query("select * from topic");


echo "<div>";
echo "<table>
<tr>
<th>topicid</th>
<th>TopicName</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr bgcolor='#736A6E'>";
$topicid =  $row['TopicID'] ;
  echo "<td>" . $row['TopicID'] .   "</td>";
  echo "<td>" . $row['TopicName'] ."</td>";
//********************************************************

//Child table  rows

//**********************
 echo "</tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";

  }
echo "</table>";


echo "</div>";

i need child rows disbaled initailly and then enabled when parent rows clcik..

i wnat this using php jquery /database

Thanks

**akhileshbc** · May 8th, 2012, 11:10 PM

Solution1:
Load all the parent and child rows at first(echo out all of them). And hide the child rows of all parents, using jQuery's hide() at document ready state. Also, write the jQuery code to enable the corresponding child rows upon clicking the respective parent.

Solution2:
List out all the parent rows. And write the click event(in jQuery) for these parents to load the respective child rows via jQuery get().

See these for some of the effects: http://api.jquery.com/category/effects/basics/

I have made a quick example, you could test it here: http://jsfiddle.net/BGVzw/

**dot_net_help** · May 11th, 2012, 01:16 AM

thanks for reply and sugessting me
can u make sample programmm .. i have already database driven code ..in thread

**akhileshbc** · May 11th, 2012, 02:24 AM

Originally Posted by dot_net_help

thanks for reply and sugessting me
can u make sample programmm .. i have already database driven code ..in thread

You didn't checked the example that I have posted ?

**dot_net_help** · May 12th, 2012, 03:20 AM

coe is like thsi but it hide child rows of Ist parents only

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP Login with jQuery AJAX</title>

<script type="text/javascript" src="jquery-1.5.2.min.js"></script>

<script>
$(document).ready(function() {
 $('#id1').hide(); 
	
	
    });



</script>

</head>
<body>

<?php
$con = mysql_connect("127.0.0.1","root","");

if (!$con)
  {
//echo "not Connected";
exit("Connection Failed: " . $con);
}
else

{
echo "Connected";

// Insertion into database 
mysql_select_db("directory") or die(mysql_error());


//mysql_query("INSERT INTO products (ProductName) VALUES ('Tabbusamm REcord')")

//or die(mysql_error());


// Insertion into database 
$result = mysql_query("select * from topic");


echo "<div>";
echo "<table>
<tr>
<th>topicid</th>
<th>TopicName</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
$topicid =  $row['TopicID'] ;
  echo "<td>" . $row['TopicID'] .   "</td>";
  echo "<td>" . $row['TopicName'] ."</td>";
//*************************************************************************
$result1 = mysql_query("select * from comment where topicID = '$topicid'  ");
echo "<table id='id1'>";
while($row = mysql_fetch_array($result1))
  {
  echo "<tr>";
 echo "<td>" . $row['TopicID'] .  "</td>";
 echo "<td>" . $row['Comments'] .  "</td>";
 echo "</tr>";
}

echo "</table>";

//******************************************************************************
 echo "</tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";

  }
echo "</table>";


echo "</div>";



mysql_close($con);

}



?>

</body>
</html> 
</html>

any help

Thread: collapslable database driven rows

Thread Tools

Display

collapslable database driven rows

Re: collapslable database driven rows

Re: collapslable database driven rows

Re: collapslable database driven rows

Re: collapslable database driven rows

Posting Permissions