[github/wallabag/wallabag.git] / process.php

<?php
/**
 * poche, a read it later open source system
 *
 * @category   poche
 * @author     Nicolas Lœuillet <nicolas@loeuillet.org>
 * @copyright  2013
 * @license    http://www.wtfpl.net/ see COPYING file
 */

include dirname(__FILE__).'/inc/config.php';
$db = new db(DB_PATH);

$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
$id     = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';


switch ($action)
{
    case 'toggle_fav' :
        $sql_action     = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
        $params_action  = array($id);
        break;
    case 'toggle_archive' :
        $sql_action     = "UPDATE entries SET is_read=~is_read WHERE id=?";
        $params_action  = array($id);
        break;
    default:
        break;
}

# action query
if (isset($sql_action))
{
    $query = $db->getHandle()->prepare($sql_action);
    $query->execute($params_action);
}
?>
Commit	Line	Data
e46efced	1	<?php
	2	/**
	3	* poche, a read it later open source system
	4	*
	5	* @category poche
	6	* @author Nicolas Lœuillet <nicolas@loeuillet.org>
	7	* @copyright 2013
	8	* @license http://www.wtfpl.net/ see COPYING file
	9	*/
	10
	11	include dirname(__FILE__).'/inc/config.php';
	12	$db = new db(DB_PATH);
	13
	14	$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
	15	$id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
	16
	17
	18	switch ($action)
	19	{
	20	case 'toggle_fav' :
	21	$sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
	22	$params_action = array($id);
	23	break;
	24	case 'toggle_archive' :
	25	$sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
	26	$params_action = array($id);
	27	break;
	28	default:
	29	break;
	30	}
	31
	32	# action query
	33	if (isset($sql_action))
	34	{
	35	$query = $db->getHandle()->prepare($sql_action);
	36	$query->execute($params_action);
	37	}
	38	?>