本文整理汇总了PHP中Read::FullRead方法的典型用法代码示例。如果您正苦于以下问题:PHP Read::FullRead方法的具体用法?PHP Read::FullRead怎么用?PHP Read::FullRead使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Read
的用法示例。
在下文中一共展示了Read::FullRead方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getCategory
/**
* Busca a categoria a partir do id
* @param INT $Category - ID do usuário cadastrado no banco
* @return STRING - retorna o nome da categoria
*/
public function getCategory($Category)
{
$this->CatId = $Category;
$read = new Read();
$read->FullRead("SELECT cat_name FROM " . DB_PRODUTOS_CATEGORIAS . " WHERE cat_id = :id", "id={$this->CatId}");
return $read->getResult()[0]['cat_name'];
}
示例2: getUserName
/**
* Busca o login do usuário a partir do user_id
* @param INT $userid - ID do usuário cadastrado no banco
* @return STRING - retorna o login do usuário
*/
public function getUserName($UserId)
{
$this->UserId = $UserId;
$read = new Read();
$read->FullRead("SELECT user_login FROM " . DB_USERS . " WHERE user_id = :id", "id={$this->UserId}");
return $read->getResult()[0]['user_login'];
}
示例3: getNames
private function getNames($nutri)
{
$read = new Read();
$read->FullRead("SELECT nutri_name FROM " . DB_NUTRICAO . " WHERE nutri_id = :id", "id={$nutri}");
if ($read->getResult()) {
return $read->getResult()[0]['nutri_name'];
} else {
return null;
}
}
示例4: GetCountBans
/**
* Obtem a quantidade total de contas vips
* @return $Array [] de contas vips
*/
public static function GetCountBans()
{
$Read = new Read();
$Read->FullRead("SELECT COUNT(*) as id FROM bans");
$Result = $Read->getResult();
if ($Result) {
foreach ($Read->getResult() as $acc) {
return $acc['id'];
}
} else {
return false;
}
}
示例5: GetCount
/**
* Obtem a quantidade total de Players
*/
public static function GetCount()
{
$Read = new Read();
$Read->FullRead("SELECT COUNT(*) as id FROM players");
$Result = $Read->getResult();
if ($Result) {
foreach ($Read->getResult() as $players) {
return $players['id'];
}
} else {
return false;
}
}
示例6: Read
<th>Data</th>
<th>Ação</th>
<th>Quantidade (<?php
echo $prod_unidade;
?>
)</th>
<th>Motivo</th>
<th>Descrição</th>
<th>Por</th>
</tr>
</thead>
<tbody>
<?php
$readUser = new Read();
foreach ($readProduto->getResult() as $registro) {
$readUser->FullRead("SELECT user_name, user_lastname FROM " . DB_USERS . " WHERE user_id = :id", "id={$registro['prod_created_by']}");
$user = $readUser->getResult()[0];
?>
<tr>
<td><?php
echo $registro['reg_data'] ? date('d/m/Y', strtotime($registro['reg_data'])) : '-';
?>
</td>
<td><?php
echo $registro['reg_action'] === 'add' ? 'Adicionado' : 'Retirado';
?>
</td>
<td><?php
echo $registro['reg_quantidade'];
?>
</td>
示例7: foreach
<th data-column-id="pai" data-formatter="familyLink">Nome do Pai:</th>
<th data-column-id="mae">Nome da Mãe:</th>
<th data-column-id="telefone">Telefone:</th>
<th data-column-id="atualizacao">Atualização:</th>
<th data-column-id="educandos" data-formatter="link">Educandos:</th>
<th data-column-id="status">Status</th>
</tr>
</thead>
<tbody>
<?php
$readFam->ExeRead(DB_FAMILIA, "ORDER BY familia_status DESC, familia_pai_nome ASC, familia_mae_nome ASC");
if ($readFam->getResult()) {
foreach ($readFam->getResult() as $fam) {
extract($fam);
$status = !$familia_status ? 'style="background: #fffed8"' : '';
$readEdu->FullRead("SELECT educando_nome, educando_data_nascimento, educando_id FROM " . DB_EDUCANDOS . " WHERE educando_familia_id = :id", "id={$familia_id}");
$familia_last_update = $familia_last_update ? date('d/m/Y H:i', strtotime($familia_last_update)) . ' hs' : '-';
$familia_status = $familia_status ? 'Ativo' : 'Inativo';
?>
<tr <?php
echo $status;
?>
>
<td><span><?php
echo $familia_id;
?>
</span></td>
<td><span><?php
echo $familia_pai_nome . ',' . $familia_id;
?>
示例8: Read
<option value="<?php
echo $Produtos['prod_id'];
?>
"><?php
echo $Produtos['prod_name'];
?>
</option>
<?php
}
?>
</select>
</div>
<div class="form-group" id="estoque_cat">
<?php
$readCat = new Read();
$readCat->FullRead("SELECT cat_id, cat_name FROM " . DB_PRODUTOS_CATEGORIAS . " ORDER BY cat_name ASC, cat_id ASC");
?>
<label class="col-sm-2">Categorias(s):</label>
<select multiple class="form-control selectpicker col-sm-10" name="estoque_cat[]" data-live-search="true">
<?php
foreach ($readCat->getResult() as $cat) {
?>
<option value="<?php
echo $cat['cat_id'];
?>
"><?php
echo $cat['cat_name'];
?>
</option>
<?php
}
示例9: checkCover
private function checkCover()
{
$readCapa = new Read();
$readCapa->FullRead("SELECT user_capa FROM " . DB_USERS . " WHERE user_email = :email", "email={$this->Data['user_email']}");
if ($readCapa->getRowCount()) {
$delCapa = $readCapa->getResult()[0]['user_capa'];
if (file_exists("../uploads/{$delCapa}") && !is_dir("../uploads/{$delCapa}")) {
unlink("../uploads/{$delCapa}");
}
}
}
示例10: date
<div class = "col-lg-11 col-p-10 headerPrintSpacing marginPrintTop printOnly">
<p class = "text-center bold text-uppercase">Patronato Santo Antonio</p>
<p class = "text-center">Rua Benjamim Claudino Barbosa, 13.600 - Bairro Zacarias</p>
<p class = "text-center">CEP 83025-323 - São José dos Pinhais - PR</p>
<p class = "text-center"><ins>www.patronatosantoantonio.org.br</ins> <ins>contato@patronatosantoantonio.org.br</ins></p>
<p class = "text-center">Tel.: (41) 3282-1034 Fax: (41) 3282-1301</p><hr />
</div>
<article class="col-lg-12 col-md-12 col-p-12">
<h1 class="text-primary h3 bold printOnly">Cardápio do dia <?php
echo date('d/m/Y', strtotime($cardapioDia));
?>
</h1>
<?php
$readMedida = new Read();
foreach ($readCardapio->getResult() as $cardapio) {
$readMedida->FullRead("SELECT nutri_medida FROM " . DB_NUTRICAO . " WHERE nutri_id = :id", "id={$cardapio['nutri_id']}");
?>
<p><strong><?php
echo $cardapio['nutri_name'];
?>
</strong> - <?php
echo $cardapio['cardapio_porcao'] . ' ' . $readMedida->getResult()[0]['nutri_medida'];
?>
</p>
<?php
}
?>
</article>
<article class="col-lg-5 col-md-5 col-p-5">
<h1 class="text-primary h4">Informação Nutricional Total</h1>
<?php
示例11: Read
?>
<form method="post" action="" class="ReportVisitForm">
<div class="col-lg-6 col-md-6">
<div class="form-group">
<label class="col-sm-2">Ação:</label>
<select class="form-control selectpicker col-sm-10" name="visit_action">
<option value="t">Tudo</option>
<option value="v">Visitante ainda no Patronato</option>
<option value="u">Última visita</option>
<option value="p">Primeira visita</option>
</select>
</div>
<div class="form-group" id="visit_nome">
<?php
$readVisitantes = new Read();
$readVisitantes->FullRead("SELECT visitante_nome, visitante_rg, visitante_id FROM " . DB_VISITANTES . " ORDER BY visitante_nome ASC, visitante_id ASC");
?>
<label class="col-sm-2">Nome(s):</label>
<select multiple class="form-control selectpicker col-sm-10" name="visit_visitantes[]" data-live-search="true">
<?php
foreach ($readVisitantes->getResult() as $Visitantes) {
?>
<option value="<?php
echo $Visitantes['visitante_id'];
?>
"><?php
echo $Visitantes['visitante_nome'] . ' - ' . $Visitantes['visitante_rg'];
?>
</option>
<?php
}
示例12: Read
$readCurso = new Read();
$readCurso->ExeRead(DB_CURSOS, "WHERE curso_id = :id", "id={$cursoId}");
foreach ($readCurso->getResult() as $curso) {
}
$readTurma = new Read();
$readTurma->ExeRead(DB_TURMAS, "WHERE turma_id = :id AND curso_id = :curso", "id={$turmaId}&curso={$cursoId}");
foreach ($readTurma->getResult() as $turma) {
}
foreach ($readAula->getResult() as $aula) {
}
require '_models/AdminEducando.class.php';
require '_models/AdminTurmas.class.php';
$inscricao = new AdminEducando();
$alunos = str_replace("|", ",", $turma['turma_alunos']);
$readAlunos = new Read();
$readAlunos->FullRead("SELECT educando_id, educando_nome from " . DB_EDUCANDOS . " WHERE educando_id in ({$alunos}) AND educando_status = 1 ORDER BY educando_nome ASC");
$readChamadaAtualizada = new Read();
$readChamadaAtualizada->ExeRead(DB_CHAMADAS, "WHERE curso_id = :curso AND turma_id = :turma AND data = :date", "curso={$cursoId}&turma={$turmaId}&date={$aula['data']}");
?>
<header class="printNone">
<ol class="breadcrumb">
<li><a href="painel.php" title="Tela Inicial">Início</a></li>
<li><a href="painel.php?exe=coord/curso" title="Lista Eventos">Lista Eventos</a></li>
<li><a href="painel.php?exe=coord/turma/index&curso=<?php
echo $curso['curso_id'];
?>
" title="Lista Turmas do Evento <?php
echo $curso['curso_nome'];
?>
">Turmas do Evento <?php
echo $curso['curso_nome'];
示例13: Read
<p align="center"><i class="fa fa-plus"></i>Submeter Novo Trabalho</p>
</section>
<table>
<thead>
<tr>
<td>Data</td>
<td>Titulo</td>
<td>Status</td>
</tr>
</thead>
<?php
$codPaslestrante = $userlogin['codigo'];
$ver = new Read();
$ver->FullRead("SELECT trabalhos.data_submetido, trabalhos.titulo, trabalhos.status\nFROM autor_trabalho\nINNER JOIN pessoas ON autor_trabalho.codigo_autor = pessoas.codigo\nINNER JOIN trabalhos ON autor_trabalho.codigo_trabalho = trabalhos.codigo\nwhere pessoas.codigo = {$codPaslestrante}");
foreach ($ver->getResult() as $result) {
extract($result);
if ($status == 'A') {
$resStatus = "Aprovado";
} elseif ($status == 'R') {
$resStatus = "Não Aprovado";
} else {
$resStatus = "Não Avaliado";
}
//$data_submetido = Check::DataR($data_submetido);
?>
<tr>
<td><?php
echo $data_submetido;
示例14: Read
<div class="col-lg-12 col-md-12 small">
<?php
$read->ExeRead(DB_TURMAS, "WHERE turma_status = 1");
if ($read->getResult()) {
?>
<table class="table table-condensed table-hover">
<thead>
<tr class="bg-info">
<th>Nome: </th>
<th>-</th>
</tr>
</thead>
<tbody>
<?php
$readChamada = new Read();
$readChamada->FullRead("SELECT " . DB_TURMAS . ".curso_id, " . DB_TURMAS . ".turma_id, id, turma_educador, turma_nome, turma_status, chamada_status, data, turma_hora_inicio, turma_hora_termino FROM " . DB_TURMAS . " INNER JOIN " . DB_AULAS . " ON " . DB_TURMAS . ".turma_id = " . DB_AULAS . ".turma_id WHERE chamada_status = 0 AND data = :date AND turma_status = 1 ORDER BY data ASC, turma_hora_inicio ASC", "date=" . date('Y-m-d'));
if ($readChamada->getResult()) {
foreach ($readChamada->getResult() as $turma) {
if ($turma['data'] . ' ' . $turma['turma_hora_inicio'] < date('Y-m-d H:i') && $turma['data'] . ' ' . $turma['turma_hora_termino'] > date('Y-m-d H:i')) {
$background = 'class="bg-warning"';
} elseif ($turma['data'] . ' ' . $turma['turma_hora_inicio'] > date('Y-m-d H:i')) {
$background = 'class="bg-success"';
} elseif ($turma['data'] . ' ' . $turma['turma_hora_termino'] < date('Y-m-d H:i')) {
$background = 'class="bg-danger"';
}
?>
<tr <?php
echo $background;
?>
>
<td><?php
示例15: Read
$mensagem = '';
$tipo = '';
$excluir = '';
$excluirTipo = '';
$read = new Read();
$resultado = true;
$form = filter_input_array(INPUT_POST, FILTER_DEFAULT);
if ($form && $form['submit']) {
if (isset($form['submit'])) {
if (!$_POST['titulo'] && !$_POST['autores'] && !$_POST['evento']) {
$mensagem = "Informe um dos campos para pesquisar!";
$tipo = RI_MSG_DANGER;
} else {
if ($_POST['titulo']) {
//echo "Título";
$read->FullRead("SELECT * FROM publicacao WHERE titulo LIKE :like AND aprovado = 'S'", "like=%{$_POST['titulo']}%");
if (!$read->getResult()) {
$resultado = false;
}
} else {
if ($_POST['autores']) {
//echo "Autores";
$read->FullRead("SELECT * FROM publicacao WHERE autores LIKE :like AND aprovado = 'S'", "like=%{$_POST['autores']}%");
if (!$read->getResult()) {
$resultado = false;
}
} else {
if ($_POST['evento']) {
//echo "Evento";
$read->FullRead("SELECT * FROM publicacao WHERE evento LIKE :like AND aprovado = 'S'", "like={$_POST['evento']}%");
if (!$read->getResult()) {