PHP avdb::close_conn_av Exemples

Exemple #1

Fichier : admin.php Projet : blogoosfero/avaliacoes

    function lista_aulas($cod_curso, $inicio)
    {
        $db = new avdb();
        $db->Conn_av();
        $this->titulo_new_aula($cod_curso);
        ?>
            <div align="center">
            <table class="tablemenuAdm">
            <tr>
            <td width="45" align="center" class="tdmenuAdm"><b>Id</b></td>
            <td align="left" class="tdmenuAdm"><b>Aulas</b></td>
            <td width="45" align="center" class="tdmenuAdm"><b>Quest&otilde;es</b></td>
            <td align="center" width="20" class="tdmenuAdm"></td>
            </tr>
            </table>
            </div>
	<?php 
        //<!-- Tabela de dados -->
        echo "<div align=\"center\">\r\n            <table class=\"tabValores\">";
        $c1 = "#FFFFFF";
        $c2 = "#CCCCCC";
        $c = 0;
        if ($sql = pg_query("SELECT aulas.\"Chave\", aulas.\"Nome\", COUNT( aulas_avaliacoes.\"CodAula\" ) AS \"c_Aulas\"\r\n                    FROM aulas LEFT JOIN aulas_avaliacoes ON aulas.\"Chave\" = aulas_avaliacoes.\"CodAula\" \r\n                    WHERE aulas.\"CodCurso\" = {$cod_curso}\r\n                    GROUP BY aulas.\"Chave\", aulas.\"Nome\" ORDER BY aulas.\"Chave\" DESC")) {
            // LIMIT $inicio , $inicio10
            //echo "<br> SQL: $sql";
            while ($r = pg_fetch_array($sql)) {
                echo "<tr bgcolor=\"" . ($c++ & 1 ? $c1 : $c2) . "\"> \r\n\t\t\t<td width=\"45\" align=\"center\">" . $r['Chave'] . "</td>\r\n\t\t\t<td align=\"left\">" . $r['Nome'] . "</td>\r\n\t\t\t<td width=\"45\" align=\"center\">" . $r['c_Aulas'] . "</td>\r\n\t\t\t<form name=\"F_EditaAulas\"" . $r['Chave'] . "\" method=\"post\">\r\n                        <td align=\"center\" width=\"20\"> \r\n\t\t\t<input type=\"hidden\" name=\"EditaAula\" value=\"" . $r['Chave'] . "\">\r\n\t\t\t<input type=\"submit\" class=\"btnEdita\" name=\"btn\" title=\"Editar Aula\" alt=\"Editar\r\n                        Aula\" value=\"\">\r\n                        </td>\r\n                        </form>\r\n                        </tr>";
            }
            //while
        }
        //if
        echo "</table>\r\n            </div>";
        echo "\r\n\t\t<!-- Botões nova aula e mais 10 -->\r\n\t\t<div align=\"center\">\r\n\t\t</table>\r\n\t\t<table class=\"tabTitle\">\r\n\t\t<tr>\r\n\t\t<td align=\"left\" width=\"45\">\r\n\t\t<form id=\"NovaAula\" name=\"NovaAula\" method=\"post\" action=\"\">\r\n\t\t<input name=\"NovaAula\" type=\"submit\" id=\"NovaAula\" value=\"NovaAula\" class=\"botaoAdm\" />\r\n\t\t</form>\r\n\t\t</td>\r\n\t\t<td align=\"left\">\r\n\t\t<!--\r\n\t\t<form id=\"ImportAulas\" name=\"ImportAulas\" method=\"post\" action=\"\">\r\n\t\t<input name=\"ImportAula\" type=\"submit\" id=\"ImportAula\" value=\"Importar Aulas\" class=\"botaoAdm\" />\r\n\t\t</form>\r\n\t\t-->\r\n\t\t</td>\r\n\t\t<td align=\"right\">\r\n\t\t<form id=\"MoreCursos\" name=\"Morecursos\" method=\"post\" action=\"\">\r\n\t\t<!--\r\n\t\t<input name=\"MoreCursos\" type=\"submit\" id=\"MoreCursos\" value=\"Mais 10\" class=\"botaoAdm\" />\r\n\t\t-->\r\n\t\t</form>\r\n\t\t</td>\r\n\t\t</tr>\t\r\n\t\t</table>\r\n\t\t<table class=\"tblinha\">\r\n\t\t<tr>\r\n\t\t<td>&nbsp;</td>\r\n\t\t</tr>\r\n\t\t</table>\r\n\t\t\t\r\n                </div>";
        //echo "<br> Listou aulas";
        //*/
        $db->close_conn_av();
    }

Exemple #2

Fichier : odim.php Projet : blogoosfero/avaliacoes

    function put_lista_usuarios()
    {
        ?>
            <div align="center">
            <table class="tabTitle">
                <tr>
		<?php 
        //exibe o nº de cursos cadastrados
        $db = new avdb();
        $db->Conn_av();
        /*$sql = "SELECT COUNT(Chave)FROM usuarios";
        		$res = mysql_query($sql)or die(mysql_error());
        		$r = mysql_fetch_row($res);*/
        ?>
                    <td><b><?php 
        echo $db->count('Chave', 'usuarios');
        ?>
 usu&aacute;rios cadastrados</b></td>
		</tr>
            </table>
            <table class="tablemenu">
                <tr>
		<td width="43" align="center" class="tdmenu"><b><font size="2" color="#FFFFFF">Id</b></td>
		<td align="left" class="tdmenu"><b>Nome</b></td>
		<td align="center" width="80" class="tdmenu"><b>N&iacute;vel</b></td>
		</tr>
            </table>
			
            <table class="tabValores">
            <?php 
        //preenche 10 últimas linhas da tabela Cursos
        $c1 = "#FFFFFF";
        $c2 = "#CCCCCC";
        $c = 0;
        //echo "<br>  SELECT Chave, Nome, Responsavel FROM cursos ORDER BY Chave DESC LIMIT $inicio ,  $inicio10";
        $db->Conn_av();
        $res = pg_query("SELECT * FROM usuarios ORDER BY \"Nome\" ");
        //echo "<br>".$res;
        while ($r = pg_fetch_array($res)) {
            //echo $r; tr bgcolor=".(($c++&1)?$c1:$c2)."
            echo "<tr bgcolor=\"" . ($c++ & 1 ? $c1 : $c2) . "\"> <td width=\"43\">" . $r['Chave'] . "</td>\r\n\t\t<td align=\"left\">" . $r['ID'] . " / " . $r['Nome'] . "</td>\r\n\t\t<td width=\"80\">" . $r['Nivel'] . "</font></td></tr>";
            //echo "<tr border=\"1\" border color=\"#000080\><td width=\"43\">". $r['Chave']."</td><td>".$r['Nome']."</td><td width=\"226\">".$r['Responsavel']."</td></tr>";
        }
        $db->close_conn_av();
        ?>
            </table>
            </div>
					
            <div align="center"> 
            
            <table class="tabTitle">
            <form id="MoreCursos" name="Morecursos" method="post" action="">
                <td align="right">
                <!--
                <input name="MoreCursos" type="submit" id="MoreCursos" value="Mais 100" class="botaoOdim" />
                -->
                </td></tr>
            </form>
            </table>
            <table class="tblinha">
                <tr>
		<td>&nbsp;</td>
		</tr>
            </table>
            </div>
        <?php 
    }