Profil: ysahin8 | DonanımHaber Forum

Y

ysahin8 (Yavuzhan Sahin) · Network altına konu açtı. 18 yıl

Wireless bağlantı sorunu..

1 Yanıt

Yanıtla

Favorilere Ekle

0

Y

ysahin8 (Yavuzhan Sahin) · PHP / CGI altına konu açtı. 18 yıl

Php ile Mysql'deki verileri sayfalama

Veri sayfalama ile ilgili forumları gezdim ve kendi veritabanıma uydurmaya çalıştım fakat olmadı. Aşağıda kodumu verdim. Bilen ve yardımcı olabilecek arkadaşlardan yardım istiyorum.

<? 
  // Change the databasesettings to fit Your server 
  $connect = @mysql_connect("localhost", "root", "") or die ("<b style='color:red;'>Unable To Connect To Database Server.</b>"); 
  $db      = @mysql_select_db("hitcounter") or die ("<b style='color:red;'>Unable To Connect To Selected Database.</b>"); 
  ?> 
   
  <? 
  function SplitDate($Date) { 
   $String = substr($Date,0,4) . "-" . substr($Date,4,2) . "-" . substr($Date,6,2); 
   return $String; 
  } 
   
  function SplitTime($Time) { 
   $String = substr($Time,0,2) . ":" . substr($Time,2,2) . ":" . substr($Time,4,2); 
   return $String; 
  } 
  ?> 
   
  <title>Siteniz İstatistikleri</title> 
  <style type="text/css"> 
  <!-- 
  .style1 { 
   color: #FF0000; 
   font-weight: bold; 
  } 
  --> 
  </style> 
   
  <tr style="height: 100%;"> 
   <td style="width:140px;"> 
    <table width=100% border=0> 
     <tr> 
      <td align=center class=small> 
      </td> 
     </tr> 
    </table> 
   </td> 
   <td colspan=2> 
    <table border=0 width=844> 
     <tr> 
      <td width="838"> 
       <table class=1box> 
        <tr><td></td></tr> 
        <tr class=header> 
          <td ><span class="style1">Sitenizden istatistikler </span></td> 
        </tr> 
       </table>     </td> 
     </tr> 
  <? 
  $MySQL = "SELECT Date, count(Date) as Visitors, SUM(Hits) as NoOfHits, Host, URI FROM hitcounter GROUP BY Host, URI, Date;"; 
  $Visits = mysql_query($MySQL); 
  ?>   
  <? 
  $MySQL = "SELECT * FROM hitcounter ORDER BY Date, IP;"; 
  $Visits = mysql_query($MySQL); 
  ?>      
     <tr> 
      <td> 
       <table class=1box> 
        <tr><td width="454"></td> 
        </tr> 
        <tr class=header> 
          <td ><strong>Ayrıntılar</strong></td> 
        </tr> 
        <tr> 
         <td><br> 
          <table border="1" cellspacing="3" cellpadding="3" bordercolor="#AAAAAA" style="border-collapse: collapse; border: 1px solid #AAAAAA;"> 
           <tr class=header> 
            <th align=center>IP address</th> 
            <th align=center>Date</th> 
            <th align=center>Last visit</th> 
            <th align=center>Host</th> 
            <th align=center>URL</th> 
            <th align=center>Country<br>code</th> 
            <th align=center>No of<br>Hits</th> 
           </tr> 
  <?        while ( $Visit = mysql_fetch_array($Visits) ) { 
            echo("<tr class=small>"); 
            echo("<td>" . $Visit['IP'] . "</td>"); 
            echo("<td>" . SplitDate($Visit['Date']) . "</td>"); 
            echo("<td>" . SplitTime($Visit['Time']) . "</td>"); 
            echo("<td>" . $Visit['Host'] . "</td>"); 
            echo("<td>" . $Visit['URI'] . "</td>"); 
            echo("<td align=center>" . $Visit['Country'] . "</td>"); 
            echo("<td align=center>" . $Visit['Hits'] . "</td>"); 
            echo("</tr>"); 
           }?> 
          </table><br><br>       </td> 
        </tr> 
       </table>    </td> 
     </tr> 
     <tr><td> </td></tr> 
     </table> 
    <br> 
   </td> 
   </tr> 
  </BODY> 
  </html>

3 Yanıt

Yanıtla

Favorilere Ekle

0

Y

ysahin8 (Yavuzhan Sahin) · Web Tasarım ve Hazır Kodlar altına konu açtı. 18 yıl

Yükleniyor ve Slaytshow beraber olmuyor. Yardım istiyorum..

Arkadaşlar elimde Slaytshow scripti var. Çalışır durumda. Resimlerin tamamını yüklediği için 30-40 sn. açılış sürüyor. Resimler yüklenene kadar, yükleniyor sicriptinin çalışması. Kodlarımı aşağıda belirttim. Epey uğraştım fakat olmadı. Ya yukleniyor scripti çalışıyor yada slaytshow scripti, ikisini çalıştıramadım. <body Onload=..........." tagında bir şey var herhalde. Lütfen bir çözüm.

1. Kod

<html> 
  <head> 
  <title>Slayt Gösterisi Tr</title> 
   
  <style> 
  .Caption { 
  font-family: Arial; 
  font-weight: normal; 
  font-size:  12pt; 
  color:      #FF3300; } 
   
  A.Controls:link    { color:#666666; 
                       text-decoration:none; 
                       font-family: Arial; 
                       font-size:   14pt; 
                       font-weight: bold; } 
  A.Controls:visited { color:#666666; text-decoration:none;  
                       font-family: Arial; 
                       font-size:   14pt; 
                       font-weight: bold; } 
  A.Controls:active  { color:#666666; text-decoration:none; 
                       font-family: Arial; 
                       font-size:   14pt; 
                       font-weight: bold; } 
  A.Controls:hover   { color:#00FF00; text-decoration:none; 
                       font-family: Arial; 
                       font-size:   14pt; 
                       font-weight: bold; } 
   
  body { 
  	background-image: url(); 
  	background-repeat: no-repeat; 
  	margin-left: 0px; 
  	margin-top: 0px; 
  	background-color: #000000; 
  } 
  .style4 {color: #000000} 
  .style5 { 
  	font-family: Verdana, Arial, Helvetica, sans-serif; 
  	font-weight: bold; 
  } 
  .style6 {color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; } 
  a:link { 
  	text-decoration: none; 
  } 
  a:visited { 
  	text-decoration: none; 
  } 
  a:hover { 
  	text-decoration: underline; 
  } 
  a:active { 
  	text-decoration: none; 
  } 
  </style> 
   
  <script> 
  // (C) 2003 by CodeLifter.com 
  // Free for all users, but leave in this header. 
   
  // ============================== 
  // Set the following variables... 
  // ============================== 
   
  // Set the slideshow speed (in milliseconds) 
  var SlideShowSpeed = 3000; 
   
  // Set the duration of crossfade (in seconds) 
  var CrossFadeDuration = 2; 
   
  var Picture = new Array(); // don't change this 
  var Caption = new Array(); // don't change this 
  var showHot = false;       // don't change this 
   
  // Specify the image files... 
  // To add more images, just continue 
  // the pattern, adding to the array below. 
  // To use fewer images, remove lines 
  // starting at the end of the Picture array. 
   
  Picture[1]  = 'images/01.jpg'; 
  Picture[2]  = 'images/02.jpg'; 
  Picture[3]  = 'images/03.jpg'; 
  Picture[4]  = 'images/04.jpg'; 
  Picture[5]  = 'images/05.jpg'; 
  Picture[6]  = 'images/06.jpg'; 
  Picture[7]  = 'images/07.jpg'; 
  Picture[8]  = 'images/08.jpg'; 
  Picture[9]  = 'images/09.jpg'; 
  Picture[10]  = 'images/10.jpg'; 
   
   
  // ===================================== 
  // Do not edit anything below this line! 
  // ===================================== 
   
  var tss; 
  var iss; 
  var jss = 0; 
  var pss = Picture.length-1; 
   
  var preLoad = new Array(); 
  for (iss = 1; iss < pss+1; iss++){ 
  preLoad[iss] = new Image(); 
  preLoad[iss].src = Picture[iss];} 
   
  function control(how){ 
  if (showHot){ 
  if (how=="H") jss = 1; 
  if (how=="F") jss = jss + 1; 
  if (how=="B") jss = jss - 1; 
  if (jss > (pss)) jss=1; 
  if (jss < 1) jss = pss; 
  if (document.all){ 
  document.images.PictureBox.style.filter="blendTrans(duration=2)"; 
  document.images.PictureBox.style.filter="blendTrans(duration=CrossFadeDuration)"; 
  document.images.PictureBox.filters.blendTrans.Apply();} 
  document.images.PictureBox.src = preLoad[jss].src; 
  if (document.all) document.images.PictureBox.filters.blendTrans.Play(); 
  }} 
   
  </script> 
   
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9"></head> 
   
   
  <!-- 
  Add onload='showHot=true;' to the body tag.  This is 
  needed to prevent false object calls while the page 
  is loading. Optional: If you are using this in a 
  popup, as in this demo, adding self.focus() to the 
  onload event in the body tag will bring the popup 
  to the front each time it is loaded [recommended].  
  //--> 
   
  <body onload='showHot=true;self.focus();' link="#FF0000" vlink="#FF0000" alink="#FF0000">  
   
  <!-- 
  The following table holds the images, captions, and controls. 
  Place the table in your page where you want the slideshow 
  to appear.  Follow the instructions for each table cell. 
  //--> 
   
  <div align="center"> 
    <center> 
  <table border=1 cellpadding=1 cellspacing=1> 
    <tr> 
      <!-- 
      The next table cell holds the images. 
      Set cell and image width and height the same. 
      The img src must have name=PictureBox in its 
      tag.  Often, the first image in the Picture 
      array in the script is used here; but you 
      may also use a different, introductory image 
      as we have here, since this image is shown 
      only on start-up. 
      //--> 
      <td height=563 colspan="3"> 
      <img src=images/Kapak-Tr.jpg name=PictureBox width=750 height=563></td> 
    </tr> 
    <tr> 
      <!--  
      The next table cell holds the captions. 
      This table cell must have id=CaptionBox and 
      class=Caption in its tag. The default caption 
      shows whilst loading in all browsers; NS4 
      will show only the default caption, throughout. 
      //--> 
        </tr> 
      <!-- 
      The following three cells contain the controls. 
      Each of the control a href's must contain class= 
      Controls, to attach the styles (see top of script). 
      To dress this up a bit, you can of course substitute 
      <img src> images for the text in the links. 
      //--> 
    <tr> 
      <td width="750" align="center" background="images/bar.gif"> 
        <span class="style4"><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=11247295&url=#" class=Controls style2 onClick="javascript:control('B');" data-href="#" class=Controls style2 onClick="javascript:control('B');"><img src="images\previous.png" alt="Geri" width="28" height="28" border="0"></a> 
        <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=11247295&url=#" class=Controls style2 onClick="javascript:control('H');" data-href="#" class=Controls style2 onClick="javascript:control('H');"><img src="images\home.png" alt="Başa Dön" width="28" height="28" border="0"></a> 
        <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=11247295&url=#" class=Controls style2 onClick="javascript:control('F');" data-href="#" class=Controls style2 onClick="javascript:control('F');"><img src="images\next.png" alt="İleri" width="28" height="28" border="0"></a></span>	</td> 
    </tr>   
  </table> 
    </center> 
  </div> 
  <div align="center" class="style5"><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=11247295&url=index.php" class="style6" data-href="index.php" class="style6">Ana Sayfa</a></div> 
  </body> 
  </html>

2. Kod

<SCRIPT LANGUAGE="JavaScript"> 
  function sayfayukle() { 
  if (document.layers) { 
  document.yukleniyor.visibility = 'hidden'; 
  } 
  else { 
  document.all.yukleniyor.style.visibility = 'hidden'; 
     } 
  } 
  </script> 
   
  <body onUnload="sayfayukle()"> 
  <img src="images/yukleniyor.gif" id="yukleniyor" style="position: absolute; left:40%; top:50%;"> 
  </body>

3 Yanıt

Yanıtla

Favorilere Ekle

0

Y

ysahin8 (Yavuzhan Sahin) · PHP / CGI altına konu açtı. 18 yıl

Parse error: syntax error, unexpected T_STRING Problemi

Aşağıdaki kodu çalıştırdığım zaman "Parse error: syntax error, unexpected T_STRING in /home/xxx/public_html/usersonline/config.php on line 20" hatasını alıyorum. Nasıl çalıştırabilirim bu kodu?

1. kod: config.php
[CODE]<?php

//Database settings
$server = "localhost";
$db_user = "xxx";
$db_pass = "xxx";
$database = "xxx;
$dbh = mysql_connect($server, $db_user, $db_pass);

//don't change settings below
$table = "useronline";

//Connect DB
mysql_connect($server, $db_user, $db_pass);

//Select DB
mysql_select_db($database, $dbh);
?>[/CODE]

2. kod: online.php
[CODE]<?

require("config.php");

//Fetch Time
$timeoutseconds = 300;
$timestamp = time();
$timeout = $timestamp - $timeoutseconds;

//Delete User
mysql_db_query($database, "DELETE FROM $table WHERE ip='$_SERVER[REMOTE_ADDR]'") or die("Cannot connect to the database");
mysql_db_query($database, "DELETE FROM $table WHERE timestamp<$timeout") or die("Cannot connect to the database");

//Insert User
$ip = $_SERVER['REMOTE_ADDR'];
$insert = mysql_db_query($database, "INSERT INTO $table VALUES
('$timestamp','$ip','$PHP_SELF')") or die("Cannot connect to the database");

//Fetch Users Online
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM $table WHERE file='$PHP_SELF'") or die("Failed!");
$users = mysql_num_rows($result);

// Compare IP's found in the database
while ($row = mysql_fetch_array($result)) {
$country_query = '
SELECT country2
FROM iptocountry
WHERE ipfrom < INET_ATON("'.$row['ip'].'")
ORDER BY ipfrom DESC
LIMIT 0,1';

//Set country code in array
$country_exec = mysql_query($country_query);
$ccode_array=mysql_fetch_array($country_exec);
$country_code=$ccode_array['country2'];

//Change to lowercase
$country_code = strtolower($country_code);

// Cut IP's
$line = substr("$row[ip]",0,5);

// Addind xx and <br>
$showip = chunk_split($line,30,".xx.xx \n");
echo "<br />\n";

// spit out the results (ip.xx flag)
echo "<a href='stats.php' style='text-decoration:none'>$showip</a> <a href='stats.php'><img src='flags/$country_code.png' border ='no'></a>\n";
}
echo "<br />\n";
echo "Online $users User(s)\n";

// Close DB
mysql_close($dbh);
?>[/CODE]

9 Yanıt

Yanıtla

Favorilere Ekle

0

Y

ysahin8 (Yavuzhan Sahin) · PHP / CGI altına konu açtı. 18 yıl

Efektli Resim Galerisi (slideshow değil)

3 Yanıt

Yanıtla

Favorilere Ekle

0

Y

ysahin8 (Yavuzhan Sahin) · Teknik Yardım altına konu açtı. 18 yıl

Media Player problemi

2 Yanıt

Yanıtla

Favorilere Ekle

0