{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"query","type":"text"}]},{"type":"paragraph","content":[{"text":"Execute read-only SQL query on the database.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"array query(string $sql, array $bind_parameters)","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Parameters","type":"text"}]},{"type":"paragraph","content":[{"text":"$sql","type":"text","marks":[{"type":"strong"}]},{"text":" The query string. All data inside the query should be bound with named bind variables or properly escaped.","type":"text"},{"type":"hardBreak"},{"text":"$bind_parameters","type":"text","marks":[{"type":"strong"}]},{"text":" An array of key-value pairs with elements that are bound parameters in the SQL statement being executed. Array key names match the named bind variables in the SQL statement.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Return Values","type":"text"}]},{"type":"paragraph","content":[{"text":"Returns FALSE on failure. For successful queries, it will return an array of data.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"getQueryError","type":"text"}]},{"type":"paragraph","content":[{"text":"Retrieve the last Query Error that was triggered by the query function. When executing invalid SQL the query function returns ","type":"text"},{"text":"false","type":"text","marks":[{"type":"em"}]},{"text":". To see the error in the query use this function.","type":"text"}]},{"type":"codeBlock","content":[{"text":"string getQueryError()","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example: Simple Services Query","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"$services = $this->query(\"SELECT * FROM SERVICES\");","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example: Using Heredoc Notation","type":"text"}]},{"type":"paragraph","content":[{"text":"This example uses ","type":"text"},{"text":"PHP heredoc Notation","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc"}}]},{"text":" to query for Available Services","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"$services = $this->query(<<query(<< 'ACTIVE', ':available' => 'AVAILABLE']);\n\n$statusCodes = ['ACTIVE', 'AVAILABLE'];\n$services = $this->query(<< $statusCodes);","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example: Retrieving Query Error","type":"text"}]},{"type":"paragraph","content":[{"text":"This example executes a bad SQL statement and then retrieves the error and sends it to the debug function.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"$invalid = $this->query(<<getQueryError();\n$this->debug($error);","type":"text"}]}],"version":1}

Browser not supported