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; }