{"id":117,"date":"2023-09-06T21:28:56","date_gmt":"2023-09-06T21:28:56","guid":{"rendered":"https:\/\/www.mucahitakin.com\/blog\/?p=117"},"modified":"2023-09-06T21:28:56","modified_gmt":"2023-09-06T21:28:56","slug":"php-ile-urunleri-databaseden-veri-cekmek","status":"publish","type":"post","link":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/","title":{"rendered":"Php ile \u00dcr\u00fcnleri Database’den \u00c7ekmek"},"content":{"rendered":"\n

Database’den veri \u00e7ekmek i\u00e7in \u00f6ncelikle bir database olu\u015fturulmas\u0131 gerekmektedir.<\/p>\n\n\n\n

Hemen \u00f6rnek bir database olu\u015ftural\u0131m.<\/p>\n\n\n\n

Tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek kodlar\u0131 kullanabiliriz.Ve MYSQL veritaban\u0131ndaki aray\u00fczden olu\u015fturabiliriz.<\/p>\n\n\n\n

CREATE TABLE tablo_adi<\/em> (\n  sutun1 veritipi k\u0131s\u0131tlama<\/em>,\n  sutun2 veritipi k\u0131s\u0131tlama<\/em>,\n  sutun3 veritipi k\u0131s\u0131tlama<\/em>,\n ....\n);\n<\/code><\/pre>\n\n\n\n
\u00d6rnek bir tablo olu\u015fturdu\u011fumuzu varsayal\u0131m. Tablomuzun ad\u0131 Customer olsun.<\/p>\n\n\n\n
tablomuzda id , isim ve soyisim de\u011ferlerinin yer ald\u0131\u011f\u0131n\u0131 varsayal\u0131m.<\/p>\n\n\n\n
\n
\"Php<\/figure>\n<\/figure>\n\n\n\n
K\u0131saca s\u00fct\u00fcnlardan bahsedelim.<\/p>\n\n\n\n
Ad\u0131 : Tablonun ad\u0131d\u0131r.<\/p>\n\n\n\n
T\u00fcr\u00fc : Tan\u0131mlanan datan\u0131n t\u00fcr\u00fcd\u00fcr.<\/p>\n\n\n\n
Uzunluk\/de\u011ferler : genellikle VARCHAR  de\u011ferleri 255 karakter olarak tan\u0131mlanmaktad\u0131r.<\/p>\n\n\n\n
Varsay\u0131lan : Bu k\u0131s\u0131mda istedi\u011finiz de\u011feri veri gelmese bile default olarak veri ekleyebilirsiniz.<\/p>\n\n\n\n
A_I : T\u0131kland\u0131\u011f\u0131nda veri geldi\u011finde otomatik olarak int de\u011ferinin say\u0131s\u0131n\u0131 y\u00fckseltir. Genellikle id de\u011ferleri otomatik artacak kullan\u0131ld\u0131\u011f\u0131 i\u00e7in bu se\u00e7enek se\u00e7ilir.<\/p>\n\n\n\n
\u00d6ncelikle veri taban\u0131m\u0131zdan veri \u00e7ekmek i\u00e7in database’e ba\u011flanmal\u0131y\u0131z.<\/p>\n\n\n\n
<?php\n\n$servername = \"localhost\";\n\n$database='sifirdanphp'\n\n$username = \"username\";\n\n$password = \"password\";\n\n\n\ntry {\n\n  $conn = new PDO(\"mysql:host=$servername;dbname=$database\", $username, $password);\n\n  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\n  echo \"Ba\u011flant\u0131 Ba\u015far\u0131l\u0131\";\n\n} catch(PDOException $e) {\n\n  echo \"Ba\u011flant\u0131 Hatas\u0131: \" . $e->getMessage();\n\n}\n\n?>\n\n<\/code><\/pre>\n\n\n\n
\u00dcst k\u0131s\u0131mda tan\u0131mlanan de\u011fi\u015fkenler $conn adl\u0131 de\u011fi\u015fkenin sunucu bilgileri almas\u0131na yard\u0131mc\u0131 olacakt\u0131r. try catch<\/em><\/strong> ile ba\u011flant\u0131m\u0131z\u0131 kontrol alt\u0131na al\u0131yoruz herhangi bir hata oldu\u011funda bizler hata mesaj\u0131n\u0131 verecek.<\/p>\n\n\n\n
A\u015fa\u011f\u0131daki kod blo\u011funda verilerinizi nas\u0131l \u00e7ekece\u011finizi html format\u0131nda g\u00f6r\u00fcnt\u00fcleyebilirsiniz.<\/p>\n\n\n\n
\n
<?php<\/p>\n\n\n\n
include “db.php”<\/p>\n\n\n\n
?><\/p>\n\n\n\n
<!DOCTYPE html><\/p>\n\n\n\n
<html lang=”en”><\/p>\n\n\n\n
<head><\/p>\n\n\n\n
    <meta charset=”UTF-8″><\/p>\n\n\n\n
    <meta name=”viewport” content=”width=device-width, initial-scale=1.0″><\/p>\n\n\n\n
    <title>Mysql’den Veri \u00c7ekmek<\/title><\/p>\n\n\n\n
    <link href=”https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.1\/dist\/css\/bootstrap.min.css” rel=”stylesheet” integrity=”sha384-4bw+\/aepP\/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9″ crossorigin=”anonymous”><\/p>\n\n\n\n
<\/head><\/p>\n\n\n\n
<body><\/p>\n\n\n\n
<table class=”table”><\/p>\n\n\n\n
  <thead><\/p>\n\n\n\n
    <tr><\/p>\n\n\n\n
      <th scope=”col”>ID<\/th><\/p>\n\n\n\n
      <th scope=”col”>\u0130sim<\/th><\/p>\n\n\n\n
      <th scope=”col”>Soyisim<\/th><\/p>\n\n\n\n
    <\/tr><\/p>\n\n\n\n
  <\/thead><\/p>\n\n\n\n
  <tbody><\/p>\n\n\n\n
  <?php<\/p>\n\n\n\n
  $urunsor=$conn->prepare(‘SELECT * FROM customer’);<\/p>\n\n\n\n
  $urunsor->execute();<\/p>\n\n\n\n
  while($uruncek=$urunsor->fetch(PDO::FETCH_ASSOC)){<\/p>\n\n\n\n
  ?><\/p>\n\n\n\n
    <tr><\/p>\n\n\n\n
      <td><?php echo $uruncek[‘Customer_id’]?><\/td><\/p>\n\n\n\n
      <td><?php echo $uruncek[‘Customer_name’]?><\/td><\/p>\n\n\n\n
      <td><?php echo $uruncek[‘Customer_surname’]?><\/td><\/p>\n\n\n\n
    <\/tr><\/p>\n\n\n\n
<?php<\/p>\n\n\n\n
}<\/p>\n\n\n\n
?><\/p>\n\n\n\n
  <\/tbody><\/p>\n\n\n\n
<\/table><\/p>\n\n\n\n
<script src=”https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.1\/dist\/js\/bootstrap.bundle.min.js” integrity=”sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm” crossorigin=”anonymous”><\/script><\/p>\n\n\n\n
<\/body><\/p>\n\n\n\n
<\/html><\/p>\n<\/blockquote>\n\n\n\n
Bu kod blo\u011fudna \u00f6ncelikle database <\/strong><\/em>ba\u011flant\u0131s\u0131n\u0131 include <\/strong><\/em>ediyoruz. Verilerimizi \u00e7ekmemiz i\u00e7in gerekli olan en \u00f6nemli konulardan bir tanesi database ba\u011flant\u0131s\u0131n\u0131 i\u015flem yapaca\u011f\u0131m\u0131z yere include etmek.<\/p>\n\n\n\n
Bu k\u0131s\u0131mda m\u00fc\u015fterilerimizin verilerini g\u00fczel bir g\u00f6r\u00fcnt\u00fcde listelemek i\u00e7in bootstrapp<\/em><\/strong> kulland\u0131k.<\/p>\n\n\n\n
while d\u00f6ng\u00fcs\u00fc<\/em><\/strong> ile b\u00fct\u00fcn verilerimizi database’den \u00e7ektik.
\u00a0$urunsor=$conn->prepare(‘SELECT * FROM customer’); bu k\u0131s\u0131mda urunsor k\u0131sm\u0131nda customer’daki b\u00fct\u00fcn verilerimizi hi\u00e7bir ko\u015ful vermeden \u00e7ektik.
<td><?php echo $uruncek[‘Customer_id’]?><\/td><\/p>\n\n\n\n
<td><?php echo $uruncek[‘Customer_name’]?><\/td><\/p>\n\n\n\n
<td><?php echo $uruncek[‘Customer_surname’]?><\/td><\/p>\n\n\n\n

bu kodlar ile  database’deki verileri \u00e7ekiyoruz.<\/p>\n\n\n\n
\n
\"\"<\/figure>\n<\/figure>\n\n\n\n
Verilerimizi bu \u015fekilde kolayca PDO <\/em><\/strong>kullanarak \u00e7ektik. Verilerimizi \u00e7ekti\u011fimiz g\u00f6r\u00fcnt\u00fc \u00fcstteki g\u00f6rseldeki gibidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
Database’den veri \u00e7ekmek i\u00e7in \u00f6ncelikle bir database olu\u015fturulmas\u0131 gerekmektedir. Hemen \u00f6rnek bir database olu\u015ftural\u0131m. Tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek kodlar\u0131 kullanabiliriz.Ve MYSQL veritaban\u0131ndaki aray\u00fczden olu\u015fturabiliriz. \u00d6rnek bir tablo olu\u015fturdu\u011fumuzu varsayal\u0131m. Tablomuzun ad\u0131 Customer olsun. tablomuzda id , isim ve soyisim de\u011ferlerinin yer ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. K\u0131saca s\u00fct\u00fcnlardan bahsedelim. Ad\u0131 : Tablonun ad\u0131d\u0131r. T\u00fcr\u00fc : Tan\u0131mlanan datan\u0131n […]<\/p>\n","protected":false},"author":1,"featured_media":118,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[43,88,42],"class_list":["post-117","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-mysql","tag-mysqlden-veri-cekmek","tag-php"],"yoast_head":"\nPhp ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Php ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin\" \/>\n<meta property=\"og:description\" content=\"Database’den veri \u00e7ekmek i\u00e7in \u00f6ncelikle bir database olu\u015fturulmas\u0131 gerekmektedir. Hemen \u00f6rnek bir database olu\u015ftural\u0131m. Tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek kodlar\u0131 kullanabiliriz.Ve MYSQL veritaban\u0131ndaki aray\u00fczden olu\u015fturabiliriz. \u00d6rnek bir tablo olu\u015fturdu\u011fumuzu varsayal\u0131m. Tablomuzun ad\u0131 Customer olsun. tablomuzda id , isim ve soyisim de\u011ferlerinin yer ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. K\u0131saca s\u00fct\u00fcnlardan bahsedelim. Ad\u0131 : Tablonun ad\u0131d\u0131r. T\u00fcr\u00fc : Tan\u0131mlanan datan\u0131n […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/\" \/>\n<meta property=\"og:site_name\" content=\"Mucahit Akin\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-06T21:28:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mucahitakin.com\/blog\/wp-content\/uploads\/2023\/09\/resim_2023-09-06_233026043.png\" \/>\n\t<meta property=\"og:image:width\" content=\"895\" \/>\n\t<meta property=\"og:image:height\" content=\"221\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"akinmucahit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"akinmucahit\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/\",\"url\":\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/\",\"name\":\"Php ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin\",\"isPartOf\":{\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/#website\"},\"datePublished\":\"2023-09-06T21:28:56+00:00\",\"dateModified\":\"2023-09-06T21:28:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/44941b8386ec7b7a0d538904d2340229\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mucahitakin.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Php ile \u00dcr\u00fcnleri Database’den \u00c7ekmek\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/#website\",\"url\":\"https:\/\/www.mucahitakin.com\/blog\/\",\"name\":\"Mucahit Akin\",\"description\":\"Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mucahitakin.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/44941b8386ec7b7a0d538904d2340229\",\"name\":\"akinmucahit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82dcabbf8a64b74dd355ead89fff0ec94009a84485c2a3d0ba8de4a2ba25576b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82dcabbf8a64b74dd355ead89fff0ec94009a84485c2a3d0ba8de4a2ba25576b?s=96&d=mm&r=g\",\"caption\":\"akinmucahit\"},\"sameAs\":[\"https:\/\/www.mucahitakin.com\/blog\"],\"url\":\"https:\/\/www.mucahitakin.com\/blog\/author\/akinmucahit\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Php ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/","og_locale":"en_US","og_type":"article","og_title":"Php ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin","og_description":"Database’den veri \u00e7ekmek i\u00e7in \u00f6ncelikle bir database olu\u015fturulmas\u0131 gerekmektedir. Hemen \u00f6rnek bir database olu\u015ftural\u0131m. Tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek kodlar\u0131 kullanabiliriz.Ve MYSQL veritaban\u0131ndaki aray\u00fczden olu\u015fturabiliriz. \u00d6rnek bir tablo olu\u015fturdu\u011fumuzu varsayal\u0131m. Tablomuzun ad\u0131 Customer olsun. tablomuzda id , isim ve soyisim de\u011ferlerinin yer ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. K\u0131saca s\u00fct\u00fcnlardan bahsedelim. Ad\u0131 : Tablonun ad\u0131d\u0131r. T\u00fcr\u00fc : Tan\u0131mlanan datan\u0131n […]","og_url":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/","og_site_name":"Mucahit Akin","article_published_time":"2023-09-06T21:28:56+00:00","og_image":[{"width":895,"height":221,"url":"https:\/\/www.mucahitakin.com\/blog\/wp-content\/uploads\/2023\/09\/resim_2023-09-06_233026043.png","type":"image\/png"}],"author":"akinmucahit","twitter_card":"summary_large_image","twitter_misc":{"Written by":"akinmucahit","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/","url":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/","name":"Php ile \u00dcr\u00fcnleri Database'den \u00c7ekmek - Mucahit Akin","isPartOf":{"@id":"https:\/\/www.mucahitakin.com\/blog\/#website"},"datePublished":"2023-09-06T21:28:56+00:00","dateModified":"2023-09-06T21:28:56+00:00","author":{"@id":"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/44941b8386ec7b7a0d538904d2340229"},"breadcrumb":{"@id":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mucahitakin.com\/blog\/php-ile-urunleri-databaseden-veri-cekmek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mucahitakin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Php ile \u00dcr\u00fcnleri Database’den \u00c7ekmek"}]},{"@type":"WebSite","@id":"https:\/\/www.mucahitakin.com\/blog\/#website","url":"https:\/\/www.mucahitakin.com\/blog\/","name":"Mucahit Akin","description":"Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mucahitakin.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/44941b8386ec7b7a0d538904d2340229","name":"akinmucahit","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mucahitakin.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/82dcabbf8a64b74dd355ead89fff0ec94009a84485c2a3d0ba8de4a2ba25576b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82dcabbf8a64b74dd355ead89fff0ec94009a84485c2a3d0ba8de4a2ba25576b?s=96&d=mm&r=g","caption":"akinmucahit"},"sameAs":["https:\/\/www.mucahitakin.com\/blog"],"url":"https:\/\/www.mucahitakin.com\/blog\/author\/akinmucahit\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":2,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/posts\/117\/revisions\/133"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/media\/118"}],"wp:attachment":[{"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mucahitakin.com\/blog\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}