{"id":1714,"date":"2017-06-08T17:57:00","date_gmt":"2017-06-08T08:57:00","guid":{"rendered":"https:\/\/yorozu.cloudfree.jp\/wordpress\/?p=1714"},"modified":"2024-04-19T07:55:57","modified_gmt":"2024-04-18T22:55:57","slug":"inquery","status":"publish","type":"post","link":"https:\/\/yorozu.cloudfree.jp\/wordpress\/?p=1714","title":{"rendered":"\u30a2\u30f3\u30b1\u30fc\u30c8\u96c6\u8a08"},"content":{"rendered":"\n

\uff11\uff0e\u30d7\u30ed\u30b0\u30e9\u30e0\u4ed5\u69d8<\/strong><\/h4>\n\n\n\n

\u3000\u7d44\u7e54\u5185\u3067\u30e1\u30f3\u30d0\u30fc\u306b\u30a2\u30f3\u30b1\u30fc\u30c8\u3092\u53d6\u308a\u3001\u96c6\u8a08\u3057\u305f\u7d50\u679c\u3092\u8868\u793a\u3059\u308b
\u3000\u3000\u3000\u30a2\u30f3\u30b1\u30fc\u30c8\u5185\u5bb9\u306f\u5225\u9014\u4f5c\u6210
\u3000\u3000\u3000\u5165\u529b\u5185\u5bb9\u306e\uff24\uff22\u4fdd\u5b58\u3068\u4fdd\u5b58\u5185\u5bb9\u306e\u7167\u4f1a\u90e8\u5206\u3092\u4f5c\u6210\u3059\u308b<\/p>\n\n\n\n

\uff12\uff0e\u30a2\u30f3\u30b1\u30fc\u30c8\u90e8\u5206<\/strong><\/h4>\n\n\n\n

\u3000\u30a2\u30f3\u30b1\u30fc\u30c8\u3078\u306e\u56de\u7b54\u3092\u5165\u529b\u3059\u308b\u90e8\u5206
\u3000\u3000\u3000\u4e8b\u524d\u767b\u9332\u6e08\u307f\u306e\u4f1a\u54e1\u540d\u3092\u9078\u629e\u3059\u308b\uff08\u533f\u540d\u306e\u9078\u629e\u3082\u53ef\uff09
\u3000\u3000\u3000\u5404\u30a2\u30f3\u30b1\u30fc\u30c8\u9805\u76ee\u306b\u300c\uff49\uff44\u300d\u756a\u53f7\u3092\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u9806\u6b21\u4ed8\u4e0e\u3057\u3066\u304a\u304f
\u3000\u3000\u3000\u3000\u3000\uff08\u4f8b\uff09Q1\u3001Q2\u30fb\u30fb\u30fb\u30fb
\u3000\u3000\u3000\u300c\u96c6\u8a08\u300d\u30dc\u30bf\u30f3\u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u308b\u3068
\u3000\u3000\u3000\u56de\u7b54\u306fNo.\uff13\uff14\u3067\u5b9a\u7fa9\u3057\u305f\u300cpost\u300d\u30e1\u30bd\u30c3\u30c9\u3067\u6b21\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u6e21\u3055\u308c\u308b<\/p>\n\n\n\n

\"\"<\/a>
\u30a2\u30f3\u30b1\u30fc\u30c8\u90e8\u5206\uff08\u898b\u672c\uff09<\/figcaption><\/figure>\n\n\n\n
<!DOCTYPE HTML PUBLIC "-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN">\n<html>\n  <head>\n<meta http-equiv="content-type" content="text\/html; charset=UTF-8">\n<meta name="GENERATOR" content="JustSystems Homepage Builder Version 17.0.15.0 for Windows">\n<meta http-equiv="Content-Style-Type" content="text\/css">\n<title>\u30b5\u30f3\u30d7\u30eb<\/title>\n  <\/head>\n  <body>\n\n<CENTER>\n<TABLE width=\u201c700\u201d>\n  <TBODY>\n    <TR>\n      <TD align=\u201ccenter\u201d>\u30af\u30e9\u30d6\u300c\u25cf\u25cf\u25cf\u25cf\u25cf\u300d\u4f1a\u54e1\u306e\u7686\u3055\u3093\u306b\u304a\u805e\u304d\u3057\u307e\u3059\u3002<\/TD>\n    <\/TR>\n  <\/TBODY>\n<\/TABLE>\n<\/CENTER>\n<DIV align=\u201ccenter\u201d>\n<HR style=\u201ccolor : aqua;background-color : lime;border-width : thick;\u201d align=\u201cright\u201d>\n  <table width=\u201c776\u201d>\n  <TBODY>\n    <TR>\n        <td align=\u201cleft\u201d width=\u201c733\u201d><FONT size=\u201c+2\u201d face=\u201c\u30e1\u30a4\u30ea\u30aa\u201d><B><I>\u3000\u3000\u3000\u5f53\u30af\u30e9\u30d6\u306b\u3064\u3044\u3066\u306e\u7686\u3055\u3093\u306e<br>\n        \u3000\u3000\u3000\u3000\u3000\u30d1\u30bd\u30b3\u30f3\u74b0\u5883\u3092\u304a\u805e\u304d\u3057\u307e\u3059<br>\n        <\/I><\/B><\/FONT>\u3000\u3000<b><font color=\u201c#000099\u201d>\u5404\u9805\u76ee\u306e\u8a72\u5f53\u3059\u308b\u25cb\u306e\u51e6\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30de\u30fc\u30ad\u30f3\u30b0\u3057\u3066\u304f\u3060\u3055\u3044<br>\n        \u3000\u3000\u306a\u304a\u8a18\u8ff0\u306e\u90e8\u5206\u304c\u3042\u308a\u307e\u3059\u304c\u8a18\u8ff0\u5165\u529b\u82e6\u624b\u306a\u65b9\u306f\u7a7a\u6b04\u306b\u3057\u3066\u9001\u4fe1\u3057\u3066\u304f\u3060\u3055\u3044<BR>\n          \u3000\u8a18\u8ff0\u90e8\u5206\u3067\u5165\u529b\u82e6\u624b\u306a\u65b9\u306f\u3001\u30e1\u30e2\u3068\u3057\u3066\u7d19\u306b\u304a\u540d\u524d\u3001\u9805\u756a\u3092\u66f8\u3044\u3066\u63d0\u51fa\u304a\u9858\u3044\u3057\u307e\u3059<\/font><\/b><\/td>\n      <\/TR>\n  <\/TBODY>\n<\/table>\n  <P>\u3000\u3000\u3000\u3000\u3000\u3000\u3000<\/P>\n<FORM action=\u201chttp:\/\/\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\/gathering.php\u201d method=\u201cPOST\u201d><BR>\n<INPUT type=\u201chidden\u201d name=\u201c_code\u201d value=\u201ckouza_data\u201d>\n  <table width=\u201c409\u201d>\n  <TBODY>\n    <TR>\n      <TD height=\u201c33\u201d width=\u201c77\u201d><B><FONT size=\u201c+1\u201d>\u304a\u540d\u524d<\/FONT><\/B><\/TD>\n      <TD height=\u201c33\u201d width=\u201c150\u201d> \u3000\u3000<SELECT size=\u201c1\u201d name=\u201cname\u201d style=\u201cfont-size : medium;\u201d>\n<OPTION value=\u201c\u25c7\u25c7\u25c7\u3055\u3093\u201d>\u25c7\u25c7\u25c7\u3055\u3093<\/OPTION>          \n<OPTION value=\u201c\u25c6\u25c6\u25c6\u3055\u3093\u201d>\u25c6\u25c6\u25c6\u3055\u3093<\/OPTION>\n        <\/SELECT>\u3000<\/TD>\n    <\/TR>\n  <\/TBODY>\n<\/table>\n  <TABLE border=\u201c1\u201d width=\u201c817\u201d cellspacing=\u201c0\u201d cellpadding=\u201c2\u201d>\n  <COL span=\u201c1\u201d width=\u201c30\u201d>\n  <COL span=\u201c1\u201d width=\u201c300\u201d>\n  <COL span=\u201c1\u201d width=\u201c400\u201d>\n  <TBODY>\n      <TR>\n      <TD bgcolor=\u201c#d3d5fc\u201d id=\u201cQ5_head\u201d>\uff31\uff11<\/TD>\n      <TD bgcolor=\u201c#defaf8\u201d width=\u201c376\u201d>\u30d1\u30bd\u30b3\u30f3\u306e\u7d4c\u9a13\u5e74\u6570\uff1f<\/TD>\n      <TD bgcolor=\u201c#ffffca\u201d width=\u201c374\u201d><\/TD>\n      <\/TR>   \n  <\/TBODY>\n<\/TABLE>\n<BR>\n\n\uff0a\uff0a\uff0a\uff0a\uff0a\u3000\u9014\u4e2d\u3000\u30a2\u30f3\u30b1\u30fc\u30c8\u9805\u76ee\u3000\u7701\u7565\u3000\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\n\n<BR> \n<P>\u304a\u75b2\u308c\u69d8\u3067\u3057\u305f\u3002\u300c\u9001\u4fe1\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u56de\u7b54\u3092\u9001\u4fe1\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/P>\n<input type=\u201csubmit\u201d value=\u201c\u9001\u4fe1\u201d>\n<HR>\n<\/FORM>\n<\/DIV>\n<CENTER><\/CENTER>\n<CENTER><\/CENTER>\n\n <\/body>\n<\/html>\n<\/code><\/pre><\/div>\n\n\n\n
\uff13\uff0e\u56de\u7b54\u3092DB\u3078\u4fdd\u5b58\u90e8\u5206<\/strong><\/h4>\n\n\n\n
\u3000\u6e21\u3055\u308c\u305f\u56de\u7b54\u7d50\u679c\u3092\uff24\uff22\u306b\u4fdd\u5b58\u3059\u308b\u90e8\u5206
\u3000\u3000\u3000\u65e2\u306b\u767b\u9332\u6e08\u307f\u306e\u65b9\u306a\u3089\u300cUpdate\u300d\u51e6\u7406
\u3000\u3000\u3000\u521d\u3081\u3066\u306e\u65b9\u306a\u3089\u300cInsert\u300d\u51e6\u7406<\/p>\n\n\n\n
<!DOCTYPE HTML PUBLIC "-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN">\n<html lang="ja-JP">\n<head>\n<meta http-equiv="Content-Type" content="text\/html; charset=UTF-8">\n<meta http-equiv="Content-Style-Type" content="text\/css">\n<meta http-equiv="Content-script-Type" content="text\/javascript">\n<link rel="stylesheet" href="index.css" type="text\/css" media="all">\n<title>\u30b5\u30f3\u30d7\u30eb<\/title>\n<\/head>\n<body >\n\n<?php\n\n\trequire('\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\/Common_Func.php');      \n\trequire('\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\/InquiryDB_Func.php');      \n\n\t$sName\t= $_POST['name']; \n\t$sQ1\t= $_POST['Q1']; \n\t$sQ2\t= $_POST['Q2']; \n\t$sQ3\t= $_POST['Q3']; \n\t$sQ4\t= $_POST['Q4']; \n\t$sQ5\t= $_POST['Q5']; \n\t$sQ6\t= $_POST['Q6']; \n\t$sQc1\t= $_POST['Qc1']; \n\t$sQ7\t= $_POST['Q7']; \n\t$sQ8\t= $_POST['Q8']; \n\t$sQ9\t= $_POST['Q9']; \n\t$sP1\t= $_POST['P1']; \n\t$sP2\t= $_POST['P2']; \n\t$sP3\t= $_POST['P3']; \n\t$sP4\t= $_POST['P4']; \n\t\n\t$cid\t= LearnDB_Open();  \n\n    $temp = "ok";\n    foreach ($sQc1 as $value)\n\t {\n\t    if ($temp == "ok")\n\t        {\n\t          $temp = $value;\n\t        }\n\t      else\n\t        {\n \t\t      $temp = $temp."\u3001".$value;\n\t        }\n\t }\n\n  \t$sql \t= "select * from $tRec_Name where ($Name = '$sName' )";   \n    $result\t= MySQL_query($sql,$cid)   \n                or die("failled to query of [$sql]");\n    $row \t= MySQL_fetch_array($result);           \n\n    if ($row[$Name] == $sName)\n      {\n        $sql \t= "update $tRec_Name set $Q1 = '$sQ1', $Q2 = '$sQ2', $Q3 = '$sQ3', $Q4 = '$sQ4', $Q5 = '$sQ5',\n                                         $Q6 = '$sQ6', $Qc1 = '$temp', $Q7 = '$sQ7', $Q8 = '$sQ8', $Q9 = '$sQ9',\n                                         $P1 = '$sP1', $P2 = '$sP2', $P3 = '$sP3', $P4 = '$sP4'\n        \t\t\twhere ($Name = '$sName')";   \n        $result\t= MySQL_query($sql,$cid)   \n                    or die("failled to query of [$sql]");\n    \n\t\tprint  "update";\n      }\n    else\n      {  \t\n\t\t$sql \t= "insert into $tRec_Name ($Name,$Q1,$Q2,$Q3,$Q4,$Q5,$Q6,$Qc1,$Q7,$Q8,$Q9,$P1,$P2,$P3,$P4) \n\t\t\t\t\tvalues('$sName','$sQ1','$sQ2','$sQ3','$sQ4','$sQ5','$sQ6','$temp','$sQ7','$sQ8','$sQ9','$sP1','$sP2','$sP3','$sP4')";   \n\t    $result\t= MySQL_query($sql,$cid)   \n                    or die("failled to query of [$sql]");\n      \n\t\tprint  "insert";\n      }                  \n\n\tLearnDB_Close($cid);\t\t\t\n?>\n<\/body>\n<\/html><\/code><\/pre><\/div>\n\n\n\n
\uff14\uff0e\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u306e\u7167\u4f1a\u90e8\u5206<\/strong><\/h4>\n\n\n\n
\u3000\u30a2\u30f3\u30b1\u30fc\u30c8\u306e\u56de\u7b54\u3092\uff24\uff22\u304b\u3089\u547c\u3073\u51fa\u3057\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b
\u3000\u3000\u3000\u540d\u524d\u9806\u306b\u5168\u4ef6\u3092\u8868\u793a\u5bfe\u8c61\u3068\u3059\u308b<\/p>\n\n\n\n
<!DOCTYPE HTML PUBLIC "-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN">\n<html lang="ja-JP">\n<head>\n<meta http-equiv="Content-Type" content="text\/html; charset=UTF-8">\n<meta http-equiv="Content-Style-Type" content="text\/css">\n<meta http-equiv="Content-script-Type" content="text\/javascript">\n<link rel="stylesheet" href="index.css" type="text\/css" media="all">\n<title>\u30b5\u30f3\u30d7\u30eb<\/title>\n<\/head>\n<body >\n\n<?php\n\n\trequire('\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\/Common_Func.php');      \n\trequire('\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\/InquiryDB_Func.php');      \n\n\t$cid\t= LearnDB_Open();  \n\n  \t$sql \t= "select * from $tRec_Name ORDER BY $Name";   \n    $result\t= MySQL_query($sql,$cid)   \n                or die("failled to query of [$sql]");\n    $row \t= MySQL_fetch_array($result);    \n    \n    while ($row = MySQL_fetch_array($result))\n      {    \n        print "*******************"."<br>";\n        print $row[$Name]."<br>";\n        print "\u3000\u3000\u3000Q1\u3000\u3000".$row[$Q1]."<br>";\n        print "\u3000\u3000\u3000Q2\u3000\u3000".$row[$Q2]."<br>";\n        print "\u3000\u3000\u3000Q3\u3000\u3000".$row[$Q3]."<br>";\n        print "\u3000\u3000\u3000Q4\u3000\u3000".$row[$Q4]."<br>";\n        print "\u3000\u3000\u3000Q5\u3000\u3000".$row[$Q5]."<br>";\n        print "\u3000\u3000\u3000Q6\u3000\u3000".$row[$Q6]."<br>";\n        print "\u3000\u3000\u3000Q7\u3000\u3000".$row[$Qc1]."<br>";\n        print "\u3000\u3000\u3000Q7\u3000\u3000".$row[$Q7]."<br>"; \n        print "\u3000\u3000\u3000Q8\u3000\u3000".$row[$Q8]."<br>";\n        print "\u3000\u3000\u3000Q9\u3000\u3000".$row[$Q9]."<br>";\n        print "\u3000\u3000\u3000P1\u3000\u3000".$row[$P1]."<br>";\n        print "\u3000\u3000\u3000P2\u3000\u3000".$row[$P2]."<br>";\n        print "\u3000\u3000\u3000P3\u3000\u3000".$row[$P3]."<br>";\n        print "\u3000\u3000\u3000P4\u3000\u3000".$row[$P4]."<br>";\n        print "*******************"."<br>";\n\n      }\n\n\tLearnDB_Close($cid);\t\t\t\n\n?>\n\n<\/body>\n<\/html>  <\/code><\/pre><\/div>\n\n\n\n
\uff15\uff0e\u88dc\u8db3\u8cc7\u6599<\/strong><\/h4>\n\n\n\n
\u3000\u5f53\u6642\u306e\u8cc7\u6599<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u30fbWeb\u4e0a\u3067\u30a2\u30f3\u30b1\u30fc\u30c8\u3092\u3068\u308a\u3001DB\u3078\u4fdd\u5b58\u3057\u3001\u7167\u4f1a\u3092\u884c\u3046\uff08\u554f\u5408\u305b\u51e6\u7406\u306e\u4f8b\uff09<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[21],"class_list":["post-1714","post","type-post","status-publish","format-standard","hentry","category-63_workshop","tag-develop"],"_links":{"self":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1714"}],"version-history":[{"count":0,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions"}],"wp:attachment":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}