logo   Home Download Documentation Support

 

DashingDB Documentation

Learn to use DashingDB Within Minutes

 

mysql_split_total_pages Function

mysql_split_total_pages - Return number of pages for rows in MySQL Table.

Syntax

string mysql_split_total_pages ( string table_name, array condition, array split)

Description

Parameter

Description

table_name

 

Name of the table where data is needed to be inserted.

Input Example: "table_name"

 

 

 

condition

 

Condition that you want to be:

Input Example: $condition["field_name"]["eq"] = "name";

Which means delete rows whose value of field is equal to string name i.e field_name = "name"

Other functions for conditions where eq can be replaced with:

eq - Equivalent to =

neq - Equivalent to !=

gr - Equivalent to >

sm - Equivalent to <

gre - Equivalent to >=

sme - Equivalent to <=

li - Equivalent to LIKE

nli - Equivalent to NOT LIKE

lip - Equivalent to %LIKE%

libp - Equivalent to %LIKE

liap - Equivalent to LIKE%

nlip - Equivalent to NOT %LIKE%

nlibp - Equivalent to NOT%LIKE

nliap - Equivalent to NOT LIKE%

regex - Equivalent to REGEXP

regex - Equivalent to REGEXP

nregex - Equivalent to NOT REGEXP

in - Equivalent to IN

nin - Equivalent to NOT IN


 

 

split

 

"false" to display all result or enter array in following way:

$split["page"] = 4;
$split["rpg"] = 5;

You cannot change the keys name i.e keys here are page and rpg. However you can change the values, page is the page number or you can say current page, while rpg means results per page or rows per page.

Input Example: $split["page"] = 4; $split["rpg"] = 10;

 


Errors

Error

Description

Error: No table ("table_name") or field ("field_name") exists. Field entered in condition or update_items either does not exist or table_name entered does not exists.

Examples

Example 1

 

<?php

include("class.php");

 

$condition["field_name"]["eq"] = "Some Value";

 

$split["rpg"] = 5;

 

echo mysql_split_total_pages("tablename" ,$condition, $split);

?>

 

Number of total pages would be returned, for example there are total 50 rows, we have made rows per page as 5, so the result would be 10.

 

 

 

© 2017 DashingDB.