01.<!DOCTYPE html>
02.<html>
03.<head>
04.<link rel="stylesheet" type="text/css" href="mystyle.css" />
05.<meta charset="UTF-8" />
06.<title>jQuery Hilight Table Rows </title>
08.</head>
09.
10.<body>
11.
12.<div id="Result">
13.<?php
14.$Hostname = "localhost";
15.$Hostuser = "root";
16.$Hostpass = "";
17.$Db_name = "";
18. $link = mysql_connect($Hostname, $Hostuser, $Hostpass) or die (mysql_error());
19. $sel_db = mysql_select_db($Db_name, $link);
20.
21.function Sex_val($val){
22. if($val == 1){
23. $Sex = "Male";
24. }else{
25. $Sex = "Female";
26. }
27. return $Sex;
28.}
29.
30.function Major_val($val){
31. if($val == 1){
32. $Major = "Computer1";
33. }elseif($val == 2){
34. $Major = "Computer2";
35. }else{
36. $Major = "Computer3";
37. }
38. return $Major;
39.}
40.
41.
42. $Sql = "SELECT * FROM student_data";
43. $Qr_Sql = mysql_query($Sql);
44. $rows = mysql_num_rows($Qr_Sql);
45.
46. if($rows <= 0){
47. echo "Not found. !!!";
48.}else{
49.?>
50.
51.<table align="center" width="800" border="1">
52. <tr>
53. <th>Name</th>
54. <th>Surename</th>
55. <th>Sex</th>
56. <th>Major</th>
57. </tr>
58.<?php
59. while($fetch = mysql_fetch_array($Qr_Sql)){
60. $numbers++;
61. if($numbers%2 == 0 ){$Col = "Col2";}else{$Col = "Col1";}
62.?>
63. <tr class="<?=$Col?>">
64. <td ><?=$fetch["Name"];?></td>
65. <td><?=$fetch["Surename"];?></td>
66. <td><?=Sex_val($fetch["Sex"]);?></td>
67. <td><?=Major_val($fetch["Major"]);?></td>
68.<?php
69. }
70.}
71.?>
72.</tr>
73.</table>
74.</div>
75.
76.<script type="text/javascript">
77.$(document).ready(function(){
78.
79. $('.Col1, .Col2').mouseover(function(){
80. $(this).toggleClass('highlight');
81. });
82.
83. $('.Col1, .Col2').mouseout(function(){
84. $(this).toggleClass('highlight');
85.
86. });
87.});
88.</script>
89.</body>
90.</html>
