public function listarResponsavel($id_aluno, $cod_situacao = 1) { $query = "\n SELECT\n pessoa.id_pessoa,\n pessoa.id_escola,\n pessoa.id_turma,\n pessoa.tipo,\n pessoa.data_inclusao,\n pessoa.ultima_alteracao,\n pessoa.nome,\n pessoa.data_nascimento,\n pessoa.genero,\n pessoa.cpf_cnpj,\n pessoa.valor_mensalidade,\n pessoa.telefone1,\n pessoa.telefone2,\n pessoa.telefone3,\n pessoa.telefone4,\n pessoa.email1,\n pessoa.email2,\n pessoa.email3,\n pessoa.email4,\n pessoa.endereco,\n pessoa.complemento,\n pessoa.bairro,\n pessoa.cidade,\n pessoa.uf,\n pessoa.cod_situacao\n FROM pessoa\n INNER JOIN aluno_responsavel ON aluno_responsavel.id_responsavel = pessoa.id_pessoa\n WHERE aluno_responsavel.id_aluno = '" . do_escape($id_aluno) . "'\n AND pessoa.cod_situacao = '" . do_escape($cod_situacao) . "'\n "; $pessoas = array(); $result = get_result_db($query); while ($pessoa = get_object($result)) { $pessoas[] = $this->atualizar($pessoa); } free_result($result); return $pessoas; }
function populate_select($table, $fields_id, $fields_value, $selected) { $conn = db_connect(HOST, USER, PASS, DB, PORT); $sql = "Select {$fields_id},{$fields_value} From {$table} Order By {$fields_value}"; $results = mkr_query($sql, $conn); while ($row = fetch_object($results)) { $SelectedCountry = $row->{$fields_id} == $selected ? " selected" : ""; echo "<option value=" . $row->{$fields_id} . $SelectedCountry . ">" . $row->{$fields_value} . "</option>"; //($row->$fields_id==$selected) ? 'selected' : ''; } free_result($results); }
public function listar($cod_situacao = null) { $query = $this->query() . "\n WHERE usuario.id_escola = '" . do_escape(ID_ESCOLA) . "'\n "; if (!is_null($cod_situacao)) { $query .= " AND usuario.cod_situacao = '" . do_escape($cod_situacao) . "' "; } $query .= " ORDER BY usuario.nome "; $usuarios = array(); $result = get_result_db($query); while ($usuario = get_object($result)) { $usuarios[] = $this->atualizar($usuario); } free_result($result); return $usuarios; }
session_start(); error_reporting(E_ALL & ~E_NOTICE); include_once "login_check.inc.php"; include_once "queryfunctions.php"; include_once "functions.php"; access("reservation"); //check if user is allowed to access this page $conn = db_connect(HOST, USER, PASS, DB, PORT); if (isset($_GET["search"]) && !empty($_GET["search"])) { find($_GET["search"]); } if (isset($_POST['Navigate'])) { //echo $_SESSION["strOffSet"]; $nRecords = num_rows(mkr_query("select * from guests", $conn), $conn); paginate($nRecords); free_result($results); find($_SESSION["strOffSet"]); } $guestid = $_POST['guestid']; if (isset($_POST['Submit'])) { $action = $_POST['Submit']; switch ($action) { case 'Guest Reservation': //if guest has not been selected exit // instantiate form validator object $fv = new formValidator(); //from functions.php if (empty($_POST["guestid"])) { //if no guest has been selected no point in displaying other errors $fv->validateEmpty('guestid', 'No guest has been selected for reservation.'); } else {
echo "<tr><td><a href=\"admin.php\">Admin</a></td></tr>"; } if ($access->guest == 1) { echo "<tr><td><a href=\"guests.php\">Guests</a></td></tr>"; } if ($access->reservation == 1) { echo "<tr><td><a href=\"reservations.php\">Reservations</a></td></tr>"; } if ($access->booking == 1) { echo "<tr><td><a href=\"bookings.php\">Bookings</a></td></tr>"; } if ($access->agents == 1) { echo "<tr><td><a href=\"agents.php\">Agents</a></td></tr>"; } if ($access->rooms == 1) { echo "<tr><td><a href=\"rooms.php\">Rooms</a></td></tr>"; } if ($access->billing == 1) { echo "<tr><td><a href=\"billings.php\">Guest Bill</a></td></tr>"; } if ($access->rates == 1) { echo "<tr><td><a href=\"rates.php\">Rates</a></td></tr>"; } if ($access->lookup == 1) { echo "<tr><td><a href=\"lookup.php\">Lookups</a></td></tr>"; } if ($access->reports == 1) { echo "<tr><td><a href=\"reports.php\">Reports</a></td></tr>"; } free_result($access);
<td><?php echo $html['date']; ?> </td> <td><?php echo $html['state']; ?> </td> <td><input type="checkbox" name="ids[]" value="<?php echo $html['id']; ?> "></td> </tr> <?php } free_result($result); ?> <tr><td colspan="5" ><label for="all"><input id="all" name="checkall" type="checkbox" />全选</label><input type="submit" name="submit" value="删除选中私信"></td></tr> </tbody> </table> </form> <?php //pager参数:t表示文本式分页,n表数字分页 pager('t'); ?> </div> </div> <script src="js/message.js"></script> <?php require ROOT_PATH . 'includes/footer.inc.php'; ?>
function execute($sql) { global $db; if (!$db->multi_query($sql)) { echo "\nsql execute failure\n-----------------\n{$sql}\n------------\n"; printf("Error - SQLSTATE %d: %s.\n", $db->errno, $db->error); echo "!!!!!!!!!!!!!!!!!!!\n"; die('error occur, exited.'); } free_result(); }
/** *This function is getting data from database<br> *@note global variables <i>sql</i>,<i>con</i> to set the result.<br> *display result to web page.<br> *Generate HTML output directly for use in web page.<br> */ function getdata() { global $sql, $conn; $results = mkr_query($sql, $conn); /*$totRows = mysql_query("SELECT FOUND_ROWS()"); //get total number of records in the select query irrespective of the LIMIT clause $totRows = mysql_result($totRows , 0); $_SESSION["nRecords"]=$totRows; $_SESSION["totPages"]=ceil($totRows/$strRows); $_SESSION["RowsDisplayed"]=$strRows;*/ echo "<table align=\"center\">"; //get field names to create the column header echo "<tr bgcolor=\"#009999\">\n\t\t<th>Action</th>"; while ($i < mysql_num_fields($results)) { $meta = mysql_fetch_field($results, $i); $field = $meta->name; echo "<th>" . $field . "</th>"; $i++; } "</tr>"; //end of field header if ((int) $results !== 0) { //get data from selected table on the selected fields while ($row = fetch_object($results)) { //alternate row colour $j++; if ($j % 2 == 1) { echo "<tr id=\"row{$j}\" onmouseover=\"javascript:setColor('{$j}')\" onmouseout=\"javascript:origColor('{$j}')\" bgcolor=\"#CCCCCC\">"; } else { echo "<tr id=\"row{$j}\" onmouseover=\"javascript:setColor('{$j}')\" onmouseout=\"javascript:origColor('{$j}')\" bgcolor=\"#EEEEF8\">"; } echo "<td><a href=\"reportqueries.php?search={$row->ID}\"><img src=\"images/button_view.png\" width=\"16\" height=\"16\" border=\"0\" title=\"view\"/></a></td>"; $i = 0; while ($i < mysql_num_fields($results)) { $meta = mysql_fetch_field($results, $i); $field = $meta->name; echo "<td>" . $row->{$field} . "</td>"; $i++; } // echo "</tr>"; //end of - data rows } //end of while row echo "</table>"; } free_result($results); }
public function listar($id_usuario, $cod_situacao = 1) { $query = $this->query(); $query .= " \n WHERE id_usuario = '" . do_escape($id_usuario) . "'\n AND cod_situacao = '" . do_escape($cod_situacao) . "'\n "; $personagens = array(); $result = get_result_db($query); while ($personagem = get_object($result)) { $personagens[] = $this->atualizar($personagem); } free_result($result); return $personagens; }
public static function listarItem($id_jogador = null) { $query = static::query(); if (!is_null($id_jogador)) { $query .= " WHERE id_jogador = " . do_escape($id_jogador) . " "; } $query .= " ORDER BY nome"; $itens = array(); $result = get_result_db($query); while ($row = get_object($result)) { $itens[] = static::carregarDB($row); } free_result($result); return $itens; }
public static function listar($limit = 0) { $query = static::query(); $query .= "\n WHERE (\n sessao.id_mestre = '" . do_escape(ID_JOGADOR) . "' OR\n " . do_escape(ID_JOGADOR) . " IN (\n SELECT personagem.id_jogador\n FROM personagem\n WHERE personagem.id_sessao = sessao.id_sessao\n )\n )\n AND sessao.cod_situacao IN (" . SESSAO_ATIVA . "," . SESSAO_PAUSA . ")\n ORDER BY sessao.ultimo_turno DESC\n "; if ($limit > 0) { $query .= " LIMIT " . do_escape($limit); } $sessoes = array(); $result = get_result_db($query); while ($dados = get_object($result)) { $sessao = new Sessao(); static::carregar($sessao, $dados); $sessoes[] = $sessao; } free_result($result); return $sessoes; }
public function gerarXML() { $xml = new XMLWriter(); $xml->openMemory(); $xml->setIndent(true); $xml->startDocument('1.0', 'UTF-8'); $xml->startElement("urlset"); $xml->writeAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9'); $url = "http://{$_SERVER['HTTP_HOST']}"; $xml->startElement("url"); $xml->writeElement('loc', 'http://bibliaemdebate.com.br'); //$xml->writeElement('lastmod', date('Y-m-d') ); $xml->writeElement('changefreq', 'daily'); $xml->writeElement('priority', '0.5'); $xml->endElement(); //url $query = "\n SELECT DISTINCT\n livros.liv_tes_id AS 'id_testamento',\n versiculos.ver_liv_id AS 'id_livro',\n versiculos.ver_capitulo AS 'id_capitulo'\n FROM versiculos\n INNER JOIN livros ON livros.liv_id = versiculos.ver_liv_id\n AND versiculos.ver_vrs_id = 3\n ORDER BY\n livros.liv_tes_id,\n versiculos.ver_liv_id,\n versiculos.ver_capitulo\n "; $result = get_result_db($query); while ($versiculo = get_object($result)) { $url = 'http://bibliaemdebate.com.br/nvi/'; if ($versiculo->id_testamento == NOVO_TESTAMENTO) { $url .= 'nt'; } elseif ($versiculo->id_testamento == ANTIGO_TESTAMENTO) { $url .= 'at'; } $url .= "/{$versiculo->id_livro}/{$versiculo->id_capitulo}"; $xml->startElement("url"); $xml->writeElement('loc', $url); //$xml->writeElement('lastmod', substr($imovel->ultima_alteracao, 0, 10) ); $xml->writeElement('changefreq', 'yearly'); $xml->writeElement('priority', '1.0'); $xml->endElement(); //url } free_result($result); $xml->endElement(); //urlset $xml->endDocument(); //echo $xml->outputMemory(TRUE); return $xml; }
echo $htmluser['email']; ?> </a></li> <li>网址:<a href="<?php echo $htmluser['url']; ?> " title=""><?php echo $htmluser['url']; ?> </a></li> </ul> </figcaption> </figure> <?php } free_result($result_newuser); ?> </section> </aside> </div> <div id="message" class="hide"> <h2 class="ddd"><span id="tips">发送消息给:</span><span id="friend"></span></h2> <form class="form-horizontal" method="post" name="message" id="mform" action="blog.php?action=message"> <div class="form-groups"> <label class="form-labels" for="" >私信内容:</label> <div class="controls"> <input type="hidden" name="touser"> <textarea name="content" id="" cols="30" rows="10" maxlength="200"></textarea> </div> </div>
public function listar($id_personagem) { $query = $this->query() . "\n WHERE id_personagem = '" . do_escape($id_personagem) . "'\n AND cod_situacao = '" . do_escape(QUEST_ATIVA) . "'\n "; $quests = array(); $result = get_result_db($query); while ($quest = get_object($result)) { if (array_key_exists($quest->id_tipo, $GLOBALS['_quest'])) { $this->carregar($quest); $quests[] = $quest; } } free_result($result); return $quests; }