Database
1. Window >Database
2. Complete "define site" > "document type (PHP)" > "testing server"
3. Click (+), Choose MySQL Connection
4. Fill up
* connection name: conn_cec
* MysQL Server : localhost
* User Name : Chian
* Password : enunst
* Chian
5.Click TEST to test connection

Back

Create Recordset
1. Window>Binding
2. Complete "define site" > "document type (PHP)" > "testing server"
3 Click (+), Choose Recordset
4. Fill up
*Name: rs_cec (rs_tablename)
*Connection : conn_cec
*Table : cec

pls : use select, where, ordered by asc&desc,
parameter ( page.php?param1=value1 & param2=value2 )
5. Test to display result of query.

Back

Display Live Data
1. Create a new page (.php)
2. Place cursor where you want result to be.
3. Choose application (tool bar)>Dynamic table (3rd) > recordset (rs_cec)
4. Click on Live Data View ( left of Title)

Back

Insert Record
1. Open the PHP file containing form.
2. Window>Server Behavior.
3. Click (+), Choose Insert Record.
4. Fill up, Form name | Connection | Table to be inserted | value | page after inserting

Back

Detach Page From Template
1. Modify>Template>Detach from template
* Enable you to insert dynamic text/table into page(.php)

Back

Apply Template To Page
1. With content (static/dynamic) ready with dynamic page (.php)
2. Open Window>Asset panel (click assets), check TEMPLATE (last 2nd from bottom).
3. Choose applied template, click Apply.
4. click Editable Regions>Document body ( inconsistent region names).
5. Select Move Content Dropdown menu, Choose where (content) you want content to be placed.
6. Ok.

Back

Passing URL Parameter

Fieldname Parameter
* used for accepting parameter passed as field name (but PK)
* eg. pass Login to itself for sorting by Login
1.Highlight Login (master page), link properties (cec_record.php?sortype=Num )
2.RS_sort, Do the following on SQL

Recordset Paging
1. Server behavior> + > Repeat region ( specify rec # to be displayed)
2. Place cursor: Application > Recordset Nagivation Status ( record 1 to 3 of 9)
3. Place curson: Application > Recordset Navigation Bar ( First | Previous | Next | Last)

Back