{"id":1225,"date":"2017-11-09T00:41:01","date_gmt":"2017-11-08T22:41:01","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1225"},"modified":"2017-11-09T00:41:01","modified_gmt":"2017-11-08T22:41:01","slug":"php-access_log-mysql-aktarma","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/php-access_log-mysql-aktarma\/","title":{"rendered":"PHP access_log mysql aktarma"},"content":{"rendered":"<p><?php\n$servername = \"localhost\";\n$username = \"user\";\n$password = \"\u015fifre;\n$dbname = \"dbase\";\n\n$conn = new mysqli($servername, $username, $password, $dbname);\nif ($conn->connect_error) {<br \/>\n    die(&#8220;Baglanti Hatasi: &#8221; . $conn->connect_error);<br \/>\n} <\/p>\n<p>$handle = fopen(&#8220;\/var\/log\/nginx\/access.log&#8221;, &#8220;r&#8221;);<br \/>\n$satirs = &#8220;&#8221;;<br \/>\n$ipadresi = &#8220;&#8221;;<br \/>\nif ($handle) {<br \/>\n    while (($line = fgets($handle)) !== false) {<br \/>\n        \/\/ process the line read.<br \/>\n\t\t\/\/$satirs = $line;<br \/>\n\t\t$ipadresi = explode(&#8221; &#8211; &#8211; &#8220;, $line);<br \/>\n\t\t$ipadresi = trim($ipadresi[0]);<br \/>\n\t\tif($ipadresi !== &#8220;85.96.184.61&#8221;){<br \/>\n\t\t\t$sql = &#8220;INSERT INTO access_log (satir,ip,zaman) VALUES (&#8216;$line&#8217;,&#8217;$ipadresi&#8217;,now());&#8221;;<br \/>\n\t\t$conn->query($sql);<br \/>\n\t\t}<br \/>\n    }<br \/>\n\/\/print_r($satirs);<br \/>\n    fclose($handle);<br \/>\n} else {<br \/>\n    \/\/ error opening the file.<br \/>\n} <\/p>\n<p>$conn->close();<br \/>\n?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1225"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1225"}],"version-history":[{"count":1,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1225\/revisions"}],"predecessor-version":[{"id":1226,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1225\/revisions\/1226"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}