Zum Beispiel so:
PHP
<?php
class funcs {
function getFracDescById($mysql, $dbh, $id)
{
$frac_id = filter_var($id, FILTER_SANITIZE_SPECIAL_CHARS);
$query = $dbh->prepare("SELECT `$mysql->db_frak_desc` FROM `$mysql->db_frak_table` WHERE `$mysql->db_frak_id` = :fid");
$query->execute(array(":fid"=>$frac_id));
$row = $query->rowCount();
$fetch = $query->fetch();
return $fetch[$mysql->db_frak_desc];
}
}
$mysql_funcs = new funcs();
//Nutzung dann:
$mysql_funcs->getFracDescById($mysql, $dbh, $id);
?>
Alles anzeigen