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!");
}
}
