Skip to content

Instantly share code, notes, and snippets.

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.2000.5" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150" StatementSubTreeCost="0.0346973" StatementText="SELECT TOP 1 theDB.IDNum, FORMAT(theDate, 'M/d/yy') as theDate, Status, Rate FROM theDB INNER JOIN DomainTable on theDB.IDNum = DomainTable.IDNum where DomainIP = '127.0.0.1' and status IN ('Active', 'To ReActivate', 'To Deactivate', 'Deactivate ASAP', 'SUSPENDED', 'SUSPENDED X', 'SUSPENDED Y', 'SUSPENDED Z') order by theDB.IDNum DESC" StatementType="SELECT" QueryHash="0x5CC8267C047604B4" QueryPlanHash="0x6634D125444C9D74" RetrievedFromCache="true" SecurityPolicyApplied="false">
<StatementSetOptions ANSI
function greeting() {
$mysql_host = "...";
$mysql_user = "...";
$mysql_pass = "...";
$connect = mysqli_connect("$mysql_host", "$mysql_user", "$mysql_pass");
$string = "Greetings nerd...";
return($string);
}
$greeting = greeting();
var_dump($connect);