Table locking code

mbh23 · August 27, 2009

I am trying to lock the headers in my table. I have gotten it to work in html but when i try and echo it in php i get an error

Parse error: parse error, unexpected T_STRING, expecting ',' or ';'

Any help

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<?php include ("login.php");?>

<html>

<head>

<title>Lock Table Head</title>

/* DIV container around table to constrict the height for IE (IE ignores the tbody height style) */

div.FixedTableHead {

overflow-y:auto;

/* this fixes IE so container width is same as table width */

width: expression( (this.childNodes[0].clientWidth + 24) + 'px' );

/* This fixes IE so the container height is table height plus the height of the header */

height: expression( (parseInt(this.childNodes[0].style.height) + this.childNodes[0].childNodes[1].offsetTop + 1) +'px' );

}

/* Scrollable Content */

.FixedTableHead table tbody {

height:100%;

overflow-x:hidden;

overflow-y:auto;

}

.FixedTableHead table tbody tr {

height: auto;

white-space: nowrap;

}

/* Prevent Mozilla scrollbar from hiding right-most cell content */

.FixedTableHead table tbody tr td:last-child {

padding-right: 20px;

}

/* Fixed Header */

/* In WinIE any element with a position property set to relative and is a child of */

/* an element that has an overflow property set, the relative value translates into fixed. */

/* Ex: parent element DIV with a class of tableContainer has an overflow property set to auto */

.FixedTableHead table thead tr {

position: relative;

height: auto;

/* this fixes IE header jumping bug when mousing over rows in the tbody */

top: expression( this.parentNode.parentNode.parentNode.scrollTop + 'px' );

}

/* Fixed Header */

.FixedTableHead table thead tr td {

border-bottom:1px solid #000000;

background-color:white;

}

</style>

</head>

<body>

Lock Table Headings<br />

<?php

echo"<div class="FixedTableHead">";

echo"<table cellspacing=0 style="height:100px;">";

echo" <thead>";

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

echo" </thead>";

$query = "select id from master where period='09P3'";

$result = mysql_query($query) or die(mysql_error());

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

echo" <tbody>

</tbody>";

}

echo" </table>";

echo"</div>";

?>

</body>

</html>

Maq · August 27, 2009

Please use

tags.

You have to learn about string formatting and interpolation. You're using double quotes for your string and attributes. The attributes should be using single quotes.

 {$row[id]}

In the line above, you're using curly braces for no reason. Associative arrays are supposed to have single quotes around the keys and surrounding it with curly braces allows you to do that.

Bendude14 · August 27, 2009

Please use code tags next time...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<?php include ("login.php");?>

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>Lock Table Head</title>

<style type='text/css'>

/* DIV container around table to constrict the height for IE (IE ignores the tbody height style) */
div.FixedTableHead {
   overflow-y:auto;
   
   /* this fixes IE so container width is same as table width */
   width: expression( (this.childNodes[0].clientWidth + 24) + 'px' );
   
   /* This fixes IE so the container height is table height plus the height of the header */
   height: expression( (parseInt(this.childNodes[0].style.height) + this.childNodes[0].childNodes[1].offsetTop + 1) +'px' );
}

/* Scrollable Content */
.FixedTableHead table tbody {
   height:100%;
   overflow-x:hidden;
   overflow-y:auto;
}

.FixedTableHead table tbody tr {
   height: auto;
   white-space: nowrap;
}

/* Prevent Mozilla scrollbar from hiding right-most cell content */
.FixedTableHead table tbody tr td:last-child {
   padding-right: 20px;
}

/* Fixed Header */
/* In WinIE any element with a position property set to relative and is a child of       */
/* an element that has an overflow property set, the relative value translates into fixed.    */
/* Ex: parent element DIV with a class of tableContainer has an overflow property set to auto */
.FixedTableHead table thead tr {
   position: relative;
   height: auto;
   /* this fixes IE header jumping bug when mousing over rows in the tbody */
   top: expression( this.parentNode.parentNode.parentNode.scrollTop + 'px' );
}

/* Fixed Header */
.FixedTableHead table thead tr td {
   border-bottom:1px solid #000000;
   background-color:white;
}
</style>

</head>

<body>

Lock Table Headings<br />


<div class='FixedTableHead'>
<table cellspacing=0 style='height:100px;'>
<thead>
<tr><td>ID</td></tr>
</thead>
<?php
      $query =  "select id from master where period='09P3'";
      $result = mysql_query($query) or die(mysql_error());
   
while($row = mysql_fetch_array($result)){
   echo"   <tbody><tr><td> {$row['id']}</td></tr>
   
      </tbody>";
   }
echo"   </table>";
echo"</div>";
?>

</body>
</html>

The errors were been caused by your extra quotes on your attributes. I just moved them out of the php section for now. I also added single quotes to your array keys...

Doh somoene beat me to it but im posting this anyway...

mbh23 · September 3, 2009

im using the code and it doesn't throw up any errors but it is still no locking the headers?

Sign In

Table locking code

Recommended Posts

mbh23

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

Bendude14

Link to comment

Share on other sites

mbh23

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information