PHP Classes
elePHPant
Icontem

File: light_example_list_sql.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Lee J  >  Lite User Agents API  >  light_example_list_sql.php  >  Download  
File: light_example_list_sql.php
Role: Example script
Content type: text/plain
Description: example list from sql
Class: Lite User Agents API
Get user agents information into XML or database
Author: By
Last change:
Date: 3 years ago
Size: 5,091 bytes
 

Contents

Class file image Download
<?php
    define
('IN_FCMS', true);
   
session_start();
    include
'class.Lite_user-agents.org.php';
    include
'class.MySQL_Connect.php';
   
$sql = new MySql_Con();
   
$rbt = new User_Agents_dot_org();
   
$sql->GetMyConnection();
   
$rbt->XML_enabled = false;
    if(!isset(
$_GET['type'])){$sype= ''; }else{ $sype=$_GET['type'];}
   
// check if we are doing a single character search and display, set correct
if(!isset($_GET['alpha'])){ $alpha = false;}else{ $alpha = true;}
   
// send of the display call to the class
   
$rbt->Display_Agents('SQL',$sype, $alpha);
   
$sql->CleanUpDB();
   
?>
<h1>SQL List & filters examples</h1>
    <a rel="nofollow" href="light_example_list_sql.php">None</a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=B">Browser</a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=C">Link, bookmark, server checking</a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=D">Downloading tool</a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=P">Proxy server, web filtering</a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=R">Robot, crawler, spider </a> |
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=S">Spam or bad bot</a>
    <strong><br>List By Alphabet</strong><br>
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=a">A</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=b">B</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=c">C</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=d">D</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=e">E</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=f">F</a>-
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=g">G</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=h">H</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=i">I</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=j">J</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=k">K</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=l">L</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=m">M</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=n">N</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=o">O</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=p">P</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=q">Q</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=r">R</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=s">S</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=t">T</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=u">U</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=v">V</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=w">W</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=x">X</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=z">Z</a>
    <br><strong>List By Number</strong><br>
       <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=1">1</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=2">2</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=3">3</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=4">4</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=5">5</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=6">6</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=7">7</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=8">8</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=9">9</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=0">0</a>
    <br><strong>List by Character</strong><br>
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=(">(</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=!">!</a> -
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=*">*</a></p>
    </article>
    <?php
   
echo '<h3><font color="red">'.sizeof($rbt->Nice_List).'</font> Results </h3>';
foreach (
$rbt->Nice_List as $i => $k){
   
// print out each type.
   
echo '['.$i.'] - '.$k['id'].' - '.$k['string'].' - '.$k['description'].' - '.$k['type'].' - '.$k['comment'].' - '.$k['link'].' - '.$k['link2'].'<br />';
    }
   
?>