Pereiti prie turinio

PHP + MYSQL - Nerusiuoja teisiklingai 2 COLUMN

mendy

Sukūrė mendy
Programuotojų kampas

 Dalintis Sekėjai 0

Rekomenduojami pranešimai

mendy

mendy 0

Sukurta
Sukurta

Sveiki,

nepagaunu kodel teisingai nerusiuoja ASP ir SPG, atrodo viskas tas pats kaip kituose COLUMN kodas, bet nesamones rusiuoja.

 

www.fifa18.lt/nba2k18

 

<?php


require_once '../../maincore.php';
require_once THEMES.'templates/header.php';
echo "<img src='proam.png' width='150' height='148' align='centre'>";
opentable('NBA2K18 LIETUVOS RINKTINĖ - STATISTIKA ');

echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border row-hover'>
<tr>

<td class='tbl2'  align='center' width='4%'><b>Žaidėjas</b></td>
<td class='tbl2'  align='center' width='4%'><b>POS</b></td>


<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'played') { echo "<b>GP</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-played'><b>GP</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'ppg') { echo "<b>PPG"; } else {
echo "<a href='".BASEDIR."nba2k18-ppg'><b>PPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'fg') { echo "<b>FG%</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-fg'><b>FG%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'fg3pts') { echo "<b>3P%</b>"; } else { 
echo "<a href='".BASEDIR."nba2k18-fg3pts'><b>3P%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'ft') { echo "<b>FT%</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-ft'><b>FT%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'rpg') { echo "<b>RPG</b>"; } else { 
echo "<a href='".BASEDIR."nba2k18-rpg'><b>RPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'spg') { echo "<b>SPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-spg'><b>SPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'apg') { echo "<b>APG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-apg'><b>APG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'bpg') { echo "<b>BPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-bpg'><b>BPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'topg') { echo "<b>TOPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-topg'><b>TOPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'dd') { echo "<b>DD</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-dd'><b>DD</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'tripledd') { echo "<b>3DD</b>"; } else { 

echo "<a href='".BASEDIR."nba2k18-tripledd'><b>DDD</b></a>"; } 
echo "</center></td>
</tr>";


$teams = array();
if($_GET['by'] == 'played') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY played DESC"); }

elseif($_GET['by'] == 'apg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY apg DESC"); }
elseif($_GET['by'] == 'spg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY spg DESC"); }

elseif($_GET['by'] == 'ppg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY ppg DESC"); }
elseif($_GET['by'] == 'fg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY fg DESC"); }
elseif($_GET['by'] == 'fg3pts') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY fg3pts DESC"); }
elseif($_GET['by'] == 'ft') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY ft DESC"); }
elseif($_GET['by'] == 'rpg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY rpg DESC"); }
elseif($_GET['by'] == 'bpg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY bpg DESC"); }
elseif($_GET['by'] == 'topg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY topg ASC"); }
elseif($_GET['by'] == 'dd') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY dd DESC"); }
elseif($_GET['by'] == 'ddd') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY tripledd DESC"); }
else { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY name DESC"); }
$i = 1;
while($q = mysql_fetch_array($rezultatai)) {
$c = $q['name'];

$ilgis = strlen($c);
if($ilgis > 30) { $c = substr($c, 0, 30)."..."; }
  echo "<tr class='tbl3'>

              <td style='padding: 4px' width='4%'>" .sprintf('%02d', $i) .". <b>$c</b></a>
</td>
   <td style='padding: 4px' width='4%'><center>".$q['position']."</center></td>

              <td style='padding: 4px' width='1%'><center>".$q['played']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['ppg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['fg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['fg3pts']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['ft']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['rpg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['apg']."</center></td>
               <td style='padding: 4px' width='1%'><center>".$q['spg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['bpg']."</center></td>
               <td style='padding: 4px' width='1%'><center>".$q['topg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['dd']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['tripledd']."</center></td>
              </tr>";
		   $i++;
		   }
echo "</table>";
closetable();

?>

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mogohax

mogohax 16

Atrašyta
Atrašyta 

<td style='padding: 4px' width='1%'><center>".$q['apg']."</center></td>
<td style='padding: 4px' width='1%'><center>".$q['spg']."</center></td>

 

Sukeisti vietom sitie pas tave. Table head'e eina is pradziu SPG, paskui APG. Kai renderini duomenis, pirma printini APG, paskui - SPG.

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mendy

mendy 0

Atrašyta
  • Autorius
Atrašyta 

<td style='padding: 4px' width='1%'><center>".$q['apg']."</center></td>
<td style='padding: 4px' width='1%'><center>".$q['spg']."</center></td>

 

Sukeisti vietom sitie pas tave. Table head'e eina is pradziu SPG, paskui APG. Kai renderini duomenis, pirma printini APG, paskui - SPG.

Jo dekui.

 

Prie to pacio, bandau ikist javascript kuris suranda HIGHEST value lentele ir pakeistu spalva, bet kazko neraguoja.

 

cia pats js: http://fifaps4turnyrai.x10.bz/minmax.js

cia style: http://fifaps4turnyrai.x10.bz/themes/Stylo/styles.css

 

js script emiau is cia: http://jsfiddle.net/tariqulazam/esfj9/

<?php

echo "<script type='text/javascript' src='http://fifaps4turnyrai.x10.bz/minmax.js'></script>";
require_once '../../maincore.php';
require_once THEMES.'templates/header.php';
echo "<img src='proam.png' width='150' height='148' align='centre'>";
opentable('NBA2K18 LIETUVOS RINKTINĖ - STATISTIKA ');
echo "<script type='text/javascript' src='http://fifaps4turnyrai.x10.bz/minmax.js'></script>";
echo "<table id='mytable' align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border row-hover' >
<tr>

<td class='tbl2'  align='center' width='4%'><b>Žaidėjas</b></td>
<td class='tbl2'  align='center' width='4%'><b>POS</b></td>


<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'played') { echo "<b>GP</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-played'><b>GP</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'ppg') { echo "<b>PPG"; } else {
echo "<a href='".BASEDIR."nba2k18-ppg'><b>PPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'fg') { echo "<b>FG%</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-fg'><b>FG%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'fg3pts') { echo "<b>3P%</b>"; } else { 
echo "<a href='".BASEDIR."nba2k18-fg3pts'><b>3P%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'ft') { echo "<b>FT%</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-ft'><b>FT%</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'rpg') { echo "<b>RPG</b>"; } else { 
echo "<a href='".BASEDIR."nba2k18-rpg'><b>RPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'spg') { echo "<b>SPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-spg'><b>SPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'apg') { echo "<b>APG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-apg'><b>APG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'bpg') { echo "<b>BPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-bpg'><b>BPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'topg') { echo "<b>TOPG</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-topg'><b>TOPG</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'dd') { echo "<b>DD</b>"; } else {
echo "<a href='".BASEDIR."nba2k18-dd'><b>DD</b></a>"; } echo "</center></td>
<td class='tbl2' width='2%'><center>"; if($_GET['by'] == 'tripledd') { echo "<b>3DD</b>"; } else { 

echo "<a href='".BASEDIR."nba2k18-tripledd'><b>DDD</b></a>"; } 
echo "</center></td>
</tr>";


$teams = array();
if($_GET['by'] == 'played') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY played DESC"); }

elseif($_GET['by'] == 'apg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY apg DESC"); }
elseif($_GET['by'] == 'spg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY spg DESC"); }

elseif($_GET['by'] == 'ppg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY ppg DESC"); }
elseif($_GET['by'] == 'fg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY fg DESC"); }
elseif($_GET['by'] == 'fg3pts') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY fg3pts DESC"); }
elseif($_GET['by'] == 'ft') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY ft DESC"); }
elseif($_GET['by'] == 'rpg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY rpg DESC"); }

elseif($_GET['by'] == 'bpg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY bpg DESC"); }
elseif($_GET['by'] == 'topg') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY topg ASC"); }
elseif($_GET['by'] == 'dd') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY dd DESC"); }
elseif($_GET['by'] == 'ddd') { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY tripledd DESC"); }
else { $rezultatai = mysql_query("SELECT * FROM ".$db_prefix."nba2k18 ORDER BY name DESC"); }
$i = 1;
while($q = mysql_fetch_array($rezultatai)) {
$c = $q['name'];

$ilgis = strlen($c);
if($ilgis > 30) { $c = substr($c, 0, 30)."..."; }
  echo "<tr class='tbl3'>

              <td style='padding: 4px' width='4%'>" .sprintf($i) .". <b>$c</b></a>
</td>
   <td style='padding: 4px' width='4%'><center>".$q['position']."</center></td>

              <td style='padding: 4px' width='1%'><center>".$q['played']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['ppg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['fg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['fg3pts']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['ft']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['rpg']."</center></td>
               <td style='padding: 4px' width='1%'><center>".$q['spg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['apg']."</center></td>

              <td style='padding: 4px' width='1%'><center>".$q['bpg']."</center></td>
               <td style='padding: 4px' width='1%'><center>".$q['topg']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['dd']."</center></td>
              <td style='padding: 4px' width='1%'><center>".$q['tripledd']."</center></td>
              </tr>";
		   $i++;
		   }

echo "</table>";
echo "<script type='text/javascript' src='http://www.fifa.18.lt/minmax.js'></script>";
closetable();
?>

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mogohax

mogohax 16

Atrašyta
Atrašyta

Tam minmax scriptui jquery reikia. Pas tave jo neuzkrauna:

 

Request URL:http://www.fifaps4turnyrai.x10.bz/includes/jquery/jquery.js
Status Code:404 Not Found

 

Dar priedo iwrappink visa minmax koda i toki bloka:

 

jQuery(document).ready(function($) {
//cia js kodas
});

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mendy

mendy 0

Atrašyta
  • Autorius
Atrašyta

Tam minmax scriptui jquery reikia. Pas tave jo neuzkrauna:

 

Request URL:http://www.fifaps4turnyrai.x10.bz/includes/jquery/jquery.js
Status Code:404 Not Found

 

Dar priedo iwrappink visa minmax koda i toki bloka:

 

jQuery(document).ready(function($) {
//cia js kodas
});

 

 

Vistiek nieko:/

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mendy

mendy 0

Atrašyta
  • Autorius
Atrašyta

Svarbu ir eiliskumas. Jquery reikia pirmiau uzloadint, tik po to minmax.js ar koki kita

pasidariau testini veikia, bet ant pagrindinio nei velnio.. atrodo taip pat sudeliojau

 

www.fifa18.lt/test.php

 

<link rel='stylesheet' href='http://www.fifaps4turnyrai.x10.bz/themes/Stylo/styles.css' type='text/css' />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"></script>
<script type='text/javascript' src='http://fifaps4turnyrai.x10.bz/minmax.js'></script>

<?php
require_once 'maincore.php';
require_once THEMES.'templates/header.php';
?>
<table id="mytable">
 <tr>
   <td>Jack</td>
   <td>450</td>
   <td>794</td>
   <td>784</td>
 </tr>
 <tr>
   <td>Steve</td>
   <td>145</td>
   <td>794</td>
   <td>789</td>
 </tr>
 <tr>
   <td>Mike</td>
   <td>2794</td>
   <td>2794</td>
   <td>79</td>
 </tr>

Nuoroda į pranešimą
Dalintis kituose puslapiuose
mogohax

mogohax 16

Atrašyta
Atrašyta

Math.max funkcija:

 

The largest of the given numbers. If at least one of the arguments cannot be converted to a number, NaN is returned.

 

Siuo atveju pas tave kiekvienam stulpelyje yra po string'a (POS, GP, PPG, FG%, ..), todel visiems stulpeliams min ir max reiksmiu neranda (NaN). Panaikink ji arba perdaryk lentele i thead+tbody ir minmax scripta pakabink tik ant tbody.

Nuoroda į pranešimą
Dalintis kituose puslapiuose

Prisijunkite prie diskusijos

Jūs galite rašyti dabar, o registruotis vėliau. Jeigu turite paskyrą, prisijunkite dabar, kad rašytumėte iš savo paskyros.

Svečias
Parašykite atsakymą...

×   Įdėta kaip raiškusis tekstas.   Atkurti formatavimą

  Only 75 emoji are allowed.

×   Nuorodos turinys įdėtas automatiškai.   Rodyti kaip įprastą nuorodą

×   Jūsų anksčiau įrašytas turinys buvo atkurtas.   Išvalyti redaktorių

×   You cannot paste images directly. Upload or insert images from URL.

Įkraunama...
×
 Dalintis
Sekėjai 0
Eiti į temų sąrašą

  • Dabar naršo   0 narių

    Nei vienas registruotas narys šiuo metu nežiūri šio puslapio.

×
×
  • Pasirinkite naujai kuriamo turinio tipą...