Exemplo n.º 1
0
function get_action($me)
{
    $q = db('select count(me) as c from actions where me=:me and date(time, "unixepoch") between date("now") and date("now", "+1 day") group by me');
    $q->bindParam(':me', $me);
    $q->execute();
    $r = $q->fetchAll(PDO::FETCH_COLUMN, 0);
    if (count($r) === 0) {
        clear_db($me);
    }
    echo json_encode($r);
}
Exemplo n.º 2
0
<?php

include 'simple_html_dom.php';
include 'db.php';
include 'head.php';
// Connect to the database
$conn = connect($config);
if (!$conn) {
    die('Problem connecting to the db.');
}
include 'content.php';
if (isset($_POST['submit-btn'])) {
    insert_urls($conn);
}
if (isset($_POST['showimages'])) {
    show_images($conn);
}
if (isset($_POST['cleardb'])) {
    clear_db($conn);
    echo '<p id="content">Database cleared</p>';
}
include 'footer.php';
Exemplo n.º 3
0
Arquivo: test.php Projeto: name3/cheng
clear_db(Order::$table, Customer::$table, 'customer');
// what if Order submited??
// clear
clear_db('big_to_small_order', Order::$table, 'small', 'small');
$big_order_ids = Pdb::fetchAll('id', BigOrder::$table);
if ($big_order_ids) {
    foreach ($big_order_ids as $id) {
        if (!Pdb::exists('big_to_small_order', array('big=?' => $id))) {
            Pdb::del(BigOrder::$table, array('id=?' => $id));
        }
    }
}
// clear address
clear_relation_db(Customer::$table, Address::$table);
// clear user log
clear_db(UserLog::$table, Customer::$table, 'subject');
// clear account
clear_11_db(Customer::$table, Account::$table);
// clear account log
clear_1m_db(Account::$table, AccountHistory::$table);
// clear price_data
$pds = Pdb::fetchAll('id', PriceData::$table);
if ($pds) {
    $tbl = Order::$table;
    foreach ($pds as $id) {
        $cond1 = array('factory_price = ?' => $id);
        $cond2 = array('customer_price = ?' => $id);
        if (!Pdb::exists($tbl, $cond1) && !Pdb::exists($tbl, $cond2)) {
            Pdb::del(PriceData::$table, array('id = ?' => $id));
        }
    }