?> </a></p> <p><?php echo vereinsbeschreibung; ?> </p> </div> <?php if (isset($_SESSION['userid'])) { ?> <h2>Helferinnen und Helfer</h2> <table> <?php getHelper($dbmysql, $_SESSION['fullEvent']); ?> </table> <h2>Hallo <?php echo $_SESSION['username']; ?> , hier kannst du dich noch eintragen: </h2> <div id="todoForm"> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <table id="openToDos"> <thead> <tr>
function selectHelper($parameters) { global $db; // check the parameters and add to where clause $where = ''; // find helper by string if (!empty($parameters['searchAll'])) { // there are two possibilities: find string in keyword, file_ending or in context-info // check in DB for entries matching $query = "\n SELECT\n `id`\n FROM\n `" . $GLOBALS['dataBaseToUse'] . "`.`tl_helper`\n WHERE\n (`firstname` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `lastname` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `street` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `city` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `postal` like '%" . addslashes($parameters['searchAll']) . "%')\n "; $result = $db->query($query); $helperIdArray = array(0); while ($row = mysqli_fetch_assoc($result)) { $helperIdArray[] = $row['id']; } $where .= "\n `tl_helper`.`id` in (" . implode(', ', $helperIdArray) . ")"; } // paging contains results per block as blocksize and number of block used for the query if (!empty($parameters['paging'])) { // blocksize from setting or standard if (!empty($parameters['paging']['blocksize'])) { $blocksize = 0 + $parameters['paging']['blocksize']; } else { $blocksize = 20; } if (!empty($parameters['paging']['block'])) { $block = 0 + $parameters['paging']['block']; } else { $block = 1; } $parameters['limit'] = " LIMIT " . ($block - 1) * $blocksize . ", " . $blocksize . " "; } if (!empty($parameters['order'])) { $where .= addslashes($parameters['order']); } if (!empty($parameters['limit'])) { $where .= addslashes($parameters['limit']); } // select Helper // get ids for helper entries $query = "\n\t\t SELECT\n SQL_CALC_FOUND_ROWS\n `tl_helper`.`id`\n FROM\n\t\t `" . $GLOBALS['dataBaseToUse'] . "`.`tl_helper`\n\n\t\t WHERE\n\n " . $where . "\n\t "; $result = $db->query($query); $return = array(); // reports $return['parameters'] = $parameters; $return['numResults'] = ''; while ($row = mysqli_fetch_assoc($result)) { $return['data'][$row['id']] = array(); } // number of possible results $countResult = $db->query("SELECT FOUND_ROWS()"); $countArray = $row = mysqli_fetch_assoc($countResult); $return['numResults'] = $countArray['FOUND_ROWS()']; // now get the values if (!empty($return['data'])) { $helperData = getHelper(array_keys($return['data'])); #print_r($helperData); foreach ($helperData as $idHelper => $row) { $return['data'][$idHelper] = $row; } } return $return; }