D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home1
/
netbooks
/
public_html
/
__nbgym
/
models
/
Filename :
exercicios.php
back
Copy
<?php class Exercicios { function __construct() { $this->auth = new database(); } function getDetalhes($parametros=null) { $conexao=$this->auth; $qry = "select * FROM exercicios WHERE id = ?"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getTiposExercicio($parametros=null) { $conexao=$this->auth; $qry = "select id, tipo FROM tipos_exercicio WHERE estado = 'A'"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getGruposMusculares($parametros=null) { $conexao=$this->auth; $qry = "select id, designacao FROM grupos_musculares WHERE estado = 'A'"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getMedia($parametros=null) { $conexao=$this->auth; $qry = "select * FROM exercicios_media WHERE id_exercicio = ?"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getExerciciosDoTipo($parametros=null) { $conexao=$this->auth; $qry = "select id FROM exercicios WHERE id_tipo_exercicio = ?"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getExerciciosDoGrupoMuscular($parametros=null) { $conexao=$this->auth; $qry = "select id FROM exercicios WHERE id_grupo_muscular_principal = ?"; $r = $conexao->selectDB($qry, $parametros); Return $r; } function getExerciciosEmPlanos($parametros=null) { $conexao=$this->auth; $qry = "select id FROM planos_treinos_det WHERE id_exercicio = ?"; $r = $conexao->selectDB($qry, $parametros); Return $r; } } ?>