Qidiruv
So'z:

Bo'lim:

Natija: 38 ta
Akbarali, bunday emasmi

<?php 

 $new 
mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `time` > '" . (time() - (86400 1)) . "'".($rights " AND `time`<='" time() . "'":"").""), 0);

$umumiy mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` ".($rights 10 " WHERE `time`<='" time() . "'":"").""), 0);

$total mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_cat`"), 0);

$req mysql_query("SELECT `cms_news_cat`.`name`, `cms_news_cat`.`id` FROM `cms_news_cat` ORDER BY `cms_news_cat`.`realid` ASC LIMIT "  $start "," $kmess);

$i 1;

while ((
$row mysql_fetch_assoc($req)) !== false) {

$count mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE ".($rights 10 "`time`<='" time() . "' AND ":"")."`refid`='{$row['id']}'"), 0);

echo 
'<a href="'.$home.'/news.php?id='.$row['id'].'"> <div class="menu"> <img src="'.$home.'/images/news.png" style="width: 15px; margin-bottom: -2px;"> '.htmlentities($row['name'], ENT_QUOTES'UTF-8').' <span style="font-size: small; float: right;"> <span class="soni"> '.$count.' </span> </span> </div> </a>';

++
$i;

?>



<script type="text/javascript">

function cdtime(container, targetdate){
if (!document.getElementById || !document.getElementById(container)) return
this.container=document.getElementById(container)
this.currentTime=new Date()
this.targetdate=new Date(targetdate)
this.timesup=false
this.updateTime()
}

cdtime.prototype.updateTime=function(){
var thisobj=this
this.currentTime.setSeconds(this.currentTime.getSeconds()+1)
setTimeout(function(){thisobj.updateTime()}, 1000) //update time every second
}

cdtime.prototype.displaycountdown=function(baseunit, functionref){
this.baseunit=baseunit
this.formatresults=functionref
this.showresults()
}

cdtime.prototype.showresults=function(){
var thisobj=this


var timediff=(this.targetdate-this.currentTime)/1000 //difference btw target date and current date, in seconds
if (timediff<0){ //if time is up
this.timesup=true
this.container.innerHTML=this.formatresults()
return
}
var oneMinute=60 //minute unit in seconds
var oneHour=60*60 //hour unit in seconds
var oneDay=60*60*24 //day unit in seconds
var dayfield=Math.floor(timediff/oneDay)
var hourfield=Math.floor((timediff-dayfield*oneDay)/oneHour)
var minutefield=Math.floor((timediff-dayfield*oneDay-hourfield*oneHour)/oneMinute)
var secondfield=Math.floor((timediff-dayfield*oneDay-hourfield*oneHour-minutefield*oneMinute))
if (this.baseunit=="hours"){ //if base unit is hours, set "hourfield" to be topmost level
hourfield=dayfield*24+hourfield
dayfield="n/a"
}
else if (this.baseunit=="minutes"){ //if base unit is minutes, set "minutefield" to be topmost level
minutefield=dayfield*24*60+hourfield*60+minutefield
dayfield=hourfield="n/a"
}
else if (this.baseunit=="seconds"){ //if base unit is seconds, set "secondfield" to be topmost level
var secondfield=timediff
dayfield=hourfield=minutefield="n/a"
}
this.container.innerHTML=this.formatresults(dayfield, hourfield, minutefield, secondfield)
setTimeout(function(){thisobj.showresults()}, 1000) //update results every second
}

/////CUSTOM FORMAT OUTPUT FUNCTIONS BELOW///////Hackers001.blogspot.com///////////////////////

//Create your own custom format function to pass into cdtime.displaycountdown()
//Use arguments[0] to access "Days" left
//Use arguments[1] to access "Hours" left
//Use arguments[2] to access "Minutes" left
//Use arguments[3] to access "Seconds" left

//The values of these arguments may change depending on the "baseunit" parameter of cdtime.displaycountdown()
//For example, if "baseunit" is set to "hours", arguments[0] becomes meaningless and contains "n/a"
//For example, if "baseunit" is set to "minutes", arguments[0] and arguments[1] become meaningless etc


function formatresults(){
if (this.timesup==false){//if target date/time not yet met
var displaystring=arguments[0]+" days "+arguments[1]+" hours "+arguments[2]+" minutes "+arguments[3]+" seconds left until December 25, 2011 18:25:00"
}
else{ //else if target date/time met
var displaystring=""
}
return displaystring
}

function formatresults2(){
if (this.timesup==false){ //if target date/time not yet met
var displaystring="<span class='lcdstyle'>"+arguments[0]+" <sup>дней</sup> "+arguments[1]+" <sup>часов</sup> "+arguments[2]+" <sup>минут</sup> "+arguments[3]+" <sup>секунд</sup></span> "
}
else{ //else if target date/time met
var displaystring="" //Don't display any text
alert("HAPPY NEW YEAR EVERYBODY!") //Instead, perform a custom alert
}
return displaystring
}

</script>
<table><tbody>
<tr>
<td>
<img style="float:left; " src="http://3.bp.blogspot.com/-id6x2AOCGc4/TvoJfxRT-oI/AAAAAAAAFso/HKKnQ5bcnGY/s400/NEW%2BYEAR.png" width="125px"/>
<h1 style="color:#289728; padding-top:40px;">До нового года осталось..</h1><br/>
</td></tr>

<tr><td>
<div id="countdowncontainer"></div>
<br />
<div id="countdowncontainer2"></div>

<script type="text/javascript">

var futuredate=new cdtime("countdowncontainer", "March 23, 2009 18:25:00")
futuredate.displaycountdown("days", formatresults)

var currentyear=new Date().getFullYear()
//dynamically get this Christmas' year value. If Christmas already passed, then year=current year+1
var thischristmasyear=(new Date().getMonth()>=11 && new Date().getDate()>31)? currentyear+1 : currentyear
var christmas=new cdtime("countdowncontainer2", "December 31, "+thischristmasyear+" 23:59:59")
christmas.displaycountdown("days", formatresults2)

</script>

</td></tr>
</tbody></table>
Mana shuni id bo'yicha chiqarish k.k:


<?php 

$new  
mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `time` > '" . (time() - (86400 1)) . "'".($rights " AND `time`<='" time() ."'":"").""), 0);

$umumiy mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` ".($rights 10 " WHERE `time`<='" time() . "'":"").""), 0);

$total mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_cat`"), 0);

$req mysql_query("SELECT `cms_news_cat`.`name`, `cms_news_cat`.`id` FROM `cms_news_cat` ORDER BY `cms_news_cat`.`realid` ASC LIMIT "  $start "," $kmess);

$i 1;

while ((
$row mysql_fetch_assoc($req)) !== false) {

$count mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE ".($rights 10 "`time`<='" time() . "' AND ":"")."`refid`='{$row['id']}'"), 0);

echo 
'<a href="'.$home.'/news.php?id='.$row['id'].'"> <div class="menu"> <img src="'.$home.'/images/news.png" style="width: 15px; margin-bottom: -2px;"> '.htmlentities($row['name'],ENT_QUOTES'UTF-8').' <span style="font-size: small; float: right;"> <span class="soni"> '.$count.' </span> </span> </div> </a>';

++
$i;

?>


H-ONE, mana o'sha fayl kodlari:

<?php 

$new  
mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `time` > '" . (time() - (86400 1)) . "'".($rights " AND `time`<='" time() ."'":"").""), 0);

$umumiy mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` ".($rights 10 " WHERE `time`<='" time() . "'":"").""), 0);

$total mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_cat`"), 0);

$req mysql_query("SELECT `cms_news_cat`.`name`, `cms_news_cat`.`id` FROM `cms_news_cat` ORDER BY `cms_news_cat`.`realid` ASC LIMIT "  $start "," $kmess);

$i 1;

while ((
$row mysql_fetch_assoc($req)) !== false) {

$count mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE ".($rights 10 "`time`<='" time() . "' AND ":"")."`refid`='{$row['id']}'"), 0);

echo 
'<a href="'.$home.'/news.php?id='.$row['id'].'"> <div class="menu"> <img src="'.$home.'/images/news.png" style="width: 15px; margin-bottom: -2px;"> '.htmlentities($row['name'],ENT_QUOTES'UTF-8').' <span style="font-size: small; float: right;"> <span class="soni"> '.$count.' </span> </span> </div> </a>';

++
$i;

?>



.
Shuni id bo'yicha chiqarish kerak
H-ONE, bo'ldi. Endi mana buni id bo'yicha chiqarish k.k

<?php 

$new  
mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `time` > '" . (time() - (86400 1)) . "'".($rights " AND `time`<='" time() ."'":"").""), 0);

$umumiy mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` ".($rights 10 " WHERE `time`<='" time() . "'":"").""), 0);

$total mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_cat`"), 0);

$req mysql_query("SELECT `cms_news_cat`.`name`, `cms_news_cat`.`id` FROM `cms_news_cat` ORDER BY `cms_news_cat`.`realid` ASC LIMIT "  $start "," $kmess);

$i 1;

while ((
$row mysql_fetch_assoc($req)) !== false) {

$count mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE ".($rights 10 "`time`<='" time() . "' AND ":"")."`refid`='{$row['id']}'"), 0);

echo 
'<a href="'.$home.'/news/index.php?id='.$row['id'].'"> <div class="menu"> <img src="'.$home.'/images/news.png" style="width: 15px; margin-bottom: -2px;"> '.htmlentities($row['name'],ENT_QUOTES'UTF-8').' <span style="font-size: small; float: right;"> <span class="soni"> '.$count.' </span> </span> </div> </a>';

++
$i;

?>


Asil4ek, &lt;?php
/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = &#039;10&#039;;
echo &#039;&lt;div class=&quot;phdr&quot;&gt;&lt;b&gt;Yangi maqolalar&lt;/b&gt;&lt;/div&gt;&#039;;
$bolm_sql = mysql_query(&quot;SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC&quot;);
$sql = mysql_result(mysql_query(&#039;SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1&#039;), 0);
$page = $page &gt;= ceil($sql / $kmess) ? ceil($sql/ $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);
$req_lib = mysql_query(&quot;SELECT * FROM `library_texts` WHERE `premod`=&#039;1&#039; ORDER BY `time` DESC LIMIT 10 &quot;);
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo&#039;&lt;div class=&quot;menu&quot;&gt;&#039;;
if (file_exists((ROOTPATH . &#039;files/library/images/big/&#039; . $lib[&#039;id&#039;] . &#039;.png&#039;))){
$img_style = &#039;width: 60px; height: 35px; float: left; clear: both; margin: 10px&#039;;
echo &#039;&lt;a href=&quot;&#039; . $set[&#039;homeurl&#039;] . &#039;/library/index.php?id=&#039; . $lib[&#039;id&#039;] . &#039;&quot;&gt;&#039;;
}else{
$img_style = &#039;width: 60px; height: 35px; float: left; clear: both; margin: 10px&#039;;
}
echo &#039;&lt;img src=&quot;/img/maqola.jpg&quot; alt=&quot;icon&quot; width=&quot;16&quot; height=&quot;16&quot;/&gt;&lt;/a&gt; &lt;a href=&quot;&#039; . $set[&#039;homeurl&#039;] . &#039;/library/index.php?id=&#039; . $lib[&#039;id&#039;] . &#039;&quot;&gt; &#039; . $lib[&#039;name&#039;] . &#039;&lt;/a&gt;&lt;div class=&quot;&quot; style=&quot;float:right;&quot;&gt; O&#039;qildi: &lt;span class=&quot;time&quot;&gt; [&#039; . $lib[&#039;count_views&#039;] . &#039;]&lt;/span&gt; &lt;/div&gt;&#039;;
echo &#039;&lt;/div&gt;&#039;;
}
}
?&gt;
&lt;?php
/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = &#039;10&#039;;
echo &#039;&lt;div class=&quot;phdr&quot;&gt;&lt;b&gt;Yangi maqolalar&lt;/b&gt;&lt;/div&gt;&#039;;
$bolm_sql = mysql_query(&quot;SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC&quot;);
$sql = mysql_result(mysql_query(&#039;SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1&#039;), 0);
$page = $page &gt;= ceil($sql / $kmess) ? ceil($sql/ $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);
$req_lib = mysql_query(&quot;SELECT * FROM `library_texts` WHERE `premod`=&#039;1&#039; ORDER BY `time` DESC LIMIT 10 &quot;);
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo&#039;&lt;div class=&quot;menu&quot;&gt;&#039;;
if (file_exists((ROOTPATH . &#039;files/library/images/big/&#039; . $lib[&#039;id&#039;] . &#039;.png&#039;))){
$img_style = &#039;width: 60px; height: 35px; float: left; clear: both; margin: 10px&#039;;
echo &#039;&lt;a href=&quot;&#039; . $set[&#039;homeurl&#039;] . &#039;/library/index.php?id=&#039; . $lib[&#039;id&#039;] . &#039;&quot;&gt;&#039;;
}else{
$img_style = &#039;width: 60px; height: 35px; float: left; clear: both; margin: 10px&#039;;
}
echo &#039;&lt;img src=&quot;/img/maqola.jpg&quot; alt=&quot;icon&quot; width=&quot;16&quot; height=&quot;16&quot;/&gt;&lt;/a&gt; &lt;a href=&quot;&#039; . $set[&#039;homeurl&#039;] . &#039;/library/index.php?id=&#039; . $lib[&#039;id&#039;] . &#039;&quot;&gt; &#039; . $lib[&#039;name&#039;] . &#039;&lt;/a&gt;&lt;div class=&quot;&quot; style=&quot;float:right;&quot;&gt; O&#039;qildi: &lt;span class=&quot;time&quot;&gt; [&#039; . $lib[&#039;count_views&#039;] . &#039;]&lt;/span&gt; &lt;/div&gt;&#039;;
echo &#039;&lt;/div&gt;&#039;;
}
}
?&gt;

manashu kod library dagi maqolalarni chiqarmayapdi kurip beriylar qayeridan bulayapdi ekan
www.uzmasters.ru Onlayn 251 (0/251)
www.uzmasters.ru Forumga a'zo bo'lish
www.uzmasters.ru Forumdan qidirish
www.uzmasters.ru Bosh sahifa
Яндекс.Метрика UzMasterS.Ru