function rsscache_sql_open()
 {
     // move item to different category
     global $rsscache_sql_db;
     global $rsscache_dbhost, $rsscache_dbuser, $rsscache_dbpass, $rsscache_dbname;
     $rsscache_sql_db = new misc_sql();
     $rsscache_sql_db->sql_open($rsscache_dbhost, $rsscache_dbuser, $rsscache_dbpass, $rsscache_dbname);
 }
Example #2
0
index.php - rsstool PHP example

Copyright (c) 2006 NoisyB


This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program 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 General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
*/
include 'config.php';
include 'sql.php';
$db = new misc_sql();
$db->sql_open($dbhost, $dbuser, $dbpass, $dbname);
$sql_query_s = 'SELECT `rsstool_url`, `rsstool_title`, `rsstool_desc`' . ' FROM `rsstool_table`' . ' ORDER BY `rsstool_dl_date` DESC' . ' LIMIT 0,100';
$db->sql_write($p);
$rsstool_table = $db->sql_read();
$p = '';
for ($i = 0; $rsstool_table[$i]; $i++) {
    $p .= '<a href="' . $rsstool_table[$i][0] . '">' . $rsstool_table[$i][1] . '</a><br><br>' . $rsstool_table[$i][2] . '<br><br><hr><br>';
}
echo $p;