Sun May 20, 2018 @ 10,685,959 unique visits

Event Calendar

Summer

  May 2018  

Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    
Legend

Normal Day:
Event Day:
Today:

More...
05/22/2018 National Maritime Day
05/22/2018 Tante's birthday
05/25/2018 Missing Childrens Day
05/28/2018 Memorial Day
05/31/2018 Koma's birthday
06/01/2018 zodan's birthday
blank.gif blank.gif
Subscriptions
Newsletter

Site Members Only

blank.gif blank.gif
Site User Pages

New Site User Pages

Gargon
Webmaster


Most Visited Pages

Gargon[148]
Webmaster[88]
blank.gif blank.gif
Classified Ads
bullet.gifCommodore 128 For Sa...
Somewhere, USA


1 Classified Ad


Version 5.00
blank.gif blank.gif
Latest Articles
bullet.gif PHP-Fusion Multiple ...
bullet.gif PHP-Fusion ver7.02.07
bullet.gif MySQL/DB Functions
blank.gif blank.gif
Articles Hierarchy
Articles Home » (D) PHP-Fusion CMS Tutorials » MySQL/DB Functions
purple-btm-left.png purple-btm-right.png
MySQL/DB Functions
Before beginning, I will hereby assume that you (the reader) understand/know/learn MySQL to a certain level. Even if you know nothing about MySQL, this may help you get started.

And now, on to the nitty-gritty:

MySQL database function code snippets

[1]
     function dbquery($query) {
}

[2]
     function dbarray($query) {
}

[3]
     function dbarraynum($query) {
}

[4]
     function dbrows($query) {
}

[5]
     function dbresult($query, $row) {
}

[6]
     function dbcount($field, $table, $conditions = "") {
}

These are the 'function' declarations in maincore.php. No, you don't have to open maincore.php, these are just samples to look at. They should provide you with some idea of how the functions work. If you don't understand the functions at first glance, don't worry. We'll explain each one in detail.
FUNCTIONS with EXAMPLES

1. dbquery($query)
This function executes a query on a MySQL database and returns a value. If the query 'fails' it will produce an error message and return 'false'.
dbquery() - is followed up by other functions listed above. There is only one parameter for this function: the 'SQL query'. Like mysql_query(), dbquery() is also used for UPDATE, DELETE, INSERT, and CREATE, but you won't be using CREATE.
2. dbarray($query)
A clone of the mysql_fetch_assoc() function that returns a row from a record-set as an associative array. If the query 'fails' it will produce an error message and return 'false'.

dbarray() requires the return value from dbquery(), because the return value specifies which result handle to use.
EXAMPLE

$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";
}

3. dbarraynum($query)
A clone of the mysql_fetch_row() function that returns a row from a record-set as a numeric array. If the query 'fails' it will produce an 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.
EXAMPLE

$query = "SELECT * FROM ".DB_DATA." WHERE data_id = '{$_GET['p']}'";
$result = dbquery($query);
$d = dbarraynum($result)
if(empty($d['id'])){
$error = "No data found";
}

4. dbrows($query)
A clone of the mysql_num_rows() function that returns the number of rows in a record-set. If the query 'fails' it will produce an error message and return 'false'.

dbrows() requires the return value from dbquery(), because the return value specifies which result handle to use.
EXAMPLE

$query = "SELECT * FROM ".DB_DATA.";
$result = dbquery($query);
$d_rows = dbrows($result);
if (!$d_rows){
$d['error'] = "Cannot count rows in data table";
}

5. dbresult($query, $row)
A clone of the mysql_result() function that returns the value of a field in a record-set. If the query 'fails' it will produce an error message and return 'false'.

dbresult() requires the return value from dbquery(). Because the return value specifies which result handle to use.
EXAMPLE

$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";
}

And Now For DB Count

6. dbcount($field, $table, $conditions = "")
This function executes a COUNT query on a MySQL database and returns a value. COUNT query means it counts the total value of records found. If the query 'fails' it will produce an error message and return 'false'.
dbcount() does not require a result from dbquery()
dbcount() is usually used for paginations
dbcount() has 3 parameters, two of which are required:

  • Parameter 1: ==> $field (required)
       { signifies which field in the table to be counted }


  • Parameter 2: ==> $table (required)
       { signifies which table is to be counted }


  • Parameter 3: ==> $conditions = "" (optional)
       { signifies the conditions that the field needs to meet }


Condition example in MySQL:
" WHERE field_name = 'some_value' AND field_name2 = 'other_value' "
EXAMPLE

this example returns the values of increments of 10
starting from zero. e.g, 0, 10, 20, 30 .. etc. etc.
$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";
}

And that's all for now folks...
Used with permission by:
elyn @ phpfusion-mods.net
purple-btm-left.png purple-btm-right.png
Ratings
Rating is available to Members only.

Please login to vote.

Awesome! Awesome! 100% [1 Vote]
Very Good Very Good 0% [No Votes]
Good Good 0% [No Votes]
Average Average 0% [No Votes]
Poor Poor 0% [No Votes]
purple-btm-left.png purple-btm-right.png
Login

Please Login Above
blank.gif blank.gif
User Log
bullet.gif Guests On: 19
bullet.gif Members On: 0


Last Seen Members

Webmaster Webmaster
Joined
08/14/08
Offline Offline
aznetcowboy aznetcowboy
Joined
07/22/15
1 week Offline
afoster afoster
Joined
01/23/09
4 weeks Offline
jarcastle jarcastle
Joined
03/20/18
4 weeks Offline
Gargon Gargon
Joined
02/19/09
5 weeks Offline
FreedomIOPList FreedomIO...
Joined
09/06/17
10 weeks Offline
scathing scathing
Joined
08/28/09
11 weeks Offline
Lord_Jereth Lord_Jereth
Joined
03/16/11
11 weeks Offline

  More Users 
blank.gif blank.gif
Shoutbox
You must login to post a message.

 afoster
03/08/2018
Like the new look of the website. I have always liked this particular theme.


 FreedomIOPList
10/07/2017
I love this site and all of the unique, original infusions and mods offered here. Excellent work, please keep it up!


 Webmaster
04/23/2016
Hi Pat! Long time no see. I'm doing well and I hope you and your family are well also. :)


 29sd102
04/23/2016
Hi Terry, I hope you are well mate, Cheers from Ireland, Pat :)


 WildHaggis
03/29/2016
Site's looking great :)


 Dallas
01/12/2016
Thanks Terry. Getting back into coding a little. Missed you all.


 Webmaster
01/10/2016
Hey Dallas! Man we thought you left the Fusion scene for good. I am really happy to welcome you back to the fold. :D


blank.gif blank.gif
center-left.png center-right.png
centerb-left.png centerb-right.png