示例#1
0
<?php

if (isset($_REQUEST['action'])) {
    if ($_REQUEST['action'] == 'active') {
        query("UPDATE tbl_video SET video_status='inactive' WHERE video_id='" . $_REQUEST['video_id'] . "'");
    }
    if ($_REQUEST['action'] == 'inactive') {
        query("UPDATE tbl_video SET video_status='active' WHERE video_id='" . $_REQUEST['video_id'] . "'");
    }
    if ($_REQUEST['action'] == 'delete') {
        query_delete('tbl_video', "video_id='" . $_REQUEST['video_id'] . "'");
        echo "<script language='javascript'> window.location='video.php'; </script>";
        exit;
    }
}
$sql = query("SELECT * FROM tbl_video ORDER BY video_id DESC");
$count = query_rows($sql);
示例#2
0
<?php

require 'framework/framework.php';
mysql_connect('omega.db', 'livereload', 'TdDmCHrUhYV4qKrN');
mysql_select_db('livereload');
if ($_GET['pw'] != '3141jopa') {
    die("Access denied.");
}
header("Content-type: text/csv");
$rows = query_rows("SELECT date, ip, email FROM subscriptions");
foreach ($rows as $row) {
    // echo "{$row->date}\t{$row->ip}\t{$row->email}\n";
    echo "{$row->email}\n";
}
示例#3
0
if ($_REQUEST['type'] == 'manufactures') {
    $image = $_REQUEST['image'];
    $data['manufacturers_image'] = '';
    query_update('tbl_manufacturers', $data, "manufacturers_id='" . $_REQUEST['id'] . "'");
    @unlink('../uploads/manufactures/' . $image);
}
if ($_REQUEST['type'] == 'category_admindropdown') {
    ?>
	<?php 
    $catId = $_GET['catId'];
    ?>
	<?php 
    $subcategory = query("SELECT category_id, category_name FROM  tbl_category WHERE category_level='2' AND category_status='active' AND category_parent_id='{$catId}' ORDER BY category_name ASC");
    ?>
	<?php 
    if (query_rows($subcategory) > 0) {
        ?>
	<select name="subcategory" id="subcategory" >
		<option value=""> Choose one </option>
		<?php 
        while ($rowcategory = fetch_array($subcategory)) {
            ?>
		<option value="<?php 
            echo $rowcategory['category_id'];
            ?>
"><?php 
            echo $rowcategory['category_name'];
            ?>
</option>
		<?php 
        }
示例#4
0
function stats_before($time)
{
    return query_rows("SELECT ip,\n          FROM_UNIXTIME(MIN(time)) start,\n          FROM_UNIXTIME(MAX(time)) end,\n          (MAX(time)-MIN(time))/(60*60*24) AS active_period,\n          ({$time}-MAX(time))/(60*60*24) AS inactive_period,\n          ({$time}-MIN(time))/(60*60*24) AS age\n      FROM `stats`\n      WHERE time <= {$time}\n      GROUP BY ip\n      ORDER BY active_period DESC");
}