</select>
                </label>

                <label class="label_small">
                    <span class="field">Cidade:</span>
                    <select class="j_loadcity" name="empresa_cidade">
                        <?php 
if (!isset($data['empresa_cidade'])) {
    ?>
                            <option value="" selected disabled> Selecione antes um estado </option>
                            <?php 
} else {
    $City = new Controle('app_cidades');
    $City->Query("estado_id = :uf ORDER BY cidade_nome ASC", "uf={$data['empresa_uf']}");
    if ($City->getRowCount()) {
        foreach ($City->getResult() as $cidade) {
            extract((array) $cidade);
            echo "<option value=\"{$cidade_id}\" ";
            if (isset($data['empresa_cidade']) && $data['empresa_cidade'] == $cidade_id) {
                echo "selected";
            }
            echo "> {$cidade_nome} </option>";
        }
    }
}
?>
                    </select>
                </label>

                <label class="label_small">
 private function getRow()
 {
     $Read = new Controle($this->Tabela);
     if (!empty($this->Places)) {
         $Read->Query($this->Termos, $this->Places, $this->BindParam);
     } else {
         $Read->findAll();
     }
     return $Read->getRowCount();
 }
Example #3
0
//Objeto READ
$read = new Controle();
//VISITAS DO SITE
$read->FullRead("SELECT SUM(siteviews_views) AS views FROM ws_siteviews");
$Views = $read->getResult()[0]->views;
//USUÁRIOS
$read->FullRead("SELECT SUM(siteviews_users) AS users FROM ws_siteviews");
$Users = $read->getResult()[0]->users;
//MÉDIA DE PAGEVIEWS
$read->FullRead("SELECT SUM(siteviews_pages) AS pages FROM ws_siteviews");
$ResPages = $read->getResult()[0]->pages;
$Pages = substr($ResPages / ($Users == 0 ? 1 : $Users), 0, 5);
//POSTS
$read->setTable("ws_posts");
$read->findAll();
$Posts = $read->getRowCount();
//            //EMPRESAS
//            $read->setTable("app_empresas");
//            $read->findAll();
//            $Empresas = $read->getRowCount();
?>
            
            <ul>
                <li class="view"><span><?php 
echo $Views;
?>
</span> visitas</li>
                <li class="user"><span><?php 
echo $Users;
?>
</span> usuários</li>
//Objeto READ
$read = new Controle();
//VISITAS DO SITE
$read->FullRead("SELECT SUM(siteviews_views) AS views FROM ws_siteviews");
$Views = $read->getResult()[0]->views;
//USUÁRIOS
$read->FullRead("SELECT SUM(siteviews_users) AS users FROM ws_siteviews");
$Users = $read->getResult()[0]->users;
//MÉDIA DE PAGEVIEWS
$read->FullRead("SELECT SUM(siteviews_pages) AS pages FROM ws_siteviews");
$ResPages = $read->getResult()[0]->pages;
$Pages = substr($ResPages / ($Users == 0 ? 1 : $Users), 0, 5);
//POSTS
$read->setTable("ws_posts");
$read->findAll();
$Posts = $read->getRowCount();
//EMPRESAS
$read->setTable("app_empresas");
$read->findAll();
$Empresas = $read->getRowCount();
?>
            
            <ul>
                <li class="view"><span><?php 
echo $Views;
?>
</span> visitas</li>
                <li class="user"><span><?php 
echo $Users;
?>
</span> usuários</li>