Whisper Willow Dot Com - PHP-Fusion Mod Support - Infusions Mods & Themes Plus Coding Help

Tue. November 21, 2017 @
Navigation
Subscriptions
Newsletter

Site Members Only

Member Birthdays

Month of November

11/03 - Webmaster
11/12 - patrekey
11/16 - ASIDONNY
11/20 - NecroPhil
11/27 - Fenix_RULEZ

No Birthdays Today

Event Calendar

Fall Season

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    



More...
Classified Ads


0 Classified Ads


Version 5.00
Personal Pages
New User Pages

Beyond63
osk
wanili
AlainT
r77


Most Visited Pages

Webmaster[4,354]
krzzgierz[3,500]
moto[2,962]
Koma[2,655]
der_kenny[2,506]
Mod Downloads
Latest Files Added

Accordian Navigation 6
Create eCards v3.0 16
Newsletters v5.01 23
Event Calendar v2.01 69
Avatar Studio v2.03 58
Site Statistics Panel v1.0 59
Advanced D/L Manager v2.01 68
Staff Application v1.2 47
Classified Ads v5.0 62
Personal Nickpages v3.1 58


Popular Downloads

My Nav Panel ver2 390
Multimedia Studio v2.02 335
EventCalendarV200 327
Newsletters v4.01 238
User Activity Panel v1.02 223
pd Stats Panel v2.2 210
Send Ecards v2.1 197
Bday Panel v2.03 173
Special Avatars 152
User Info Panel 145



Total Downloads: 5,059
Latest Articles
· PHP-Fusion Multiple ...
· PHP-Fusion ver7.02.04
· 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 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]
Login
Username
Password


Forgotten your password?
Request a new one here.
Donations
User Log
· Guests On: 2
· Members On: 0


Last Seen Members

FreedomIOPList FreedomIO...
Joined
09/06/17
5 weeks Offline
PHPar
Joined
02/05/10
8 weeks Offline
afoster
Joined
01/23/09
9 weeks Offline
scathing scathing
Joined
08/28/09
9 weeks Offline
MarkITA
Joined
02/22/16
13 weeks Offline
evanernanda
Joined
10/06/09
17 weeks Offline
woody1
Joined
01/09/17
19 weeks Offline
lystfisker lystfisker
Joined
05/05/14
19 weeks Offline
aznetcowboy aznetcowboy
Joined
07/22/15
23 weeks Offline
theDark
Joined
01/03/14
27 weeks Offline

  More Users 
Shoutbox
Login to post a message.

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

Dallas
01/10/2016
Hey Terry. How ya been

Rate My Site
Overall Site Rating



37 members have rated.
643 members have not.

You must be logged in
to Rate the Site
Onixet by Fusion-Style.Ro 9,216,904 unique visits