function load_project($username, $project_url_name) { $account = account_id_from_username($username); $sql = "SELECT project_head.project, name, spec_link, img_link, created, modified"; $sql .= " FROM project_info"; $sql .= " INNER JOIN project_head"; $sql .= " ON project_head.project = project_info.project"; $sql .= " WHERE project_head.owner={$account}"; $sql .= " AND project_info.url_name='{$project_url_name}'"; $result = query($sql); if ($result == false || mysqli_num_rows($result) <= 0) { echo "project-not-found"; return; } print_r(sql_to_json($result)); }
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY), members.member_id, NULL) AS last_day, IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 WEEK), members.member_id, NULL) AS last_week, IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 MONTH), members.member_id, NULL) AS last_month, IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 QUARTER), members.member_id, NULL) AS last_quarter, IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 YEAR), members.member_id, NULL) AS last_year, members.member_id AS anytime FROM members JOIN vend_log ON members.member_id = vend_log.member_id JOIN ( SELECT vend_log.member_id, MAX(vend_log.enq_datetime) max_enq_datetime FROM vend_log GROUP BY vend_log.member_id ) max_vend_log ON vend_log.member_id = max_vend_log.member_id AND vend_log.enq_datetime = max_vend_log.max_enq_datetime WHERE members.member_status = 5 ) stats; SQL; print sql_to_json(db_pdo_link(), $sql);
function load_blog_body($blog_id) { $sqlBlogInfo = "SELECT * FROM blog_info WHERE blog={$blog_id}"; $result = query($sqlBlogInfo); if (mysqli_num_rows($result) != 1) { echo '{"result": "load-blog-body-error"}'; return; } echo sql_to_json($result); }