Dec 14, 2018 @ 12,137,353 unique visits

center-left.png center-right.png
Event Calendar

 Winter Season 
 « December 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

Birthdays
12-01 - douwe_yntema
12-12 - Mutsche
12-19 - ezenya20072
12-20 - mpbubu
12-21 - KennsteNich
12-22 - pvrwizard
12-26 - Privablie
12-27 - Dallas

Events
 12-24Christmas Eve
 12-25Christmas Day
blank.gif blank.gif
Subscriptions
Newsletter

Site Members Only

blank.gif blank.gif
Classified Ads


0 Classified Ads


Version 5.02
blank.gif blank.gif
Site User Pages

New Site User Pages

21Matze
gjsttt
outlaw
FreedomIOPList
Gargon


Most Visited Pages

Gargon[743]
Webmaster[551]
outlaw[348]
FreedomIOPList[315]
gjsttt[255]
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 or register 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
Users Online
bullet.gif Guests Online: 1
bullet.gif Total Members: 686

bullet.gif Unactivated Members: 0
bullet.gif Newest Member: GnarlyWebsites
Last Seen Admin:
bullet.gif Webmaster 2 days
Last Seen Users:
bullet.gif douwe_yntema 1 week
bullet.gif afoster 2 weeks
bullet.gif wizard01210 4 weeks
bullet.gif Harlekin 5 weeks
bullet.gif 21Matze 7 weeks
bullet.gif Gargon 7 weeks
bullet.gif aznetcowboy 7 weeks
bullet.gif Beyond6311 weeks
bullet.gif kenloen12 weeks
bullet.gif helmuth13 weeks
bullet.gif Ingolstadt18 weeks
bullet.gif outlaw18 weeks
bullet.gif gjsttt21 weeks
bullet.gif jarcastle23 weeks
bullet.gif Sc07723 weeks
blank.gif blank.gif
Shoutbox
You must login to post a message.

 Gargon
Since 02/19/2009
On August 02, 2018 00:34
OK... new shoutbox stuff huh? Kool !!

 Webmaster
Since 08/14/2008
On August 01, 2018 11:44
Hey hey I think I have it Fred !!!

 Webmaster
Since 08/14/2008
On August 01, 2018 11:29
Sure will Fred !!

 afoster
Since 01/23/2009
On August 01, 2018 11:15
OK, I see what you are talking about and yes...the online/offline icons are not needed. Can you send me the "finished" product when you are done?

 afoster
Since 01/23/2009
On August 01, 2018 10:51
Let me know what oddities you are talking about. If there are any code issues, I am sure you fill find and fix them.

 Webmaster
Since 08/14/2008
On August 01, 2018 10:13
Yeah thanks Fred! Still tinkering with it to clear up some oddities that it has though. !crazy!

 afoster
Since 01/23/2009
On August 01, 2018 10:01
I see you have installed the new shoutbox. Glad you got it working the way you wanted it to.

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