WhisperWillow PHP-Fusion Mod Support
Username:
Password:
Remember Me   
Forgot your password?
Request a new one here.
Wed. July 18, 2018 @
Event Calendar

Summer

  July 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:

No events.
Subscriptions
Newsletter

Site Members Only

Classified Ads
 DEMO - New Ad Type
Delta Quadrant
 Code Development
Some City, Some State
 Just A Demo Ad
Ames. Iowa
 Commodore-128 System
Ft Worth, Texas


4 Classified Ads


Version 5.02
Site User Pages

New Site User Pages

gjsttt
outlaw
FreedomIOPList
Gargon
Webmaster


Most Visited Pages

Gargon[326]
Webmaster[273]
FreedomIOPList[59]
outlaw[19]
gjsttt[11]
Latest Articles
· PHP-Fusion Multiple ...
· PHP-Fusion ver7.02.07
· MySQL/DB Functions
Articles Hierarchy
Articles Home » (D) PHP-Fusion CMS Tutorials » MySQL/DB Functions
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
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]
Login

Please Login Above
User Log
· Guests On: 16
· Members On: 0


Last Seen Members

outlaw outlaw
Joined
07/10/18
Offline Offline
Webmaster Webmaster
Joined
08/14/08
Offline Offline
Harlekin Harlekin
Joined
01/21/13
1 day Offline
gjsttt
Joined
07/15/18
2 days Offline
jarcastle jarcastle
Joined
03/20/18
2 weeks Offline
Sc077 Sc077
Joined
07/17/16
2 weeks Offline
Gargon Gargon
Joined
02/19/09
3 weeks Offline
abele
Joined
02/20/11
4 weeks Offline

  More Users 
Shoutbox
You must login to post a message.

 outlaw
07/12/2018
i got it thanks Webmaster


 Webmaster
07/12/2018
See the PM I sent you.


 outlaw
07/11/2018
where is this Multimedia Studio v2.02 i am reading about?


 outlaw
07/10/2018
its pouring down rain here in lakeland


 outlaw
07/10/2018
Hey people,


 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!


Metalic by GFXpixel :: Mods by Grimloch11,309,753 unique visits