Resources
Submit
|
|
Things to Do |
 |
|
· Validate V7 mods/infusions
© |
PHPfusion-mods.net is hosted at:
|
|
|
Handling MySQL Database on php-Fusion |
|
Before i start anything, i will hereby take for granted that you (reader) understand/know/learn MySQL to a certain level. Even, if you don't know anything about MySQL, this might help you start. And now, we may start.
MySQL database functions code snippets
function dbquery($query) {
}
function dbcount($field, $table, $conditions = "") {
}
function dbresult($query, $row) {
}
function dbrows($query) {
}
function dbarray($query) {
}
function dbarraynum($query) {
}
These are the functions' declarations on maincore.php. No, you don't have to open maincore.php, this is just a sample i wanted you all to look. From there, it should provide you with some idea of how this functions works. If you don't seems to understand the idea, don't worry. i'll will explain each functions.
1. dbquery($query)
This function executes a query on a MySQL database and then it returns a value. If the query failed, it will produce error message and return "false".
dbquery() is followed up by other function listed above accept for dbcount(). There are only one parameter for this function: the SQL query. Like mysql_query(), dbquery() is also used for UPDATE, DELETE, INSERT, and CREATE. You won't be using CREATE though.
Examples
see examples for other functions except dbcount(). :P
2. dbcount($field, $table, $conditions = "")
This function executes a COUNT query on a MySQL database and then it returns a value. COUNT query means it counts the total value of records found. If the query failed, it will produce error message and return "false".
dbcount() does not requires a result from dbquery(). dbcount() is usually used for paginations.
dbcount() has 3 parameters, two of which are required.
first paramenter -> $field
signifies which field in the table to be count
second parameter -> $table
signifies which table to be count
$conditions = ""
signifies the conditions of the field that need to be met.
conditions in MySQL is the
"WHERE field_name = 'some_value' AND field_name2 = 'other_value'"
Examples
this example returns the values of increment of 10 starting from 0. e.g, 0, 10, 20, 30 .. and so forth
$count = dbcount("(data_id)", DB_DATA, "data_access='".$d_ac.");
$count = ($count / 10) - 1;
$d_count = ceil($count) * 10;
if (!$d_count){
$d['error'] = "Cannot count data";
}
3. dbresult($query, $row)
A clone of the mysql_result() function that returns the value of a field in a recordset. If the query failed, it will produce error message and return "false".
dbresult() requires the return value from dbquery(). Because the return value specifies which result handle to use.
Examples
$query = "SELECT * FROM ".DB_DATA." WHERE data_id = '{$_GET['p']}'";
$result = dbquery($query);
$d['name'] = dbresult($result, 1);
if (!$d['name']){
$d['error'] = "No Name found";
}
4. dbrows($query)
A clone of the mysql_num_rows() function that returns the number of rows in a recordset. If the query failed, it will produce error message and return "false".
dbrows() requires the return value from dbquery(). Because the return value specifies which result handle to use.
Examples
$query = "SELECT * FROM ".DB_DATA.";
$result = dbquery($query);
$d_rows = dbrows($result);
if (!$d_rows){
$d['error'] = "Cannot count rows in data table";
}
5. dbarray($query)
A clone of the mysql_fetch_assoc() function that returns a row from a recordset as an associative array. If the query failed, it will produce error message and return "false".
dbarray() requires the return value from dbquery(). Because the return value specifies which result handle to use.
Examples
$query = "SELECT * FROM ".DB_DATA." WHERE data_id = '{$_GET['p']}'";
$result = dbquery($query);
if($db = dbarray($result)){
$d['id'] = $db['data_id'];
$d['name'] = $db['data_name'];
$d['desc'] = $db['data_desc'];
$d['access'] = $db['data_access'];
}
else{
$d['error'] = "No data found";
}
6. dbarraynum($query)
A clone of the mysql_fetch_row() function that returns a row from a recordset as a numeric array. If the query failed, it will produce error message and return "false". This function is very similar to dbarray, you will understand after reading the example
dbarraynum() requires the return value from dbquery(). Because the return value specifies which result handle to use.
Examples
$query = "SELECT * FROM ".DB_DATA." WHERE data_id = '{$_GET['p']}'";
$result = dbquery($query);
$d = dbarraynum($result)
if(empty($d['id'])){
$error = "No data found";
}
|
|
#1 |
on April 19 2009 15:04:18 |  |
| |
#2 |
on May 27 2009 23:27:15 |  |
|
|
|
|
Please Login to Post a Comment.
|
|
|
Not a member yet? Click here to register.
Forgotten your password? Request a new one here.
|
|
You must login to post a message.
|
|
Information
you mention that dbrows returns false when the query fails,
however you check the return value like this if (!$d_rows) {....}
You should be using this:
if ($d_rows===false) {..... querie failed ...}
other examples:
if ($d_rows===0) {..... query returned 0 rows (but not false) ...}
if ($d_rows>0) {..... query returned more then one row...}
In your case you would throw that error when when the number of rows from the query would be zero (0) whish is perfeclty fine for some queries.