function testReturnStrQuery()
{
$opt = new OptionClass();
$strSearchArr = explode(" ", "Carlo luis");
$strSearchArr2 = explode(" ", "Carlo");
$fieldArr = $opt->returnFieldsArray();
$this->assertNotNull($fieldArr);
$this->assertNotNull($strSearchArr);
$this->assertNotNull($opt->returnStrQuery($fieldArr, $strSearchArr, "SELECT * FROM RESIDENT"));
$this->assertNotNull($opt->returnStrQuery($fieldArr, $strSearchArr2, "SELECT * FROM RESIDENT"));
echo $opt->returnStrQuery($fieldArr, $strSearchArr2, "SELECT * FROM RESIDENT");
}
<?php
if (isset($_GET["strSearch"])) {
$opt = new OptionClass();
$con = mysql_connect("localhost", "DORMA", "dorm");
$strSearch = $_GET["strSearch"];
$length = 200;
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dormdatabase", $con);
if (trim($strSearch) != "") {
$strSearchArr = explode(" ", $strSearch);
$fieldArr = $opt->returnFieldsArray();
$mainQuery = $opt->returnStrQuery($fieldArr, $strSearchArr, "SELECT * FROM RESIDENT WHERE");
//$mainQuery = mysql_query("SELECT FirstName, LastName from resident where LastName LIKE '$strSearch%'");;
//$returnFName = mysql_query("SELECT FirstName, LastName from resident where FirstName LIKE '$strSearch%'");;
$table = $opt->returnTable(mysql_query($mainQuery), 'FirstName', 'LastName', $length);
//returnTD($returnFName,'FirstName','LastName');
echo $table;
} else {
echo "";
}
}
?>
<?php
class OptionClass
{
function returnTable($ret, $f1, $f2, $len)
{
