本文整理汇总了PHP中COMMONFUNC::totalRows方法的典型用法代码示例。如果您正苦于以下问题:PHP COMMONFUNC::totalRows方法的具体用法?PHP COMMONFUNC::totalRows怎么用?PHP COMMONFUNC::totalRows使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类COMMONFUNC
的用法示例。
在下文中一共展示了COMMONFUNC::totalRows方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
$db1->next_record();
if($db1->num_rows()>0){
$fadd = $db1->f('fld_add');
$fedit = $db1->f('fld_edit');
$fdelete = $db1->f('fld_delete');
$fview = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Catagory Deleted Successfully!";
$count = $func->totalRows(TBL_CATAGORY);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
//print_r($_POST['check_delete']);
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
//print_r($fldPageId);
//print_r($k);
$delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
示例2: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Team Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE_COACH);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "College Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE_COACH);
示例3: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldClass like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Class Deleted Successfully!";
$count = $func->totalRows(TBL_CLASS);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
//print_r($_POST['check_delete']);
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Class Deleted Successfully!";
示例4:
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldTitle like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $fldId . "'";
$db1->query($query_Image);
$db1->next_record();
echo $db1->f('fldImage');
@unlink('../banner/' . $db1->f('fldImage'));
$delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $fldId . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Banner Deleted Successfully!";
$count = $func->totalRows(TBL_BANNER);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $_POST['check_delete'][$i] . "'";
$db1->query($query_Image);
$db1->next_record();
echo $db1->f('fldImage');
@unlink('../banner/' . $db1->f('fldImage'));
$delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $_POST['check_delete'][$i] . "'";
示例5:
$db1->next_record();
if($db1->num_rows()>0){
$fadd = $db1->f('fld_add');
$fedit = $db1->f('fld_edit');
$fdelete = $db1->f('fld_delete');
$fview = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Other Deleted Successfully!";
$count = $func->totalRows(TBL_OTHER);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
//print_r($_POST['check_delete']);
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
//print_r($fldPageId);
//print_r($k);
$delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
示例6: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldSportsname like '%{$searchname}%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_SPORTS . " where fldId='" . $fldId . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Sport Deleted Successfully!";
$count = $func->totalRows(TBL_SPORTS);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
foreach ($_REQUEST['check_delete'] as $key => $fldId) {
$delete_query_details = "delete from " . TBL_SPORTS . " where fldId='{$fldId}'";
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Sports Deleted Successfully!";
$count = $func->totalRows(TBL_SPORTS);
示例7: foreach
}
}
}
if ($_POST['search'] == 'Search') {
$fldStartdate = $_POST['fldStartdate'];
$fldEndDate = $_POST['fldEndDate'];
$fldcontent = $_POST['fldcontent'];
}
if ($_REQUEST['mode'] == "delAll") {
foreach ($_REQUEST['check_delete'] as $k => $mail_id) {
$delete_query_details = "delete from " . TBL_MAIL . " where mail_id='{$mail_id}'";
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Message Deleted Successfully!";
$count = $func->totalRows(TBL_MAIL);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "dective") {
$mail_id = $_REQUEST['mail_id'];
$active_query_details = "update " . TBL_MAIL . " set visible = 'DECTIVE' where mail_id='" . $mail_id . "'";
$activemsg = $db->query($active_query_details);
if (isset($activemsg)) {
$_REQUEST['msg'] = "Message De-Active Successfully!";
}
}
示例8:
$db1->next_record();
$db1->num_rows();
if ($db->num_rows() == 0) {
$delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $fldId;
$delmsg = $db1->query($delete_query_details);
} else {
?>
<script type="text/javascript">
alert("You have to delete its Subcategory first");
</script>
<?php
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Category Deleted Successfully!";
$count = $func->totalRows(TBL_ATHLETE_STATS_CATAGORY);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$query_child = " Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where fldParentId =" . $_POST['check_delete'][$i];
$db1->query($query_child);
$db1->next_record();
$db1->num_rows();
if ($db1->num_rows() == 0) {
$delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $_POST['check_delete'][$i];
示例9: header
header("Location:login.php");
}
//for paging
$func = new COMMONFUNC();
$page = new Page();
$db = new DB();
$db2 = new DB();
$flag = 0;
//Local Variables
$IsMyProfile = 0;
if ($_REQUEST['mode'] == "del") {
$delete_query_details = "delete from " . TBL_COLLEGE_NEEDS . " where fldId='" . $_REQUEST['fldId'] . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Need Type successfully deleted.";
$count = $func->totalRows(TBL_NEEDTYPE);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
//Detect if this Athlete is Athlete viewing profile
if ($_REQUEST['collegeid'] != '' and $_SESSION['College_Coach_id'] != '' and $_REQUEST['collegeid'] == $_SESSION['College_Coach_id']) {
$IsMyProfile = 1;
}
#######################################
## SEND NETWORK REQUEST
//Insert, Display Notification, and Email Recipient
$GLOBALPage = "collegeprofile.php?collegeid=";
示例10: OR
$srchCond = "AND ((fldName like '%{$searchname}%') OR (fldSchool = '{$searchteam}'))";
}
} else {
if (!$_REQUEST['searchname'] and $_REQUEST['fldSchool'] != 0) {
$searchteam = $_REQUEST['fldSchool'];
$srchCond = "AND fldSchool = '{$searchteam}'";
$flag++;
}
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='" . $fldId . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!";
$count = $func->totalRows(TBL_HS_AAU_COACH);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
foreach ($_REQUEST['check_delete'] as $key => $fldId) {
$delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='{$fldId}'";
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!";
$count = $func->totalRows(TBL_HS_AAU_COACH);
示例11: addslashes
/*if(!$searchname){
$searchname=$_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if(strlen($searchname)>0)
{ $queryString="searchname=$searchname";
$srchCond= "AND fldEventName like '%".$searchname."%'";
}
*/
if ($_REQUEST['mode'] == "del") {
$id = $_REQUEST['id'];
$delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $id;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Transportation Discount Deleted Successfully!";
$count = $func->totalRows($tbl_transportation_discount);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Transportation Discount Deleted Successfully!";
$count = $func->totalRows($tbl_transportation_discount);
示例12: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldTitle like '%" . $searchname . "%' OR fldDescription like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from tbl_notes where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Note Deleted Successfully!";
$count = $func->totalRows("tbl_notes");
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from tbl_notes where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "Note Deleted Successfully!";
$count = $func->totalRows("tbl_notes");
示例13: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldCollegename like '%{$searchname}%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='" . $fldId . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "College Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE_REGISTER);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
foreach ($_REQUEST['check_delete'] as $k => $fldId) {
$delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='{$fldId}'";
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "College Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE_REGISTER);
示例14: addslashes
$srchCond = '';
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "fldStatus=1 AND fldName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "College Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $_POST['check_delete'][$i];
$delmsg = $db->query($delete_query_details);
}
if (isset($delmsg)) {
$_REQUEST['msg'] = "College Deleted Successfully!";
$count = $func->totalRows(TBL_COLLEGE);
示例15:
$db1->next_record();
if($db1->num_rows()>0){
$fadd = $db1->f('fld_add');
$fedit = $db1->f('fld_edit');
$fdelete = $db1->f('fld_delete');
$fview = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
$delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $fldId . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Athlete Stat Deleted Successfully!";
$count = $func->totalRows(TBL_ATHELETE_STAT);
$offset = $_REQUEST['page'] * 10;
if ($count <= $offset) {
$offset = $offset - $count;
$_REQUEST['page'] = $offset / 10;
}
}
}
if ($_REQUEST['mode'] == "delAll") {
for ($i = 0; $i < count($_POST['check_delete']); $i++) {
$delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $_POST['check_delete'][$i] . "'";
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Athlete Stat Deleted Successfully!";
$count = $func->totalRows(TBL_ATHELETE_STAT);
$offset = $_REQUEST['page'] * 10;