Yangi formatda davom etish uchun: https://uzfor.net/view.php?id=736&page=54
Johncms bo'yicha umumiy savollar
Mavzu fayllari (121)
Xabarlar
DjHuSo, Misol
$qidirsoz = 'test';
mysql_query("SELECT * FROM `news` WHERE `nomi` LIKE '%".$qidirsoz."%'");
Endi natichani siklda (while) chiqarasiz.
.
Shunda news ustunidagi nomi ustunini tanladik undan like yordamida news nomida test sözi bor barcha newslar chiqadi.
$qidirsoz = 'test';
mysql_query("SELECT * FROM `news` WHERE `nomi` LIKE '%".$qidirsoz."%'");
Endi natichani siklda (while) chiqarasiz.
.
Shunda news ustunidagi nomi ustunini tanladik undan like yordamida news nomida test sözi bor barcha newslar chiqadi.
ATOYAT, Tushundim buni chiqdi faqat boshida salom bor so'slarni topyapti
Biriktirilgan fayllar [1]:
— screenshot_2018-04-12-22-43-39.png (262.72 KB) (186 ↴)
— screenshot_2018-04-12-22-43-39.png (262.72 KB) (186 ↴)
DjHuSo, # DjHuSo (12.04.2018 / 22:44)
#1064 faqat o'zidagi yangilik chiqyapti!$qidirsoz ni filtirlab html teglarni qirib sinab ko'ring. Lekin menimcha LIKE so'zma so'z qidiradi.
#1064 faqat o'zidagi yangilik chiqyapti!$qidirsoz ni filtirlab html teglarni qirib sinab ko'ring. Lekin menimcha LIKE so'zma so'z qidiradi.
Bekmurod, qilsam barcelona qatnashgan newslarni topyapti
qilsam faqat o'z yangiligini topyapti!
$qidirsoz ='Barcelona';
$qidirsoz =''.$res['nomi'].'';
Bekmurod, Barbir bo'ldi!
Biriktirilgan fayllar [1]:
— screenshot_2018-04-13-08-29-27.png (260.67 KB) (152 ↴)
— screenshot_2018-04-13-08-29-27.png (260.67 KB) (152 ↴)
DjHuSo, avalambor siz bazangizni o`zini qidiruvga moslab indesklashingiz kerak bo`ladi!
Buning uchun bazaga
yuborasiz!
Chiqarish:
Buning uchun bazaga
CREATE FULLTEXT INDEX nomi ON news(nomi);
yuborasiz!
Chiqarish:
$sorov = 'Manga shu yangilik kerak yoki shunga o`xshash yangilik';
SELECT * FROM news WHERE MATCH (nomi) AGAINST ('" . $sorov . "');
Rahmat aytdi (1): Tayota,
Akalar ukalar shuni tugirlab beringlar eng pasida ung tomonida 123...7>> bulib chiqsin
Limitga 15 ta mp3 chiqishi kerak
<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"> <center><b> Yangi Mp3lar</b></center></div>';
echo '<div class="fobar"><table cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td><a href="/download/dir_31.html"><div style="font-size:15px;">Uzbek</div></a></td><td><a href="/download/dir_33.html"><div style="font-size:15px;">Yosh Ijodkorlar</div></a></td><td><a href="/download/dir_32.html"><div style="font-size:15px;">Zarubej</div></a></td></tr></table></div>';
$cat ='2';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){
$cat_inf = mysql_fetch_assoc($cat_inf);
}else{
$cat_inf = array('way' => '');
}
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT 15");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="menu">' : '<div class="menu">';
$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0);
echo "<img src='/images/mp3.png' width='16' height='16' align='middle'/> <a href='/download/" . str_replace(' ', '_', $ok['name']) . "_".$ok['id'].".html'>".$ok['name']."</a>";
if($new > 0){
echo '<span class="red"><img src="/new.gif"></span>';
}else{
echo '';
}
if($ok['count'] > 50){
echo '<img src="xit.gif">';
}else{
echo '';
}
echo "</div>";
}
if ($total > $kmess){
echo '<p>' . functions::display_pagination('?', $start, $total, $kmess) . '</p>';
}
echo '<div class="menu"><img src="/images/davomi.png"><a href="/download/dir_2.html"> <font color="FA0000">Barchasini Kurish »» </font></a></div>';
?>
Limitga 15 ta mp3 chiqishi kerak
<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"> <center><b> Yangi Mp3lar</b></center></div>';
echo '<div class="fobar"><table cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td><a href="/download/dir_31.html"><div style="font-size:15px;">Uzbek</div></a></td><td><a href="/download/dir_33.html"><div style="font-size:15px;">Yosh Ijodkorlar</div></a></td><td><a href="/download/dir_32.html"><div style="font-size:15px;">Zarubej</div></a></td></tr></table></div>';
$cat ='2';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){
$cat_inf = mysql_fetch_assoc($cat_inf);
}else{
$cat_inf = array('way' => '');
}
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT 15");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="menu">' : '<div class="menu">';
$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0);
echo "<img src='/images/mp3.png' width='16' height='16' align='middle'/> <a href='/download/" . str_replace(' ', '_', $ok['name']) . "_".$ok['id'].".html'>".$ok['name']."</a>";
if($new > 0){
echo '<span class="red"><img src="/new.gif"></span>';
}else{
echo '';
}
if($ok['count'] > 50){
echo '<img src="xit.gif">';
}else{
echo '';
}
echo "</div>";
}
if ($total > $kmess){
echo '<p>' . functions::display_pagination('?', $start, $total, $kmess) . '</p>';
}
echo '<div class="menu"><img src="/images/davomi.png"><a href="/download/dir_2.html"> <font color="FA0000">Barchasini Kurish »» </font></a></div>';
?>
Saytim tez-tez shunday bo'lib qolyapti.
FLOOD: exceeded limit of allowed requests
FLOOD: exceeded limit of allowed requests
Tavsiya etamiz:
- Hoziroq maydonlarni to'ldiring va reklamangizni joylashtiring!
Mavzuga oid xabarlar soni: 3101 ta
So'ngi faollik vaqti: 15:21:31, 19 Apr 2022