Velka pomoc s PHP prosiiiim ... – PHP – Fórum – Programujte.com

Cafte, tak mam kod:

page.php

<?php

if(isset($_GET['page'])){

$page=$_GET['page'];

$page2=$page.".php";



if(file_exists($page2)){

header("Location: $page2");

}}

?>

<?php



/*



CREATE DATABASE `games` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;



 CREATE TABLE `games`.`hry` (

`id` INT NOT NULL AUTO_INCREMENT ,

`name` TINYTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`other` TINYTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`category` TINYTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

PRIMARY KEY ( `id` )

) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci



*/





class MyDb{

   

   public $sql;

   public $connect;



 function __construct(){

    require_once('password.php');

    $this->connect = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);

   mysql_select_db("games");

    }

   

   

function vypis($sql){

   require('page.php');

   $this->sql= mysql_query("SELECT * FROM hry WHERE category>='$page' ORDER BY id DESC");

   while($row = mysql_fetch_array($this->sql)){

      echo $row["name"];

      echo $row["other"];

   }

   

}

}

<?php

require('head.php');

require('MyDb.class.php');

?>



<a href="index.php?page=arkada">kat</a>



<?php

$in = new MyDb();

$in->vypis($sql);

?>

<?php

$in = new MyDb();

$in->vypis($sql);

?>

a skusal si ci to spadne aj na webhostingu ? :smile16:

To marioff : co kdyz se to jen nejak zacykly s redirectama? :D

To KIIV : predtym som si to nepozrel poriadne... ale asi mas pravdu:

vsak ani nemoze dojst k vypisu kedze vo funkcii vypis($sql) nastane redirect (ak bude nastavena prem. page) :smile1: atd.... a mimo toho je cely ten kod minimalne nejaky zvlastny...

napr. toto je co??:

WHERE category>='$page'

To marioff : mozna by nebylo od veci aby nastavil zobrazovani warningu :)


nevim teda jestli sem neco prehledl... ale vsude pouziva promennou $sql kterou predava metode vypis ale nikde sem ji nevidel ani definovanou a tak jak tak ji ve funkci nepouziva