<?php
 
// Check if MySQLI Extension exists
 
if (!function_exists('mysqli_connect')) {
	throw new Exception('MySQLI Extension not found!');
}
 
// Connect to MySQL database
 
$mysqli = @new mysqli("host", "user", "pass", "db");
 
if (mysqli_connect_errno()) {
    throw new Exception(mysqli_connect_error()));
}
 
// Sanitize values
 
$id = (int)$_POST['id'];
$title = $mysqli->real_escape_string($_POST['title']);
$body = $mysqli->real_escape_string($_POST['body']);
 
$query = "SELECT * FROM something WHERE title = '$title' AND body LIKE '%$body%' AND id = $id";
 
// Execute Query
 
$result = $mysqli->query($query);
 
// Throw exception if something goes wrong with the query
// supposed to be default behavior in my opinion
 
if ($mysqli->error) {
	throw new Exception($mysqli->error);
}
 
// Render rows
 
if (is_object($result))
{
	echo '<table>';
	while ($row = $result->fetch_assoc()) 
	{
		echo '<tr>'. 
		'<td>'.$row['id'].'</td>'.
		'<td>'.$row['title'].'</td>'.
		'<td>'.$row['body'].'</td>'.
		'</tr>';
	}
	echo '</table>';
    $result->close();
}
 
// Close connection - apparently not necessary according to PHP documentation 
 
$mysqli->close();
 
?>
 

 
// Place within config file - Note this won't open an active MySQL Connection
 
MySQL::Config('host', 'user', 'pass', 'db');
 
// Open MySQL Connection and Execute Query, Connection closed on object destruct
// Perhaps move this to some kind of datalayer e.g. one for MySQL, one for PostgreSQL etc...
 
$rows = MySQL::Create('SELECT * FROM something 
			WHERE title = ?title 
			AND body LIKE ?body 
			AND id = ?id')
	->Parameter('title', $_POST['title'])
	->Parameter('body', '%'.$_POST['body'].'%')
	->Parameter('id', $_POST['id'], 'integer')
	->Query();
 
// Consider replacing with datagrid control/class
 
if (isset($rows))
{
	echo '<table>';
	foreach($rows as $row)
	{
		echo '<tr>'. 
		'<td>'.$row['id'].'</td>'.
		'<td>'.$row['title'].'</td>'.
		'<td>'.$row['body'].'</td>'.
		'</tr>';
	}
	echo '</table>';
}
 

 
<?php
 
abstract class MySQLStrategy
{
	protected $resource;
	protected $count;
	protected $host;
	public function __construct(MySQL $host) {
		$this->host = $host;
	}
 
	abstract public function AffectedRows();
	abstract public function Count();
	abstract public function Escape($value);
	abstract public function LastId();
	abstract public function Open();
	abstract public function Query();
	abstract public function NonQuery();
	abstract public function Scalar();
	abstract public function Close();	
}
 
?>
 

 
private function __construct(array $settings) {
	$this->settings = $settings;
 
	if (function_exists('mysqli_connect')) {
		$this->_strategy = new MySQLI_Strategy($this);
	} else if (function_exists('mysql_connect')) {
		$this->_strategy = new MySQL_Strategy($this);
	} else {
		throw new Exception("No compatible MySQL strategy found");
	}
}	
 

 
public class Website
{
    public Int32 Identity
    {
        get;
        set;
    }
 
    public String Name
    {
        get;
        set;
    }
 
    public String PhysicalPath
    {
        get;
        set;
    }
 
    public ServerState Status
    {
        get;
        set;
    }
}
 

 
public enum ServerState
{
    Starting = 1,
    Started = 2,
    Stopping = 3,
    Stopped = 4,
    Pausing = 5,
    Paused = 6,
    Continuing = 7
}
 

 
public static void Main()
{
	foreach (Website site in GetSites("IIS://localhost/W3SVC"))
	{
		Console.WriteLine(String.Concat
		(
			site.Name, " , ", 
			site.Identity, " , ", 
			site.Status, " , ", 
			site.PhysicalPath
		));
	}
}
 
static IEnumerable<Website> GetSites(String Path)
{
    DirectoryEntry IIsEntities = new DirectoryEntry(Path);
 
    foreach (DirectoryEntry IIsEntity in IIsEntities.Children)
    {
        if (IIsEntity.SchemaClassName == "IIsWebServer")
        {
            yield return new Website
            (
                Convert.ToInt32(IIsEntity.Name),
                IIsEntity.Properties["ServerComment"].Value.ToString(),
                GetPath(IIsEntity),
                (ServerState)IIsEntity.Properties["ServerState"].Value
            );
        }
    }
}
 
static String GetPath(DirectoryEntry IIsWebServer)
{
    foreach (DirectoryEntry IIsEntity in IIsWebServer.Children)
    {
        if (IIsEntity.SchemaClassName == "IIsWebVirtualDir")
            return IIsEntity.Properties["Path"].Value.ToString();
    }
    return null;
}
 
// Alternatively we can rewrite the preceding snippet using a linq statement
/*static IEnumerable<Website> GetSites(String Path)
{
    DirectoryEntry IIsEntities = new DirectoryEntry(Path);
 
    return (from s in IIsEntities.Children.OfType<DirectoryEntry>()
            where s.SchemaClassName == "IIsWebServer"
            select new Website
            {
                Identity = Convert.ToInt32(s.Name),
                Name = s.Properties["ServerComment"].Value.ToString(),
                PhysicalPath = (from p in s.Children.OfType<DirectoryEntry>()
                                where p.SchemaClassName == "IIsWebVirtualDir"
                                select p.Properties["Path"].Value.ToString()).Single(),
                Status = (ServerState)s.Properties["ServerState"].Value
            });
 
}*/
 

 
ServerManager IIS = new ServerManager();
 
foreach (Site site in IIS.Sites)
{
    Console.WriteLine(String.Concat
    (
        site.Name, " , ",
        site.Id, " , ",
        site.State, " , ",
        site.Applications["/"].VirtualDirectories[0].PhysicalPath
    ));
}