JohnCMS da bosh sahifaga chiqarish

TimX
#501 18:17:52, 20 Jun 2020

Besthakker, # Besthakker (20.06.2020 / 17:19)
TimX, <?php

echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$kmess = '7';
$cat_id = 48; //bu yerga kategorya idsini yozasiz
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `libraMan boshqacha chiqardim. Qatta `premod`=1 bo'lsa, shuni o'rniga `cat_id`=NumberID qilib chiqdim. Ishladi lekin

0

code_one
#502 21:02:09, 23 Jun 2020

Johncmsda bosh sahifada if bilan ishlash qanday buladi masalan shu forumda bilidirish nomani bossa orqasidagi div class ozgaradi shuni qanday qilingan
if (??) {
<div class="test"><img src="m.png"></div>
}
else{<div class="test2">.....</div>
}
shunaqa ??ni ichiga nima yozish kerak

0

@uMansurov
#503 21:53:07, 23 Jun 2020

ʬʬΞ NOKIA Ξʬʬ, # ʬʬΞ NOKIA Ξʬʬ (23.06.2020 / 21:02)
Johncmsda bosh sahifada if bilan ishlash qanday buladi masalan shu forumda bilidirish nomani bossa orqasidagi div class ozgaradi shuni qanday qilingan
if (??) {
<div class="test"><img src="m.png"></

if ($mysqlkodnomibuyerda) {
echo '<div class="test"><img src="m.png"></div>';
}
 else { 
echo '<div class="test2">.....</div>';
}

1

code_one
#504 22:01:12, 23 Jun 2020

Улугбек, # Улугбек (23.06.2020 / 21:53)
ʬʬΞ NOKIA Ξʬʬ, if ($mysqlkodnomibuyerda) {
echo '<div class="test"><img src="m.png"></div>';
}
else {
echo '<div class="test2">.....</div>';
}Kod nomi digan joyiga nima yoziladi html kodmi yoki istalgan nom ?

0

@uMansurov
#505 22:31:04, 23 Jun 2020

ʬʬΞ NOKIA Ξʬʬ, # ʬʬΞ NOKIA Ξʬʬ (23.06.2020 / 22:01)
Улугбек, Kod nomi digan joyiga nima yoziladi html kodmi yoki istalgan nom ?$nom=...kodlar balo battarlar);

if ($nom) {

shunaqa

$nom=....davomi

bu mysql kod bu kod orqali if beriladi bolmasa yoq

$nom bu mysql kod nomi

1

Tayota
#506 23:28:59, 23 Jun 2020

Улугбек, # Улугбек (23.06.2020 / 22:31)
ʬʬΞ NOKIA Ξʬʬ, $nom=...kodlar balo battarlar);

if ($nom) {

shunaqa

$nom=....davomi

bu mysql kod bu kod orqali if beriladi bolmasa yoq

$nom bu mysql kod nomiPrichom betda mysql?

1

#507 23:31:33, 23 Jun 2020

ʬʬΞ NOKIA Ξʬʬ, # ʬʬΞ NOKIA Ξʬʬ (23.06.2020 / 21:02)
Johncmsda bosh sahifada if bilan ishlash qanday buladi masalan shu forumda bilidirish nomani bossa orqasidagi div class ozgaradi shuni qanday qilingan
if (??) {
<div class="test"><img src="m.png"></if($headmod == "mainpage"){
bosh sahifada
}else{
bosh sahifada emas
}
59 soniyadan keyin yozdi:
Headmodga qarab mosluras

2

Fanat_FCB
#508 19:11:14, 22 Aug 2020

Bosh sahifaga newsni eng kup uqilganlarini chiqaradigan kod kerak

0

CleverBoy
#509 19:48:07, 22 Aug 2020

Fanat_FCB,

$req = mysql_query("SELECT * FROM `cms_news` WHERE `time` > '".(TIME()-86400*7)."' ORDER BY `reads` DESC LIMIT 10;");

2

@uMansurov
#510 22:22:54, 22 Aug 2020

CleverBoy, # CleverBoy (22.08.2020 / 19:48)
Fanat_FCB, $req = mysql_query("SELECT * FROM `cms_news` WHERE `time` > '".(time()-86400*7)."' ORDER BY `reads` DESC LIMIT 10;");Bu manimcha haftalik ni chiqaradi, shuni 2yoki3 kunlik qilib chiqarish kodi qanaqa endi

0

code_one
#511 02:22:05, 23 Aug 2020

Мансуров Улугбек, TIME()-86400*7
bu yerda 86400 sek shuni tahrirlasiz kerak manimcha

0

CleverBoy
#512 04:43:40, 23 Aug 2020

Мансуров Улугбек, Tepani qarang haftaning eng ko'p o'qilgani kerak degan "'.(time()-86400*1 yoki 2 yoki 3).'" Bo'ldi

0

sobirjonovv
#513 11:39:41, 24 Aug 2020

<?php
 
echo '<div class="blue">';
echo '<div class="phdr"><center><b>Новые</b></center></div>';
$kmess = '5';
 
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `time` AND `cat_id`= 1"), 0);
$page = $page >= ceil($total / $kmess) ? ceil($total / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$sql = mysql_query("SELECT `id`, `name`, `time`, `uploader`, `uploader_id`, `count_views`, `comments`, `count_comments`, `cat_id`, `announce` FROM `library_texts` WHERE `cat_id`=1 ORDER BY `time` DESC LIMIT " . $start . "," . $kmess);
$nav = ($total > $kmess) ? '<div class="menu"><center>' . functions::display_pagination('?act=new&amp;', $start, $total, $kmess) . '</center></div>' : '';
if ($total) {
    $i = 0;
    while ($lib = mysql_fetch_assoc($sql)) {
$comm = mysql_result( mysql_query("select count(*)  from `cms_library_comments` where `refid` = '".$lib['id']."'"),0);
 
echo '<div class="menu"><a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"><b>' . $lib['name'] . '</a></b><br>';
$post1 = functions::checkout($lib['announce'], 1, 1);
$post = functions::smileys($post1, 1);
echo $post;
echo '<br/>';
$catalog  = mysql_fetch_assoc(mysql_query("SELECT `id`, `name` FROM `library_cats` WHERE `id` = " . $lib['cat_id'] . " LIMIT 1"));
echo '['. functions::display_date($lib['time']) . ']';
 
echo  '[<a href="/library/index.php?act=comments&amp;id=' . $lib['id'] . '">Обсуждения (' . $lib['count_comments'] . ')</a>]';
echo '<span style="float:right;"><b>[' . $lib['count_views'] . ']</b></span></div>';
 
}
}
echo '<div class="menu"><a href="' . $set['homeurl'] . '/library/index.php?do=dir&id=1"><b>Показать все >></a></b></div></div>';
?>

bu kod librarydagi maqolalarni faqat bitta cat bo'yicha chiqaryapti. Huddi shu kodni tahrirlab beringlar, librarydagi umumiy yangi maqolalar chiqadigan qilib.

0

CleverBoy
#514 12:36:13, 24 Aug 2020

VORZAKON, $total dan buni olib tashlang AND `cat_id`= 1

1

Ulty
#515 17:41:04, 24 Aug 2020

VORZAKON,

<?php
 
echo '<div class="blue">';
echo '<div class="phdr"><center><b>Новые</b></center></div>';
$kmess = '5';
 
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts`"), 0);
$page = $page >= ceil($total / $kmess) ? ceil($total / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$sql = mysql_query("SELECT `id`, `name`, `time`, `uploader`, `uploader_id`, `count_views`, `comments`, `count_comments`, `cat_id`, `announce` FROM `library_texts` ORDER BY `time` DESC LIMIT " . $start . "," . $kmess);
$nav = ($total > $kmess) ? '<div class="menu"><center>' . functions::display_pagination('?act=new&amp;', $start, $total, $kmess) . '</center></div>' : '';
if ($total) {
    $i = 0;
    while ($lib = mysql_fetch_assoc($sql)) {
$comm = mysql_result( mysql_query("select count(*)  from `cms_library_comments` where `refid` = '".$lib['id']."'"),0);
 
echo '<div class="menu"><a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"><b>' . $lib['name'] . '</a></b><br>';
$post1 = functions::checkout($lib['announce'], 1, 1);
$post = functions::smileys($post1, 1);
echo $post;
echo '<br/>';
$catalog  = mysql_fetch_assoc(mysql_query("SELECT `id`, `name` FROM `library_cats` WHERE `id` = " . $lib['cat_id'] . " LIMIT 1"));
echo '['. functions::display_date($lib['time']) . ']';
 
echo  '[<a href="/library/index.php?act=comments&amp;id=' . $lib['id'] . '">Обсуждения (' . $lib['count_comments'] . ')</a>]';
echo '<span style="float:right;"><b>[' . $lib['count_views'] . ']</b></span></div>';
 
}
}
echo '<div class="menu"><a href="' . $set['homeurl'] . '/library/index.php?do=dir&id=1"><b>Показать все >></a></b></div></div>';
?>

Shunaqa

1

TimX
#516 18:46:19, 24 Aug 2020

Ulty, # Ulty (24.08.2020 / 17:41)
VORZAKON, <?php

echo '<div class="blue">';
echo '<div class="phdr"><center><b>Новые</b></center></div>';
$kmess = '5';

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts`Kod to'g'ri lekin xatosi bor

1

Biriktirilgan fayllar 1

screenshot_2020-08-24-18-46-57-1.png37.77 KB · 207 yuklab olingan

Ulty
#517 22:07:13, 24 Aug 2020

TimX, # TimX (24.08.2020 / 18:46)
Ulty, Kod to'g'ri lekin xatosi borTushunmasam ♂️

0

tahrirlandi · лет oldin

code_one
#518 10:44:28, 25 Aug 2020

library dagi tasodifiy 10 ta bo'limni qanday chiqarsa bo'ladi

0

AkmyradoffSoft
#519 12:09:53, 25 Aug 2020

coder, # coder (25.08.2020 / 10:44)
library dagi tasodifiy 10 ta bo'limni qanday chiqarsa bo'ladi

echo '<div class="phdr">Tasodifi 10 ta kutubxona bolimlari</div>';
$req = mysql_query("select * from `library_cats` ORDER BY RAND() LIMIT 10");
while ($res = mysql_fetch_array($req)) {
echo '<div class="menu">
<a href="'.$home.'/library/?do=dir&id='.$res['id'].'">
'.$res['name'].'
</a>
</div>';
}

test qilib kormadim, lekin ishlashi kerak...

1

tahrirlandi · лет oldin

code_one
#520 12:25:28, 25 Aug 2020

ZET-PRO2003, # ZET-PRO2003 (25.08.2020 / 12:09)
coder,
echo '<div class="phdr">Tasodifi 10 ta kutubxona bolimlari</div>';
$req = mysql_query("select * from `library_cats` ORDER BY RAND() LIMIT 10");
while ($res = mysql_fetch_array($req)) {
echLIMIT 10 buni 5 qilsam 5 tasi chiqadimi?

0

Menyu

Navigatsiya