public function getProjects() { $user_id = $_POST['userId']; $dbh = new PDO("mysql:host=" . $GLOBALS['db_host'] . ";dbname=" . $GLOBALS['db_db'], $GLOBALS['db_user'], $GLOBALS['db_pass']); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $dbh->prepare("select * from projects where userId = :userId"); $stmt->execute(array('userId' => $user_id)); if ($stmt->rowCount()) { $pagesArray = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $pagesArray[] = array("projectName" => $row["ProjectName"], "projectId" => $row["ProjectID"]); } echo json_success_data("Successfully retrieved your projects", $pagesArray); } else { echo json_error_msg("You dont have any projects"); } }
public function getPages() { $project_id = $_POST['projectId']; $dbh = new PDO("mysql:host=" . $GLOBALS['db_host'] . ";dbname=" . $GLOBALS['db_db'], $GLOBALS['db_user'], $GLOBALS['db_pass']); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $dbh->prepare("select * from pages where ProjectID = :projectId"); $stmt->execute(array('projectId' => $project_id)); if ($stmt->rowCount()) { $pagesArray = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { // $page_name = $row["pageName"]; // $page_id = $row["pageId"]; // $tmpArr = array('pageName' => $page_name, 'pageId' => $page_id); // $pagesArray[] = $row; $pagesArray[] = array("pageName" => $row["PageName"], "projectId" => $row["ProjectID"], "pageId" => $row["PageID"], "pageContent" => $row["PageContent"], "pageJS" => $row["PageJS"]); } echo json_success_data("successfully retrieved pages for this project", $pagesArray); } else { echo json_error_msg("failed to retrieve pages for this project"); } }
public function login() { $host = $GLOBALS['db_host']; $db = $GLOBALS['db_db']; $user = $GLOBALS['db_user']; $pass = $GLOBALS['db_pass']; // Username and Password $username = $_POST['username']; $password = sha1($_POST['password']); $dbh = new PDO("mysql:host={$host};dbname={$db}", $user, $pass); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $dbh->prepare("select * from users where Username = :username"); $stmt->execute(array('username' => $username)); // old way if ($stmt->rowCount()) { while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { if ($row['UserPass'] == $password) { $result[] = array("userEmail" => $row['UserEmail'], "adminStatus" => $row['UserAdminStatus'], "username" => $row["Username"], "userId" => $row["UserID"]); $this->set_login_session($row["UserID"], $row["Username"], $row['UserAdminStatus']); echo json_success_data("Welcome " . $username . "! You are logged in!", $result); } else { echo json_error_msg("Incorrect Password! Please Try Again!"); } } } else { echo json_error_msg("please register!"); } }