function setstatus($data, $id = "") { $dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS); $ids = explode(',', $_POST['id']); for ($i = 0; $i < count($ids); $i++) { $result = $dbase->_query("SELECT * FROM " . TBLPREFIX . "subscribers where id=\"{$ids[$i]}\""); $recrow = mysql_fetch_row($result); $stat = $recrow[15]; unset($recrow); if ($stat == 1) { $stat = 0; } else { $stat = 1; } $in = "update " . TBLPREFIX . "subscribers set status = {$stat}\n where id=\"{$ids[$i]}\""; $result = $dbase->_query($in); } if ($result) { } else { } unset($dbase); }
function getProfileDetails() { $detailsJSON = array(); $JSONData = json_decode(file_get_contents('php://input')); $breakerID = $JSONData->breaker_id; $dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS); $query = "SELECT B.id,B.socialid,B.mobile,B.country,B.name,B.username,B.email,B.profileimage,B.latitude,\n B.longitude,B.dateregistered,B.dateofbirth,B.about,B.gender,B.city,B.lang,\n (SELECT name_en FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_en,\n (SELECT name_ar FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_ar \n FROM breakers as B WHERE B.id={$breakerID}"; $result = $dbase->_query($query); while ($row = mysql_fetch_array($result)) { $details = array("id" => $row['id'], "socialid" => $row['socialid'], "mobile" => $row['mobile'], "country" => $row['country'], "name" => $row['name'], "username" => $row['username'], "email" => $row['email'], "breaker_image" => UPLOAD_SERVER . "/resources/images/profile/" . $row['profileimage'], "latitude" => $row['latitude'], "longitude" => $row['longitude'], "latitude" => $row['latitude'], "dateregistered" => $row['dateregistered'], "dateofbirth" => $row['dateofbirth'], "about" => $row['about'], "gender" => $row['gender'], "city" => $row['city'], "lang" => $row['lang'], "break_category_en" => $row['break_category_en'], "break_category_ar" => $row['break_category_ar']); $detailsJSON[] = $details; } giveResponseToApp($detailsJSON); }