<%
int imgCount = 0;
int rowCount = 0;
int imageid = 0;
int tdCount = 5;
String img_name = null;
String url_image = null;
if ( search != null )
{
strSQL = "Select * from up_images where img_store='S' and img_name Like '%" + search + "%' order by img_name";
}
else
{
strSQL = "Select * from up_images where img_store='S' order by img_name";
}
rs = dbcon.executeQuery ( strSQL, chDelete, preview, pid );
pid = dbcon.getpageID ( );
totalRow = dbcon.getTotalRow ( );
totalPage = dbcon.getTotalPage ( );
%>
| หน้า <%= pid %> จาก <%= totalPage %> |
|
|
<%
Vector imgFunction = new Vector ( );
while ( rs.next ( ) )
{
imageid = rs.getInt ( "imageid" );
img_name = rs.getString ( "img_name" );
url_image = rs.getString ( "url_image" );
// @@@ START LINUX
// img_name = new String ( img_name.getBytes ( "ISO8859_1" ), "MS874" );
// @@@ END LINUX
imgFunction.addElement ( "" + imageid );
if ( imgCount == 0 )
{
out.print ( "" );
}
%>
 { out.print ( url_image ); } %>)
| <% if ( img_name != null ) { out.print ( img_name ); } %> |
|
<%
imgCount++;
rowCount++;
if ( imgCount >= tdCount )
{
out.print ( " | " );
imgCount = 0;
}
if ( rowCount >= preview )
{
rs.afterLast ( );
}
}
rs.close ( );
for ( int i = imgCount; i < tdCount; i++ )
{
out.print ( " | " );
if ( i == tdCount )
{
out.print ( "" );
}
}
if ( rowCount == 0 )
{
pid = 0;
}
%>
|