dbquery() sends an unique query to the database.
dbquery
Docs
PHPFusion Development
Core Functions verify_image uncompressIPv6 trimlink theme_exists stripslash stripinput stripget showdate set_admin_pass redirect profile_link preg_check phpentities parseubb parsesmileys parsebytesize make_captcha makepagenav makefileopts makefilelist isnum highlight_words hide_email groupaccess getuserlevel getusergroups getgroupname formatcode displaysmileys descript dbrows dbresult dbquery dbcount dbconnect dbarraynum dbarray cleanurl check_captcha check_admin_pass checkrights checkgroup censorwords cache_smileys cache_groups cache_bbcode addslashTheme FunctionsOther FunctionsMail FunctionsComments and RatingsPhoto Gallery FunctionsInfusions FunctionsOutput HandlingForum FunctionsBBCodesCustom includesJavascript Functionsdbquery
Quote
dbquery ( string $query )
Parameters
query
A SQL query, The query string should not end with a semicolon.
Return Values
For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning results, dbquery() returns a resource on success, or FALSE on error.
For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.
The returned result resource should be passed to dbarray(), and other functions for dealing with result tables, to access the returned data.
Use dbrows() to find out how many rows were returned for a SELECT statement or mysql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
Notes
dbquery() will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query.
Example Invalid Query
The following query is syntactically invalid, so dbquery() fails and returns FALSE.
Code
<?php
$result = dbquery('SELECT * WHERE 1=1');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
?>Example Valid Query
The following query is valid, so dbquery() returns a resource.
Code
<?php
// This could be supplied by a user, for example
$firstname = 'fred';
$lastname = 'fox';
// Formulate and Prefom Query
// This is the best way to perform a SQL query
// For more examples, see dbarray()
$result = dbquery("SELECT firstname, lastname, address, age
FROM friends WHERE firstname='$firstname' AND lastname='$lastname'");
// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "n";
$message .= 'Whole query: ' . $query;
die($message);
}
// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), dbarraynum(), etc.
while ($row = dbarray($result)) {
echo $row['firstname'];
echo $row['lastname'];
echo $row['address'];
echo $row['age'];
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>Changelog
7.01.00 - Added query count