function getColumnsFromTable($table_name, $columns_name_array, $size = 1, $echo = false) { $comma_separated = implode(",", $columns_name_array); $select_name = $table_name . 'Data'; $query = "SELECT {$comma_separated} FROM `{$table_name}` WHERE " . __users_tl_expired . " IS NULL"; $selectDropdown = "<select name=\"{$select_name}\" size=\"{$size}\">"; $row_comma_separated = implode(", ", $columns_name_array); //echo $query; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $selectDropdown .= '<option>'; $optionValue = ''; foreach ($columns_name_array as $value) { $formattedValue = niceValue($value) . ': ' . $row[$value] . ', '; //$selectDropdown .= str_replace(" ", " ", substr(str_pad($formattedValue, 50, " "), 0, 40)).'.';//str_pad((niceValue($value).': '.$row[$value].', '),35,"."); $optionValue .= substr(str_pad($formattedValue, 80 - strlen($optionValue), "_"), 0, 35); //str_pad((niceValue($value).': '.$row[$value].', '),35,"."); } $trimmedVal = trim($optionValue, " \\_\\,\t\n"); $selectDropdown .= $trimmedVal; $selectDropdown .= '</option>'; } $selectDropdown .= "</select>"; if ($echo) { echo $selectDropdown; } return $selectDropdown; }
/** * Remove user by marking it as expired. */ public function RemoveUser() { if ($_SERVER["REQUEST_METHOD"] == "POST") { $option_selected = test_input($_POST["usersData"]); echo '/' . niceValue(__users_tl_user_name) . ':.*/<br>'; preg_match('/' . niceValue(__users_tl_user_name) . ':.*/', $option_selected, $matches); echo $matches[0]; $userName = trim(substr($matches[0], 10), ','); echo '<br><br> user name: ' . $userName . '<br>'; $date = date("Y-m-d"); $removeQuery = 'UPDATE users SET `' . __users_tl_user_name . " = 'EXP_" . $userName . "', " . __users_tl_expired . "` = '" . $date . "' WHERE `" . __users_tl_user_name . "` = '" . trim($userName, ' ') . "'"; //UPDATE `users` SET `user_name` = 'EXP_ca', `expired` = '2015-12-04' WHERE `users`.`user_name` = 'ca' //', '.__users_tl_user_name.'='.$expUserName. echo '<br><br>' . $removeQuery . '<br>'; $removeQuery_res = mysql_query($removeQuery) or die(mysql_error()); //_______$removeQuery_res = mysql_query($removeQuery"UPDATE users SET `expired` = 2015/12/04 WHERE `user_name` = ' nce093'") or die(mysql_error()); if ($removeQuery_res == FALSE) { echo '<br><h3>FALSE </h3><br>'; } else { if (mysql_errno()) { echo "MySQL error " . mysql_errno() . ": " . mysql_error() . "\n<br>When executing <br>\n{$removeQuery}\n<br>"; } else { // if insert succeeded echo "<script type=\"text/javascript\"> alert(\"User {$userName} was removed successfully!\"); </script>"; } } } }