<?php /* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */ /** * Autocompoleter fro RPMPHP * * PHP version 5 * * Copyright © 2010-2014 Remi Collet * * This file is part of rpmphp. * * rpmphp is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * rpmphp is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with rpmphp. If not, see <http://www.gnu.org/licenses/>. * * @category Main * @package RPMPHP * * @author Remi Collet <unknown@unknwown.com> * @author Johan Cwiklinski <johan@x-tnd.be> * @copyright 2010-2014 Remi Collet * @license http://www.gnu.org/licenses/agpl-3.0-standalone.html AGPL License 3.0 or (at your option) any later version * @link https://git.remirepo.net/cgit/web/rpmphp.git/ * @since The begining of times. */ require 'include/main.php'; $q = null; $limit = null; $ret = null; if ( !isset($_GET['q']) || $_GET['q'] == '' ) { die(); } else { $q = addslashes($_GET['q']); if ( !isset($_GET['limit']) || $_GET['limit'] == '' ) { $limit = 10; } else { $limit = intval($_GET['limit']); } } try { $db = new PDO ("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS); $sql = "SELECT name FROM rpm WHERE name LIKE '$q%' GROUP BY name LIMIT 0,$limit"; $resrpm = $db->query($sql); while ( $rpm = $resrpm->fetchObject() ) { $ret .= $rpm->name . "\n"; $limit--; } if ($limit) { $sql = "SELECT rpmname FROM packagist WHERE pkgname LIKE '$q%' LIMIT 0,$limit"; $resrpm = $db->query($sql); while ( $rpm = $resrpm->fetchObject() ) { $ret .= $rpm->rpmname . "\n"; } } } catch(PDOException $e) { echo 'An error occured.'; } echo $ret; ?>