Sql Expert
DBMS - September 1996 - Data Warehouse Architect
DBMS Online article by Ralph Kimball discussing two types of useful fact tables
that contain no facts at all.
PAVAN : India web developer Website designer India,freelance ASP ...
Provides freelance web design and development services.
Ask Tom Home
Oracle's VP, Core Technologies within the Oracle Support organization is a
brilliant technologist named Tom Kyte. Also the author or Oracle Expert One-on-One, ...
Oracle FAQ: Software tool reviews for Oracle Developers and DBAs
Semi-independent third-party review of various PL/SQL development products.
Access-VB-SQL Advisor Magazine
Articles, code, and discussion groups.
The DBA Zone, Inc. - Remote DBA for Oracle and SQL Server
Company specializes in implementing, monitoring and managing Oracle databases on
Unix, Linux and Microsoft Windows platforms. Offers news, FAQ, description of ...
SQL Server training class, 2000 course in Florida, FL, UK.
Hands on SQL Server training for developers and Web Masteers. Locations in
US (Florida) and UK (Glos.)
IT Outsourcing Company Serving Los Angeles, Orange County, San ...
We are a Network Consulting firm located in the Los Angeles area. We provide
companies a single source for all of their technology service needs.
Alentus Web Hosting, Dedicated Servers, and Business Website ...
Offers ASP.NET hosting.
oracle.oreilly.com -- Welcome to the O'Reilly Oracle Center ...
O'Reilly resource center for Oracle.
Red Rock SQL Services
SQL Server resource site that includes articles, book reviews, product reviews,
news and links. By Tony Bain.
Experts Exchange, the #1 IT Professional Collaboration Network on ...
Free online "ask an expert" site for computer questions.
MSExpert.Com - Recent News
Free resources for MCSE, MCSA, MCSD, and MCDBA, including practice exams.
Data Base Unlimited (DBU): SQL Server consulting
SQL server database design, development and consulting. Includes an overview of
products and services.
Aldex Software Ltd, Database Development, Developers ,Consultants ...
Developers of custom database applications using SQL Server, MS Access, Visual
Basic and .NET.
Resume SEO Expert James H. Summer, Jr. Resume Cold Fusion ...
Specializing in search engine optimization, natural search engine placement.
Lecco SQL Expert
Development environment with special emphasis on SQL and PL/SQL performance
optimization. By Leccotech. [Commercial]
Expert Witness Referrals: Medical_Technical@(800)683-9847
Free referrals to medical witnesses and technical expert witnesses. View CVs online.
Perpetual Technologies, Inc., Indianapolis, Indiana: Oracle ...
An Oracle and IT consulting and training company.
Oracle
Exchange information and solve problems through mutual discussions. Also voluntary
mailing lists.
rss_url = $url;
$this->num_to_show = $numtoshow;
$this->do_update = $update;
$this->my_html = preg_replace("/(#{.*?):(.*?})/", "\\1__\\2", $html); //xx:xx tag workaround
$this->content = $this->fetch_feed();
$this->parse_feed();
$this->show();
}
/* string */
function fetch_feed()
{
$url_parts = parse_url($this->rss_url);
$filename = $url_parts['host'] . str_replace("/", ",", $url_parts['path']) . "_" . @$url_parts['query'];
if(file_exists($this->data_directory . "/$filename")) {
$last = filemtime($this->data_directory . "/$filename");
if(time() - $last > $this->update_interval * 60 || $this->update_interval == 0) {
$update = 1;
}
} else {
$create= 1;
}
if($create == 1 || ($this->do_update == TRUE && $update == 1)) {
$fp = @fsockopen($url_parts['host'], 80, $errno, $errstr, 5);
if (!$fp) {
echo "Couldn't open rss feed {$this->feed_url} in {$_SERVER['PHP_SELF']}
\n";
return;
}
fputs($fp, "GET " . $url_parts['path'] . "?" . @$url_parts['query'] . " HTTP/1.0\r\n"
."Host: " . $url_parts['host'] . "\r\n"
."User-Agent: Drew's RSS Reader 0.1\r\n"
."Connection: Close\r\n\r\n");
while(!feof($fp)) {
$rss_data .= @fgets($fp, 1024);
}
list(, $rss_data) = explode("\r\n\r\n", $rss_data, 2);
$output = @fopen($this->data_directory . "/$filename", "w+");
if(!$output) {
return $rss_data;
} else {
flock($output, LOCK_EX);
fputs($output, $rss_data);
flock($output, LOCK_UN);
fclose($output);
}
} //update
return file_get_contents($this->data_directory . "/$filename");
}
/* void */
function parse_feed()
{
preg_match("/
(.*?)<\/title>/", $this->content, $title);
$this->feed_title = @$title[1];
preg_match("/<link>(.*?)<\/link>/", $this->content, $link);
$this->feed_link = @$link[1];
preg_match("/<description>(.*?)<\/description>/", $this->content, $description);
$this->feed_description = @$description[1];
preg_match_all("/<item[^>]*>(.*?)<\/item>/s", $this->content, $items);
if (sizeof($items[0]) == 0) {
echo "No item elements found in rss feed.<br />\n";
}
for($i = 0; $i < sizeof($items[0]); ++$i) {
preg_match_all("/(?:<([\w:]*)[^>]*>(?:<!\[CDATA\[)?(.*?)(?:]]>)?<\/\\1>)+?/si", preg_replace("/<item[^>]*>/", "", $items[0][$i]), $elements);
for($j = 0; $j < sizeof($elements[0]); ++$j) {
$elements[1][$j] = str_replace(":", "__", $elements[1][$j]); //regex fix for items with : like dc:date
$this->rss[$i][$elements[1][$j]] = trim(html_entity_decode($elements[2][$j]));
}
}
}
/* void */
function show()
{
if($this->my_html == "") {
$this->show_html();
} else {
$this->show_user_html();
}
}
function show_html()
{
$show = (sizeof($this->rss) > $this->num_to_show ? $this->num_to_show : sizeof($this->rss));
for($i = 0; $i < $show; ++$i) {
echo "- <a href=\"{$this->rss[$i]['link']}\" target=\"_new\">{$this->rss[$i]['title']}</a><br />\n";
}
}
function show_user_html()
{
$show = (sizeof($this->rss) > $this->num_to_show ? $this->num_to_show : sizeof($this->rss));
for($i = 0; $i < $show; ++$i) {
extract($this->rss[$i]);
$item = preg_replace("/#\{([^}]+)}/e", "$\\1", $this->my_html);
echo $item;
}
}
} // end class
$url = "http://www.justinpfister.com/gnewsfeed.php?q=Expert&lang=en&ned=us";
$show = 3;
$html = "#{title}<br />#{description}<br />";
$update = 1;
$rss = new rss_parser($url, $show, $html, $update);
$url = "http://search.news.yahoo.com/usns/ynsearch/categories/47/index.html?p=Expert";
$show = 3;
$html = "#{title}<br />#{description}<br />";
$update = 1;
$rss = new rss_parser($url, $show, $html, $update);
?>
</div>
<div id="Footer">Copyright © 2005 <a href="http://www.experts-tips.info/08" title="http://www.experts-tips.info/08">http://www.experts-tips.info/08</a> All Rights Reserved.</div>
<script language="javascript" type="text/javascript"
src="http://www.clicktoys.co.uk/help/asrep/record.php"></script>
<noscript><img width="1" height="1" border="0"
src="http://www.clicktoys.co.uk/help/asrep/record.php?rep=v&transport=img"></noscript>
<p align="center"><a href="http://www.experts-tips.info">EXPERTS Home</a></p>
</body>
</html>