Ticketa каза:Добавяш си една колона `views` при преглед на новината правиш UPDATE заявка с view+1
UPDATE `news` SET views = views +1 WHERE `news_id` = $id;
<?php
$pid=intval($_GET['nid']);
$query=mysqli_query($con,"select tblposts.PostTitle as posttitle,tblposts.id as pid,tblposts.Count as count,tblposts.Vrolite as vrolite,tblposts.Rejisior as rejisior,tblposts.Tags as tags,tblposts.Vremetraene as vremetraene,tblposts.DataSuzdavane as datasuzdavane,tblposts.Imdbrating as imdbrating,tblposts.Tags as tags,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.Video as video,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.id='$pid'");
while ($row=mysqli_fetch_array($query)) {
?>
Vladislaw каза:Ticketa каза:Добавяш си една колона `views` при преглед на новината правиш UPDATE заявка с view+1
UPDATE `news` SET views = views +1 WHERE `news_id` = $id;
Добавил съм такава колона "count" и изкарвам резултата така:
Код:<?php $pid=intval($_GET['nid']); $query=mysqli_query($con,"select tblposts.PostTitle as posttitle,tblposts.id as pid,tblposts.Count as count,tblposts.Vrolite as vrolite,tblposts.Rejisior as rejisior,tblposts.Tags as tags,tblposts.Vremetraene as vremetraene,tblposts.DataSuzdavane as datasuzdavane,tblposts.Imdbrating as imdbrating,tblposts.Tags as tags,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.Video as video,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.id='$pid'"); while ($row=mysqli_fetch_array($query)) { ?>
Демек да добавя update в този код?
Vladislaw каза:Нещо май не правя както трябва, пробвах и така
$update=mysql_query("UPDATE `tblposts` SET count = count +1 WHERE `id` = $id;");
но грешка в страницата.
WHERE `id` = " . (int) $id . ";"
<?php
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 3;
}
$no_of_records_per_page = 5;
$offset = ($pageno-1) * $no_of_records_per_page;
$total_pages_sql = "SELECT COUNT(*) FROM tblposts";
$result = mysqli_query($con,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$query=mysqli_query($con,"select tblposts.id as pid,tblposts.Datasuzdavane as datasuzdavane,tblposts.Vremetraene as vremetraene,tblposts.Imdbrating as imdbrating,tblposts.PostTitle as posttitle,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.Is_Active=1 order by tblposts.id desc LIMIT $offset, $no_of_records_per_page");
while ($row=mysqli_fetch_array($query)) {
?>
<?php
$pid=intval($_GET['nid']);
$query=mysqli_query($con,"select tblposts.PostTitle as posttitle,tblposts.id as pid,tblposts.Count as count,tblposts.Vrolite as vrolite,tblposts.Rejisior as rejisior,tblposts.Tags as tags,tblposts.Vremetraene as vremetraene,tblposts.DataSuzdavane as datasuzdavane,tblposts.Imdbrating as imdbrating,tblposts.Tags as tags,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.Video as video,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.id='$pid'");
while ($row=mysqli_fetch_array($query)) {
?>
uphero каза:как ги правите тия сайтове като една заявка не може да дебъгнеш?
<?php
$pid=intval($_GET['nid']);
$query=mysqli_query($con,"select tblposts.PostTitle as posttitle,tblposts.id as pid,tblposts.Count as count,tblposts.Vrolite as vrolite,tblposts.Rejisior as rejisior,tblposts.Tags as tags,tblposts.Vremetraene as vremetraene,tblposts.DataSuzdavane as datasuzdavane,tblposts.Imdbrating as imdbrating,tblposts.Tags as tags,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.Video as video,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.id='$pid'");
while ($row=mysqli_fetch_array($query)) {
?>