function exibir()
{
$link = conect();
if (isset($_POST['buscar'])) {
/*
1- Região e Regionalismo
2- Meio Ambiente
3- Territórios Rurais
4- Cidades Médias e Pequenas
5- Relação Rural/Urbano
*/
if ($_POST['eixo'] == 0) {
$CondicaoArea = "`area` = '1' OR `area` = '2' OR `area` = '3' OR `area` = '4' OR `area` = '5'";
if (!empty($_POST['autores'])) {
$NomeAutor = mysqli_real_escape_string($link, $_POST['autores']);
$CondicaoAutor = "`nome` LIKE '%{$NomeAutor}%'";
$sql = mysqli_query($link, "SELECT * FROM `anais` WHERE {$CondicaoAutor} ORDER BY `nome`;");
} else {
$sql = mysqli_query($link, "SELECT * FROM `anais` WHERE {$CondicaoArea} ORDER BY `nome`;");
}
} else {
$area = $_POST['eixo'];
$CondicaoArea = "`area` = '{$area}'";
if (!empty($_POST['autores'])) {
$NomeAutor = mysqli_real_escape_string($link, $_POST['autores']);
$CondicaoAutor = "`nome` LIKE '%{$NomeAutor}%'";
$sql = mysqli_query($link, "SELECT * FROM `anais` WHERE {$CondicaoAutor} AND {$CondicaoArea} ORDER BY `nome`;");
} else {
$sql = mysqli_query($link, "SELECT * FROM `anais` WHERE {$CondicaoArea} ORDER BY `nome`;");
}
}
} else {
$sql = mysqli_query($link, "SELECT * FROM `anais` ORDER BY `nome`");
}
while ($row = mysqli_fetch_array($sql)) {
$Nome = $row['nome'];
$Titulo = $row['titulo_trabalho'];
$Area = $row['area'];
$Diretorio = $row['diretorio_arquivo'];
echo "\t<tr>\r\n\t\t \t\t\t<td>\r\n\t\t\t\t\t\t\t" . utf8_encode($Nome) . "\r\n\t\t \t\t\t</td>\r\n\t\t \t\t\t<td>\r\n\t\t\t\t\t\t\t" . utf8_encode($Titulo) . "\r\n\t\t \t\t\t</td>\r\n\t\t \t\t\t<td style='text-align:center;'>\r\n\t\t\t\t\t\t\t<a href='arquivo/" . utf8_encode($Diretorio) . ".pdf' target='_BLANK'><i class='fa fa-2x fa-file-pdf-o'></i></a>\r\n\t\t \t\t\t</td>\r\n\t\t\t \t\t</tr>";
}
}
define('USUARIO', 'rdsin098_babyeat');
define('SENHA', 'RDS20120243');
define('DB', 'rdsin098_babyeatbeta');
// FUNÇÃO DE CONEXAO
function conect()
{
$dsn = "mysql:\t=" . HOST . ";dbname=" . DB;
try {
$conn = new PDO($dsn, USUARIO, SENHA);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $conn;
} catch (PDOException $erro) {
echo $erro->getMessage();
}
}
$pdo = conect();
try {
$preparar = $pdo->query("SELECT SUM(ml)AS ml_total FROM tb_registro WHERE data= '2014-11-01'");
$totaldeml = $preparar->fetch(PDO::FETCH_OBJ);
foreach ($totaldeml as $total_ml) {
$tml = $total_ml;
echo $tml;
}
} catch (PDOException $e) {
echo $e->getMessage();
}
/*
$h1 = 'localhost';
$u1 = 'root';
$p1 = '123';
$b1 = 'babyeat';
$table = SendRequest($url4, $formpost, $header);
$mas = "{$table}";
$masiv = explode(';', $mas);
// echo gettype($masiv);
//echo $table;
//var_dump($table);
//echo $dani=$table->find('doc');
//if(is_array($dani)){
$i = 0;
foreach ($masiv as $span) {
$i++;
$SPECIAL_DAYS[$i] = explode('= new Array', $span);
}
//$item2=substr($item1,-60);
//$item3=substr($item2, 0,12);
//var_dump($SPECIAL_DAYS);
if ($SPECIAL_DAYS) {
conect($SPECIAL_DAYS);
}
//$masiv=$table['doc'];
//var_dump($table);
//$masiv=preg_split(';', $table, PREG_SPLIT_OFFSET_CAPTURE);
//var_dump($masiv);
//echo $table;
//$masiv=spliti(';',$table);
//echo $masiv;
//var_dump($masiv);
?>
</body>
</html>
//echo date("d/m/Y");
while ($day <= $cal_days) {
//echo $i."/01/2015"."<br>";
// echo date("d/m/Y");
$data = array('__LASTFOCUS' => '', 'ctl00_ScriptManager1_HiddenField' => ';;AjaxControlToolkit, Version=3.5.50401.0, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e:en-US:beac0bd6-6280-4a04-80bd-83d08f77c177:f2c8e708:de1feab2:720a52bf:f9cec9bc:589eaa30:698129cf:e148b24b:fcf0e993:fb9b4c57:ccb96cf9:987bb99b:a4b66312:35576c48', '__EVENTTARGET' => '', '__VIEWSTATE' => '/wEPDwULLTE1OTc1NTc1MTMPZBYCZg9kFgICAw9kFggCAQ8WAh4FY2xhc3MFBm5vcm1hbGQCHQ9kFgICAQ8WAh4JaW5uZXJodG1sBRBCb29rIEFwcG9pbnRtZW50ZAIhDxYCHgdWaXNpYmxlaGQCIw9kFgYCAw8PFgIeBFRleHRlZGQCBQ8PFgIfA2VkZAIHD2QWCgIHD2QWAgIBD2QWAmYPZBYCAgMPZBYCAgEPZBYMAgEPDxYCHglNYXhMZW5ndGgCMhYIHgpvbmtleXByZXNzBRBSZXN0cmljdFNwYWNlKCk7HghvbmNoYW5nZQVZamF2YXNjcmlwdDpyZXR1cm4gdHJpbSh0aGlzKTsoJ2N0bDAwX0NvbnRlbnRQbGFjZUhvbGRlcjFfdHh0UmVmZXJlbmNlTm9fdHh0UmVmZXJlbmNlTm8nKTseB29uZm9jdXMFD2FkZEJvcmRlcih0aGlzKR4Gb25ibHVyBRxSZW1vdmVCb3JkZXIodGhpcyxmYWxzZSwnJyk7ZAIDDxYCHwJoZAIFDxYCHwJoZAIHDw8WBh4MRXJyb3JNZXNzYWdlBQ1UeXBlIE1pc21hdGNoHhFDb250cm9sVG9WYWxpZGF0ZQUOdHh0UmVmZXJlbmNlTm8eFFZhbGlkYXRpb25FeHByZXNzaW9uBQ5eW2EtekEtWjAtOV0rJGRkAgkPDxYCHwoFDnR4dFJlZmVyZW5jZU5vZGQCCw8PFgQfCQUNVHlwZSBNaXNtYXRjaB4HRW5hYmxlZGhkZAIJD2QWCAIDD2QWDAIBDw8WAh8EAgEWBB8HBQ9hZGRCb3JkZXIodGhpcykfCAUcUmVtb3ZlQm9yZGVyKHRoaXMsZmFsc2UsJycpO2QCAw8WAh8CaGQCBQ8WAh8CaGQCBw8PFgYfCQUOIFR5cGUgTWlzbWF0Y2gfCgURdHh0Tm9PZkFwcGxpY2FudHMfCwUVWzAtOV0qWy5dezAsMX1bMC05XSskZGQCCQ8PFgIfCgURdHh0Tm9PZkFwcGxpY2FudHNkZAILDw8WBB8JBQ4gVHlwZSBNaXNtYXRjaB8MaGRkAgcPEA8WBh4NRGF0YVRleHRGaWVsZAUUQXBwb2ludG1lbnRfQ2F0ZWdvcnkeDkRhdGFWYWx1ZUZpZWxkBRdBcHBvaW50bWVudF9DYXRlZ29yeV9JZB4LXyFEYXRhQm91bmRnZBAVAww8LS1TZWxlY3QtLT4HR2VuZXJhbAdQcmVtaXVtFQMBMCQwNzczZTNkNC1iZjI1LTRlYTItOWFjNS1mNTE0Y2ExOWY3NTYkNDljNmMyNDUtMjNmMS00ZDYzLWFmYzUtNjhjMzk2ZWM2ZjEyFCsDA2dnZxYBZmQCCw9kFg4CAQ8PFgQfBGYeB1Rvb2xUaXAFCkREL01NL1lZWVkWBB8HBQ9hZGRCb3JkZXIodGhpcykfCAUcUmVtb3ZlQm9yZGVyKHRoaXMsZmFsc2UsJycpO2QCAw8WAh8CaGQCBQ8WAh8CaGQCBw8PFgYfCQUOIFR5cGUgTWlzbWF0Y2gfCgUSZHRwQXBwb2ludG1lbnREYXRlHwsFRV5bYS16QS1aMC05XC0uLEBcJCAlIF4iIHtcfSAjJyZcKis9fDw+YH5bXF0oXClcXC9fLDo7PyFcbi9cci9cdC9cc10rJGRkAgkPDxYCHwoFEmR0cEFwcG9pbnRtZW50RGF0ZWRkAgsPDxYEHwoFEmR0cEFwcG9pbnRtZW50RGF0ZR8JBQ4gVHlwZSBNaXNtYXRjaGRkAhMPFggeDklucHV0RGlyZWN0aW9uCymGAUFqYXhDb250cm9sVG9vbGtpdC5NYXNrZWRFZGl0SW5wdXREaXJlY3Rpb24sIEFqYXhDb250cm9sVG9vbGtpdCwgVmVyc2lvbj0zLjUuNTA0MDEuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj0yOGYwMWIwZTg0YjZkNTNlAB4OQWNjZXB0TmVnYXRpdmULKYIBQWpheENvbnRyb2xUb29sa2l0Lk1hc2tlZEVkaXRTaG93U3ltYm9sLCBBamF4Q29udHJvbFRvb2xraXQsIFZlcnNpb249My41LjUwNDAxLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49MjhmMDFiMGU4NGI2ZDUzZQAeCkFjY2VwdEFtUG1oHgxEaXNwbGF5TW9uZXkLKwUAZAIRDxAPFgYfDQUSQXBwbGljYXRpb25fY2VudGVyHw4FFUFwcGxpY2F0aW9uX2NlbnRlcl9pZB8PZ2QQFQEDSVREFQEkMTE4MGUwMDQtZGI3My00ZjM1LThhZGYtMmZiYzE3YmU3ZDA4FCsDAWcWAWZkAgsPZBYCZg9kFgICAQ88KwANAGQCDQ9kFgICAQ88KwANAGQCEQ9kFgJmD2QWAgIDDzwrAA0AZBgEBR5fX0NvbnRyb2xzUmVxdWlyZVBvc3RCYWNrS2V5X18WAQUmY3RsMDAkQ29udGVudFBsYWNlSG9sZGVyMSRpbWdCdG5TZWFyY2gFJWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcjEkZ3ZBcHBEZXRhaWwPZ2QFJWN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcjEkZ3ZOZXh0U2xvdHMPZ2QFKGN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcjEkZ3ZTZWFyY2hSZXN1bHQPZ2TjwkCNXe/rFN8CEYuLhqLYlKD2PQ==', '__EVENTVALIDATION' => '/wEWDwKM25q3AQLMrteFDQL0rvrXDwL/roI8As65xLwPAvn909UCAtvR1dIEApaN3vMPApvZj4cOAqrbjcADAtT/htQEAquKqoQMAuavv9gEAtzgm/QOAtmJ8NUCTTK+9HdjCqW4KAK+NFu9MtwzBvM=', '__VIEWSTATEGENERATOR' => 'CD6DA3C7', 'ctl00$ContentPlaceHolder1$txtNoOfApplicants$txtNoOfApplicants' => 1, 'ctl00$ContentPlaceHolder1$txtNoOfApplicants$vceReq_ClientState' => '', 'ctl00$ContentPlaceHolder1$txtNoOfApplicants$vceReg_ClientState' => '', 'ctl00$ContentPlaceHolder1$ddlAppointmentCategory' => '0773e3d4-bf25-4ea2-9ac5-f514ca19f756', 'ctl00$ContentPlaceHolder1$vceAppointmentCategory_ClientState' => '', 'ctl00$ContentPlaceHolder1$dtpAppointmentDate$dtpAppointmentDate' => $day . "/" . $month_year, 'ctl00$ContentPlaceHolder1$dtpAppointmentDate$vceReg_ClientState' => '', 'ctl00$ContentPlaceHolder1$dtpAppointmentDate$vceCustomdtpAppointmentDate_ClientState' => '', 'ctl00$ContentPlaceHolder1$dtpAppointmentDate$medtpAppointmentDate_ClientState' => '', 'ctl00$ContentPlaceHolder1$dtpAppointmentDate$mewaterdtpAppointmentDate_ClientState' => '', 'ctl00$ContentPlaceHolder1$imgBtnSearch.x' => 40, 'ctl00$ContentPlaceHolder1$imgBtnSearch.y' => 1, 'ctl00_ScriptManager1_HiddenField' => ';;AjaxControlToolkit, Version=3.5.50401.0, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e:en-US:beac0bd6-6280-4a04-80bd-83d08f77c177:f2c8e708:de1feab2:720a52bf:f9cec9bc:589eaa30:698129cf:e148b24b:fcf0e993:fb9b4c57:ccb96cf9:987bb99b:a4b66312:35576c48');
$day++;
$date = $data['ctl00$ContentPlaceHolder1$dtpAppointmentDate$dtpAppointmentDate'];
// визначаєм дату
$data2 = http_build_query($data);
//var_dump($data);
$html = SendRequest($url, $data2);
$table = $html->find("table[id=ctl00_ContentPlaceHolder1_gvSearchResult] span");
if (is_array($table)) {
$m = 1;
foreach ($table as $span) {
$item1['time'] = $span->plaintext;
$item1['date'] = $date;
$max_masiv[] = $item1;
$m++;
}
}
}
if ($max_masiv) {
conect($max_masiv);
}
echo '(' . round(microtime(true) - $btime, 4) . ' sec.)';
?>
</body>
</html>
$db1 = conect();
$result_db1 = $db1->query("select * from tb_registro");
foreach ($result_db1 as $linhas_db1){
echo $linhas_db1['data'] . "<br />";
echo $linhas_db1['ml'] . "<br />";
}
*
$db2 = conect();
$result_db2 = $db2->query("select * from total_ml");
foreach ($result_db2 as $linhas_db2){
echo $linhas_db2['data'] . "<br />";
echo $linhas_db2['tml'] . "<br />"; }
*
*/
$db1 = conect();
$sql_db1 = "insert into tb_registro (refeicao, ml, data, horas)values (:r, :m, :d, :h)";
$stmt = $db1->prepare($sql_db1);
$stmt->bindValue(":r", "MAMADEIRA");
$stmt->bindValue(":m", 100);
$stmt->bindValue(":d", "2014-11-14");
$stmt->bindValue(":h", "18:22");
$stmt->execute();
################################################################################################
############################################################################################### /*
$db2 = conect2();
$sql_db2 = "insert into tb_registro (refeicao, ml, data, horas)values (:r, :m, :d, :h)";
$stmt = $db2->prepare($sql_db2);
$stmt->bindValue(":r", "MAMADEIRA");
$stmt->bindValue(":m", 100);
$stmt->bindValue(":d", "2014-11-14");
