{"id":5436,"date":"2016-02-13T23:55:49","date_gmt":"2016-02-13T21:55:49","guid":{"rendered":"http:\/\/www.karadere.com\/blog\/?p=5436"},"modified":"2016-02-13T23:55:49","modified_gmt":"2016-02-13T21:55:49","slug":"php-sqlite-select-count-kayit-sayisi-bulma","status":"publish","type":"post","link":"https:\/\/www.karadere.com\/blog\/php-sqlite-select-count-kayit-sayisi-bulma.html","title":{"rendered":"Php SQlite select count(*) kayit sayisi bulma"},"content":{"rendered":"

\"\"<\/p>\n

\u00f6rnek telefonrehberi \u00a0tablosundaki ilgili ko\u015fula g\u00f6re kay\u0131t say\u0131s\u0131 bulmak (ada g\u00f6re arama)<\/p>\n

<?php<\/p>\n

if(!$db){
\necho $db->lastErrorMsg();
\n} else { \/\/ db baglandi ise yapilacaklar<\/p>\n

$sql = “SELECT count(*) FROM telefonrehberi\u00a0where adim= ‘”.$adi.”‘”\u00a0\u00a0;
\n$results = $db->query($sql);
\n$row = $results->fetchArray();
\n$kayitsayisi = $row[0];<\/p>\n

$db->close(); \/\/ db kapat<\/p><\/blockquote>\n

 <\/p>\n

?><\/p>\n

kayit say\u0131s\u0131 : <?=$kayitsayisi ?><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00f6rnek telefonrehberi \u00a0tablosundaki ilgili ko\u015fula g\u00f6re kay\u0131t say\u0131s\u0131 bulmak (ada g\u00f6re arama) <?php if(!$db){ echo $db->lastErrorMsg(); } else { \/\/ db baglandi ise yapilacaklar $sql = “SELECT count(*) FROM telefonrehberi\u00a0where adim= ‘”.$adi.”‘”\u00a0\u00a0; $results = $db->query($sql); $row = $results->fetchArray(); $kayitsayisi = $row[0]; $db->close(); \/\/ db kapat   ?> kayit say\u0131s\u0131 : <?=$kayitsayisi ?><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[2],"tags":[235,482,622,2457,970,2463,1873,2470,2471],"class_list":["post-5436","post","type-post","status-publish","format-standard","hentry","category-2015-2016","tag-php","tag-apache","tag-bulma","tag-count","tag-for","tag-php-ile","tag-select","tag-sqlite","tag-sqlite3","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":1762,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/5436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=5436"}],"version-history":[{"count":0,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/5436\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=5436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=5436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=5436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}