Home: Frontend    Home: Backend (user=admin ; password=admin)This sample is using the JQuery UI Theme: cupertino / Server Date-Time: 2014-07-30 18:09:09 +0300
 Start    Prev
  Page 1 of 3  
Next      End 
Insert Record

  Sample Table - SQLite  

  
ID
Name
Description
View Record 0E1U019A82 Name "1" Description '1'
View Record 0E1U019A83 Name "2" Description '2'
View Record 0E1U019A84 Name "3" Description '3'
View Record 0E1U019A85 Name "4" Description '4'
View Record 0E1U019A86 Name "5" Description '5'
View Record 0E1U019A87 Name "6" Description '6'
View Record 0E1U019A88 Name "7" Description '7'
View Record 0E1U019A89 Name "8" Description '8'
View Record 0E1U019A8A Name "9" Description '9'
View Record 0E1U019A8B 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
ReqVarMode: private

DEBUG DATA - CORE:


DEBUG DATA - GET:

Array
(
)

DEBUG DATA - POST:

Array
(
)

DEBUG DATA - SESSION:

Array
(
    [session_ID] => isk50v4uha1smru3hk1rhk2ekvkgsii75vvvtp1bh5hi44s0ifnf97f4a2v0urqhiicpc63tqibusjdqtd723m4uh3ocv86lf7n3cv0
    [uniqbrowser_ID] => Sess_ID___Key_40711614f635ed4aa35c5551e99b9209754c10c4
    [customer_ID] => IP: 54.81.236.36 // Browser Signature: CCBot/2.0 (http://commoncrawl.org/faq/)
)

DEBUG DATA - SQLite:

Array
(
    [enabled] => yes
    [version] => 3
    [slow_time] => 0.002
    [total_queries] => 15
    [library-version] => 3.8.3.1 / 3008003
    [log] => 
SQLITE // Open: tmp/testunit.sqlite3
# 1 :: READ :: [ 0.00033498 sec. ]
SELECT name FROM sqlite_master WHERE type='table' AND name='openframework_db_metadata'


# 2 :: READ :: [ 0.00011492 sec. ]
SELECT name FROM sqlite_master WHERE type='table' AND name='test_unit_html_load'


# 3 :: READ :: [ 0.00011086 sec. ]
SELECT name FROM sqlite_master WHERE type='table' AND name='test_unit_flexigrid'


# 4 :: COUNT :: [ 0.00015211 sec. ]
SELECT COUNT(1) FROM test_unit_html_load WHERE (id = '') LIMIT 1 OFFSET 100000


# 5 :: READ :: [ 0.00011611 sec. ]
SELECT * FROM test_unit_html_load WHERE (id = '') LIMIT 1 OFFSET 100000


# 6 :: aREAD :: [ 0.00011921 sec. ]
SELECT * FROM test_unit_html_load WHERE (id = '') LIMIT 1 OFFSET 100000


# 7 :: aREAD :: [ 0.00011396 sec. ]
SELECT * FROM test_unit_html_load WHERE (id = '') LIMIT 1 OFFSET 100000


# 8 :: READ :: [ 0.00011301 sec. ]
SELECT name FROM sqlite_master WHERE type='table' AND name='test_unit_html_load'


# 9 :: COUNT :: [ 0.00010490 sec. ]
SELECT COUNT(1) FROM test_unit_html_load


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


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

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


# 13 :: WRITE (1) :: [ 0.00006890 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.00013494 sec. ] =====

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

[total_time] => 0.002108097076416 )

DEBUG DATA - SQL:

Array
(
)