{"id":19,"date":"2023-11-10T20:35:34","date_gmt":"2023-11-10T20:35:34","guid":{"rendered":"http:\/\/superwebtasarim.com\/bilgibankasi\/?p=19"},"modified":"2023-11-20T12:29:26","modified_gmt":"2023-11-20T12:29:26","slug":"pdo-delete-query-pdo-sql-veri-silme-sql-veri-silme","status":"publish","type":"post","link":"https:\/\/superwebtasarim.com\/bilgibankasi\/php\/pdo-delete-query-pdo-sql-veri-silme-sql-veri-silme\/","title":{"rendered":"PDO Delete Query &#8211; Pdo Sql Veri Silme &#8211; Sql Veri Silme"},"content":{"rendered":"\n<p>PDO kullanarak bir kayd\u0131 silmek i\u00e7in \u015fu ad\u0131mlar\u0131 takip edebilirsiniz:<\/p>\n\n\n\n<ol>\n<li>PDO&#8217;yu kullanarak veritaban\u0131n\u0131za ba\u011flan\u0131n.<\/li>\n\n\n\n<li>Kayd\u0131 silmek i\u00e7in bir a\u00e7\u0131klama haz\u0131rlay\u0131n.<\/li>\n\n\n\n<li>Gerekli parametreleri ifadeye ba\u011flay\u0131n.<\/li>\n\n\n\n<li>\u0130fadeyi y\u00fcr\u00fct\u00fcn.<\/li>\n\n\n\n<li>Bildirimi ve ba\u011flant\u0131y\u0131 kapat\u0131n.<\/li>\n<\/ol>\n\n\n\n<p>Bunun kodda nas\u0131l g\u00f6r\u00fcnebilece\u011fine dair bir \u00f6rnek:<\/p>\n\n\n\n<p>&#8220;`php<br>\/\/Veritaban\u0131na ba\u011flan\u0131n<br>$dsn = &#8216;mysql:host=localhost;dbname=my_database&#8217;;<br>$kullan\u0131c\u0131ad\u0131 = &#8216;kullan\u0131c\u0131_ad\u0131m&#8217;;<br>$\u015fifre = &#8216;\u015fifrem&#8217;;<br>$se\u00e7enekler = [<br>PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION,<br>PDO::ATTR_DEFAULT_FETCH_MODE =&gt; PDO::FETCH_ASSOC,<br>PDO::ATTR_EMULATE_PREPARES =&gt; yanl\u0131\u015f,<br>];<br>denemek {<br>$pdo = new PDO($dsn, $kullan\u0131c\u0131ad\u0131, $\u015fifre, $se\u00e7enekler);<br>} catch (PDOException $e) {<br>\/\/ Ba\u011flant\u0131 hatalar\u0131n\u0131 y\u00f6net<br>die(&#8220;Ba\u011flant\u0131 ba\u015far\u0131s\u0131z oldu: &#8221; . $e-&gt;getMessage());<br>}<\/p>\n\n\n\n<p>\/\/ Kayd\u0131 silmek i\u00e7in ifadeyi haz\u0131rlay\u0131n<br>$stmt = $pdo-&gt;prepare(&#8216;my_table&#8217;dan DELETE FROM WHERE id = :id&#8217;);<\/p>\n\n\n\n<p>\/\/ Parametreyi ifadeye ba\u011fla<br>$stmt-&gt;bindParam(&#8216;:id&#8217;, $id, PDO::PARAM_INT);<\/p>\n\n\n\n<p>\/\/ Parametrenin de\u011ferini ayarl\u0131yoruz<br>$id = 123;<\/p>\n\n\n\n<p>\/\/ \u0130fadeyi \u00e7al\u0131\u015ft\u0131r<br>$stmt-&gt;execute();<\/p>\n\n\n\n<p>\/\/ \u0130fadeyi ve ba\u011flant\u0131y\u0131 kapat<br>$stmt = bo\u015f;<br>$pdo = bo\u015f;<br>&#8221;&#8221;<\/p>\n\n\n\n<p>Bu \u00f6rnekte, PDO kullanarak bir MySQL veritaban\u0131na ba\u011flan\u0131yoruz, belirli bir kimli\u011fe sahip bir kayd\u0131 silmek i\u00e7in bir ifade haz\u0131rl\u0131yoruz, ID parametresini ifadeye ba\u011fl\u0131yoruz, ifadeyi \u00e7al\u0131\u015ft\u0131r\u0131yoruz ve ard\u0131ndan ifadeyi ve ba\u011flant\u0131y\u0131 kapat\u0131yoruz. Ayr\u0131ca olu\u015fabilecek ba\u011flant\u0131 hatalar\u0131n\u0131 ele almak i\u00e7in PDO&#8217;nun hata i\u015fleme \u00f6zelliklerini kulland\u0131\u011f\u0131m\u0131z\u0131 unutmay\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PDO kullanarak bir kayd\u0131 silmek i\u00e7in \u015fu ad\u0131mlar\u0131 takip edebilirsiniz: Bunun kodda nas\u0131l g\u00f6r\u00fcnebilece\u011fine dair bir \u00f6rnek: &#8220;`php\/\/Veritaban\u0131na ba\u011flan\u0131n$dsn = &#8216;mysql:host=localhost;dbname=my_database&#8217;;$kullan\u0131c\u0131ad\u0131 = &#8216;kullan\u0131c\u0131_ad\u0131m&#8217;;$\u015fifre = &#8216;\u015fifrem&#8217;;$se\u00e7enekler = [PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE =&gt; PDO::FETCH_ASSOC,PDO::ATTR_EMULATE_PREPARES =&gt; yanl\u0131\u015f,];denemek {$pdo = new PDO($dsn, $kullan\u0131c\u0131ad\u0131, $\u015fifre, $se\u00e7enekler);} catch (PDOException $e) {\/\/ Ba\u011flant\u0131 hatalar\u0131n\u0131 y\u00f6netdie(&#8220;Ba\u011flant\u0131 ba\u015far\u0131s\u0131z oldu: &#8221; . $e-&gt;getMessage());} \/\/ Kayd\u0131 silmek [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,4,5],"tags":[],"_links":{"self":[{"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/posts\/19"}],"collection":[{"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":2,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":35,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/posts\/19\/revisions\/35"}],"wp:attachment":[{"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/superwebtasarim.com\/bilgibankasi\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}