public function mysqlSelect($id=""){
if(!$this->dbh())
return false;
if (empty($id)){
$sql="SELECT * FROM cms_cat";
$stmt=$this->dbh->prepare($sql);
$stmt->execute();
$categories=array();
foreach($stmt->fetchAll() as $value){
$p = new pCategory();
$p->id($value['id']);
$p->name($value['cat']);
$p->dbh=$this->dbh();
$categories[$p->id]=$p;
}
return $categories;
} else {
$sql="SELECT * FROM cms_cat WHERE id=?";
$stmt=$this->dbh->prepare($sql);
$stmt->bindParam(1, $id, PDO::PARAM_INT);
$stmt->execute();
$result=$stmt->fetch(PDO::FETCH_ASSOC);
$this->id($result['id']);
$this->name($result['cat']);
}
}
<link rel="stylesheet" media="all" href="layout.css">
</head>
<body>
<div id="head">
<h1>add exploit</h1>
<!-- <img src="img/logo.png" alt="logo" /> -->
</div>
<div>
<h2>new exploit</h2>
<?php
$exploit =new pExploit();
$exploit->dbh($dbh);
//$exploit->mysqlSelect();
$platform=new pPlatform();
$platform->dbh($dbh);
$category=new pCategory();
$category->dbh($dbh);
$vars= new Getvars();
$vars->requireVar('catname');
$vars->requireVar('category');
$vars->requireVar('platform');
$vars->requireVar('content');
$vars->assignVar('url_upload');
$vars->assignVar('pc_upload');
$vars->assignVar('verified');
/*benutzereingaben auswerten*/
if($vars->validateVars()){
/**sortieren ***/
$get->assignVar('order');
$get->assignVar('order_by');
/**sortieren ***/
if($get->validateVars()){
$e= new pExploit();
$e->dbh($dbh);
$n=$e->mysqlCountByCategory($get->view()); //anpassen
//-----lsExploits--------------------------------------------------------------------------------------------------------------------------------------------------------------
$e= new pExploit();
$e->dbh($dbh);
$c=new pCategory();
$c->dbh($dbh);
$c->mysqlSelect($get->view());
/*******order*******************/
$currentVars=array("view"=>$get->view());
$order="asc"; //asc||desc
$orderBy="date"; //order by column field
if ($get->order_by()!="" && $get->order()!=""){
$orderBy=$get->order_by();
$order=$get->order();
}
$get->order()=="asc"?$cursor="↑" : $cursor="↓";
$get->order()=="asc"?$order="desc" : $order="asc";
<link rel="stylesheet" media="all" href="layout.css">
</head>
<body>
<div id="head">
<h1>edit exploit</h1>
<!-- <img src="img/logo.png" alt="logo" /> -->
</div>
<div>
<h2>edit exploit</h2>
<?php
$exploit =new pExploit();
$exploit->dbh($dbh);
//$exploit->mysqlSelect();
$platform=new pPlatform();
$platform->dbh($dbh);
$category=new pCategory();
$category->dbh($dbh);
$vars= new Getvars();
$vars->requireVar('catname');
$vars->requireVar('category');
$vars->requireVar('platform');
$vars->requireVar('content');
$vars->assignVar('url_upload');
$vars->assignVar('pc_upload');
$vars->assignVar('verified');
$vars->requireVar('id');
$vars->requireVar('edit');
/*benutzereingaben auswerten*/
public function loadCategory(){
if ($this->dbh){
$c=new pCategory();
$c->dbh($this->dbh());
$c->mysqlSelect($this->category());
return $c->name();
}
}
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>ue-cr3w exploits</title>
<link rel="stylesheet" media="all" href="layout.css">
</head>
<body>
<div id="head">
<h1><a href="index.php">ue-cr3w exploits</a></h1>
<img src="img/logo.png" alt="logo" />
</div>
<div>
<!-- aus jeder kategorie 7-8 ausgeben. div drum, werte in table -->
<?php
$c=new pCategory();
$c->dbh($dbh);
$categories=$c->mysqlSelect();
foreach ($categories as $c){
//-----lsExploits--------------------------------------------------------------------------------------------------------------------------------------------------------------
$f=new Formgen();
$e= new pExploit();
$e->dbh($dbh);
$exploits=$e->mySqlSelectByCategory($c->id(),0, 8);
$viewByCategory=$f->getLink($c->name(), "ViewByCategory.php", array("view"=> $c->id()));
echo "<div class=\"exploit-category\">\n";
