{"id":817,"date":"2024-05-22T14:12:53","date_gmt":"2024-05-22T05:12:53","guid":{"rendered":"https:\/\/www.ambulo.tv\/blog\/?p=817"},"modified":"2024-10-05T10:52:51","modified_gmt":"2024-10-05T01:52:51","slug":"pdo","status":"publish","type":"post","link":"https:\/\/www.ambulo.tv\/blog\/pdo\/","title":{"rendered":"PDO"},"content":{"rendered":"\n

https:\/\/codezine.jp\/article\/detail\/5736?p=2<\/a><\/p>\n\n\n\n

\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 : sqlsrv_connect\u95a2\u6570\u3092\u4f7f\u7528\u3057\u305fSQL Server\u3078\u306e\u63a5\u7d9a<\/p>\n\n\n\n

<html>\n    <head>\n        <title><\/title>\n    <\/head>\n    <body>\n<?php\n\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u6307\u5b9a\n$serverName = \".\\\\SQLEXPRESS\";\n\/\/\u63a5\u7d9a\u60c5\u5831\u3092\u6307\u5b9a\n$connectionInfo = array(\"UID\"=>\"sa\",\n                \"PWD\"=>\"password\",\n                \"Database\"=>\"MyDB\",\n                \"CharacterSet\"=>\"UTF-8\");\n\/\/\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3092\u78ba\u7acb\n$conn = sqlsrv_connect($serverName, $connectionInfo);\n\/\/\u30af\u30a8\u30ea\u30fc\u6587\u3092\u6307\u5b9a\n$tsql = \"SELECT * from staffs\";\n\/\/\u30af\u30a8\u30ea\u30fc\u3092\u5b9f\u884c\n$result = sqlsrv_query($conn, $tsql);\n?>\n  <table>\n<caption>\u30b9\u30bf\u30c3\u30d5\u30ea\u30b9\u30c8<\/caption>\n<?php\n    \/\/\u5b9f\u884c\u7d50\u679c\u3092\u63cf\u753b\n    while($row = sqlsrv_fetch_array($result)) {\n         printf(\"<tr><td class='hdr'>\".$row['id'].\"<\/td>\");\n        printf(\"<td>\".$row['name'].\"<\/td><\/tr>\");\n    }\n?>\n<\/table>\n<?php\n\/\/\u30af\u30a8\u30ea\u30fc\u7d50\u679c\u306e\u958b\u653e\nsqlsrv_free_stmt($result);\n\/\/\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u306e\u30af\u30ed\u30fc\u30ba\nsqlsrv_close($conn);\n?>\n    <\/body>\n<\/html><\/code><\/pre>\n\n\n\n
\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 : PDO\u3092\u4f7f\u7528\u3057\u305fSQL Server\u3078\u306e\u63a5\u7d9a<\/p>\n\n\n\n
<html>\n<head><title>PHP TEST<\/title>\n<style type=\"text\/css\">\n    table{\n        border-color:skyblue;\n        border-style:solid;\n        boder-widht:1px;\n        width:300px;\n        }\n    .hdr{background-color:gainsboro}\n<\/style>\n<\/head>\n<body>\n<table>\n<caption>\u30b9\u30bf\u30c3\u30d5\u30ea\u30b9\u30c8<\/caption>\n<?php\n$dsn = 'sqlsrv:server=.\\sqlexpress;database=MyDB';\n$user = 'sa';\n$password = 'P@ssword';\n    $dbh = new PDO($dsn, $user, $password);\n    $sql = \"select * from staffs\";\n    foreach ($dbh->query($sql) as $row) {\n        print(\"<tr><td class='hdr'>\".$row['id'].\"<\/td>\");\n        print(\"<td>\".$row[\"name\"].\"<\/td><\/tr>\");\n    }\n$dbh = null;\n?>\n<\/table>\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
$dsn = 'mysql:host=localhost;dbname=MyDB';\n$user = 'root';\n$password = 'P@ssword<\/code><\/pre>\n\n\n\n
\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30bb\u30f3\u30bf\u30fc – Microsoft Drivers for PHP for SQL Server<\/a><\/p>\n\n\n\n
PDO\u306e\u5229\u7528<\/a><\/p>\n\n\n\n
PHP\u306ePDO\u3067\u30ab\u30e9\u30e0\u306bNULL\u3092\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
https:\/\/codezine.jp\/article\/de…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,22,21],"tags":[],"class_list":["post-817","post","type-post","status-publish","format-standard","hentry","category-php","category-sqlserver","category-21","article","has-background","has-excerpt","has-avatar","has-author","has-date","has-comment-count","has-category-meta","has-read-more","thumbnail-"],"_links":{"self":[{"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/posts\/817"}],"collection":[{"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/comments?post=817"}],"version-history":[{"count":2,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":822,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions\/822"}],"wp:attachment":[{"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ambulo.tv\/blog\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}