diff options
| author | Maksim Kozhukh <mkozhukh@ya.ru> | 2014-08-05 15:05:01 +0300 |
|---|---|---|
| committer | Maksim Kozhukh <mkozhukh@ya.ru> | 2014-08-05 15:05:01 +0300 |
| commit | a3f61f91ca50598de2126ea0864b3acc7f56a847 (patch) | |
| tree | e858faa1effc6729d7e02d1464f51cd768088f01 /samples/grid/01a_sql_basic.html | |
| parent | 4fc1e6da2aaf2e9c47c31b2b4d247c3ed99dc9d2 (diff) | |
| download | connector-php-a3f61f91ca50598de2126ea0864b3acc7f56a847.zip connector-php-a3f61f91ca50598de2126ea0864b3acc7f56a847.tar.gz connector-php-a3f61f91ca50598de2126ea0864b3acc7f56a847.tar.bz2 | |
[update] pdo based samples
Diffstat (limited to 'samples/grid/01a_sql_basic.html')
| -rw-r--r-- | samples/grid/01a_sql_basic.html | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/samples/grid/01a_sql_basic.html b/samples/grid/01a_sql_basic.html index 601b833..9564e1e 100644 --- a/samples/grid/01a_sql_basic.html +++ b/samples/grid/01a_sql_basic.html @@ -31,8 +31,18 @@ </script>
<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);">
<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()">
-<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php
<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(ID)"</span><span style="color: #007700">,</span><span style="color: #DD0000">"grid50000.item_id(ID),item_nm"</span><span style="color: #007700">);
<br /></span><span style="color: #0000BB">?></span> -</span> +<div class='code'><code><span style="color: #000000">
+<span style="color: #0000BB"><?php
+<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
+<br />
+<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(ID)"</span><span style="color: #007700">,</span><span style="color: #DD0000">"grid50000.item_id(ID),item_nm"</span><span style="color: #007700">);
+<br /></span><span style="color: #0000BB">?></span>
+</span>
</code></div></body>
</html>
|