🛵 ✌🏼 ☝🏿 Mooha - PHP के लिए नोड इंटरफ़ेस 🐇 ⛹🏿 📥

मुझे अक्सर कार्यक्रमों में नोड इंटरफेस से निपटना पड़ता था। तीन-आयामी ग्राफिक्स बनाने के लिए पैकेज के साथ समाप्त होने वाले मॉड्यूलर संगीत अनुप्रयोगों के साथ शुरू होता है।

प्रोग्राम लॉजिक के चित्रमय नियंत्रण का विचार मुझे हमेशा बहुत ही सुंदर लगा, और कुछ मामलों में, एकमात्र सफल समाधान। बाद में, जब संगीत और वीडियो के अलावा, मुझे प्रोग्रामिंग (ज्यादातर पीएचपी, ऐसा हुआ) में दिलचस्पी हो गई, तो मैं एक सरल प्रयोग के रूप में, उन सरल कार्यों को करने के लिए एक ग्राफिकल शेल बनाने की कोशिश करना चाहता था जो मुझे अपने काम में मिले थे।

नोड इंटरफेस (या ग्राफिकल प्रोग्रामिंग) के साथ मेरा परिचय प्लॉग बिड्यूल कार्यक्रम के साथ शुरू हुआ। यह एप्लिकेशन वास्तविक समय ध्वनि नियंत्रण के लिए मॉड्यूलर कार्यक्रमों के परिवार से संबंधित है। एक समय में, इस कार्यक्रम ने मुझे मेरे कई म्यूज़िकल प्रोजेक्ट्स के लाइव परफॉरमेंस में साउंड प्रोसेसिंग और स्टेज इक्विपमेंट को सिंक्रोनाइज़ करने के बारे में काफी गैर-तुच्छ कार्यों को हल करने में मदद की।

Plogue Bidule प्रोग्राम का इंटरफ़ेस इस प्रकार है:

काम के दिल में तार्किक श्रृंखलाओं का निर्माण है। यह मुझे लगता है कि यह दृष्टिकोण स्वाभाविक रूप से ध्वनि के साथ काम में फिट बैठता है, हालांकि यह पहली नजर में किसी के लिए जटिल लग सकता है। एक कार्यक्रम में एक ध्वनि एक सतत धारा है जो एक स्रोत (एक साउंड कार्ड, एक ऑडियो फ़ाइल, या एक सिग्नल जनरेटर के एक आने वाले चैनल) से प्रकट होती है, और कुछ प्रसंस्करण के बाद सबसे अधिक बार साउंड कार्ड के आउटपुट या किसी फ़ाइल पर लिखने के लिए भेजा जाता है।

इंटरफ़ेस का मुख्य नियंत्रण निर्माण नोड्स (या मॉड्यूल, ब्लॉक, नोड्स, आदि) हैं, जो अनिवार्य रूप से कार्य करते हैं। संगीत उपकरण के अनुरूप, ये तार द्वारा जुड़े उपकरण हैं।

प्लॉग बिड्यूल में कई दिलचस्प विशेषताएं शामिल हैं जो केवल ध्वनि के साथ काम करने तक सीमित नहीं हैं, लेकिन इस लेख के लिए यह विवरण पर्याप्त होगा।

मैं पहली बार एक संगीत कार्यक्रम में नोड इंटरफेस से परिचित होने के लिए भाग्यशाली था, क्योंकि ध्वनि स्ट्रीम, मेरी राय में, एक प्रक्रियात्मक कार्यक्रम के प्रवाह के लिए एक उत्कृष्ट सादृश्य है।

3 डी ग्राफिक्स बनाने के लिए ग्राफिक्स पैकेज में नोड संपादकों का व्यापक रूप से उपयोग किया जाता है। ऐसे कार्यक्रमों में, "ब्लैक बॉक्स" सबसे जटिल संरचनाओं और कार्यों का वर्णन करते हैं, और इंटरफ़ेस आपको निष्पादन तर्क को बनाने में स्वतंत्रता और लचीलेपन को बचाने की अनुमति देता है। सबसे दिलचस्प, मेरी राय में, हौदिनी कार्यक्रम में नोड सिस्टम का कार्यान्वयन।

तो वेब प्रोग्रामिंग के बारे में क्या? समान सिस्टम की खोज से कोई परिणाम नहीं मिला। मैंने सोचा कि शायद ऐसी तकनीक जरूरी नहीं है। और यह कि मेरा विचार अक्षमता और भोलेपन से अधिक पैदा हुआ था। लेकिन इस तरह के एक उपकरण को बनाने की कोशिश करने की इच्छा मेरे संदेह से अधिक मजबूत हुई।

इसलिए मूहा परियोजना का जन्म हुआ।

PHP, MySQL, HTML

सुविधाजनक ग्राफिकल टूल प्राप्त करने के लिए इन तीन तकनीकों को एक नोड सिस्टम में कैसे जोड़ा जा सकता है? नोड संपादकों में 3 डी ग्राफिक्स बनाने के कार्यक्रम अक्सर संदर्भों में अलगाव का उपयोग करते हैं, जो आमतौर पर एक दूसरे के साथ खराब संगत होते हैं। लेकिन हमारे मामले में, डेटा संरचनाएं इतनी जटिल और विषम नहीं हैं जितना कि व्यक्तिगत संपादकों का उत्पादन करना। इसलिए, मैंने नोड्स को प्रौद्योगिकी द्वारा श्रेणियों में विभाजित करके एकल स्थान बनाने का निर्णय लिया:

HTML / XML नोड्स (HTML / XML टैग्स के आउटपुट के लिए)
PHP नोड्स (लॉजिक कंट्रोल)
MySQL डेटाबेस क्वेरी नोड्स

उपयोगकर्ता के लिए प्रौद्योगिकियों को अदृश्य बनाने के लिए विचार करना था। कार्यक्रम निष्पादन के एक एकल धागे को बनाने के लिए विभिन्न श्रेणियों के नोड्स को एक दूसरे के साथ जोड़ना।

आइए तीनों श्रेणियों के नोड्स के क्रम में विचार करें।

HTML / XML नोड्स

ऐसे नोड्स को एक साथ जोड़ने से हमें HTML डॉक्यूमेंट की सबसे सरल संरचना मिलती है। डिफ़ॉल्ट रूप से, एक HTML / XML नोड में एक इनपुट और एक आउटपुट होता है। इनपुट (IN) वह है जो टैग के अंदर रखा गया है, आउटपुट (OUT) परिणामी स्ट्रिंग है। इस प्रकार, HTML नोड के अंतिम आउटपुट से, हमें लाइन मिलती है:

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

"मर्ज" सेवा नोड का उपयोग आने वाले कनेक्शनों की छंटाई को प्रभावित करने के लिए किया जाता है। छँटाई नोड के गुणों में ही उपलब्ध है। अंतिम HTML नोड में, आने वाले दो कनेक्शनों को उस क्रम में समाप्‍त किया जाता है जिसमें कनेक्शन हुआ था। यानी यदि आप पहले "हेड", और फिर "बॉडी" से जुड़े हैं, तो उस क्रम में वे अंतिम पंक्ति में दिखाई देंगे।

हम नोड के गुणों में टैग विशेषताएँ लिख सकते हैं, लेकिन यदि वांछित है, तो हम उन्हें आने वाले कनेक्शन के लिए कनेक्टर के रूप में प्रदर्शित कर सकते हैं। उदाहरण के लिए, कनेक्टर्स "आईडी और क्लास" नोड के लिए "मेरी डिव" हमें निम्नलिखित रूप मिलते हैं:

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

स्ट्रिंग वैल्यू "माय-आईडी" और "माय-क्लास" के साथ चर हमारी विशेषताओं में आते हैं। चर "मेरा पाठ" पहले div टैग की सामग्री बन जाता है। चर पहले से ही PHP नोड्स हैं, जिनके बारे में नीचे चर्चा की जाएगी।

कनेक्टर्स के रूप में, हम टेग को टैग के अंदर बदलने के लिए टेम्प्लेट प्रदर्शित कर सकते हैं। उदाहरण के लिए, यदि हमारे पास निर्धारित सामग्री के साथ निम्नलिखित टैग है:

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

और यदि टेम्प्लेट% उपयोगकर्ता% को कनेक्टर के रूप में प्रदर्शित किया जाता है, तो अब हम इस टेम्प्लेट को एक चर के साथ निम्नानुसार बदल सकते हैं:

पहले मामले में, नोड के अंदर का पाठ इसके गुणों में पंजीकृत है और डेटा के लिए कनेक्टर बंद है, और केवल टेम्पलेट को बदलने के लिए कनेक्टर प्रदर्शित किया गया है। दूसरे मामले में, टेम्पलेट के साथ पाठ भी चर से आता है। और दोनों ही मामलों में, हमें जो आउटपुट मिलता है:

 <h1>Hello, Mooha</h1>

बेशक, इस तरह से HTML कोड बनाने के लिए बहुत कम अर्थ है। संपादक में केवल व्यक्तिगत टैग के साथ नोड्स का उपयोग करने की क्षमता है, लेकिन कोड के पूरे टुकड़ों के साथ और यहां तक कि बाहरी फ़ाइलों को भी कनेक्ट करें।

उदाहरण के लिए, हमारे पास एक टेम्प्लेट.प्लेट फाइल है जिसमें दो टेम्प्लेट हैं जिन्हें बदलने के लिए:% शीर्षक% और% सामग्री% है। फ़ाइल की सामग्री इस प्रकार है:

 <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 नोड्स का उपयोग करके अंतर्निहित एब्स () फ़ंक्शन को कॉल करना है। नोड्स के नाम मनमाने हैं और प्रत्येक नोड के गुणों में बदल सकते हैं। सुविधा के लिए, मैंने उनका नाम बदल दिया ताकि चर के मान और अंकगणितीय संचालन के नाम दिखाई दें।
पहले तीन नोड्स "1", "2" और "5" वे चर हैं जिनके मान नामों के अनुरूप हैं।
यानी परिणामस्वरूप, हमें निम्नलिखित स्क्रिप्ट मिलती है:

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

और आउटपुट सिर्फ नंबर 2 है।

मैंने आमतौर पर नोड सिस्टम में उपयोग किए जाने वाले आवश्यक तार्किक निर्माणों को लागू करने की कोशिश की। उदाहरण के लिए, यह दो चर (या दो थ्रेड्स के परिणाम) की तुलना इस तरह दिखता है:

परिणाम सही होगा (1! = 2)।

और यह है कि आप शर्तों के आधार पर एक स्ट्रीम चयन कैसे कर सकते हैं:

यहां, नोड गुणों में प्रत्येक लाल कनेक्टर को मान दिया जाता है जिसके साथ नारंगी कनेक्टर में प्राप्त मूल्य की तुलना की जाती है। यदि मान मेल खाते हैं, तो स्विच स्विच संबंधित स्ट्रीम को छोड़ देता है। इस उदाहरण में, लाल कनेक्टर्स में 1, 2 और 3 मान हैं। यानी, इस डिज़ाइन का परिणाम "यह 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);

कॉपी नोड पर विशेष ध्यान दिया जाता है, जो पहले कनेक्शन से मूल्यों के अनुसार, दूसरे से टेम्पलेट का प्रचार करता है। यह उपयोगी है, उदाहरण के लिए, उस स्थिति में जब हमें HTML कोड को प्रचारित करने और किसी टेम्पलेट से मानों के साथ टेम्पलेट को बदलने की आवश्यकता होती है। एक-आयामी सरणी के साथ सबसे सरल मामले में, ऐसी योजना इस तरह दिखती है:

स्पष्टता के लिए, मैंने उनके चरों के मूल्यों को नोड कहा। पहले कनेक्टर (मानों के लिए) में, हम एक JSON सरणी चलाते हैं, दूसरे में - प्रतिस्थापन के लिए टेम्पलेट के साथ HTML कोड। टेम्पलेट कनेक्टर से जुड़े सभी नोड्स (या नोड्स की श्रृंखला) को कई बार कॉपी किया जाएगा क्योंकि पहले कनेक्टर से जुड़े सरणी में तत्व हैं। इसके अलावा, इस तरह के कनेक्शन के बाईं ओर प्रत्येक नोड में एक विशेष सेटिंग होगी, जिसमें डेटा को सरणी से एक तत्व के साथ प्रतिस्थापित किया जाना चाहिए। हमारे मामले में, पैराग्राफ के साथ नोड में, टेम्पलेट प्रतिस्थापन% संख्या% कॉन्फ़िगर किया गया है। यानी इस सर्किट का परिणाम निम्न कोड होगा:

 <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
%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

Mooha - PHP के लिए नोड इंटरफ़ेस

PHP, MySQL, HTML

HTML / XML नोड्स

PHP नोड्स

More articles: