{"id":3520,"date":"2020-09-20T12:06:28","date_gmt":"2020-09-20T09:06:28","guid":{"rendered":"https:\/\/furkansandal.com\/?p=3520"},"modified":"2020-09-21T16:38:42","modified_gmt":"2020-09-21T13:38:42","slug":"php-ile-rest-api-servisinizi-yazmak-v1-0-get","status":"publish","type":"post","link":"https:\/\/furkansandal.com\/php-ile-rest-api-servisinizi-yazmak-v1-0-get\/","title":{"rendered":"PHP ile REST API Servisinizi Yazmak: v1.0 GET"},"content":{"rendered":"\n<p>Selamlar, kendi uygulaman\u0131z\u0131 ve web servisinizi yazmak istedi\u011finizde imdad\u0131n\u0131za yeti\u015fecek yaz\u0131mda sizlere en basit \u015fekilde PHP ile REST API yazmay\u0131 anlataca\u011f\u0131m.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/github.com\/furkansandal\/php-restful-api-get\" target=\"_blank\" rel=\"noreferrer noopener\">Github&#8217;ta incelemek i\u00e7in t\u0131klay\u0131n!<\/a><\/strong><\/p>\n\n\n\n<p>\u0130htiya\u00e7lar\u0131m\u0131z:<\/p>\n\n\n\n<ul><li>PHP versiyonu \u00f6nemli de\u011fil \ud83d\ude42 <\/li><li>Herhangi bir veritaban\u0131, SQLite, MySQL, MSSQL, MongoDB vs.<\/li><li>Notepad++, SublimeText veya benzeri basic edit\u00f6r.<\/li><li>PHP \u00e7al\u0131\u015ft\u0131rabilece\u011finiz bir ortam. Ben kendi sunucumda CyberPanel kullan\u0131yorum, lokalde \u00e7al\u0131\u015fmak ,isterseniz Xamp, Wamp, AppServ vs. kullanabilirsiniz. Linux kullan\u0131c\u0131s\u0131ysan\u0131z blogumda Linux i\u00e7in kurulumu var.<\/li><\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-662e3d2381935\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-662e3d2381935\"  type=\"checkbox\" id=\"item-662e3d2381935\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/furkansandal.com\/php-ile-rest-api-servisinizi-yazmak-v1-0-get\/#Hadi_Baslayalim_Veritabanimiz\" title=\"Hadi Ba\u015flayal\u0131m: Veritaban\u0131m\u0131z\">Hadi Ba\u015flayal\u0131m: Veritaban\u0131m\u0131z<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/furkansandal.com\/php-ile-rest-api-servisinizi-yazmak-v1-0-get\/#Hadi_yazalim_PHP_Islemleri\" title=\"Hadi yazal\u0131m: PHP \u0130\u015flemleri\">Hadi yazal\u0131m: PHP \u0130\u015flemleri<\/a><\/li><\/ul><\/nav><\/div>\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Hadi_Baslayalim_Veritabanimiz\"><\/span>Hadi Ba\u015flayal\u0131m: Veritaban\u0131m\u0131z<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>SQLite veritaban\u0131 kullanmay\u0131 tercih ediyorum. Kesinlikle veritaban\u0131 farketmez burada. Kolayl\u0131k olmas\u0131 a\u00e7\u0131s\u0131ndan se\u00e7iyorum. Github&#8217;a att\u0131\u011f\u0131mda i\u00e7eri d\u0131\u015far\u0131 aktar problemi olmamas\u0131 a\u00e7\u0131s\u0131ndan.<\/p>\n\n\n\n<p>DB Browser For SQLite uygulamas\u0131 ile yeni veritaban\u0131 olu\u015ftural\u0131m.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"706\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-13.png?resize=1024%2C706&#038;ssl=1\" alt=\"\" class=\"wp-image-3522\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>Olu\u015fturur olu\u015fturmaz tablo ekran\u0131 gelecek. Burada kullanaca\u011f\u0131m\u0131z bir tablo olu\u015ftural\u0131m. id, isim, soyisim,yas ve cinsiyet koydum. id ve yas numeric di\u011ferleri text olarak.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"749\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-14.png?resize=1024%2C749&#038;ssl=1\" alt=\"\" class=\"wp-image-3523\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>\u0130\u00e7erisine 5 tane veri girdim. Veriyi g\u00f6r\u00fcnt\u00fcle k\u0131sm\u0131ndan verileri d\u00fczenleyemeye girebilir k\u0131rm\u0131z\u0131 ok ile g\u00f6sterdi\u011fim alandan yeni veri giri\u015f alan\u0131 a\u00e7abilirsiniz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"376\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-15.png?resize=1024%2C376&#038;ssl=1\" alt=\"\" class=\"wp-image-3524\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>De\u011fi\u015fikleri kaydet diyip veritaban\u0131m\u0131zla i\u015fimizi tamamlayal\u0131m.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Hadi_yazalim_PHP_Islemleri\"><\/span>Hadi yazal\u0131m: PHP \u0130\u015flemleri<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>PHP \u00e7al\u0131\u015fan bir sistem kurdu\u011funuzu d\u00fc\u015f\u00fcnerek devam ediyorum \ud83d\ude42 veritabanimiz.db dosyam\u0131z\u0131n oldu\u011fu dizine yeni bir PHP dosyas\u0131 olu\u015ftural\u0131m. \u0130smine veri_cek.php koydum. Ve dosyam\u0131z\u0131 d\u00fczenleyelim.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"117\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-16.png?resize=1024%2C117&#038;ssl=1\" alt=\"\" class=\"wp-image-3525\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>\u00d6ncelikle &lt;?php ?&gt; taglar\u0131m\u0131z\u0131n i\u00e7erisine s\u0131ras\u0131yla \u015fu i\u015flemleri yapal\u0131m.<\/p>\n\n\n\n<ul><li>Header&#8217;a content-type application\/json ekleyelim. Eklemesekte olur, ancak baz\u0131 taray\u0131c\u0131lar\u0131n iyi anlamas\u0131 i\u00e7in kullanabilirsiniz.<\/li><li>Veritaban\u0131m\u0131z\u0131 okuyal\u0131m.<\/li><li>Json_encode etmek i\u00e7in yeni dizi olu\u015ftural\u0131m.<\/li><li>indis sayac\u0131 olu\u015ftural\u0131m.<\/li><li>Verilerimizi \u00e7ekelim.<\/li><li>Sat\u0131r sat\u0131r okuyal\u0131m: Okuduklar\u0131m\u0131z\u0131n i\u00e7erisindeki verileri jsonDizimize ekleyelim ve indis sayac\u0131 artt\u0131ral\u0131m.<\/li><li>Ekrana json encode edip yazd\u0131ral\u0131m.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-17.png?resize=585%2C184&#038;ssl=1\" alt=\"\" class=\"wp-image-3526\" width=\"585\" height=\"184\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&lt;?php \nheader('Content-type: application\/json'); \/\/ Taray\u0131c\u0131dan girdi\u011fimizde JSON format\u0131nda g\u00f6relim.\n\n$db = new SQLite3('veritabanimiz.db'); \/\/SQLite veritaban\u0131m\u0131za ba\u011flanal\u0131m.\n\n$jsonDizisi = array(); \/\/ JSON Dizimizi Olu\u015ftural\u0131m.\n\n$sayac = 0; \/\/ \u0130ndis sayac\u0131m\u0131z\n\n$results = $db-&gt;query('SELECT * FROM kisiler'); \/\/Ki\u015filer tablomuzdan t\u00fcm verileri \u00e7ekelim.\n\nwhile ($row = $results-&gt;fetchArray()) { \/\/ Sat\u0131r sat\u0131r verileri \u00e7ektik.\n\n    $jsonDizisi&#91;'kisiler']&#91;$sayac]&#91;'id'] = $row&#91;&quot;id&quot;]; \/\/ json dizimizin kisiler -&gt; indis -&gt; id de\u011ferine \u00e7ekti\u011fimiz de\u011feri atad\u0131k.\n    $jsonDizisi&#91;'kisiler']&#91;$sayac]&#91;'isim'] = $row&#91;&quot;isim&quot;]; \/\/ json dizimizin kisiler -&gt; indis -&gt; isim de\u011ferine \u00e7ekti\u011fimiz de\u011feri atad\u0131k.\n    $jsonDizisi&#91;'kisiler']&#91;$sayac]&#91;'soyisim'] = $row&#91;&quot;soyisim&quot;]; \/\/ json dizimizin kisiler -&gt; indis -&gt; soyisim de\u011ferine \u00e7ekti\u011fimiz de\u011feri atad\u0131k.\n    $jsonDizisi&#91;'kisiler']&#91;$sayac]&#91;'yas'] = $row&#91;&quot;yas&quot;]; \/\/ json dizimizin kisiler -&gt; indis -&gt; yas de\u011ferine \u00e7ekti\u011fimiz de\u011feri atad\u0131k.\n    $jsonDizisi&#91;'kisiler']&#91;$sayac]&#91;'cinsiyet'] = $row&#91;&quot;cinsiyet&quot;]; \/\/ json dizimizin kisiler -&gt; indis -&gt; cinsiyet de\u011ferine \u00e7ekti\u011fimiz de\u011feri atad\u0131k.\n\n    $sayac++; \/\/ \u0130ndis sayac\u0131m\u0131z\u0131 artt\u0131rd\u0131k.\n}\n\necho json_encode($jsonDizisi); \/\/json dizimizi json format\u0131na encode edip yazd\u0131rd\u0131k.\n?&gt;\n<\/pre><\/div>\n\n\n<p>Yaz\u0131n\u0131n ba\u015f\u0131na b\u0131rakt\u0131\u011f\u0131m linkten <strong>Github<\/strong> \u00fczerinden inceleyebilirsiniz. Hadi kontrol edelim. <a href=\"https:\/\/furkansandal.com\/github_projects\/1-restapi-get\/veri_cek.php\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/furkansandal.com\/github_projects\/1-restapi-get\/veri_cek.php<\/a> adresinden inceleyebilirsiniz. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"322\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-18.png?resize=1024%2C322&#038;ssl=1\" alt=\"\" class=\"wp-image-3527\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>G\u00f6rsellik ve okunabilirlik i\u00e7in jsonviewer.stack.hu adresine \u00e7\u0131kt\u0131m\u0131z\u0131 yap\u0131\u015ft\u0131ral\u0131m ve kontrol edelim nas\u0131l olmu\u015f?<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1018\" height=\"1024\" src=\"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/image-19.png?resize=1018%2C1024&#038;ssl=1\" alt=\"\" class=\"wp-image-3528\" data-recalc-dims=\"1\"\/><\/figure>\n\n\n\n<p>Ancak hen\u00fcz RESTful API olmad\u0131 \ud83d\ude42 Sadece verileri \u00e7ekiyoruz. \u0130leriki postlarda RESTful API&#8217;nin devam\u0131 i\u00e7in POST, DELETE, UPDATE \u00fczerinede i\u015flem yapaca\u011f\u0131z \ud83d\ude42  Ama dikkat etmemiz gereken bir konu ise SQL Injection. \u0130leriki k\u0131s\u0131mlarda parametre alaca\u011f\u0131m\u0131z i\u00e7in SQL Injection&#8217;a kar\u015f\u0131 dikkatli kod yazaca\u011f\u0131z \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Selamlar, kendi uygulaman\u0131z\u0131 ve web servisinizi yazmak istedi\u011finizde imdad\u0131n\u0131za yeti\u015fecek yaz\u0131mda sizlere en basit \u015fekilde PHP ile REST API yazmay\u0131&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":""},"categories":[1,155],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/furkansandal.com\/wp-content\/uploads\/2020\/09\/php-rest-api.png?fit=600%2C338&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6BM7I-UM","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/posts\/3520"}],"collection":[{"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/comments?post=3520"}],"version-history":[{"count":3,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/posts\/3520\/revisions"}],"predecessor-version":[{"id":3640,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/posts\/3520\/revisions\/3640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/media\/3530"}],"wp:attachment":[{"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/media?parent=3520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/categories?post=3520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/furkansandal.com\/wp-json\/wp\/v2\/tags?post=3520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}