{"action":"created","comment":{"url":"https://api.github.com/repos/felixgate13/portfolio/pulls/comments/222261959","pull_request_review_id":161095085,"id":222261959,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIyMjI2MTk1OQ==","diff_hunk":"@@ -0,0 +1,50 @@\n+<?php\n+\n+\n+require 'dbConn.php';\n+\n+\n+//setting the data into the  about me page\n+function set_about_me($content, $picture_link, $db, $email, $phone_number)\n+{\n+        $query = $db->prepare('UPDATE `about_me` SET content=?, picture_link=?, phone_number=?, email=? WHERE `id` = 1;');\n+        $query->bindParam(1, $content);\n+        $query->bindParam(2, $picture_link);\n+        $query->bindParam(3, $phone_number);\n+        $query->bindParam(4, $email);\n+        $query->execute();\n+        $row_count = $query->rowCount();\n+        print(\"Replaced $row_count row(s). \\n\");\n+}\n+\n+\n+\n+$content = $_POST[content];\n+$phone_number = $_POST[phone_number];\n+$email = $_POST[email];\n+$picture_link = $_POST[picture_link];\n+\n+\n+set_about_me($content, $picture_link, $db, $email, $phone_number);\n+?>\n+<!DOCTYPE html>\n+<html>\n+\n+<head>\n+\n+    <title> About Page </title>\n+\n+</head>\n+\n+\n+<body>\n+<a href=\"dashboard.php\">","path":"db_querys.php","position":41,"original_position":41,"commit_id":"167a3db9e5ec5f91ebc7a408e9a87338500e246c","original_commit_id":"167a3db9e5ec5f91ebc7a408e9a87338500e246c","user":{"login":"imogenhallett","id":33464193,"node_id":"MDQ6VXNlcjMzNDY0MTkz","avatar_url":"https://avatars3.githubusercontent.com/u/33464193?v=4","gravatar_id":"","url":"https://api.github.com/users/imogenhallett","html_url":"https://github.com/imogenhallett","followers_url":"https://api.github.com/users/imogenhallett/followers","following_url":"https://api.github.com/users/imogenhallett/following{/other_user}","gists_url":"https://api.github.com/users/imogenhallett/gists{/gist_id}","starred_url":"https://api.github.com/users/imogenhallett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/imogenhallett/subscriptions","organizations_url":"https://api.github.com/users/imogenhallett/orgs","repos_url":"https://api.github.com/users/imogenhallett/repos","events_url":"https://api.github.com/users/imogenhallett/events{/privacy}","received_events_url":"https://api.github.com/users/imogenhallett/received_events","type":"User","site_admin":false},"body":"Put lines 41 - 43 on one line","created_at":"2018-10-03T10:39:14Z","updated_at":"2018-10-03T10:59:32Z","html_url":"https://github.com/felixgate13/portfolio/pull/3#discussion_r222261959","pull_request_url":"https://api.github.com/repos/felixgate13/portfolio/pulls/3","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/comments/222261959"},"html":{"href":"https://github.com/felixgate13/portfolio/pull/3#discussion_r222261959"},"pull_request":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/3"}}},"pull_request":{"url":"https://api.github.com/repos/felixgate13/portfolio/pulls/3","id":219978244,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE5OTc4MjQ0","html_url":"https://github.com/felixgate13/portfolio/pull/3","diff_url":"https://github.com/felixgate13/portfolio/pull/3.diff","patch_url":"https://github.com/felixgate13/portfolio/pull/3.patch","issue_url":"https://api.github.com/repos/felixgate13/portfolio/issues/3","number":3,"state":"open","locked":false,"title":"Cms","user":{"login":"felixgate13","id":42411328,"node_id":"MDQ6VXNlcjQyNDExMzI4","avatar_url":"https://avatars2.githubusercontent.com/u/42411328?v=4","gravatar_id":"","url":"https://api.github.com/users/felixgate13","html_url":"https://github.com/felixgate13","followers_url":"https://api.github.com/users/felixgate13/followers","following_url":"https://api.github.com/users/felixgate13/following{/other_user}","gists_url":"https://api.github.com/users/felixgate13/gists{/gist_id}","starred_url":"https://api.github.com/users/felixgate13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/felixgate13/subscriptions","organizations_url":"https://api.github.com/users/felixgate13/orgs","repos_url":"https://api.github.com/users/felixgate13/repos","events_url":"https://api.github.com/users/felixgate13/events{/privacy}","received_events_url":"https://api.github.com/users/felixgate13/received_events","type":"User","site_admin":false},"body":"all php to be reviewed thanks 🥇 ","created_at":"2018-10-03T09:57:49Z","updated_at":"2018-10-03T10:59:32Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1fb06dd99e0fcea7747f7a0f9eabc6fefd04146a","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/felixgate13/portfolio/pulls/3/commits","review_comments_url":"https://api.github.com/repos/felixgate13/portfolio/pulls/3/comments","review_comment_url":"https://api.github.com/repos/felixgate13/portfolio/pulls/comments{/number}","comments_url":"https://api.github.com/repos/felixgate13/portfolio/issues/3/comments","statuses_url":"https://api.github.com/repos/felixgate13/portfolio/statuses/167a3db9e5ec5f91ebc7a408e9a87338500e246c","head":{"label":"felixgate13:CMS","ref":"CMS","sha":"167a3db9e5ec5f91ebc7a408e9a87338500e246c","user":{"login":"felixgate13","id":42411328,"node_id":"MDQ6VXNlcjQyNDExMzI4","avatar_url":"https://avatars2.githubusercontent.com/u/42411328?v=4","gravatar_id":"","url":"https://api.github.com/users/felixgate13","html_url":"https://github.com/felixgate13","followers_url":"https://api.github.com/users/felixgate13/followers","following_url":"https://api.github.com/users/felixgate13/following{/other_user}","gists_url":"https://api.github.com/users/felixgate13/gists{/gist_id}","starred_url":"https://api.github.com/users/felixgate13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/felixgate13/subscriptions","organizations_url":"https://api.github.com/users/felixgate13/orgs","repos_url":"https://api.github.com/users/felixgate13/repos","events_url":"https://api.github.com/users/felixgate13/events{/privacy}","received_events_url":"https://api.github.com/users/felixgate13/received_events","type":"User","site_admin":false},"repo":{"id":148138715,"node_id":"MDEwOlJlcG9zaXRvcnkxNDgxMzg3MTU=","name":"portfolio","full_name":"felixgate13/portfolio","private":false,"owner":{"login":"felixgate13","id":42411328,"node_id":"MDQ6VXNlcjQyNDExMzI4","avatar_url":"https://avatars2.githubusercontent.com/u/42411328?v=4","gravatar_id":"","url":"https://api.github.com/users/felixgate13","html_url":"https://github.com/felixgate13","followers_url":"https://api.github.com/users/felixgate13/followers","following_url":"https://api.github.com/users/felixgate13/following{/other_user}","gists_url":"https://api.github.com/users/felixgate13/gists{/gist_id}","starred_url":"https://api.github.com/users/felixgate13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/felixgate13/subscriptions","organizations_url":"https://api.github.com/users/felixgate13/orgs","repos_url":"https://api.github.com/users/felixgate13/repos","events_url":"https://api.github.com/users/felixgate13/events{/privacy}","received_events_url":"https://api.github.com/users/felixgate13/received_events","type":"User","site_admin":false},"html_url":"https://github.com/felixgate13/portfolio","description":null,"fork":false,"url":"https://api.github.com/repos/felixgate13/portfolio","forks_url":"https://api.github.com/repos/felixgate13/portfolio/forks","keys_url":"https://api.github.com/repos/felixgate13/portfolio/keys{/key_id}","collaborators_url":"https://api.github.com/repos/felixgate13/portfolio/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/felixgate13/portfolio/teams","hooks_url":"https://api.github.com/repos/felixgate13/portfolio/hooks","issue_events_url":"https://api.github.com/repos/felixgate13/portfolio/issues/events{/number}","events_url":"https://api.github.com/repos/felixgate13/portfolio/events","assignees_url":"https://api.github.com/repos/felixgate13/portfolio/assignees{/user}","branches_url":"https://api.github.com/repos/felixgate13/portfolio/branches{/branch}","tags_url":"https://api.github.com/repos/felixgate13/portfolio/tags","blobs_url":"https://api.github.com/repos/felixgate13/portfolio/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/felixgate13/portfolio/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/felixgate13/portfolio/git/refs{/sha}","trees_url":"https://api.github.com/repos/felixgate13/portfolio/git/trees{/sha}","statuses_url":"https://api.github.com/repos/felixgate13/portfolio/statuses/{sha}","languages_url":"https://api.github.com/repos/felixgate13/portfolio/languages","stargazers_url":"https://api.github.com/repos/felixgate13/portfolio/stargazers","contributors_url":"https://api.github.com/repos/felixgate13/portfolio/contributors","subscribers_url":"https://api.github.com/repos/felixgate13/portfolio/subscribers","subscription_url":"https://api.github.com/repos/felixgate13/portfolio/subscription","commits_url":"https://api.github.com/repos/felixgate13/portfolio/commits{/sha}","git_commits_url":"https://api.github.com/repos/felixgate13/portfolio/git/commits{/sha}","comments_url":"https://api.github.com/repos/felixgate13/portfolio/comments{/number}","issue_comment_url":"https://api.github.com/repos/felixgate13/portfolio/issues/comments{/number}","contents_url":"https://api.github.com/repos/felixgate13/portfolio/contents/{+path}","compare_url":"https://api.github.com/repos/felixgate13/portfolio/compare/{base}...{head}","merges_url":"https://api.github.com/repos/felixgate13/portfolio/merges","archive_url":"https://api.github.com/repos/felixgate13/portfolio/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/felixgate13/portfolio/downloads","issues_url":"https://api.github.com/repos/felixgate13/portfolio/issues{/number}","pulls_url":"https://api.github.com/repos/felixgate13/portfolio/pulls{/number}","milestones_url":"https://api.github.com/repos/felixgate13/portfolio/milestones{/number}","notifications_url":"https://api.github.com/repos/felixgate13/portfolio/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/felixgate13/portfolio/labels{/name}","releases_url":"https://api.github.com/repos/felixgate13/portfolio/releases{/id}","deployments_url":"https://api.github.com/repos/felixgate13/portfolio/deployments","created_at":"2018-09-10T10:28:37Z","updated_at":"2018-09-10T10:28:40Z","pushed_at":"2018-10-03T09:57:49Z","git_url":"git://github.com/felixgate13/portfolio.git","ssh_url":"git@github.com:felixgate13/portfolio.git","clone_url":"https://github.com/felixgate13/portfolio.git","svn_url":"https://github.com/felixgate13/portfolio","homepage":null,"size":5394,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":null,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"base":{"label":"felixgate13:master","ref":"master","sha":"8e63986451116cf9178556ed41ac5794aa925db5","user":{"login":"felixgate13","id":42411328,"node_id":"MDQ6VXNlcjQyNDExMzI4","avatar_url":"https://avatars2.githubusercontent.com/u/42411328?v=4","gravatar_id":"","url":"https://api.github.com/users/felixgate13","html_url":"https://github.com/felixgate13","followers_url":"https://api.github.com/users/felixgate13/followers","following_url":"https://api.github.com/users/felixgate13/following{/other_user}","gists_url":"https://api.github.com/users/felixgate13/gists{/gist_id}","starred_url":"https://api.github.com/users/felixgate13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/felixgate13/subscriptions","organizations_url":"https://api.github.com/users/felixgate13/orgs","repos_url":"https://api.github.com/users/felixgate13/repos","events_url":"https://api.github.com/users/felixgate13/events{/privacy}","received_events_url":"https://api.github.com/users/felixgate13/received_events","type":"User","site_admin":false},"repo":{"id":148138715,"node_id":"MDEwOlJlcG9zaXRvcnkxNDgxMzg3MTU=","name":"portfolio","full_name":"felixgate13/portfolio","private":false,"owner":{"login":"felixgate13","id":42411328,"node_id":"MDQ6VXNlcjQyNDExMzI4","avatar_url":"https://avatars2.githubusercontent.com/u/42411328?v=4","gravatar_id":"","url":"https://api.github.com/users/felixgate13","html_url":"https://github.com/felixgate13","followers_url":"https://api.github.com/users/felixgate13/followers","following_url":"https://api.github.com/users/felixgate13/following{/other_user}","gists_url":"https://api.github.com/users/felixgate13/gists{/gist_id}","starred_url":"https://api.github.com/users/felixgate13/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/felixgate13/subscriptions","organizations_url":"https://api.github.com/users/felixgate13/orgs","repos_url":"https://api.github.com/users/felixgate13/repos","events_url":"https://api.github.com/users/felixgate13/events{/privacy}","received_events_url":"https://api.github.com/users/felixgate13/received_events","type":"User","site_admin":false},"html_url":"https://github.com/felixgate13/portfolio","description":null,"fork":false,"url":"https://api.github.com/repos/felixgate13/portfolio","forks_url":"https://api.github.com/repos/felixgate13/portfolio/forks","keys_url":"https://api.github.com/repos/felixgate13/portfolio/keys{/key_id}","collaborators_url":"https://api.github.com/repos/felixgate13/portfolio/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/felixgate13/portfolio/teams","hooks_url":"https://api.github.com/repos/felixgate13/portfolio/hooks","issue_events_url":"https://api.github.com/repos/felixgate13/portfolio/issues/events{/number}","events_url":"https://api.github.com/repos/felixgate13/portfolio/events","assignees_url":"https://api.github.com/repos/felixgate13/portfolio/assignees{/user}","branches_url":"https://api.github.com/repos/felixgate13/portfolio/branches{/branch}","tags_url":"https://api.github.com/repos/felixgate13/portfolio/tags","blobs_url":"https://api.github.com/repos/felixgate13/portfolio/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/felixgate13/portfolio/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/felixgate13/portfolio/git/refs{/sha}","trees_url":"https://api.github.com/repos/felixgate13/portfolio/git/trees{/sha}","statuses_url":"https://api.github.com/repos/felixgate13/portfolio/statuses/{sha}","languages_url":"https://api.github.com/repos/felixgate13/portfolio/languages","stargazers_url":"https://api.github.com/repos/felixgate13/portfolio/stargazers","contributors_url":"https://api.github.com/repos/felixgate13/portfolio/contributors","subscribers_url":"https://api.github.com/repos/felixgate13/portfolio/subscribers","subscription_url":"https://api.github.com/repos/felixgate13/portfolio/subscription","commits_url":"https://api.github.com/repos/felixgate13/portfolio/commits{/sha}","git_commits_url":"https://api.github.com/repos/felixgate13/portfolio/git/commits{/sha}","comments_url":"https://api.github.com/repos/felixgate13/portfolio/comments{/number}","issue_comment_url":"https://api.github.com/repos/felixgate13/portfolio/issues/comments{/number}","contents_url":"https://api.github.com/repos/felixgate13/portfolio/contents/{+path}","compare_url":"https://api.github.com/repos/felixgate13/portfolio/compare/{base}...{head}","merges_url":"https://api.github.com/repos/felixgate13/portfolio/merges","archive_url":"https://api.github.com/repos/felixgate13/portfolio/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/felixgate13/portfolio/downloads","issues_url":"https://api.github.com/repos/felixgate13/portfolio/issues{/number}","pulls_url":"https://api.github.com/repos/felixgate13/portfolio/pulls{/number}","milestones_url":"https://api.github.com/repos/felixgate13/portfolio/milestones{/number}","notifications_url":"https://api.github.com/repos/felixgate13/portfolio/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/felixgate13/portfolio/labels{/name}","releases_url":"https://api.github.com/repos/felixgate13/portfolio/releases{/id}","deployments_url":"https://api.github.com/repos/felixgate13/portfolio/deployments","created_at":"2018-09-10T10:28:37Z","updated_at":"2018-09-10T10:28:40Z","pushed_at":"2018-10-03T09:57:49Z","git_url":"git://github.com/felixgate13/portfolio.git","ssh_url":"git@github.com:felixgate13/portfolio.git","clone_url":"https://github.com/felixgate13/portfolio.git","svn_url":"https://github.com/felixgate13/portfolio","homepage":null,"size":5394,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":null,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/3"},"html":{"href":"https://github.com/felixgate13/portfolio/pull/3"},"issue":{"href":"https://api.github.com/repos/felixgate13/portfolio/issues/3"},"comments":{"href":"https://api.github.com/repos/felixgate13/portfolio/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/felixgate13/portfolio/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/felixgate13/portfolio/statuses/167a3db9e5ec5f91ebc7a408e9a87338500e246c"}},"author_association":"OWNER"}}
{"actor":{"display_login":"imogenhallett"}}