Weblabor

case "katfelvitel2":

if (!preg_match("/[0-9]/", $_GET['k'])) {
$kod = 0 ;
}
else{
$kod = $_GET['k'];
}
$lek = mysql_query("select * from kategoria2");
$num = mysql_num_rows($lek);
$id=$num+1 ; 
mysql_query("insert into kategoria2(id) values('$id')") or die ("<font size=1 face=verdana>Kategória rögzítése sikertelen!</font>"); 
if(isset($_GET['k'])){
header("Location:kategoria.php?k=$_GET[k]");
}
else{
header("Location:kategoria.php");
}
break;

$sql = "SELECT tananyag.*, doc.*, admin_user.id, admin_user.nev FROM tananyag 
				INNER JOIN doc ON tananyag.tan_id = doc.tananyag_id
				LEFT OUTER JOIN admin_user ON tananyag.tan_uploader = admin_user.id
				WHERE tananyag.tananyag_csoport = ".$_SESSION['logged']['nevsor_csoport']."
				ORDER BY tananyag.tan_upload_date DESC";
		
		echo $sql;
		
		$get_tananyag = mysqli_query($kapcs, $sql);
		
		if(mysqli_num_rows($get_tananyag) > 0 )
		{
			while($t = mysqli_fetch_assoc($get_tananyag))
			{
				?>
                <div class="row tananyag_row">
                	<h4 class="tananyag_title"><?php echo $t['tan_nev']; ?></h4>
                    <p><?php echo $t['tan_leiras']; ?></p>
                    <span class="tananyag_uploaded_info"><i class="glyphicon glyphicon-user"></i> Feltöltötte: <?php echo $t['nev']; ?></span>
                    <span class="tananyag_uploaded_info"><i class="glyphicon glyphicon-calendar"></i> 
                    Feltöltés dátuma: <?php echo substr($t['tan_upload_date'], 0, -3); ?></span>
                    <span class="tananyag_uploaded_info"><i class="glyphicon glyphicon-file"></i> Fájl, dokumentum: 
                    <a href="docs/<?php echo $t['doc_file']; ?>" class="file_link"><?php echo $t['doc_file']; ?></a></span>
                </div>
                <?php
			}
		}
		else
		{
			echo '<p>Tananyagok feltöltése folyamatban...</p>';
		}
		?>

class pelda{
	public function kapcsolodas(){
	$hoszt="VALAMI";
	$uname="VALAMI";
	$passw="VALAMI";
	$link = mysqli_connect(
		$this->hoszt,
		$this->uname,
		$this->passw
	);

	$dbname="VALAMI";
	$select_db= mysqli_select_db(
	$this->link,
	$this->dbname) or die(mysqli_error($this->link));
	}
}

<?php
require_once('class/class.kapcs.php');
$kap = new pelda();
$kap->kapcsolodas();
?>