<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/3e808986-5114-4a72-bd6a-de256d96566e/E55D0BA4-FF4D-462F-9BEF-959D2BB67462/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://phpspot.org/blog/archives/2006/06/phpmysqlrestphp.html" href="http://phpspot.org/blog/archives/2006/06/phpmysqlrestphp.html" style="font-size: 11px;">phpspot.org</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://phpspot.org/blog/archives/2006/06/phpmysqlrestphp.html"><DIV class='entrybody'><div> <a href="http://phprestsql.sourceforge.net/?" target="_blank">PHP REST SQL: A HTTP REST interface to MySQL written in PHP<img class="TargetAlertIcon" src="http://phpspot.org/blog/archives/2006/06/chrome://targetalert/content/skin/new.png"></a></div><br><blockquote>PHP REST SQL was built and tested using Apache 2.0.45, PHP 4.3.4, and MySQL 3.23, although it should work with any version of PHP4 and MySQL and any HTTP server that will pass requests of all HTTP method types to PHP.</blockquote> <p>PHPを使ってRESTによるMySQL操作を可能にするPHP REST SQL。</p> <p>サイト上の例を見るところによると具体的に、次のようなRESTインタフェースにてMySQL操作が可能になる模様。</p> <p>●データの取得<br>SELECT * FROM table WHERE uid = 1<br>↓<br>GET http://example.org/phprestsql/table/1/ HTTP/1.1 (HTTPのGETでデータを取得できる)</p> <p>●データの挿入<br>INSERT INTO table (field1, field2, field3) VALUES ("this", "that", "theother")<br>↓<br>POST http://example.org/phprestsql/table/ HTTP/1.1 (HTTPのPOSTでデータを挿入できる)<br><code><font face="ＭＳ ゴシック">field1=thisn<br>field2=thatn<br>field3=theothern</font></code></p> <p><code><font face="ＭＳ ゴシック">HTTPをベースプロトコルにすることで、用途によっては便利な使い方が出来るのかもしれませんね。<br>なかなか面白いと思いました。</font></code></p> </DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/E55D0BA4-FF4D-462F-9BEF-959D2BB67462/blog/" title="blog or email this clip"><img src="http://content9.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks:  Amplify.com - Don't just share the news...Amplify it!