Login   Register  
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 Johnstone  >  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: 2011-04-02 07:05
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 />';
    }
    
?>