Mooha - node interface for PHP
I often had to deal with node interfaces in programs. From musical modular applications to packages for creating three-dimensional graphics.
The idea of graphical control of the logic of the program always seemed to me a very elegant, and in some cases, the only successful solution. Later, when, in addition to music and video, I became interested in programming (mostly PHP, as it happened), I wanted to try, even as an experiment, to create a graphical shell for performing the simple tasks I encountered in my work.
My acquaintance with the node interface (or graphical programming) began with the program Plogue Bidule . This application belongs to the family of modular programs for real-time sound control. At one time, this program helped me to solve quite non-trivial tasks related to sound processing and synchronization of stage equipment at live performances of several of my musical projects.
')
The Plogue Bidule program interface is as follows:
The basis of the work - the creation of logical chains. It seems to me that this approach quite naturally fits into the work with sound, although it may seem difficult to someone at first glance. A sound in a program is a continuous stream that appears from a source (an incoming channel of a sound card, an audio file or a signal generator), and after certain processing it is most often sent to the output of a sound card or to write to a file.
The main interface control structures are nodes (or modules, blocks, nodes, etc.), which are essentially functions. By analogy with the musical equipment - these are devices interconnected by wires.
Plogue Bidule includes many interesting features that are not limited to working with sound, but for this article this description will be enough.
I was lucky for the first time to get acquainted with the node interface in the music program, since the flow of sound, in my opinion, is an excellent analogy for the flow of the procedural program.
Node editors are widely used in graphics packages for creating 3D graphics. In such programs, black boxes describe the most complex structures and functions, and the interface allows you to maintain freedom and flexibility in building execution logic. The most interesting, in my opinion, implementation of the node system in the Houdini program.
So what about web programming? Search similar systems did not return results. I thought that maybe this technology is simply not necessary. And that my idea was born more from incompetence and naivety. But the desire to try to create such a tool turned out to be stronger than my doubts.
So the Mooha project was born.
PHP, MySQL, HTML
How can these three technologies be combined in one node system to get a convenient graphical tool? In programs for creating 3D graphics in node editors, it is often used to divide contexts that are usually poorly compatible with each other. But in our case, the data structures are not so complex and heterogeneous as to produce individual editors. Therefore, I decided to create a single space, dividing nodes into categories according to technologies:
- HTML / XML nodes (for outputting HTML / XML tags)
- PHP nodes (logic management)
- MySQL database query nodes
The idea was that the transition between technologies was invisible to the user. So that the connection of nodes of different categories between each other creates a single flow of program execution.
Consider in order all three categories of nodes.
HTML / XML nodes
Combining such nodes together we get the simplest structure of an HTML document. By default, the HTML / XML node has one input and one output. The input (IN) is what is placed inside the tag, the output (OUT) is the resulting string. Thus, from the last output of the HTML node, we get the string:
<html> <head> <meta /> <script /> </head> <body> <div> <div /> <div /> </div> </body> </html> The "Merge" service node is used to influence the sorting of incoming connections. Sorting is available in the properties of the node itself. In the last HTML node, the two incoming connections are concatenated in the order in which the connection occurred. Those. if you first connected "HEAD", and then "BODY", then in this sequence they will appear in the final line.
Attributes of the tag we can write in the properties of the node, but if you wish, we can display them in the form of connectors for incoming connections. For example, adding the node “my div” connectors for the attributes id and class we get the following form:
<div id="my-id" class="my-class"> <div>my text</div> </div> Variables with the string values "my-id" and "my-class" fall into our attributes. The variable "my text" becomes the content of the first tag div. Variables - this is PHP nodes, which will be discussed below.
As connectors, we can also output templates for replacing text within the tag. For example, if we have the following tag with the written content:
<h1>Hello, %user%</h1> And if the% user% template is displayed as a connector, now we can replace this template with a variable as follows:
In the first case, the text inside the node is registered in its properties and the data connector is turned off, and only the connector for replacing the template is displayed. In the second case, the text with the template also comes from a variable. In this and in another case, the output we get:
<h1>Hello, Mooha</h1> Of course, there is little point in building HTML code in this way. In the editor, it is possible to use nodes not only with individual tags, but with whole pieces of code and even include external files.
For example, we have a template.tpl file that contains two templates for replacing:% title% and% content%. The file contents are as follows:
<html> <head> </head> <body> <h1>%title%</h1> <div>%content%</div> </body> </html> To connect the file and replace the templates with variables, it is enough to build just such a scheme:
As a result, we get:
<html> <head> </head> <body> <h1>My article title</h1> <div>My article content</div> </body> </html> Since we have already gone beyond the description of only HTML nodes, we move on to the next type - to PHP nodes.
PHP nodes
This is the simplest example of arithmetic calculations and calling the built-in function abs () using PHP nodes. The names of the nodes are arbitrary and may vary in the properties of each node. For convenience, I renamed them so that the values of variables and the names of arithmetic operations are visible.
The first three nodes “1”, “2” and “5” are variables whose values correspond to the names.
Those. as a result, we get the following script:
<?php print abs((1+2)-5); ?> And the output is just the number 2.
I tried to implement the necessary logical constructions commonly used in node systems. For example, here is the comparison of two variables (or the results of two streams):
The result will be true (1! = 2).
And this is how you can make a choice of flow, based on the conditions:
Here, in the properties of the node, each red connector is assigned values to which the value received in the orange connector is compared. If the values match, the Switch skips the appropriate stream. In this example, the red connectors have the values 1, 2 and 3. That is, the result of this design will be “it was 2”.
In all chains in connections, the final values of all previous flow calculations are transferred. Thus, in the following example, our result will also be “it was 2”, but the resulting string is made up of several actions:
About the following code is generated:
$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); The Copy node deserves special attention, which, by the values from the first connection, propagates the pattern from the second. This is useful, for example, in the case when we need to multiply the HTML code and replace the templates in it with values from the array. In the simplest case with a one-dimensional array, such a scheme looks like this:
For clarity, I called the nodes of the values of their variables. In the first connector (for values), we run the JSON array, in the second, the HTML code with a replacement template. All nodes (or chains of nodes) connected to the template connector will be copied as many times as there are elements in the array connected to the first connector. In this case, each node to the left of such a connection will have a special setting, which data in it to replace with an element from the array. In our case, the node with the paragraph is configured to replace the template% number%. Those. The result of this scheme is the following code:
<p>first paragraph</p> <p>second paragraph</p> <p>third paragraph</p> Here an example is more difficult, with an array of objects and with several nodes:
In the variable "JSON" the following array of objects:
[ {"title":"first title","content":"first content"}, {"title":"second title","content":"second content"} ] In tag node
%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
%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
Source: https://habr.com/ru/post/201646/
All Articles