Linux\/Unix \u00fczerinde C programlama dilini kullanarak Mysql’e ba\u011flanan bir program yazmak ve bu program\u0131 derlemek istiyorsan\u0131z \u00f6ncelikle a\u015fa\u011f\u0131daki paketlerin sistemde y\u00fckl\u00fc ve yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131 gereklidir.<\/p>\n
Yukar\u0131daki paketleri Centos \u00fczerinde yum ile, Ubuntu \u00fczerinde Synaptic ile y\u00fckleyebilirsiniz.<\/p>\n
E\u011fer Ubuntu \u00fczerinde mysql_config binarysini bulam\u0131yorsan\u0131z a\u015fa\u011f\u0131daki komutlar ile son mysql-devel paketini bularak y\u00fcklemelesiniz.<\/p>\n
hakan@hakan-laptop:~$ sudo aptitude search libmysqlclient\r\ni\u00a0\u00a0 libmysqlclient16<\/strong>\r\n<\/pre>\nYukar\u0131daki \u00e7\u0131kt\u0131y\u0131 ald\u0131ktan sonra libmyclientxx \u00f6rne\u011findeki xx bilgisini alarak a\u015fa\u011f\u0131daki komut \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131.<\/p>\n
hakan@hakan-laptop:~$ sudo apt-get install libmysqlclient16-dev\r\n<\/pre>\nEvet bu durumda mysql_config binarysi y\u00fcklenmi\u015f olmal\u0131.<\/p>\n
<\/p>\n
A\u015fa\u011f\u0131da verdi\u011fim \u00f6rnek kodu mysql.c olarak kaydedin.<\/p>\n
\/* Simple C program that connects to MySQL Database server*\/<\/span><\/em>\r\n#include<\/span><\/strong> <mysql.h><\/span>\r\n#include<\/span><\/strong> <stdio.h><\/span>\r\n\r\nmain<\/span><\/strong>()<\/span> {<\/span>\r\n MYSQL *<\/span>conn;<\/span>\r\n MYSQL_RES *<\/span>res;<\/span>\r\n MYSQL_ROW row;<\/span>\r\n\r\n char<\/span> *<\/span>server =<\/span> \"localhost\"<\/span>;<\/span>\r\n char<\/span> *<\/span>user =<\/span> \"root\"<\/span>;<\/span>\r\n char<\/span> *<\/span>password =<\/span> \"PASSWORD\"<\/span>;<\/span> \/* yazd\u0131g\u0131n\u0131z kullan\u0131c\u0131 i\u00e7in \u015fifre yaz\u0131n *\/<\/span><\/em>\r\n char<\/span> *<\/span>database =<\/span> \"mysql\"<\/span>;<\/span>\r\n\r\n conn =<\/span> mysql_init<\/span><\/strong>(<\/span>NULL);<\/span>\r\n\r\n \/* Connect to database *\/<\/span><\/em>\r\n if<\/span><\/strong> (!<\/span>mysql_real_connect<\/span><\/strong>(<\/span>conn,<\/span> server,<\/span>\r\n user,<\/span> password,<\/span> database,<\/span> 0<\/span>,<\/span> NULL,<\/span> 0<\/span>))<\/span> {<\/span>\r\n fprintf<\/span><\/strong>(<\/span>stderr,<\/span> \"%s<\/span>\\n<\/span>\"<\/span>,<\/span> mysql_error<\/span><\/strong>(<\/span>conn));<\/span>\r\n exit<\/span><\/strong>(<\/span>1<\/span>);<\/span>\r\n }<\/span>\r\n\r\n \/* send SQL query *\/<\/span><\/em>\r\n if<\/span><\/strong> (<\/span>mysql_query<\/span><\/strong>(<\/span>conn,<\/span> \"show tables\"<\/span>))<\/span> {<\/span>\r\n fprintf<\/span><\/strong>(<\/span>stderr,<\/span> \"%s<\/span>\\n<\/span>\"<\/span>,<\/span> mysql_error<\/span><\/strong>(<\/span>conn));<\/span>\r\n exit<\/span><\/strong>(<\/span>1<\/span>);<\/span>\r\n }<\/span>\r\n\r\n res =<\/span> mysql_use_result<\/span><\/strong>(<\/span>conn);<\/span>\r\n\r\n \/* output table name *\/<\/span><\/em>\r\n printf<\/span><\/strong>(<\/span>\"MySQL Tables in mysql database:<\/span>\\n<\/span>\"<\/span>);<\/span>\r\n while<\/span><\/strong> ((<\/span>row =<\/span> mysql_fetch_row<\/span><\/strong>(<\/span>res))<\/span> !=<\/span> NULL)<\/span>\r\n printf<\/span><\/strong>(<\/span>\"%s <\/span>\\n<\/span>\"<\/span>,<\/span> row[<\/span>0<\/span>]);<\/span>\r\n\r\n \/* close connection *\/<\/span><\/em>\r\n mysql_free_result<\/span><\/strong>(<\/span>res);<\/span>\r\n mysql_close<\/span><\/strong>(<\/span>conn);<\/span>\r\n}<\/span>\r\n<\/tt><\/pre>\nArt\u0131k mysql.c dosyas\u0131n\u0131 derleyebiliriz. Bunun i\u00e7in sisteminize \u00f6zel olarak mysqlin hangi library ve include dosya
\nlar\u0131n\u0131 kullanaca\u011f\u0131n\u0131 belirlemek i\u00e7in bize yard\u0131mc\u0131 olmas\u0131 a\u00e7\u0131s\u0131ndan mysql_config program\u0131ndan yararlanaca\u011f\u0131z.<\/p>\nA\u015fa\u011f\u0131daki komut ile mysql apisinin derleme a\u015famas\u0131nda sizin sisteminiz \u00fczerinde hangi librarylere ihtiyac\u0131 oldu\u011funu belirleyebilirsiniz.<\/p>\n
hakan@hakan-laptop:~$mysql_config --libs<\/code>\r\n-L\/usr\/lib64\/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L\/usr\/lib64 -lssl -lcrypto\r\n<\/pre>\nAyn\u0131 \u015fekilde a\u015fa\u011f\u0131daki komut ile mysql apisini derleyebilmek i\u00e7in gerekli include dosyalar\u0131n\u0131 tespit edebilirsiniz<\/p>\n
hakan@hakan-laptop:~$ mysql_config --cflags<\/code>\r\n-I\/usr\/include\/mysql -g -pipe -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 \\\r\n-D_LARGEFILE_SOURCE -fno-strict-aliasing\r\n<\/pre>\nEvet gereken k\u00fct\u00fcphane ve include dosyalar\u0131n\u0131 bildi\u011fimize g\u00f6re derleme komutunu verebiliriz.<\/p>\n
hakan@hakan:~$<\/strong> gcc -o mysql $(mysql_config --cflags) mysql.c $(mysql_config --libs)\r\n<\/strong><\/code>mysql.c: In function \u2018mysql\u2019:\r\nmysql.c:23: warning: incompatible implicit declaration of built-in function \u2018exit\u2019\r\nmysql.c:33: warning: incompatible implicit declaration of built-in function \u2018exit\u2019\r\n<\/pre>\nBu durumda e\u011fer yukar\u0131daki uyar\u0131 mesajlar\u0131ndan ba\u015fka mesaj almad\u0131ysan\u0131z mysql ad\u0131nda bir binary olu\u015fmu\u015f olmal\u0131. Olu\u015fan binary b\u00fcy\u00fck ihtimalle +x hakk\u0131 ile olu\u015facakt\u0131r fakat her ihtimale kar\u015f\u0131 izinlerine +x verelim ve olu\u015fan binaryimizi \u00e7al\u0131\u015ft\u0131ral\u0131m.<\/p>\n
hakan@hakan:~$ chmod +x mysql\r\nhakan@hakan:~$ .\/mysql\r\nMySQL Tables in mysql database:\r\ncolumns_priv\r\ndb\r\nfunc\r\nhelp_category\r\nhelp_keyword\r\nhelp_relation\r\nhelp_topic\r\nhost\r\ntables_priv\r\ntime_zone\r\ntime_zone_leap_second\r\ntime_zone_name\r\ntime_zone_transition\r\ntime_zone_transition_type\r\nuser \r\n\r\n\u00a0<\/strong>\u00a0<\/strong><\/code><\/pre>\nEvet C ile yazd\u0131\u011f\u0131m\u0131z program\u0131m\u0131z mysql ile haberle\u015ferek bize \u00e7\u0131kt\u0131 \u00fcretti. \u00d6rnek kodun i\u00e7erisindeki query \u00fczerinde de\u011fi\u015fikilk yaparak istedi\u011finiz bir ama\u00e7 i\u00e7in program yazabilirsiniz.<\/p>\n
Umar\u0131m faydal\u0131 bir payla\u015f\u0131m olmu\u015ftur, yeni bir yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle…<\/p>\n","protected":false},"excerpt":{"rendered":"
Linux\/Unix \u00fczerinde C programlama dilini kullanarak Mysql’e ba\u011flanan bir program yazmak ve bu program\u0131 derlemek istiyorsan\u0131z \u00f6ncelikle a\u015fa\u011f\u0131daki paketlerin sistemde y\u00fckl\u00fc ve yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131 gereklidir. mysql : MySQL binary ve k\u00fct\u00fcphaneleri mysqlclient : MySQL client taraf\u0131 i\u00e7in gerekli binary ve k\u00fct\u00fcphaneler<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,15],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/323"}],"collection":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=323"}],"version-history":[{"count":0,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/323\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}