function get_tweets_by_day($query, $timestamp = null)
{
//if no date is supplied default to yesterday
if (is_null($timestamp)) {
$timestamp = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'));
}
//sanitize their timestamp {not really required}
$date = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp), date('Y', $timestamp));
$end = mktime(0, 0, 0, date('m', $date), date('d', $date) + 1, date('Y', $date));
$options = array('q' => $query, 'result_type' => 'recent', 'since' => date('Y-m-d', $date), 'until' => date('Y-m-d', $end));
$page = 1;
$rpp = 100;
$response['p' . $page] = send_query($options, $page, $rpp);
while (count($response['p' . $page]->results) == $rpp) {
$last_id = array_pop($response['p' . $page]->results)->id_str;
$options['max_id'] = $last_id;
$page++;
$response['p' . $page] = send_query($options, 1, $rpp);
if (isset($response['p' . $page]->error)) {
unset($response['p' . $page]);
break;
}
}
$results = array();
$total_query_time = 0;
foreach ($response as $page) {
$total_query_time += $page->completed_in;
foreach ($page->results as $res) {
array_push($results, $res);
}
}
//take some data from last
$last_page = array_pop($response);
return array('query_time' => $total_query_time, 'last_id' => $last_page->max_id_str, 'total_records' => count($results), 'results' => $results);
}
function db_interfacing($connection, $query, $form_is_empty)
{
$connection = $connection;
$query = $query;
$form_is_empty = $form_is_empty;
function send_query($connection, $query, $empty_form_test)
{
$connection = $connection;
$form_is_empty = $empty_form_test;
$query = $query;
if ($form_is_empty == FALSE) {
$result = mysqli_query($connection, $query);
return $result;
}
}
$result = send_query($connection, $query, $form_is_empty);
return $result;
}
<?php
require_once "../includes/inc.includes.php";
// Include necessary files
// set trackrow parameters (to be improved! OOP!)
$trackrow_param->artist = TRUE;
$trackrow_param->title = TRUE;
$trackrow_param->length = TRUE;
$trackrow_param->play = TRUE;
$trackrow_param->edit = TRUE;
$input = file_get_contents("php://input");
$tracklist = json_decode(send_query($input));
write_tracklist($tracklist, null, $level1);
</h3>
<p>Данный релиз опросных листов, содержит не полный перечень оборудования <?php
echo $corp_name;
?>
<br>
в формате MS Word 2010 или в архиве <a href="https://ru.wikipedia.org/wiki/ZIP" title="Что такое формат zip" target="_blank">zip</a> (Сдесь можно <a href="http://7-zip.org.ua/ru/" title="Сдесь можно скачать программу для работы с zip файлами" target="_blank">скачать</a> программу для работы с zip файлами).</p>
</div>
<div class="container">
<div class="row">
<?php
for ($t = 1; $t < $arr_type_product[0]; $t++) {
echo '<div class="col-sm-4">' . $BR;
echo '<div class="well well-sm">' . $BR;
echo '<h2 class="text-uppercase index-product">' . $arr_type_product[$t] . '</h2>' . $BR;
for ($g = 1; $g < $arr_group[0]; $g++) {
$result = send_query("SELECT * FROM " . $tab_prouct_group . " WHERE TYPE_PRODUCT = '" . $arr_type_product[$t] . "' AND GROUP_PRODUCT = '" . $arr_group[$g] . "';");
if ($result->num_rows >= 1) {
if (!$arr_group[$g] == $arr_type_product[$t]) {
echo '<h4 class="text-uppercase"><i class="fa fa-chevron-right" style=" color:#CCC;"></i> ' . $arr_group[$g] . '</h4>' . $BR;
}
echo '<div class="list-group">' . $BR;
while ($row = $result->fetch_assoc()) {
//echo ' <a href="'.$root_dir.$BFL.$product_page_name.'?p_NM='.translit($row['HEADERS']).'&p_ID='.$row['ID'].'" class="list-group-item" title="'.strstr($row['ANATATIONS'], '.', true).'"><span class="badge">'.$row['ABR'].'</span>'.$row['HEADERS'].'</a></li>'.$BR;
if (!$row['OPROS_LIST'] == NULL) {
echo ' <a href="' . $dir_files_opros_list . $FL . $row['OPROS_LIST'] . '" target="_blank" style="color: #337ab7;" class="list-group-item" title="Скачать опросной лист"><i class="fa fa-link" style="color:#000;"></i> ' . $row['HEADERS'] . '</a></li>' . $BR;
} else {
echo ' <a href="#" class="list-group-item disabled"><i class="fa fa-chain-broken"></i> ' . $row['HEADERS'] . '</a></li>' . $BR;
}
}
echo '</div>' . $BR;
}
