{"id":36,"date":"2010-12-02T16:17:49","date_gmt":"2010-12-02T07:17:49","guid":{"rendered":"http:\/\/www.psdks.com\/blog\/?p=36"},"modified":"2010-12-02T16:17:49","modified_gmt":"2010-12-02T07:17:49","slug":"php-mysql","status":"publish","type":"post","link":"http:\/\/www.psdks.com\/blog\/?p=36","title":{"rendered":"php mysql"},"content":{"rendered":"<p>&lt;?php<br \/>\nfunction sqlk($pn) {<\/p>\n<p>\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u540d\u306e\u8a2d\u5b9a<br \/>\n$db_host\u00a0\u00a0 = &#8220;localhost&#8221;;<\/p>\n<p>\/\/\u30e6\u30fc\u30b6\u540d\u306e\u8a2d\u5b9a<br \/>\n$db_user\u00a0\u00a0 = &#8220;user&#8221;;<\/p>\n<p>\/\/\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a<br \/>\n$db_passwd = &#8220;passwd&#8221;;<\/p>\n<p>\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u3078\u306e\u63a5\u7d9a<br \/>\n$db = mysql_connect($db_host,$db_user,$db_passwd);<\/p>\n<p>\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306e\u8a2d\u5b9a<br \/>\n$db_name = &#8220;dbname&#8221;;<\/p>\n<p>\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u9078\u629e<br \/>\nmysql_select_db($db_name,$db);<br \/>\n\/\/\u30da\u30fc\u30b8\u5165\u529b<\/p>\n<p>\/\/SQL\u6587\u306e\u8a2d\u5b9a \u691c\u7d22\u6761\u4ef6(where)\u3068\u3000\u30bd\u30fc\u30c8(order)\u9006\u9806(desc)\u3092\u3057\u3066\u3044\u308b<br \/>\n$str_sql = &#8220;select * from hp where p1=$pn or p2=$pn or p3=$pn order by ID desc<br \/>\n&#8220;;<\/p>\n<p>\/\/SQL\u6587\u306e\u5b9f\u884c<br \/>\n$rs = mysql_query($str_sql,$db);<\/p>\n<p>\/\/\u7d50\u679c\u30bb\u30c3\u30c8\u5185\u306e\u5404\u30ec\u30b3\u30fc\u30c9\u3092\u9806\u6b21\u53c2\u7167\u3057\u3001\u9023\u60f3\u914d\u5217\u306b\u4ee3\u5165<br \/>\nwhile($arr_item = mysql_fetch_assoc($rs))<br \/>\n{<\/p>\n<p>\/\/\u30ec\u30b3\u30fc\u30c9\u5185\u306e\u5404\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3068\u5024\u3092\u9806\u6b21\u53c2\u7167<br \/>\n$re.=&#8221;&lt;p&gt;&lt;a href=\\&#8221;${arr_item[&#8216;link&#8217;]}\\&#8221; target=\\&#8221;_blank\\&#8221; class=\\&#8221;b1\\&#8221;&gt;${arr_item[&#8216;text&#8217;]}&lt;\/a&gt;&lt;\/p&gt;\\n&lt;p&gt;&amp;nbsp;&lt;\/p&gt;\\n&#8221; ;<\/p>\n<p>}<\/p>\n<p>\/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u3078\u306e\u63a5\u7d9a\u306e\u5207\u65ad<br \/>\nmysql_close($db);<br \/>\nreturn $re;<br \/>\n}<br \/>\n$hp1=sqlk(1);<br \/>\n$hp2=sqlk(2);<br \/>\nrequire &#8220;text\/index.txt&#8221;;<br \/>\n?&gt;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&lt;?php function sqlk($pn) { \/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc &hellip; <a href=\"http:\/\/www.psdks.com\/blog\/?p=36\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-36","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/36","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=36"}],"version-history":[{"count":1,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/36\/revisions"}],"predecessor-version":[{"id":37,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/36\/revisions\/37"}],"wp:attachment":[{"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.psdks.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}