function __construct() { //echo "some thing "; $poll_id = app_controller::$strcln->esc($_POST['poll_id']); $pollDataGetter = new database_selectpolldata(); $poll = $pollDataGetter->selectPollData($poll_id); if (!$poll) { return; } $options = unserialize($poll['custom']); $count = 0; $newOptions = array(); foreach ($options as $option) { $cleanOptions = app_controller::$strcln->esc($_POST['option' . $count]); if ($cleanOptions != "") { array_push($newOptions, $cleanOptions); } $count++; } if (isset($_POST['option' . $count])) { $cleanOptions = app_controller::$strcln->esc($_POST['option' . $count]); if ($cleanOptions != "") { array_push($newOptions, $cleanOptions); } } $sNewOptions = serialize($newOptions); //exit(print_r($newOptions)); $doQuery = new database_doquery(); $sql = "UPDATE tables SET custom='{$sNewOptions}' WHERE url='{$poll_id}'"; $doQuery->tryQuery($sql); $users = unserialize($poll['poll']); $colCount = count($options); $rowCount = 0; foreach ($users as $user) { $rowCount++; $userCount = 0; $inPoll = false; foreach ($users as $user) { $userCount++; if (isset($_POST['user_' . $userCount])) { $delUserValue = app_controller::$strcln->esc($_POST['user_' . $userCount]); if ($delUserValue === $user['email']) { $inPoll = true; break; } } } if ($inPoll === true) { unset($users[$user['email']]); continue; } $newArray = array(); for ($i = 1; $i <= $colCount; $i++) { if (isset($_POST['usr_' . $rowCount . '_' . $i])) { array_push($newArray, $_POST['usr_' . $rowCount . '_' . $i]); } } $users[$user['email']][0] = $newArray; //array_replace($user[0], $newArray); } $sChoices = serialize($users); $sql = "UPDATE tables SET poll='{$sChoices}' WHERE url='{$poll_id}'"; $doQuery->tryQuery($sql); /* $options = unserialize($poll['custom']); $optionsCount = count($options); $count = 0; $data = Array(); foreach ($options as $option) { $count++; for ($i = 0; $i < $optionsCount; $i++) { $item = $_POST['usr_'.$count.'_'.$i]; array_push($data, $item); } } exit(print_r($data)); */ }
public function __construct($poll_url) { $query = "DELETE FROM tables WHERE url='{$poll_url}'"; $querymaker = new database_doquery(); $querymaker->tryQuery($query); }