{"action":"created","issue":{"url":"https://api.github.com/repos/LectCap/web_folder/issues/7","labels_url":"https://api.github.com/repos/LectCap/web_folder/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/LectCap/web_folder/issues/7/comments","events_url":"https://api.github.com/repos/LectCap/web_folder/issues/7/events","html_url":"https://github.com/LectCap/web_folder/issues/7","id":121479284,"number":7,"title":"IMPORTANT - Database changes needed for page myCourses.php","user":{"login":"stmi11","id":10886480,"avatar_url":"https://avatars.githubusercontent.com/u/10886480?v=3","gravatar_id":"","url":"https://api.github.com/users/stmi11","html_url":"https://github.com/stmi11","followers_url":"https://api.github.com/users/stmi11/followers","following_url":"https://api.github.com/users/stmi11/following{/other_user}","gists_url":"https://api.github.com/users/stmi11/gists{/gist_id}","starred_url":"https://api.github.com/users/stmi11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stmi11/subscriptions","organizations_url":"https://api.github.com/users/stmi11/orgs","repos_url":"https://api.github.com/users/stmi11/repos","events_url":"https://api.github.com/users/stmi11/events{/privacy}","received_events_url":"https://api.github.com/users/stmi11/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/LectCap/web_folder/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-12-10T13:05:27Z","updated_at":"2015-12-29T10:51:18Z","closed_at":"2015-12-29T10:51:18Z","body":"Due to the way the DataTables jQuery plugin works, I needed to construct a database `VIEW` to easily query for a list of the logged in user's courses. This is how the `VIEW` is created in phpMyAdmin:\r\n```sql\r\nCREATE VIEW view_mycourses \r\nAS SELECT u.id \"user_id\", c.id \"id\", c.name \"name\", c.code \"code\", c.description \"description\", b.status \"status\", b.teacher \"teacher\"\r\nFROM users u, user_course b, courses c \r\nWHERE (b.user_id = u.id AND b.course_id = c.id)\r\n```\r\n\r\nThe code is entered in the `SQL` tab in phpMyAdmin where you can freely write SQL code."},"comment":{"url":"https://api.github.com/repos/LectCap/web_folder/issues/comments/167764250","html_url":"https://github.com/LectCap/web_folder/issues/7#issuecomment-167764250","issue_url":"https://api.github.com/repos/LectCap/web_folder/issues/7","id":167764250,"user":{"login":"stmi11","id":10886480,"avatar_url":"https://avatars.githubusercontent.com/u/10886480?v=3","gravatar_id":"","url":"https://api.github.com/users/stmi11","html_url":"https://github.com/stmi11","followers_url":"https://api.github.com/users/stmi11/followers","following_url":"https://api.github.com/users/stmi11/following{/other_user}","gists_url":"https://api.github.com/users/stmi11/gists{/gist_id}","starred_url":"https://api.github.com/users/stmi11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stmi11/subscriptions","organizations_url":"https://api.github.com/users/stmi11/orgs","repos_url":"https://api.github.com/users/stmi11/repos","events_url":"https://api.github.com/users/stmi11/events{/privacy}","received_events_url":"https://api.github.com/users/stmi11/received_events","type":"User","site_admin":false},"created_at":"2015-12-29T10:51:18Z","updated_at":"2015-12-29T10:51:18Z","body":"Obsolete, closing."}}