Home: Frontend    Home: Backend (user=admin ; password=admin)This sample is using the JQuery UI Theme: cupertino / Server Date-Time: 2013-05-24 01:02:23 +0300
 Start    Prev
  Page 1 of 3  
 Next      End 
Insert Record

  Sample Table - SQLite  
  
ID
Name
Description
View Record 0C781NF7CZ Name "1" Description '1'
View Record 0C781NF7D0 Name "2" Description '2'
View Record 0C781NF7D1 Name "3" Description '3'
View Record 0C781NF71B Name "4" Description '4'
View Record 0C781NF7D2 Name "5" Description '5'
View Record 0C781NF7D3 Name "6" Description '6'
View Record 0C781NF7D4 Name "7" Description '7'
View Record 0C781NF7D5 Name "8" Description '8'
View Record 0C781NF7D6 Name "9" Description '9'
View Record 0C781NF7D7 Name "10" Description '10'
   
Click on the links below to see a basic confirm interaction:

Test JQuery Dialog

Test JQuery Alert


Press the Submit button to see how form submit confirmation works:



This is the dialog. The dialog window can be moved, resized and closed with the 'x' icon.



Click on the images below to see how LightBox Control works for an Image Gallery:

 
Sample - Submit form by AJAX using advanced controls and Captcha (click on the button from the bottom of this page)::

[This area must be replaced after sending the form !]
Calendar Selector:

TimePicker Selector:

Limited TextArea:




SingleSelect DropDown List:

MultiSelect DropDown List:

MultiSelect CheckBoxes:
  Label 1
  Label 2
  Label 3
Click Here to Reload the Image ...  Captcha:


NOTICE on The Bing Maps: requires an ApiKey. For this sample the author generated a Test Bing ApiKey. Please generate your own Bing ApiKey prior to go in production ...
NOTICE on Maps Caching: the Open Map types (except Google and Bing) support local caching on your server if you need maps for very hight web traffic. If you need this feature, please contact support@unix-world.org and buy some extra support services for this framework ... :-)
Enjoy the map control from below !
Click on the links below to see some XML-to-Array and Array-to-XML samples:

XML Read Test (XML -> Array)

XML Read Write (Array -> XML)

Database Server Samples are Disabled !


By default, no database server is selected in cfg/config.php, but you can activate in config either a PostgreSQL or MySQL(i) Database Servers

DEBUG DATA - GET:

Array
(
)

DEBUG DATA - POST:

Array
(
)

DEBUG DATA - SESSION:

Array
(
    [session_ID] => 1c5c3d2693de5c0b4fca0bab58762e80af19f56d
    [uniqbrowser_ID] => Sess_ID___Key_5de08b4dbf3d26965c0ee433bc6a70e69203a646
    [customer_ID] => IP: 107.21.186.38 // Browser Signature: CCBot/2.0
)

DEBUG DATA - SQLite:

Array
(
    [enabled] => yes
    [version] => 3
    [slow_time] => 0.002
    [library-version] => 3.7.15.1 / 3007015
    [total_time] => 0.0019066333770752
    [total_queries] => 10
    [log] => 
# 1 :: READ :: [ 0.00015306 sec. ]
SELECT dataval FROM openframework_db_metadata WHERE (id = 'sqlite-version') LIMIT 1 OFFSET 0


# 2 :: aREAD :: [ 0.00009322 sec. ]
SELECT dataval FROM openframework_db_metadata WHERE (id = 'lib-version') LIMIT 1 OFFSET 0


# 3 :: aREAD :: [ 0.00008607 sec. ]
SELECT dataval FROM openframework_db_metadata WHERE (id = 'sqlite-version') LIMIT 1 OFFSET 0


# 4 :: COUNT :: [ 0.00009203 sec. ]
SELECT COUNT(1) FROM test_unit_html_load


# 5 :: aREAD :: [ 0.00009203 sec. ]
SELECT id, name, description FROM test_unit_html_load WHERE (id='TRANSACT-X') LIMIT 1 OFFSET 0


===== - BEGIN - [TRANSACTION] :: [ 0.00002003 sec. ] =====


# 7 :: WRITE (10) :: [ 0.00068402 sec. ]
UPDATE test_unit_html_load SET name = '' WHERE ((name NOT LIKE '%"1"%') AND (name LIKE '%"1%'))


# 8 :: WRITE (1) :: [ 0.00006509 sec. ]
INSERT INTO test_unit_html_load (id,name,description) VALUES ('TRANSACT-X','Transaction Test','If you see this Record, your SQLite FAIL with TRANSACTIONS !!')


===== - ROLLBACK - [TRANSACTION] :: [ 0.00044298 sec. ] =====


# 10 :: READ :: [ 0.00017810 sec. ]
SELECT id, name, description FROM test_unit_html_load LIMIT 10 OFFSET 0


)

DEBUG DATA - SQL: