{"id":4219,"date":"2023-09-05T15:00:43","date_gmt":"2023-09-05T15:00:43","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=4219"},"modified":"2023-09-06T13:36:14","modified_gmt":"2023-09-06T13:36:14","slug":"mariadb-ile-php-ve-python-ile-entegrasyon","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/mariadb-ile-php-ve-python-ile-entegrasyon\/","title":{"rendered":"MariaDB ile PHP ve Python ile Entegrasyon"},"content":{"rendered":"<p>MariaDB, MySQL&#8217;in a\u00e7\u0131k kaynakl\u0131 bir dal\u0131d\u0131r ve bir\u00e7ok geli\u015ftirici ve \u015firket taraf\u0131ndan tercih edilen bir veritaban\u0131 y\u00f6netim sistemi olarak kullan\u0131lmaktad\u0131r. Bu blog yaz\u0131s\u0131nda, MariaDB&#8217;nin ne oldu\u011funu ve nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. PHP ile MariaDB veritaban\u0131na nas\u0131l ba\u011flant\u0131 kurabilece\u011fimizi, veri ekleme ve sorgulama i\u015flemlerini nas\u0131l ger\u00e7ekle\u015ftirebilece\u011fimizi ve hatta <a href=\"https:\/\/sunucucozumleri.com\/blog\/python-nedir\/\">Python<\/a> ile nas\u0131l entegre edebilece\u011fimizi \u00f6\u011frenece\u011fiz. Hem PHP hem de Python geli\u015ftiricileri i\u00e7in faydal\u0131 olacak bu bilgileri detayl\u0131 bir \u015fekilde ele alaca\u011f\u0131z. Haz\u0131rsan\u0131z, MariaDB&#8217;nin kap\u0131lar\u0131n\u0131 ard\u0131na kadar a\u00e7maya ba\u015flayal\u0131m!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 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\" style=\"cursor:inherit\">Makale \u0130\u00e7eri\u011fi<\/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=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucucozumleri.com\/blog\/mariadb-ile-php-ve-python-ile-entegrasyon\/#MariaDB_nedir_ve_nasil_kullanilir\" >MariaDB nedir ve nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucucozumleri.com\/blog\/mariadb-ile-php-ve-python-ile-entegrasyon\/#PHP_ile_MariaDB_veritabanina_baglanti_kurma\" >PHP ile MariaDB veritaban\u0131na ba\u011flant\u0131 kurma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucucozumleri.com\/blog\/mariadb-ile-php-ve-python-ile-entegrasyon\/#MariaDB_ile_PHP_uzerinden_veri_ekleme_ve_sorgulama\" >MariaDB ile PHP \u00fczerinden veri ekleme ve sorgulama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucucozumleri.com\/blog\/mariadb-ile-php-ve-python-ile-entegrasyon\/#Python_ile_MariaDB_veritabani_entegrasyonu\" >Python ile MariaDB veritaban\u0131 entegrasyonu<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"MariaDB_nedir_ve_nasil_kullanilir\"><\/span>MariaDB nedir ve nas\u0131l kullan\u0131l\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>MariaDB, MySQL&#8217;in bir dal\u0131 olan a\u00e7\u0131k kaynakl\u0131 bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Michael &#8220;Monty&#8221; Widenius taraf\u0131ndan geli\u015ftirilen MariaDB, kullan\u0131c\u0131lar\u0131n veritaban\u0131 i\u015flemlerini y\u00f6netmelerine ve verileri saklamalar\u0131na olanak tan\u0131r. MySQL ile uyumlu olmas\u0131 sayesinde, MariaDB kullan\u0131c\u0131lar\u0131 mevcut MySQL veritabanlar\u0131n\u0131 kolayl\u0131kla ta\u015f\u0131yabilir ve mevcut uygulamalar\u0131n\u0131 MariaDB ile sorunsuz bir \u015fekilde \u00e7al\u0131\u015ft\u0131rabilirler.<\/p>\n<p>MariaDB&#8217;nin bir\u00e7ok avantaj\u0131 vard\u0131r. \u00d6ncelikle, MariaDB, y\u00fcksek performans sunan ve g\u00fcvenli bir veritaban\u0131 sunucusu sa\u011flar. Veritaban\u0131 y\u00f6netimi konusunda geni\u015f bir \u00f6zellik k\u00fcmesine sahip olmas\u0131, MariaDB&#8217;nin \u00e7e\u015fitli i\u015fletim sistemlerinde kolayca kullan\u0131labilmesini sa\u011flar. Ayr\u0131ca, MariaDB&#8217;nin a\u00e7\u0131k kaynak kodlu olmas\u0131, kullan\u0131c\u0131lar\u0131n ihtiya\u00e7lar\u0131na uygun \u015fekilde \u00f6zelle\u015ftirme yapmas\u0131n\u0131 kolayla\u015ft\u0131r\u0131r.<\/p>\n<ul>\n<li>MariaDB&#8217;nin avantajlar\u0131:<\/li>\n<li>H\u0131zl\u0131 ve g\u00fcvenli veri i\u015fleme<\/li>\n<li>A\u00e7\u0131k kaynak kodlu ve \u00f6zelle\u015ftirilebilir<\/li>\n<li>\u00c7e\u015fitli i\u015fletim sistemlerinde kullan\u0131labilir<\/li>\n<li>MySQL ile uyumlu ve kolay ge\u00e7i\u015f imkan\u0131<\/li>\n<\/ul>\n<table>\n<tr>\n<th>\u00d6zellik<\/th>\n<th>A\u00e7\u0131klama<\/th>\n<\/tr>\n<tr>\n<td>H\u0131zl\u0131 ve verimli<\/td>\n<td>MariaDB, performans odakl\u0131 bir veritaban\u0131 sunucusudur ve verilerin h\u0131zl\u0131 bir \u015fekilde i\u015flenmesini sa\u011flar.<\/td>\n<\/tr>\n<tr>\n<td>\u00d6zelle\u015ftirilebilir<\/td>\n<td>MariaDB&#8217;nin a\u00e7\u0131k kaynak kodlu olmas\u0131, kullan\u0131c\u0131lar\u0131n ihtiya\u00e7lar\u0131na uygun \u015fekilde \u00f6zelle\u015ftirme yapabilmesine olanak tan\u0131r.<\/td>\n<\/tr>\n<tr>\n<td>Uyumlu<\/td>\n<td>MariaDB, MySQL ile uyumlu oldu\u011fu i\u00e7in mevcut MySQL veritabanlar\u0131n\u0131 sorunsuz bir \u015fekilde ta\u015f\u0131yabilir ve \u00e7al\u0131\u015ft\u0131rabilirsiniz.<\/td>\n<\/tr>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"PHP_ile_MariaDB_veritabanina_baglanti_kurma\"><\/span>PHP ile MariaDB veritaban\u0131na ba\u011flant\u0131 kurma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>PHP ve MariaDB, dinamik bir web sitesi veya uygulama olu\u015ftururken s\u0131k\u00e7a kullan\u0131lan iki \u00f6nemli bile\u015fendir. PHP, <a href=\"https:\/\/sunucucozumleri.com\/blog\/frontpage\/\">sunucu<\/a> tarafl\u0131 bir programlama dilidir ve web sayfalar\u0131nda etkile\u015fimli \u00f6zellikler eklemek i\u00e7in kullan\u0131l\u0131rken, MariaDB ise veritaban\u0131 y\u00f6netim sistemi olarak kullan\u0131l\u0131r. Bu yaz\u0131da, PHP ile MariaDB veritaban\u0131na nas\u0131l ba\u011flant\u0131 kurabilece\u011fimizi \u00f6\u011frenece\u011fiz.<\/p>\n<p>PHP dilinde, MariaDB veritaban\u0131na ba\u011flant\u0131 kurmak i\u00e7in <strong>mysqli_connect()<\/strong> i\u015flevini kullanmam\u0131z gerekiyor. Bu i\u015flev, MariaDB sunucusuyla bir ba\u011flant\u0131 olu\u015fturur ve bu ba\u011flant\u0131y\u0131 kullanarak veritaban\u0131 \u00fczerinde \u00e7e\u015fitli i\u015flemler ger\u00e7ekle\u015ftirmemizi sa\u011flar. \u0130lk olarak, MariaDB sunucusunun ad\u0131n\u0131, kullan\u0131c\u0131 ad\u0131n\u0131, \u015fifreyi ve davran\u0131\u015f ayarlar\u0131n\u0131 i\u00e7eren bir dizi olu\u015fturmam\u0131z gerekiyor.<\/p>\n<p>Ard\u0131ndan, <strong>mysqli_connect()<\/strong> i\u015flevini kullanarak ba\u011flant\u0131y\u0131 ger\u00e7ekle\u015ftiriyoruz. A\u015fa\u011f\u0131da \u00f6rnek bir kod blo\u011funu g\u00f6rebilirsiniz:<\/p>\n<p>$servername = &#8220;localhost&#8221;;<br \/>\n$username = &#8220;kullanici_adi&#8221;;<br \/>\n$password = &#8220;sifre&#8221;;<br \/>\n$dbname = &#8220;veritabani_adi&#8221;;<\/p>\n<p>$conn = mysqli_connect($servername, $username, $password, $dbname);<\/p>\n<p>if (!$conn) {<br \/>\n    die(&#8220;Ba\u011flant\u0131 hatas\u0131: &#8221; . mysqli_connect_error());<br \/>\n}<\/p>\n<p>Yukar\u0131daki kodda, <strong>$servername<\/strong> de\u011fi\u015fkenine MariaDB sunucusunun ad\u0131n\u0131, <strong>$username<\/strong> de\u011fi\u015fkenine kullan\u0131c\u0131 ad\u0131n\u0131, <strong>$password<\/strong> de\u011fi\u015fkenine \u015fifreyi ve <strong>$dbname<\/strong> de\u011fi\u015fkenine veritaban\u0131n\u0131n ad\u0131n\u0131 atad\u0131k. Ard\u0131ndan, <strong>mysqli_connect()<\/strong> i\u015flevini kullanarak ba\u011flant\u0131y\u0131 ger\u00e7ekle\u015ftiriyoruz. E\u011fer ba\u011flant\u0131 ba\u015far\u0131s\u0131z olursa, <strong>mysqli_connect_error()<\/strong> i\u015flevi taraf\u0131ndan bir hata mesaj\u0131 g\u00f6r\u00fcnt\u00fclenir.<\/p>\n<p>Ba\u011flant\u0131 ba\u015far\u0131l\u0131 bir \u015fekilde ger\u00e7ekle\u015ftirildiyse, art\u0131k MariaDB veritaban\u0131yla \u00e7e\u015fitli i\u015flemler yapabiliriz. Ba\u011flant\u0131y\u0131 kapatmak i\u00e7in <strong>mysqli_close()<\/strong> i\u015flevini kullanabiliriz. A\u015fa\u011f\u0131da \u00f6rnek bir kod blo\u011funu g\u00f6rebilirsiniz:<\/p>\n<p>\/\/ Ba\u011flant\u0131y\u0131 ger\u00e7ekle\u015ftir<\/p>\n<p>\/\/ Veritaban\u0131 \u00fczerinde i\u015flemler ger\u00e7ekle\u015ftir<\/p>\n<p>mysqli_close($conn);<\/p>\n<p>Yukar\u0131daki kodda, <strong>mysqli_close()<\/strong> i\u015flevini kullanarak ba\u011flant\u0131y\u0131 kapat\u0131yoruz. Bu, MariaDB sunucusuyla olan ba\u011flant\u0131y\u0131 sonland\u0131r\u0131r ve kaynaklar\u0131 serbest b\u0131rak\u0131r. Bununla birlikte, ba\u011flant\u0131n\u0131n her zaman kapat\u0131lmas\u0131 zorunlu olmasa da, iyi bir uygulama y\u00f6ntemi olarak d\u00fc\u015f\u00fcn\u00fclmelidir.<\/p>\n<p>PHP ile MariaDB veritaban\u0131na ba\u011flant\u0131 kurmak olduk\u00e7a basittir. Yukar\u0131daki ad\u0131mlar\u0131 takip ederek, web siteniz veya uygulaman\u0131z i\u00e7in bir veritaban\u0131 ba\u011flant\u0131s\u0131 olu\u015fturabilir ve MariaDB \u00fczerinde \u00e7e\u015fitli i\u015flemler ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"MariaDB_ile_PHP_uzerinden_veri_ekleme_ve_sorgulama\"><\/span>MariaDB ile PHP \u00fczerinden veri ekleme ve sorgulama<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>MariaDB, pop\u00fcler bir veritaban\u0131 y\u00f6netim sistemidir ve PHP programlama diliyle entegre \u00e7al\u0131\u015fabilir. Bu yaz\u0131da, MariaDB ile PHP \u00fczerinden veri ekleme ve sorgulama i\u015flemlerini nas\u0131l ger\u00e7ekle\u015ftirebilece\u011fimizi \u00f6\u011frenece\u011fiz.<\/p>\n<p><strong>Veri Ekleme:<\/strong><\/p>\n<p>MariaDB ile PHP \u00fczerinden veri eklemek i\u00e7in \u00f6ncelikle bir ba\u011flant\u0131 olu\u015fturmam\u0131z gerekmektedir. Ba\u011flant\u0131y\u0131 sa\u011flamak i\u00e7in mysqli_connect() fonksiyonunu kullanabiliriz. A\u015fa\u011f\u0131da \u00f6rnek bir ba\u011flant\u0131 kodu bulunmaktad\u0131r:<\/p>\n<table>\n<tr>\n<th>Kod \u00d6rne\u011fi:<\/th>\n<\/tr>\n<tr>\n<td>&lt;?php<br \/>\n$servername = &#8220;localhost&#8221;;<br \/>\n$username = &#8220;kullanici_adi&#8221;;<br \/>\n$password = &#8220;sifre&#8221;;<br \/>\n$dbname = &#8220;veritabani_adi&#8221;;<br \/>\n\/\/ Ba\u011flant\u0131y\u0131 olu\u015ftur<br \/>\n$conn = mysqli_connect($servername, $username, $password, $dbname);<br \/>\n\/\/ Ba\u011flant\u0131y\u0131 kontrol et<br \/>\nif (!$conn) {<br \/>\n    die(&#8220;Ba\u011flant\u0131 hatas\u0131: &#8221; . mysqli_connect_error());<br \/>\n}?&gt;<\/td>\n<\/tr>\n<\/table>\n<p>Ba\u011flant\u0131y\u0131 olu\u015fturduktan sonra, INSERT INTO SQL komutunu kullanarak veri ekleyebiliriz. A\u015fa\u011f\u0131da \u00f6rnek bir veri ekleme kodu bulunmaktad\u0131r:<\/p>\n<table>\n<tr>\n<th>Kod \u00d6rne\u011fi:<\/th>\n<\/tr>\n<tr>\n<td>&lt;?php<br \/>\n$sql = &#8220;INSERT INTO users (name, email, password) VALUES (&#8216;John Doe&#8217;, &#8216;johndoe@example.com&#8217;, &#8216;123456&#8217;);&#8221;;<\/p>\n<p>if (mysqli_query($conn, $sql)) {<br \/>\n    echo &#8220;Veri ba\u015far\u0131yla eklendi&#8221;;<br \/>\n} else {<br \/>\n    echo &#8220;Hata: &#8221; . mysqli_error($conn);<br \/>\n}?&gt;<\/td>\n<\/tr>\n<\/table>\n<p><strong>Veri Sorgulama:<\/strong><\/p>\n<p>MariaDB ile PHP \u00fczerinden veri sorgulamak i\u00e7in SELECT SQL komutunu kullanabiliriz. A\u015fa\u011f\u0131da \u00f6rnek bir veri sorgulama kodu bulunmaktad\u0131r:<\/p>\n<table>\n<tr>\n<th>Kod \u00d6rne\u011fi:<\/th>\n<\/tr>\n<tr>\n<td>&lt;?php<br \/>\n$sql = &#8220;SELECT * FROM users;&#8221;;<br \/>\n$result = mysqli_query($conn, $sql);<\/p>\n<p>if (mysqli_num_rows($result) > 0) {<br \/>\n    while($row = mysqli_fetch_assoc($result)) {<br \/>\n        echo &#8220;ID: &#8221; . $row[&#8220;id&#8221;]. &#8221; &#8211; Name: &#8221; . $row[&#8220;name&#8221;]. &#8221; &#8211; Email: &#8221; . $row[&#8220;email&#8221;]. &#8220;&#8221;;<br \/>\n    }<br \/>\n} else {<br \/>\n    echo &#8220;Veritaban\u0131nda hi\u00e7 kay\u0131t bulunamad\u0131&#8221;;<br \/>\n}?&gt;<\/td>\n<\/tr>\n<\/table>\n<p>Yukar\u0131daki \u00f6rnekte, SELECT * FROM users ifadesiyle &#8220;users&#8221; tablosundaki t\u00fcm verileri sorgulad\u0131k. Sorgu sonucunda e\u015fle\u015fen kay\u0131tlar varsa, while d\u00f6ng\u00fcs\u00fc ile bu kay\u0131tlar\u0131 ekrana yazd\u0131rd\u0131k. E\u011fer hi\u00e7 kay\u0131t bulunamazsa, &#8220;Veritaban\u0131nda hi\u00e7 kay\u0131t bulunamad\u0131&#8221; mesaj\u0131n\u0131 g\u00f6sterdik.<\/p>\n<p>MariaDB ile PHP \u00fczerinden veri ekleme ve sorgulama i\u015flemlerini bu \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz. MariaDB&#8217;nin sa\u011flad\u0131\u011f\u0131 g\u00fc\u00e7l\u00fc \u00f6zellikler ve PHP&#8217;nin esnekli\u011fi sayesinde, veritaban\u0131 i\u015flemlerini kolayl\u0131kla yapabilirsiniz.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Python_ile_MariaDB_veritabani_entegrasyonu\"><\/span>Python ile MariaDB veritaban\u0131 entegrasyonu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Python ile MariaDB Veritaban\u0131 Entegrasyonu<\/strong><\/p>\n<p>Python, <a href=\"https:\/\/sunucucozumleri.com\/blog\/veri-tabani-sunucusu-kiralama\/\">veri taban\u0131<\/a> y\u00f6netimi i\u00e7in bir\u00e7ok se\u00e7ene\u011fe sahip etkili bir programlama dilidir. Bu se\u00e7eneklerden biri de MariaDB ile entegrasyonu sa\u011flamakt\u0131r. MariaDB, MySQL tabanl\u0131 bir veritaban\u0131 y\u00f6netim sistemidir ve Python&#8217;un g\u00fc\u00e7l\u00fc \u00f6zelliklerini kullanarak veri ekleme, sorgulama ve y\u00f6netim i\u015flemlerini ger\u00e7ekle\u015ftirebiliriz.<\/p>\n<p>Python ile MariaDB entegrasyonu yapabilmek i\u00e7in \u00f6ncelikle <strong>mysql-connector-python<\/strong> ad\u0131n\u0131 verdi\u011fimiz Python mod\u00fcl\u00fcn\u00fc y\u00fcklememiz gerekmektedir. Bu mod\u00fcl, MariaDB veritaban\u0131na ba\u011flanmam\u0131z\u0131 sa\u011flar ve veri taban\u0131 i\u015flemlerini ger\u00e7ekle\u015ftirmemize yard\u0131mc\u0131 olur.<\/p>\n<p>MariaDB veritaban\u0131na ba\u011flant\u0131 kurabilmek i\u00e7in Python&#8217;da a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip etmemiz yeterlidir:<\/p>\n<ol>\n<li>mysql-connector-python mod\u00fcl\u00fcn\u00fc y\u00fckleyin: <strong>pip install mysql-connector-python<\/strong><\/li>\n<li>Python dosyan\u0131zda mod\u00fcl\u00fc i\u00e7e aktar\u0131n: <strong>import mysql.connector<\/strong><\/li>\n<li>Veritaban\u0131 ba\u011flant\u0131s\u0131 olu\u015fturun: <strong>mydb = mysql.connector.connect(host=&#8221;localhost&#8221;, user=&#8221;root&#8221;, password=&#8221;password&#8221;, database=&#8221;databasename&#8221;)<\/strong><\/li>\n<li>Veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131 kontrol edin ve i\u015flem yap\u0131n: <strong>if mydb.is_connected():<\/strong>\n<ul>\n<li># Veritaban\u0131na sorgu g\u00f6nderme<\/li>\n<li># Veri ekleme<\/li>\n<li># Veri sorgulama<\/li>\n<li># Veri g\u00fcncelleme veya silme<\/li>\n<\/ul>\n<\/li>\n<li>Ba\u011flant\u0131y\u0131 kapat\u0131n: <strong>mydb.close()<\/strong><\/li>\n<\/ol>\n<p>Bu ad\u0131mlar\u0131 takip ederek Python ile MariaDB veritaban\u0131na ba\u011flant\u0131 kurabilir ve veri ekleme, sorgulama, g\u00fcncelleme veya silme gibi i\u015flemleri ger\u00e7ekle\u015ftirebilirsiniz. Python&#8217;un esnekli\u011fi ve MariaDB&#8217;nin veri taban\u0131 y\u00f6netim kapasitesi birle\u015ferek etkili bir \u015fekilde veri taban\u0131 entegrasyonu sunar.<\/p>\n<table>\n  \u00d6rnek bir MariaDB Veritaban\u0131 Tablosu<\/p>\n<tr>\n<th>ID<\/th>\n<th>Ad<\/th>\n<th>Soyad<\/th>\n<th>Ya\u015f<\/th>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Ahmet<\/td>\n<td>Y\u0131lmaz<\/td>\n<td>25<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Ali<\/td>\n<td>Demir<\/td>\n<td>32<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Ay\u015fe<\/td>\n<td>Kaya<\/td>\n<td>28<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB, MySQL&#8217;in a\u00e7\u0131k kaynakl\u0131 bir dal\u0131d\u0131r ve bir\u00e7ok geli\u015ftirici ve \u015firket taraf\u0131ndan tercih edilen bir veritaban\u0131 y\u00f6netim sistemi olarak kullan\u0131lmaktad\u0131r. Bu blog yaz\u0131s\u0131nda, MariaDB&#8217;nin ne oldu\u011funu ve nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. PHP ile MariaDB veritaban\u0131na nas\u0131l ba\u011flant\u0131 kurabilece\u011fimizi, veri ekleme ve sorgulama i\u015flemlerini nas\u0131l ger\u00e7ekle\u015ftirebilece\u011fimizi ve hatta Python ile nas\u0131l entegre edebilece\u011fimizi \u00f6\u011frenece\u011fiz. Hem PHP hem &hellip;<\/p>\n","protected":false},"author":6,"featured_media":4218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[236],"tags":[],"class_list":["post-4219","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/4219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=4219"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/4219\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/4218"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=4219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=4219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=4219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}