File: /var/www/html/autoload_process.php
<?php
include("includes/limittext.php");
include('Connections/videoondemand.php');
require("DbSql2.inc.php");
require("NewsSql2.inc.php");
$db = new NewsSQL();
$items_per_group = 10;
$mysqli = new mysqli($DBHost, $DBUser, $DBPassword,$DBName);
if($_POST)
{
//sanitize post value
$group_number = filter_var($_POST["group_no"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
//throw HTTP error if group number is not valid
if(!is_numeric($group_number)){
header('HTTP/1.1 500 Invalid number!');
exit();
}
//get current starting point of records
$position = ($group_number * 5);
//Limit our results within a specified range.
$results = $mysqli->query("SELECT * FROM gallery where isdisplay =3 ORDER BY viewnum DESC LIMIT $position, $items_per_group");
if ($results) {
//output results from database
while($obj = $results->fetch_object())
{
$newsid = $db->base64url_encode($obj->newsid);
?>
<table id="Table_01" width="780" height="76" border="0" cellpadding="0" cellspacing="0" style="background-image:url(images/base.png); background-repeat:no-repeat; margin-bottom:5px; margin-top:5px">
<tr>
<td style="padding:5px">
<table width="780" cellspacing="0" cellpadding="0">
<tr >
<td width="64" valign="middle">
<a href="taswira.php?share=<?php print $newsid; ?>&width=900&image=/v/uploads/gallery/<?php print $obj->picture; ?>" class="albumpix" rel="albumpix"> <img src="taswira.php?width=100&height=60&nocache=1&cropratio=1.666666666666667:1&image=/v/uploads/gallery/<?php print $obj->picture; ?>" alt="edit thumb" title="Published: <?php echo $adddate ?>" width="100" height="60" style=" margin-left:2px;-moz-border-radius : 3px 3px 3px 3px:-webkit-border-radius : 3px 3px 3px 3px;border-radius : 3px 3px 3px 3px;"/> </a>
</td>
<td width="100%" valign="middle"><div align="left" style=" padding-left:10px; color:#FFF; font-size:14px" title="Published: <?php echo $adddate ?>" ><?php print $obj->title; ?>...</div></td>
<td width="40" style=" padding-right:15px">
</td>
<?php
$newsid = $db->base64url_encode($obj->newsid); ?>
<!-- <td width="54" valign="middle" >
<?php
switch($isdisplay){
case "3":
?>
<img src="images/distributed.png" width="40" alt="Pending Distribution" />
<?php
break;
case "2":
?>
<img src="images/distributionpending.png" width="40" alt="New Distribution Added But Pending" />
<?php
break;
case "1":
?>
<img src="images/distribute.png" width="40" alt="Distributed"/>
<?php
break;
case "0":
?>
<img src="no.png" alt="not featured" />
<?php
break;
}
?>
</td> -->
<td width="40" valign="middle" ><!--<a href="?mode=updateReport&newsid=<?php print "$newsid"; ?>"> <img src="images/edit.png" width="40" alt="Edit" hspace="10" /></a>--> </td>
<td width="104" style="padding-left:2px">
<?php
if ($isdisplay ==5 ){
?>
<a href="?mode=share&newsid=<?php print "$newsid"; ?>&newsid3=<?php print "$idS"; ?>"> <IMG src="images/share.png" id="Video_<?php echo $nnewsid; ?>" ></a>
<?php }
?>
</td>
<td width="30"> </td>
</tr></table>
</td></tr></table>
<?php }
}
unset($obj);
$mysqli->close();
}
?>