_IMv2.key - PDF Free Download

飯島基文 customb2b@me.com

$ ssh ladmin@im.example.com $ cd /Library/Server/Web/Data/Sites/Default/ $ git clone https://github.com/msyk/inter-mediator.git

$ sudo mkdir /var/db/im $ cd /Library/Server/Web/Data/Sites/Default/INTER-Mediator/dist-docs/ $ sudo sqlite3 /var/db/im/sample.sq3 < sample_schema_sqlite.txt $ sudo chown _www /var/db/im $ sudo chown _www /var/db/im/sample.sq3

CREATE TABLE fruit ( id INTEGER PRIMARY KEY AUTOINCREMENT, item TEXT, price INTEGER ); INSERT INTO fruit (id, item, price) VALUES (1, ' ',100); INSERT INTO fruit (id, item, price) VALUES (2, ' ', 150); INSERT INTO fruit (id, item, price) VALUES (3, ' ', 450); INSERT INTO fruit (id, item, price) VALUES (4, ' ', 200); INSERT INTO fruit (id, item, price) VALUES (5, ' ', 850); INSERT INTO fruit (id, item, price) VALUES (6, ' ', 2500); INSERT INTO fruit (id, item, price) VALUES (7, ' ', 126); INSERT INTO fruit (id, item, price) VALUES (8, ' ', 390); INSERT INTO fruit (id, item, price) VALUES (9, ' ', 420); INSERT INTO fruit (id, item, price) VALUES (10, ' ', 320); INSERT INTO fruit (id, item, price) VALUES (11, ' ', 3200);

$ sqlite3 mysample.sq3 < mysample.txt $ sqlite3 mysample.sq3 sqlite>.header ON sqlite> select * from fruit; id item price 1 100 2 150 3 450 4 200 5 850 6 2500 7 126 8 390 9 420 10 320 11 3200

$ ssh ladmin@im.example.com $ sudo chown _www:admin /var/db/im //_www:wheel"_www:admin $ sudo chmod 775 /var/db/im //755"775 $ exit $ scp mysample.sq3 ladmin@im.example.com:/var/db/im/ $ ssh ladmin@im.example.com $ sudo chown _www /var/db/im/mysample.sq3

<?php // INTER-Mediator.php require_once(dirname( FILE ). /../INTER-Mediator.php'); // IM_Entry() IM_Entry( // array(), // array(), // DB array(), );?> // 2

<?php require_once(dirname( FILE ). /../INTER-Mediator.php'); IM_Entry( // array( arrary( 'name' => 'fruit', 'records' => 5, 'paging' => true, 'key' => 'id', 'sort' => array(array('field' => 'id', 'direction' => 'ASC')), ) ), null, // DB );?> array( 'db-class' => 'PDO', 'dsn' => 'sqlite:/var/db/im/mysample.sq3' ), // 2

<html> <head> <script src= contexts_sqlite.php"></script> </head> <body> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> </body> </html>

<html lang="ja"> <head> <meta charset="utf-8"> <title>inter-mediator - MySample - SQLite</title> <script src="contexts_sqlite.php"></script> </head> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> <table border="1" id=""> <thead> <tr> <th> </th> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td><div data-im="fruit@id"></div></td> <td><div data-im="fruit@item"></div></td> <td><div data-im="fruit@price"></div></td> </tr> </tbody> </table> </body> </html>

<html> <head> <meta charset="utf-8"> <title>inter-mediator - MySample - SQLite</title> <script src="contexts_sqlite.php"></script> </head> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> <table border="1" id=""> <thead> <tr> <th> </th> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td><div data-im="fruit@id"></div></td> <td><div data-im="fruit@item"></div></td> <td><div data-im="fruit@price"></div></td> </tr> <tr data-im-control="noresult"> <td colspan="4"> </td> </tr> </tbody> </table> </body> </html>

IM_Entry( // array( 'repeat-control' => 'insert delete, ), // array(), // DB array(), );?> // 2

<div> :<input type="text" data-im="_@condition:fruit:id,item,price:*match*"> : <select type="text" data-im="_@limitnumber:fruit"> <option value="5">5</option> <option value="10">10</option> <option value="20" selected>20</option> </select> <button data-im="_@update:fruit">search</button> </div>

CREATE TABLE receipt ( id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp TEXT, person INTEGER, category INTEGER, company TEXT, details TEXT, amount REAL, payment INTEGER, settlement INTEGER, filepath TEXT, remarks TEXT );

<?php require_once(dirname( FILE ). '/../../INTER-Mediator.php'); IM_Entry( array( array( 'name' => 'receipt', 'records' => 10, 'paging' => true, 'key' => 'id', 'sort' => array(array('field' => 'timestamp', 'direction' => 'ASC')), 'repeat-control' => 'insert delete' ), array( 'name' => 'receiptdetail', 'view' => 'receipt', 'table' => 'receipt', 'records' => 1, 'key' => 'id', 'repeat-control' => 'delete' ), array( 'name' => 'person', 'key' => 'id', ), array( 'name' => 'category', 'key' => 'id', ), array( 'name' => 'payment', 'key' => 'id', ), array( 'name' => 'settlement', 'key' => 'id', ), ), array( 'formatter' => array( array( 'field' => 'receipt@amount', 'converter-class' => 'Number', 'parameter' => '0' ), ), ), array( 'db-class' => 'PDO', 'dsn' => 'sqlite:/var/db/im/myapp.sq3' ), 2 );?>