root / src / cl_storage.php @ master
Historique | Voir | Annoter | Télécharger (5,86 ko)
1 | 7c18e02a | Florent Chuffart | <?php
|
---|---|---|---|
2 | 7c18e02a | Florent Chuffart | session_start (); |
3 | 7c18e02a | Florent Chuffart | require("headers.php"); |
4 | 7c18e02a | Florent Chuffart | |
5 | 7c18e02a | Florent Chuffart | /*
|
6 | 7c18e02a | Florent Chuffart | * IMPORTANT NOTE: This generated file contains only a subset of huge amount
|
7 | 7c18e02a | Florent Chuffart | * of options that can be used with phpMyEdit. To get information about all
|
8 | 7c18e02a | Florent Chuffart | * features offered by phpMyEdit, check official documentation. It is available
|
9 | 7c18e02a | Florent Chuffart | * online and also for download on phpMyEdit project management page:
|
10 | 7c18e02a | Florent Chuffart | *
|
11 | 7c18e02a | Florent Chuffart | * http://platon.sk/projects/main_page.php?project_id=5
|
12 | 7c18e02a | Florent Chuffart | *
|
13 | 7c18e02a | Florent Chuffart | * This file was generated by:
|
14 | 7c18e02a | Florent Chuffart | *
|
15 | 7c18e02a | Florent Chuffart | * phpMyEdit version: unknown
|
16 | 7c18e02a | Florent Chuffart | * phpMyEdit.class.php core class: 1.204
|
17 | 7c18e02a | Florent Chuffart | * phpMyEditSetup.php script: 1.50
|
18 | 7c18e02a | Florent Chuffart | * generating setup script: 1.50
|
19 | 7c18e02a | Florent Chuffart | */
|
20 | 7c18e02a | Florent Chuffart | |
21 | 7c18e02a | Florent Chuffart | |
22 | 7c18e02a | Florent Chuffart | /*************************/
|
23 | 7c18e02a | Florent Chuffart | //
|
24 | 7c18e02a | Florent Chuffart | // Pass phpMyEdit options
|
25 | 7c18e02a | Florent Chuffart | //
|
26 | 7c18e02a | Florent Chuffart | /*************************/
|
27 | 7c18e02a | Florent Chuffart | |
28 | 7c18e02a | Florent Chuffart | |
29 | 7c18e02a | Florent Chuffart | $opts['dbh'] = $connexion; |
30 | 7c18e02a | Florent Chuffart | $opts['tb'] = $tb; |
31 | 7c18e02a | Florent Chuffart | |
32 | 7c18e02a | Florent Chuffart | // Name of field which is the unique key
|
33 | 7c18e02a | Florent Chuffart | $opts['key'] = 'ID'; |
34 | 7c18e02a | Florent Chuffart | |
35 | 7c18e02a | Florent Chuffart | // Type of key field (int/real/string/date etc.)
|
36 | 7c18e02a | Florent Chuffart | $opts['key_type'] = 'int'; |
37 | 7c18e02a | Florent Chuffart | |
38 | 7c18e02a | Florent Chuffart | // Sorting field(s)
|
39 | 7c18e02a | Florent Chuffart | $opts['sort_field'] = array('ID'); |
40 | 7c18e02a | Florent Chuffart | |
41 | 7c18e02a | Florent Chuffart | // Number of records to display on the screen
|
42 | 7c18e02a | Florent Chuffart | // Value of -1 lists all records in a table
|
43 | 7c18e02a | Florent Chuffart | $opts['inc'] = 15; |
44 | 7c18e02a | Florent Chuffart | |
45 | 7c18e02a | Florent Chuffart | // Options you wish to give the users
|
46 | 7c18e02a | Florent Chuffart | // A - add, C - change, P - copy, V - view, D - delete,
|
47 | 7c18e02a | Florent Chuffart | // F - filter, I - initial sort suppressed
|
48 | 7c18e02a | Florent Chuffart | $opts['options'] = $privopt; |
49 | 7c18e02a | Florent Chuffart | |
50 | 7c18e02a | Florent Chuffart | // Number of lines to display on multiple selection filters
|
51 | 7c18e02a | Florent Chuffart | $opts['multiple'] = '4'; |
52 | 7c18e02a | Florent Chuffart | |
53 | 7c18e02a | Florent Chuffart | // Navigation style: B - buttons (default), T - text links, G - graphic links
|
54 | 7c18e02a | Florent Chuffart | // Buttons position: U - up, D - down (default)
|
55 | 7c18e02a | Florent Chuffart | $opts['navigation'] = 'UDBG'; |
56 | 7c18e02a | Florent Chuffart | |
57 | 7c18e02a | Florent Chuffart | // Display special page elements
|
58 | 7c18e02a | Florent Chuffart | $opts['display'] = array( |
59 | 7c18e02a | Florent Chuffart | 'form' => true, |
60 | 7c18e02a | Florent Chuffart | 'query' => true, |
61 | 7c18e02a | Florent Chuffart | 'sort' => true, |
62 | 7c18e02a | Florent Chuffart | 'time' => true, |
63 | 7c18e02a | Florent Chuffart | 'tabs' => true |
64 | 7c18e02a | Florent Chuffart | ); |
65 | 7c18e02a | Florent Chuffart | |
66 | 7c18e02a | Florent Chuffart | // Set default prefixes for variables
|
67 | 7c18e02a | Florent Chuffart | $opts['js']['prefix'] = 'PME_js_'; |
68 | 7c18e02a | Florent Chuffart | $opts['dhtml']['prefix'] = 'PME_dhtml_'; |
69 | 7c18e02a | Florent Chuffart | $opts['cgi']['prefix']['operation'] = 'PME_op_'; |
70 | 7c18e02a | Florent Chuffart | $opts['cgi']['prefix']['sys'] = 'PME_sys_'; |
71 | 7c18e02a | Florent Chuffart | $opts['cgi']['prefix']['data'] = 'PME_data_'; |
72 | 7c18e02a | Florent Chuffart | |
73 | 7c18e02a | Florent Chuffart | /* Get the user's default language and use it if possible or you can
|
74 | 7c18e02a | Florent Chuffart | specify particular one you want to use. Refer to official documentation
|
75 | 7c18e02a | Florent Chuffart | for list of available languages. */
|
76 | 7c18e02a | Florent Chuffart | $opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'] . '-UTF8'; |
77 | 7c18e02a | Florent Chuffart | |
78 | 7c18e02a | Florent Chuffart | /* Table-level filter capability. If set, it is included in the WHERE clause
|
79 | 7c18e02a | Florent Chuffart | of any generated SELECT statement in SQL query. This gives you ability to
|
80 | 7c18e02a | Florent Chuffart | work only with subset of data from table.
|
81 | 7c18e02a | Florent Chuffart | |
82 | 7c18e02a | Florent Chuffart | $opts['filters'] = "column1 like '%11%' AND column2<17";
|
83 | 7c18e02a | Florent Chuffart | $opts['filters'] = "section_id = 9";
|
84 | 7c18e02a | Florent Chuffart | $opts['filters'] = "PMEtable0.sessions_count > 200";
|
85 | 7c18e02a | Florent Chuffart | */
|
86 | 7c18e02a | Florent Chuffart | |
87 | 7c18e02a | Florent Chuffart | /* Field definitions
|
88 | 7c18e02a | Florent Chuffart |
|
89 | 7c18e02a | Florent Chuffart | Fields will be displayed left to right on the screen in the order in which they
|
90 | 7c18e02a | Florent Chuffart | appear in generated list. Here are some most used field options documented.
|
91 | 7c18e02a | Florent Chuffart | |
92 | 7c18e02a | Florent Chuffart | ['name'] is the title used for column headings, etc.;
|
93 | 7c18e02a | Florent Chuffart | ['maxlen'] maximum length to display add/edit/search input boxes
|
94 | 7c18e02a | Florent Chuffart | ['trimlen'] maximum length of string content to display in row listing
|
95 | 7c18e02a | Florent Chuffart | ['width'] is an optional display width specification for the column
|
96 | 7c18e02a | Florent Chuffart | e.g. ['width'] = '100px';
|
97 | 7c18e02a | Florent Chuffart | ['mask'] a string that is used by sprintf() to format field output
|
98 | 7c18e02a | Florent Chuffart | ['sort'] true or false; means the users may sort the display on this column
|
99 | 7c18e02a | Florent Chuffart | ['strip_tags'] true or false; whether to strip tags from content
|
100 | 7c18e02a | Florent Chuffart | ['nowrap'] true or false; whether this field should get a NOWRAP
|
101 | 7c18e02a | Florent Chuffart | ['select'] T - text, N - numeric, D - drop-down, M - multiple selection
|
102 | 7c18e02a | Florent Chuffart | ['options'] optional parameter to control whether a field is displayed
|
103 | 7c18e02a | Florent Chuffart | L - list, F - filter, A - add, C - change, P - copy, D - delete, V - view
|
104 | 7c18e02a | Florent Chuffart | Another flags are:
|
105 | 7c18e02a | Florent Chuffart | R - indicates that a field is read only
|
106 | 7c18e02a | Florent Chuffart | W - indicates that a field is a password field
|
107 | 7c18e02a | Florent Chuffart | H - indicates that a field is to be hidden and marked as hidden
|
108 | 7c18e02a | Florent Chuffart | ['URL'] is used to make a field 'clickable' in the display
|
109 | 7c18e02a | Florent Chuffart | e.g.: 'mailto:$value', 'http://$value' or '$page?stuff';
|
110 | 7c18e02a | Florent Chuffart | ['URLtarget'] HTML target link specification (for example: _blank)
|
111 | 7c18e02a | Florent Chuffart | ['textarea']['rows'] and/or ['textarea']['cols']
|
112 | 7c18e02a | Florent Chuffart | specifies a textarea is to be used to give multi-line input
|
113 | 7c18e02a | Florent Chuffart | e.g. ['textarea']['rows'] = 5; ['textarea']['cols'] = 10
|
114 | 7c18e02a | Florent Chuffart | ['values'] restricts user input to the specified constants,
|
115 | 7c18e02a | Florent Chuffart | e.g. ['values'] = array('A','B','C') or ['values'] = range(1,99)
|
116 | 7c18e02a | Florent Chuffart | ['values']['table'] and ['values']['column'] restricts user input
|
117 | 7c18e02a | Florent Chuffart | to the values found in the specified column of another table
|
118 | 7c18e02a | Florent Chuffart | ['values']['description'] = 'desc_column'
|
119 | 7c18e02a | Florent Chuffart | The optional ['values']['description'] field allows the value(s) displayed
|
120 | 7c18e02a | Florent Chuffart | to the user to be different to those in the ['values']['column'] field.
|
121 | 7c18e02a | Florent Chuffart | This is useful for giving more meaning to column values. Multiple
|
122 | 7c18e02a | Florent Chuffart | descriptions fields are also possible. Check documentation for this.
|
123 | 7c18e02a | Florent Chuffart | */
|
124 | 7c18e02a | Florent Chuffart | |
125 | 7c18e02a | Florent Chuffart | |
126 | 7c18e02a | Florent Chuffart | |
127 | 7c18e02a | Florent Chuffart | $opts['fdd']['ID'] = array( |
128 | 7c18e02a | Florent Chuffart | 'name' => 'ID', |
129 | 7c18e02a | Florent Chuffart | 'select' => 'T', |
130 | 7c18e02a | Florent Chuffart | 'options' => 'AVCPDR', // auto increment |
131 | 7c18e02a | Florent Chuffart | 'maxlen' => 15, |
132 | 7c18e02a | Florent Chuffart | 'default' => '0', |
133 | 7c18e02a | Florent Chuffart | 'sort' => true |
134 | 7c18e02a | Florent Chuffart | ); |
135 | 7c18e02a | Florent Chuffart | $opts['fdd']['container'] = array( |
136 | 7c18e02a | Florent Chuffart | 'name' => 'Container', |
137 | 7c18e02a | Florent Chuffart | 'options' => 'LFACPDVR', |
138 | 7c18e02a | Florent Chuffart | 'select' => 'T', |
139 | 7c18e02a | Florent Chuffart | 'maxlen' => 50, |
140 | 7c18e02a | Florent Chuffart | 'sort' => true |
141 | 7c18e02a | Florent Chuffart | ); |
142 | 7c18e02a | Florent Chuffart | $opts['fdd']['rack'] = array( |
143 | 7c18e02a | Florent Chuffart | 'name' => 'Rack', |
144 | 7c18e02a | Florent Chuffart | 'options' => 'LFACPDVR', |
145 | 7c18e02a | Florent Chuffart | 'select' => 'T', |
146 | 7c18e02a | Florent Chuffart | 'maxlen' => 50, |
147 | 7c18e02a | Florent Chuffart | 'sort' => true |
148 | 7c18e02a | Florent Chuffart | ); |
149 | 7c18e02a | Florent Chuffart | $opts['fdd']['box'] = array( |
150 | 7c18e02a | Florent Chuffart | 'name' => 'Box', |
151 | 7c18e02a | Florent Chuffart | 'options' => 'LFACPDVR', |
152 | 7c18e02a | Florent Chuffart | 'select' => 'T', |
153 | 7c18e02a | Florent Chuffart | 'maxlen' => 50, |
154 | 7c18e02a | Florent Chuffart | 'sort' => true |
155 | 7c18e02a | Florent Chuffart | ); |
156 | 53861c89 | Florent Chuffart | $opts['fdd']['field_y'] = array( |
157 | 53861c89 | Florent Chuffart | 'name' => 'Field Y', |
158 | 53861c89 | Florent Chuffart | 'options' => 'LFACPDVR', |
159 | 53861c89 | Florent Chuffart | 'select' => 'T', |
160 | 53861c89 | Florent Chuffart | 'maxlen' => 50, |
161 | 53861c89 | Florent Chuffart | 'sort' => true |
162 | 53861c89 | Florent Chuffart | ); |
163 | 53861c89 | Florent Chuffart | $opts['fdd']['field_x'] = array( |
164 | 53861c89 | Florent Chuffart | 'name' => 'Field X', |
165 | 7c18e02a | Florent Chuffart | 'options' => 'LFACPDVR', |
166 | 7c18e02a | Florent Chuffart | 'select' => 'T', |
167 | 7c18e02a | Florent Chuffart | 'maxlen' => 50, |
168 | 7c18e02a | Florent Chuffart | 'sort' => true |
169 | 7c18e02a | Florent Chuffart | ); |
170 | 7c18e02a | Florent Chuffart | $opts['fdd']['cl_passages'] = array( |
171 | 7c18e02a | Florent Chuffart | 'name' => 'Passage', |
172 | 7c18e02a | Florent Chuffart | 'select' => 'D', |
173 | 7c18e02a | Florent Chuffart | 'maxlen' => 50, |
174 | 7c18e02a | Florent Chuffart | 'sort' => true, |
175 | 7c18e02a | Florent Chuffart | 'values' => array( |
176 | 7c18e02a | Florent Chuffart | 'table' => 'cl_passages', |
177 | 7c18e02a | Florent Chuffart | 'column' => 'ID', |
178 | 7c18e02a | Florent Chuffart | 'description' => array( |
179 | 7c18e02a | Florent Chuffart | 'columns' => array("name", "passage", "date_of_freezing"), |
180 | 7c18e02a | Florent Chuffart | 'divs' => array(".", ".") |
181 | 7c18e02a | Florent Chuffart | ) |
182 | 7c18e02a | Florent Chuffart | ) |
183 | 7c18e02a | Florent Chuffart | ); |
184 | 7c18e02a | Florent Chuffart | |
185 | 7c18e02a | Florent Chuffart | |
186 | 7c18e02a | Florent Chuffart | require("footers.php"); |
187 | 7c18e02a | Florent Chuffart | ?> |