PHP PrintHouseList Exemples

Exemple #1

Fichier : HousesSQL.php Projet : JFeakes/IFB299

function SearchHouses($name)
{
    $myquery = "Select * FROM Houses Where Address LIKE CONCAT('%', '{$name}', '%')";
    if (!empty($_GET["Bedrooms"])) {
        $beds = $_GET["Bedrooms"];
        $myquery = $myquery . " AND Beds >= {$beds}";
    }
    if (!empty($_GET["Toilets"])) {
        $toilets = $_GET["Toilets"];
        $myquery = $myquery . " AND Toilets >= {$toilets}";
    }
    if (!empty($_GET["Garages"])) {
        $garages = $_GET["Garages"];
        $myquery = $myquery . " AND Garages >= {$garages}";
    }
    PrintHouseList($myquery);
}

Exemple #2

Fichier : HousesSQL.php Projet : JaydenWhiley/SavingPrivateTrump

function SearchHouses($name)
{
    $myquery = "Select * FROM Houses Where address ~* '{$name}'";
    if (!empty($_GET["Bedrooms"])) {
        $beds = $_GET["Bedrooms"];
        $myquery = $myquery . " AND beds >= {$beds}";
    }
    if (!empty($_GET["Toilets"])) {
        $toilets = $_GET["Toilets"];
        $myquery = $myquery . " AND toilets >= {$toilets}";
    }
    if (!empty($_GET["Garages"])) {
        $garages = $_GET["Garages"];
        $myquery = $myquery . " AND garages >= {$garages}";
    }
    PrintHouseList($myquery);
}

Exemple #3

Fichier : Recent.php Projet : JFeakes/IFB299

<?php

include "SiteBanner.php";
include_once "Sql.php";
include_once "HousesSQL.php";
$query = "Select * From Houses ORDER BY id DESC LIMIT 4";
PrintHouseList($query);