Mooha-PHPのノードインターフェイス





私はしばしばプログラムのノードインターフェースを扱わなければなりませんでした。 モジュラー音楽アプリケーションから始まり、3次元グラフィックスを作成するためのパッケージで終わります。



プログラムロジックのグラフィカルな制御のアイデアは、常に非常にエレガントで、場合によっては唯一の成功したソリューションに思えました。 後に、音楽とビデオに加えて、プログラミング(主にPHP)に興味を持ち始めたとき、実験としても、仕事で出会った単純なタスクを実行するためのグラフィカルシェルを作成してみました。



ノードインターフェイス(またはグラフィカルプログラミング)の知識は、 Plogue Biduleプログラムから始まりました。 このアプリケーションは、リアルタイムサウンドコントロール用のモジュラープログラムファミリに属しています。 かつて、このプログラムは、いくつかの音楽プロジェクトのライブパフォーマンスでのサウンド処理とステージ機器の同期に関する非常に重要なタスクを解決するのに役立ちました。



Plogue Biduleプログラムのインターフェースは次のとおりです。







作業の中心にあるのは、論理チェーンの作成です。 一見すると複雑に見えるかもしれませんが、このアプローチは自然に音のある作品に収まるように思えます。 プログラム内のサウンドは、ソース(サウンドカード、オーディオファイル、または信号ジェネレーターの着信チャンネル)から表示される連続ストリームであり、いくつかの処理の後、ほとんどの場合、サウンドカードの出力に送信されるか、ファイルに書き込まれます。



インターフェイスの主な制御構造はノード(またはモジュール、ブロック、ノードなど)であり、本質的には機能です。 音楽機器との類推により、これらはワイヤーで接続されたデバイスです。







Plogue Biduleには、サウンドの操作に限定されない多くの興味深い機能が含まれていますが、この記事ではこの説明で十分です。



私の意見では、サウンドストリームは手続き型プログラムの流れに非常によく似ているため、音楽プログラムのノードインターフェイスに初めて触れたのは幸運でした。



ノードエディタは、3Dグラフィックを作成するためにグラフィックパッケージで広く使用されています。 このようなプログラムでは、「ブラックボックス」は最も複雑な構造と機能を表し、インターフェイスにより、実行ロジックを構築する際の自由度と柔軟性を節約できます。 私の意見では、 Houdiniプログラムでのノードシステムの実装の中で最も興味深いものです。







では、Webプログラミングについてはどうでしょうか? 同様のシステムを検索しても結果は得られませんでした。 おそらくそのような技術は単に必要ではないと思いました。 そして、私の考えは無能と素朴さから生まれた可能性が高いと。 しかし、そのような楽器を作成しようとする欲求は、私の疑問よりも強いことが判明しました。



そのため、 Moohaプロジェクトが誕生しました。



PHP、MySQL、HTML



便利なグラフィカルツールを得るために、これら3つのテクノロジーを1つのノードシステムにどのように組み合わせることができますか? ノードエディタで3Dグラフィックスを作成するプログラムは、多くの場合、コンテキストへの分離を使用します。コンテキストは通常​​、相互の互換性が不十分です。 しかし、私たちの場合、データ構造は個々のエディターを作成するほど複雑で異質ではありません。 そのため、テクノロジーごとにノードをカテゴリに分けて、単一のスペースを作成することにしました。







その考えは、テクノロジー間の移行をユーザーには見えないようにすることでした。 異なるカテゴリのノードを相互に接続して、プログラム実行の単一スレッドを作成します。



ノードの3つのカテゴリすべてを順番に検討してみましょう。



HTML / XMLノード







このようなノードを接続すると、HTMLドキュメントの最も単純な構造が得られます。 デフォルトでは、HTML / XMLノードには1つの入力と1つの出力があります。 入力(IN)はタグ内に配置され、出力(OUT)は結果の文字列です。 したがって、HTMLノードの最後の出力から、次の行を取得します。



<html> <head> <meta /> <script /> </head> <body> <div> <div /> <div /> </div> </body> </html>
      
      







「結合」サービスノードは、着信接続のソートに影響を与えるために使用されます。 ソートは、ノード自体のプロパティで使用できます。 最後のHTMLノードでは、2つの着信接続が、接続が発生した順序で連結されます。 つまり 最初に「HEAD」、次に「BODY」を接続した場合、その順序で最終行に表示されます。







ノードのプロパティにタグ属性を記述できますが、必要に応じて、着信接続のコネクタとして表示できます。 たとえば、コネクタ「id and class」をノード「my div」に追加すると、次の形式が得られます。







 <div id="my-id" class="my-class"> <div>my text</div> </div>
      
      







文字列値が「my-id」および「my-class」の変数は、属性に分類されます。 変数「my text」は、最初のdivタグのコンテンツになります。 変数は既にPHPノードです。これについては、以下で説明します。



コネクタとして、タグ内のテキストを置き換えるテンプレートを表示できます。 たとえば、所定のコンテンツを含む次のタグがある場合:



 <h1>Hello, %user%</h1>
      
      







また、template%user%がコネクタとして表示されている場合、次のようにこのテンプレートを変数に置き換えることができます。







最初のケースでは、ノード内のテキストがそのプロパティに登録され、データのコネクターがオフになり、テンプレートを置き換えるコネクターのみが表示されます。 2番目のケースでは、テンプレートを含むテキストも変数から取得されます。 そして、どちらの場合でも、出力は次のようになります。



 <h1>Hello, Mooha</h1>
      
      











もちろん、この方法でHTMLコードを作成することはほとんど意味がありません。 エディターには、個々のタグだけでなく、コード全体でノードを使用したり、外部ファイルに接続することもできます。



たとえば、置き換える2つのテンプレートを含むtemplate.tplファイルがあります:%title%と%content%。 ファイルの内容は次のとおりです。



 <html> <head> </head> <body> <h1>%title%</h1> <div>%content%</div> </body> </html>
      
      







ファイルを接続し、テンプレートを変数に置き換えるには、次のスキームを作成します。







その結果、以下が得られます。



 <html> <head> </head> <body> <h1>My article title</h1> <div>My article content</div> </body> </html>
      
      







すでにHTMLノードの説明を超えているため、次のタイプであるPHPノードに進みます。



PHPノード









これは、PHPノードを使用した算術計算と組み込みabs()関数の呼び出しの最も単純な例です。 ノードの名前は任意であり、各ノードのプロパティで変更できます。 便宜上、変数の値と算術演算の名前が見えるように名前を変更しました。

最初の3つのノード「1」、「2」、および「5」は、値が名前に対応する変数です。

つまり その結果、次のスクリプトを取得します。



 <?php print abs((1+2)-5); ?>
      
      







そして、出力はちょうど2です。







ノードシステムで一般的に使用される必要な論理構造を実装しようとしました。 たとえば、2つの変数の比較(または2つのスレッドの結果)は次のようになります。







結果はtrue(1!= 2)になります。



そして、これは条件に基づいてストリームを選択する方法です:







ここでは、ノードプロパティの各赤いコネクタに値が割り当てられ、オレンジ色のコネクタで受信した値と比較されます。 値が一致する場合、スイッチスイッチは対応するストリームをスキップします。 この例では、赤いコネクタの値は1、2、および3です。つまり、この設計の結果は「it was 2」になります。



接続内のすべてのチェーンでは、以前のすべてのフロー計算の最終値が送信されます。 したがって、次の例では、結果は「それは2」でしたが、結果の文字列はいくつかのアクションから組み立てられます。







次のコードが生成されます:



 $data = 2; switch ($data) { case "1": //        $result = "it was 1"; break; case "2"://        $result = str_replace("foo", "2", "in was foo"); break; case "3": //        $result = "it was 3"; break; default: $result=false; } var_dump($result);
      
      







コピーノードには特別な注意が払われます。コピーノードは、最初の接続の値に応じて、2番目の接続からテンプレートを伝播します。 これは、たとえば、HTMLコードを伝播し、その中のテンプレートを配列の値で置き換える必要がある場合に役立ちます。 1次元配列の最も単純な場合、このようなスキームは次のようになります。







わかりやすくするために、ノードを変数の値と呼びました。 最初のコネクタ(値用)ではJSON配列を実行し、2番目のコネクタでは置換用のテンプレートを使用したHTMLコードを実行します。 テンプレートコネクタに接続されたすべてのノード(またはノードのチェーン)は、最初のコネクタに接続された配列内の要素が存在する回数だけコピーされます。 同時に、そのような接続の左側にある各ノードには特別な設定があり、そのデータは配列の要素に置き換えられます。 この例では、段落のあるノードで、テンプレートのreplacement%number%が構成されています。 つまり この回路の結果は次のコードになります。



 <p>first paragraph</p> <p>second paragraph</p> <p>third paragraph</p>
      
      











オブジェクトの配列と複数のノードを使用した、より複雑な例を次に示します。







変数「JSON」には、次のオブジェクトの配列があります。



 [ {"title":"first title","content":"first content"}, {"title":"second title","content":"second content"} ]
      
      







タグ付きのノード内
   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`



JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]



SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1



:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'



:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC



AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')



UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'



DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'



PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24












%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








   %title%        "title" .      %content%        "content" .     : 
      



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24









%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24








%title% "title" . %content% "content" . :



<div> <h1>first title</h1> <p>first content</p> </div> <div> <h1>second title</h1> <p>second content</p> </div>












Copy foreach , . for, , , ( ).



MySQL







— , — SELECT, - . , "*", :



SELECT * FROM `authors`







JSON. "" :



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" }, { "id": "2", "Name": "Charles Michael Palahniuk", "Birthday": "1962-02-21" } ]







, :







:



["Iain Menzies Banks", "Charles Michael Palahniuk"]







SQL , . :







() :



SELECT * FROM `authors` WHERE id=1







:



[ { "id": "1", "Name": "Iain Menzies Banks", "Birthday": "1954-02-16" } ]







() :



SELECT * FROM `authors` WHERE Name LIKE '%Banks%'







:







SELECT * FROM `authors` WHERE (`Birthday` < '1990-01-01' AND `Birthday` > '1920-01-01') ORDER BY `Name` ASC







AND WHERE, ( , ORDER BY)







INSERT, UPDATE DELETE -, .



INSERT :







INSERT INTO `authors` (`id`, `Name`, `Birthday`) VALUES ('1', 'Iain Menzies Banks', '1954-02-16')







UPDATE:







UPDATE `authors` SET `Name`='Iain Banks', `Birthday`='1954-02-17' WHERE `id`='1'







DELETE:







DELETE FROM `authors` WHERE `Birthday`<'1954-02-17'







PDO.



, JOIN . , SQL . , , , MySQL .



" !"

, , (MySQL, PHP HTML) , :







library.tpl . :



<div> <select> <option value=''>all authors</option> %author-list% </select> </div> <br /> <div>%book-list%</div>







: %author-list% %book-list%. option, . — , — "book block", HTML . , ( jquery library.tpl).



%author-list% Copy ("Author Copy"), "authors" "option", , "value" id. "Author Copy" :



<option value='1'>Iain Menzies Banks</option> <option value='2'>Charles Michael Palahniuk</option> <option value='3'>Mikhail Bulgakov</option>







"book block" :



<div class='author-%author-id%'> <img width='100' src='images/%image%' align='left' /> <b>%title%</b> by <b>%author%</b> <br /> ISBN: %isbn%<br /> <small>%description%</small> <br clear='all'/> </div>







"books" "authors". "authors" . , "books".



:









. . — , , . :



— , . . -. , . , . , . (include), , . , . MySQL.



— PHP . — , . . , , , ( ).



— , . , . , , .



. -. , — Mooha.net .







:

HTML5 Canvas Javascript ( ) JQuery 2.0 ( ) Codemirror ( ) CKEditor ( ) Spectrum Colorpicker ( ) jQuery File Tree Plugin ( )

:

Apache 2.2.22 PHP 5.4.3 MySQL 5.5.24











All Articles