Sat Sep 22, 2018 @ 11,835,889 unique visits

center-left.png center-right.png
Member Birthdays

Our World
Today: September 22, 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

Birthdays in September

09/03 - Tamaris
09/08 - Shadow_asp
09/08 - Bertomi
09/10 - helmuth
09/17 - kenloen
09/19 - HotChatLive
09/19 - ParadiseGamez
09/19 - afoster
09/19 - InsatiableKisses
09/19 - FreedomIOPList
09/29 - Luecke
09/29 - CrasHandBurN
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

gjsttt
outlaw
FreedomIOPList
Gargon
Webmaster


Most Visited Pages

Gargon[528]
Webmaster[377]
outlaw[182]
FreedomIOPList[164]
gjsttt[121]
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: 13
bullet.gif Members On: 0


Last Seen Members

Beyond63 Beyond63
Joined 01/29/10
1 day Offline
Webmaster Webmaster
Joined 08/14/08
1 day Offline
kenloen
Joined 05/12/12
1 day Offline
afoster afoster
Joined 01/23/09
2 days Offline
Harlekin Harlekin
Joined 01/21/13
5 days Offline
helmuth
Joined 09/30/09
1 week Offline
aznetcowboy aznetcowboy
Joined 07/22/15
3 weeks Offline
Gargon Gargon
Joined 02/19/09
5 weeks Offline

  More Users 
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