Php ile web sayfas\u0131 tasarlaman\u0131n en temel nedeni dinamik bir site haz\u0131rlamak istememizdir. Yani duruma ve ko\u015fullara g\u00f6re de\u011fi\u015fen nitelikte, bazen sorgulama bazen i\u015flem yapt\u0131rma ve benzeri sonu\u00e7lara ula\u015fma konusunda php en \u00e7ok tercih edilen sunucu tabanl\u0131 bir yaz\u0131l\u0131m dildir. PHP program\u0131 mysql ile uyumlu \u00e7al\u0131\u015fmaktad\u0131r. PHPmyAdmin arac\u0131l\u0131\u011f\u0131 ile olu\u015fturulan veri taban\u0131 tablolar\u0131na eri\u015fmek ve sorgu yapmak ise sadece birka\u00e7 sat\u0131r kod ile m\u00fcmk\u00fcnd\u00fcr.<\/p>\n
E\u011fer php sayfa haz\u0131rlan\u0131yorsa kesinlikle class mant\u0131\u011f\u0131yla haz\u0131rlaman\u0131z\u0131 tavsiye ederim. \u00d6rne\u011fin connect.php isimli php sayfas\u0131 olu\u015fturup, a\u015fa\u011f\u0131daki kodlar\u0131 yap\u0131\u015ft\u0131r\u0131n. B\u00f6ylelikle veri taban\u0131n\u0131za ba\u011flanm\u0131\u015f olacaks\u0131n\u0131z.<\/p>\n
<?php \r\n$baglantim=mysqli_connect(\"alanadiniz.com\",\"kullaniciadi\",\"sifre\",\"veritabaniadi\"); \r\nif (mysqli_connect_errno()) \r\n{ \r\necho \"Veri Taban\u0131na Ba\u011flanamad\u0131.: \" . mysqli_connect_error(); \r\n} \r\n?><\/pre>\nOlu\u015fturmu\u015f oldu\u011funuz connect.php sayfas\u0131n\u0131 istedi\u011finiz php sayfas\u0131na class y\u00f6ntemi ile dahil edebilirsiniz. Bunun i\u00e7in ise istedi\u011finiz sayfalara a\u015fa\u011f\u0131daki kodu yap\u0131\u015ft\u0131rmal\u0131s\u0131n\u0131z.<\/p>\n
include('connect.php')<\/pre>\n\u015eimdi veri taban\u0131nda select metodu ile veri \u00e7ekelim. Bunun i\u00e7in a\u015fa\u011f\u0131daki kodu kullanmal\u0131s\u0131n\u0131z.<\/p>\n
<?php \r\ninclude('connect.php') \r\n$sorgu = mysqli_query($baglantim,\"SELECT * FROM Muhasebe\"); \r\nwhile($row = mysqli_fetch_array($sorgu)) \r\n{ \r\necho $row['ARGE'] . \" \" . $row['Tutar']; \r\necho \"<\/br>\"; \r\n} \r\nmysqli_close($baglantim); \r\n?><\/pre>\nFaydal\u0131 olmas\u0131 dile\u011fiyle…<\/p>\n","protected":false},"excerpt":{"rendered":"
Php ile web sayfas\u0131 tasarlaman\u0131n en temel nedeni dinamik bir site haz\u0131rlamak istememizdir. Yani duruma ve ko\u015fullara g\u00f6re de\u011fi\u015fen nitelikte, bazen sorgulama bazen i\u015flem yapt\u0131rma ve benzeri sonu\u00e7lara ula\u015fma konusunda…<\/p>\n","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_joinchat":[],"footnotes":""},"categories":[206,277],"tags":[273,275,276,274,271,272,269,270],"acf":[],"views":490,"taxonomy_info":{"category":[{"value":206,"label":"Bilgisayar"},{"value":277,"label":"PHP"}],"post_tag":[{"value":273,"label":"mysql sorgulama"},{"value":275,"label":"php class y\u00f6ntemi"},{"value":276,"label":"php include"},{"value":274,"label":"php mysql komutlar\u0131"},{"value":271,"label":"php veri taban\u0131"},{"value":272,"label":"php veri taban\u0131 ba\u011flant\u0131 y\u00f6ntemleri"},{"value":269,"label":"phpmyadmin"},{"value":270,"label":"phpmysql"}]},"featured_image_src_large":["https:\/\/bymmb.com\/wp-content\/uploads\/2014\/02\/PHP-Mysql.png",500,270,false],"author_info":{"display_name":"bymmb","author_link":"https:\/\/bymmb.com\/author\/bymmb\/"},"comment_info":2,"category_info":[{"term_id":206,"name":"Bilgisayar","slug":"bilgisayar","term_group":0,"term_taxonomy_id":206,"taxonomy":"category","description":"","parent":0,"count":42,"filter":"raw","cat_ID":206,"category_count":42,"category_description":"","cat_name":"Bilgisayar","category_nicename":"bilgisayar","category_parent":0},{"term_id":277,"name":"PHP","slug":"php","term_group":0,"term_taxonomy_id":277,"taxonomy":"category","description":"","parent":0,"count":11,"filter":"raw","cat_ID":277,"category_count":11,"category_description":"","cat_name":"PHP","category_nicename":"php","category_parent":0}],"tag_info":[{"term_id":273,"name":"mysql sorgulama","slug":"mysql-sorgulama","term_group":0,"term_taxonomy_id":273,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":275,"name":"php class y\u00f6ntemi","slug":"php-class-yontemi","term_group":0,"term_taxonomy_id":275,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":276,"name":"php include","slug":"php-include","term_group":0,"term_taxonomy_id":276,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":274,"name":"php mysql komutlar\u0131","slug":"php-mysql-komutlari","term_group":0,"term_taxonomy_id":274,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":271,"name":"php veri taban\u0131","slug":"php-veri-tabani","term_group":0,"term_taxonomy_id":271,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":272,"name":"php veri taban\u0131 ba\u011flant\u0131 y\u00f6ntemleri","slug":"php-veri-tabani-baglanti-yontemleri","term_group":0,"term_taxonomy_id":272,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":269,"name":"phpmyadmin","slug":"phpmyadmin","term_group":0,"term_taxonomy_id":269,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":270,"name":"phpmysql","slug":"phpmysql","term_group":0,"term_taxonomy_id":270,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/701"}],"collection":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/comments?post=701"}],"version-history":[{"count":0,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/701\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media?parent=701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/categories?post=701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/tags?post=701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}