Mr.n Posted June 3, 2008 Share Posted June 3, 2008 hello, i have a php script that prints the records fetched from a table in mysql in a <table> <tr><td>, when the number of records is higher than the size of the page, no scroll bar appear. Anyone knows how can i resolv this please? i need to allow users to see all the data printed. Quote Link to comment Share on other sites More sharing options...
samshel Posted June 3, 2008 Share Posted June 3, 2008 scrolling or not scrolling is part of HTML and does not have anything to do with PHP, Please post your HTML code and we can help you further. Quote Link to comment Share on other sites More sharing options...
Mr.n Posted June 3, 2008 Author Share Posted June 3, 2008 here is my html code produced by the php script: echo '<html><body scroll="yes"><tbody><br><br><br><br><br><br><br><br><br><br><br><table border="0" width="520" id="table1" height="68"> <tr> <td height="29" colspan="2"><font size="4" color="darkblue"> <td width="1%"/> <hr color="blue"><center>Missions: '.$this->ESearchMission->Text.'</center></font><hr color="blue"></td> </tr> <tr> <td width="1%"/> <td height="33" width="8%"> </td> <td height="33" width="79%"> <table border="0" width="100%" id="table2" height="27"> <tr valign=top><tr valign=top><td width=8%><center><bold>ID</bold></center></td><td width=100%><center><font size="3">Name</font></center></td><td width="21"></td></tr>'; $num_results = mysql_num_rows($result); if ($num_results == 0) { echo '<tr><td colspan="3"><bold>No match retrieved</bold></td></tr>'; } else { while($data=mysql_fetch_row($result)) { if ($k < $j + 6) echo('<tr valign=top><td bgcolor="#efefef" width=8%><font size="3">'.$data[0].'</font></td><td bgcolor="#efefef" width=100%><font size="3">'.$data[1].'</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID='.$data[0].'"><img border="0" src="images/edit.png" width="20" height="20"></a></td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID='.$data[0].'" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20"></a></td></tr>'); } mysql_free_result($result); } echo '</table></td></tr></table></tbody></body></html>'; Quote Link to comment Share on other sites More sharing options...
samshel Posted June 3, 2008 Share Posted June 3, 2008 Please paste view source of the page you see in browser, i.e. only the HTML Quote Link to comment Share on other sites More sharing options...
Mr.n Posted June 3, 2008 Author Share Posted June 3, 2008 <html><body scroll="yes"><tbody><br><br><br><br><br><br><br><br><br><br><br><table border="0" width="520" id="table1" height="68"> <tr> <td height="29" colspan="2"><font size="4" color="darkblue"> <td width="1%"/> <hr color="blue"><center>Missions: </center></font><hr color="blue"></td> </tr> <tr> <td width="1%"/> <td height="33" width="8%"> </td> <td height="33" width="79%"> <table border="0" width="100%" id="table2" height="27"> <tr valign=top><tr valign=top><td width=8%><center><bold>ID</bold></center></td><td width=100%><center><font size="3">Name</font></center></td><td width="21"></td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">126</font></td><td bgcolor="#efefef" width=100%><font size="3">Ingenieur Systeme reseaux multimedia test</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=126"><img border="0" src="images/edit.png" width="20" height="20"></a></td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=126" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20"></a></td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">117</font></td><td bgcolor="#efefef" width=100%><font size="3">charbel</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=117"><img border="0" src="images/edit.png" width="20" height="20"></a></td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=117" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20"></a></td></tr></table></td></tr></table></tbody></body></html><html DIR=ltr > Quote Link to comment Share on other sites More sharing options...
samshel Posted June 3, 2008 Share Posted June 3, 2008 I put the above code in a blank file , added many rows to it, and opened it in browser. it does show a scroll bar. Quote Link to comment Share on other sites More sharing options...
Mr.n Posted June 3, 2008 Author Share Posted June 3, 2008 here is all the code with the scripts, not only the html body: <html><body scroll="yes"><tbody><br><br><br><br><br><br><br><br><br><br><br><table border="0" width="520" id="table1" height="68"> <tr> <td height="29" colspan="2"><font size="4" color="darkblue"> <td width="1%"/> <hr color="blue"><center>Missions: </center></font><hr color="blue"></td> </tr> <tr> <td width="1%"/> <td height="33" width="8%"> </td> <td height="33" width="79%"> <table border="0" width="100%" id="table2" height="27"> <tr valign=top><tr valign=top><td width=8%><center><bold>ID</bold></center></td><td width=100%><center><font size="3">Name</font></center></td><td width="21"></td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">126</font></td><td bgcolor="#efefef" width=100%><font size="3">Ingenieur Systeme reseaux multimedia test</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=126"><img border="0" src="images/edit.png" width="20" height="20"></a></td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=126" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20"></a></td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">117</font></td><td bgcolor="#efefef" width=100%><font size="3">charbel</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=117"><img border="0" src="images/edit.png" width="20" height="20"></a></td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=117" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20"></a></td></tr></table></td></tr></table></tbody></body></html><html DIR=ltr > <head> <title>Admin missions</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <script type="text/javascript" src="/vcl-bin/js/common.js"></script> <script type="text/javascript">var UAdminmissions=new Object(Object);</script> <script type="text/javascript"> <!-- function EMissionName_updatehidden(event) { edit=findObj('EMissionName'); hidden=findObj('EMissionName_hidden'); hidden.value=edit.value; } function EMissionNotes_updatehidden(event) { edit=findObj('EMissionNotes'); hidden=findObj('EMissionNotes_hidden'); hidden.value=edit.value; } function Button1ClickWrapper(event, hiddenfield, submitvalue, wrappedfunc) { var event = event || window.event; submit1=true; submit2=true; if (typeof(wrappedfunc) == 'function') submit1=wrappedfunc(event); hiddenfield.value = submitvalue; form = hiddenfield.form; if ((form) && (form.onsubmit) && (typeof(form.onsubmit) == 'function')) submit2=form.onsubmit(); if ((submit1) && (submit2)) form.submit(); return false; } function ESearchMission_updatehidden(event) { edit=findObj('ESearchMission'); hidden=findObj('ESearchMission_hidden'); hidden.value=edit.value; } --> </script> <script type="text/javascript" src="/vcl-bin/qooxdoo/framework/script/qx.js" charset="UTF-8"></script> <script type="text/javascript"> qx.log.Logger.ROOT_LOGGER.setMinLevel(qx.log.Logger.LEVEL_FATAL); qx.manager.object.AliasManager.getInstance().add("static", "/vcl-bin/qooxdoo/framework/resource/static/"); qx.manager.object.AliasManager.getInstance().add("widget", "/vcl-bin/qooxdoo/framework/resource/widget/windows/"); qx.manager.object.AliasManager.getInstance().add("icon", "/vcl-bin/qooxdoo/framework/resource/icon/VistaInspirate/"); </script> </head> <body style=" margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; " > <form style="margin-bottom: 0" id="UAdminmissions" name="UAdminmissions" method="post" action="/Admin_missions.php"><input type="hidden" name="EMissionName_hidden" value=""><input type="hidden" name="EMissionNotes_hidden" value=""><input type="hidden" id="addSubmitEvent" name="addSubmitEvent" value="" /><input type="hidden" name="ESearchMission_hidden" value=""> <script type="text/javascript"> var d = qx.ui.core.ClientDocument.getInstance(); d.setBackgroundColor(null); </script> <table width="584" style="height:288px" border="0" cellpadding="0" cellspacing="0" ><tr><td valign="top"> <div id="GroupBox1_outer" style="Z-INDEX: 0; LEFT: 58px; WIDTH: 456px; POSITION: absolute; TOP: 18px; HEIGHT: 104px"> <input type="hidden" id="GroupBox1_state" name="GroupBox1_state" value="" /> <div id="GroupBox1"></div> <script type="text/javascript"> var d = qx.ui.core.ClientDocument.getInstance(); var inline_div = new qx.ui.basic.Inline("GroupBox1"); inline_div.setHeight("auto"); inline_div.setWidth("auto"); var GroupBox1 = new qx.ui.groupbox.GroupBox("New record"); GroupBox1.setWidth(456); GroupBox1.setHeight(104); d.add(inline_div); inline_div.add(GroupBox1); </script> </div> <div id="EMissionName_outer" style="Z-INDEX: 1; LEFT: 177px; WIDTH: 169px; POSITION: absolute; TOP: 45px; HEIGHT: 21px"> <input type="text" id="EMissionName" onchange="return EMissionName_updatehidden(event)" name="EMissionName" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:169px;" tabindex="0" /> </div> <div id="Label1_outer" style="Z-INDEX: 2; LEFT: 96px; WIDTH: 75px; POSITION: absolute; TOP: 49px; HEIGHT: 13px"> <div id="Label1" style=" font-family: Verdana; font-size: 10px; height:13px;width:75px;" >Name:</div> </div> <div id="EMissionNotes_outer" style="Z-INDEX: 3; LEFT: 177px; WIDTH: 169px; POSITION: absolute; TOP: 73px; HEIGHT: 21px"> <input type="text" id="EMissionNotes" onchange="return EMissionNotes_updatehidden(event)" name="EMissionNotes" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:169px;" tabindex="0" /> </div> <div id="Notes_outer" style="Z-INDEX: 4; LEFT: 96px; WIDTH: 75px; POSITION: absolute; TOP: 77px; HEIGHT: 13px"> <div id="Notes" style=" font-family: Verdana; font-size: 10px; height:13px;width:75px;" >Notes:</div> </div> <div id="add_outer" style="Z-INDEX: 5; LEFT: 420px; WIDTH: 59px; POSITION: absolute; TOP: 74px; HEIGHT: 20px"> <input type="submit" id="add" name="add" value="add" onclick="return Button1ClickWrapper(event, findObj('addSubmitEvent'), 'add_Button1Click')" style=" font-family: Verdana; font-size: 10px; height:20px;width:59px;" tabindex="0" /> </div> <div id="ESearchMission_outer" style="Z-INDEX: 6; LEFT: 221px; WIDTH: 121px; POSITION: absolute; TOP: 157px; HEIGHT: 21px"> <input type="text" id="ESearchMission" onchange="return ESearchMission_updatehidden(event)" name="ESearchMission" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:121px;" tabindex="0" /> </div> <div id="Button1_outer" style="Z-INDEX: 7; LEFT: 356px; WIDTH: 59px; POSITION: absolute; TOP: 157px; HEIGHT: 21px"> <input type="submit" id="Button1" name="Button1" value="Filter" style=" font-family: Verdana; font-size: 10px; height:21px;width:59px;" tabindex="0" /> </div> <div id="Label2_outer" style="Z-INDEX: 8; LEFT: 161px; WIDTH: 51px; POSITION: absolute; TOP: 161px; HEIGHT: 13px"> <div id="Label2" style=" font-family: Verdana; font-size: 10px; height:13px;width:51px;" >Filter:</div> </div> </td></tr></table> </form></body> </html> <!-- UAdminmissions end --> Quote Link to comment Share on other sites More sharing options...
samshel Posted June 3, 2008 Share Posted June 3, 2008 Putting all this code in a file and opening i see only 2 rows, so it wont show a scroll bar.sorry if i am getting it wrong. Quote Link to comment Share on other sites More sharing options...
Mr.n Posted June 3, 2008 Author Share Posted June 3, 2008 when i save localy the file as html i see a scrollbar when open it the webserver i dont see a scrollbar. here is the code try it plz you should see a scrollbar: <html><body scroll="yes"><tbody> <table border="0" width="520" id="table1" height="68"> <tr> <td height="29" colspan="2"><font size="4" color="darkblue"> <td width="1%"/> <hr color="blue"><center>Missions: </center></font><hr color="blue"></td> </tr> <tr> <td width="1%"/> <td height="33" width="8%"> </td> <td height="33" width="79%"> <table border="0" width="100%" id="table2" height="27"> <tr valign=top><tr valign=top><td width=8%><center><bold>ID</bold></center></td><td width=100%><center><font size="3">Name</font></center></td><td width="21"></td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">126</font></td><td bgcolor="#efefef" width=100%><font size="3">Ingenieur Systeme reseaux multimedia test</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=126"><img border="0" src="images/edit.png" width="20" height="20">[/url]</td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=126" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20">[/url]</td></tr><tr valign=top><td bgcolor="#efefef" width=8%><font size="3">117</font></td><td bgcolor="#efefef" width=100%><font size="3">charbel</font></td><td bgcolor="#efefef"><a href="execute_update_Tmission.php?ID=117"><img border="0" src="images/edit.png" width="20" height="20">[/url]</td><td bgcolor="#efefef"><a href="execute_delete.php?Table=Tmission&ID=117" style="width=1;height=1;"><img border="0" src="images/delete.png" width="20" height="20">[/url]</td></tr></table></td></tr></table></tbody></body></html><html DIR=ltr > <head> <title>Admin missions</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <script type="text/javascript" src="/vcl-bin/js/common.js"></script> <script type="text/javascript">var UAdminmissions=new Object(Object);</script> <script type="text/javascript"> <!-- function EMissionName_updatehidden(event) { edit=findObj('EMissionName'); hidden=findObj('EMissionName_hidden'); hidden.value=edit.value; } function EMissionNotes_updatehidden(event) { edit=findObj('EMissionNotes'); hidden=findObj('EMissionNotes_hidden'); hidden.value=edit.value; } function Button1ClickWrapper(event, hiddenfield, submitvalue, wrappedfunc) { var event = event || window.event; submit1=true; submit2=true; if (typeof(wrappedfunc) == 'function') submit1=wrappedfunc(event); hiddenfield.value = submitvalue; form = hiddenfield.form; if ((form) && (form.onsubmit) && (typeof(form.onsubmit) == 'function')) submit2=form.onsubmit(); if ((submit1) && (submit2)) form.submit(); return false; } function ESearchMission_updatehidden(event) { edit=findObj('ESearchMission'); hidden=findObj('ESearchMission_hidden'); hidden.value=edit.value; } --> </script> <script type="text/javascript" src="/vcl-bin/qooxdoo/framework/script/qx.js" charset="UTF-8"></script> <script type="text/javascript"> qx.log.Logger.ROOT_LOGGER.setMinLevel(qx.log.Logger.LEVEL_FATAL); qx.manager.object.AliasManager.getInstance().add("static", "/vcl-bin/qooxdoo/framework/resource/static/"); qx.manager.object.AliasManager.getInstance().add("widget", "/vcl-bin/qooxdoo/framework/resource/widget/windows/"); qx.manager.object.AliasManager.getInstance().add("icon", "/vcl-bin/qooxdoo/framework/resource/icon/VistaInspirate/"); </script> </head> <body style=" margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; " > <form style="margin-bottom: 0" id="UAdminmissions" name="UAdminmissions" method="post" action="/Admin_missions.php"><input type="hidden" name="EMissionName_hidden" value=""><input type="hidden" name="EMissionNotes_hidden" value=""><input type="hidden" id="addSubmitEvent" name="addSubmitEvent" value="" /><input type="hidden" name="ESearchMission_hidden" value=""> <script type="text/javascript"> var d = qx.ui.core.ClientDocument.getInstance(); d.setBackgroundColor(null); </script> <table width="584" style="height:288px" border="0" cellpadding="0" cellspacing="0" ><tr><td valign="top"> <div id="GroupBox1_outer" style="Z-INDEX: 0; LEFT: 58px; WIDTH: 456px; POSITION: absolute; TOP: 18px; HEIGHT: 104px"> <input type="hidden" id="GroupBox1_state" name="GroupBox1_state" value="" /> <div id="GroupBox1"></div> <script type="text/javascript"> var d = qx.ui.core.ClientDocument.getInstance(); var inline_div = new qx.ui.basic.Inline("GroupBox1"); inline_div.setHeight("auto"); inline_div.setWidth("auto"); var GroupBox1 = new qx.ui.groupbox.GroupBox("New record"); GroupBox1.setWidth(456); GroupBox1.setHeight(104); d.add(inline_div); inline_div.add(GroupBox1); </script> </div> <div id="EMissionName_outer" style="Z-INDEX: 1; LEFT: 177px; WIDTH: 169px; POSITION: absolute; TOP: 45px; HEIGHT: 21px"> <input type="text" id="EMissionName" onchange="return EMissionName_updatehidden(event)" name="EMissionName" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:169px;" tabindex="0" /> </div> <div id="Label1_outer" style="Z-INDEX: 2; LEFT: 96px; WIDTH: 75px; POSITION: absolute; TOP: 49px; HEIGHT: 13px"> <div id="Label1" style=" font-family: Verdana; font-size: 10px; height:13px;width:75px;" >Name:</div> </div> <div id="EMissionNotes_outer" style="Z-INDEX: 3; LEFT: 177px; WIDTH: 169px; POSITION: absolute; TOP: 73px; HEIGHT: 21px"> <input type="text" id="EMissionNotes" onchange="return EMissionNotes_updatehidden(event)" name="EMissionNotes" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:169px;" tabindex="0" /> </div> <div id="Notes_outer" style="Z-INDEX: 4; LEFT: 96px; WIDTH: 75px; POSITION: absolute; TOP: 77px; HEIGHT: 13px"> <div id="Notes" style=" font-family: Verdana; font-size: 10px; height:13px;width:75px;" >Notes:</div> </div> <div id="add_outer" style="Z-INDEX: 5; LEFT: 420px; WIDTH: 59px; POSITION: absolute; TOP: 74px; HEIGHT: 20px"> <input type="submit" id="add" name="add" value="add" onclick="return Button1ClickWrapper(event, findObj('addSubmitEvent'), 'add_Button1Click')" style=" font-family: Verdana; font-size: 10px; height:20px;width:59px;" tabindex="0" /> </div> <div id="ESearchMission_outer" style="Z-INDEX: 6; LEFT: 221px; WIDTH: 121px; POSITION: absolute; TOP: 157px; HEIGHT: 21px"> <input type="text" id="ESearchMission" onchange="return ESearchMission_updatehidden(event)" name="ESearchMission" value="" style=" font-family: Verdana; font-size: 10px; height:20px;width:121px;" tabindex="0" /> </div> <div id="Button1_outer" style="Z-INDEX: 7; LEFT: 356px; WIDTH: 59px; POSITION: absolute; TOP: 157px; HEIGHT: 21px"> <input type="submit" id="Button1" name="Button1" value="Filter" style=" font-family: Verdana; font-size: 10px; height:21px;width:59px;" tabindex="0" /> </div> <div id="Label2_outer" style="Z-INDEX: 8; LEFT: 161px; WIDTH: 51px; POSITION: absolute; TOP: 161px; HEIGHT: 13px"> <div id="Label2" style=" font-family: Verdana; font-size: 10px; height:13px;width:51px;" >Filter:</div> </div> </td></tr></table> </form></body> </html> <!-- UAdminmissions end --> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.