{"id":191,"date":"2011-04-04T20:12:29","date_gmt":"2011-04-05T00:12:29","guid":{"rendered":"http:\/\/joshho.com\/?page_id=191"},"modified":"2012-07-08T23:42:48","modified_gmt":"2012-07-09T03:42:48","slug":"database-searching-website","status":"publish","type":"page","link":"https:\/\/www.joshho.com\/blog\/projects\/database-searching-website\/","title":{"rendered":"Simple Database Searching Website"},"content":{"rendered":"<h1>Database Website<\/h1>\n<p>Written in PHP, this project was created to test my ability to write in PHP, query a MySQL database, and to practice good coding to prevent SQL injections (hopefully I have achieved this?).<\/p>\n<p>At any rate, it includes a registration form, which allows you to create an account to search the database for any song, album, or musician.<br \/>\nBe advised however, the database is not completely populated and may not return results you are looking for.<\/p>\n<p>It employs REGEX for searching, simple I know, and I am looking into making the search function a bit more advanced which will deliver better and closer results<br \/>\n(ie: corrections for misspellings).<\/p>\n<p>If you&#8217;re interested, just check the website out <a href=\"http:\/\/joshho.com\/repository\/SchoolWork\/CP363_Website\/\">here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<h1>Database Website<\/h1>\n<p>Written in PHP, this project was created to test my ability to write in PHP, query a MySQL database, and to practice good coding to prevent SQL injections (hopefully I have achieved this?).<\/p>\n<p>At any rate, it includes a registration form, which allows you to create an account to search the database for any song, album, or musician.<br \/>\nBe advised however, the database is not completely populated and may not return results you are looking for.<\/p>\n<p>It employs REGEX for searching, simple I know, and I am looking into making the search function a bit more advanced which will deliver better and closer results<br \/>\n(ie: corrections for misspellings).<\/p>\n<p>If you&#8217;re interested, just check the website out <a href=\"http:\/\/joshho.com\/repository\/SchoolWork\/CP363_Website\/\">here<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":350,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/pages\/191"}],"collection":[{"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":0,"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/pages\/191\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/pages\/350"}],"wp:attachment":[{"href":"https:\/\/www.joshho.com\/blog\/wp-json\/wp\/v2\/media?parent=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}