Statistiques
| Branche: | Révision :

root / src / cl_name.php @ e45ece5c

Historique | Voir | Annoter | Télécharger (5,62 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 2059046b Florent Chuffart
$opts['key'] = 'name';
34 7c18e02a Florent Chuffart
35 7c18e02a Florent Chuffart
// Type of key field (int/real/string/date etc.)
36 2059046b Florent Chuffart
$opts['key_type'] = 'string';
37 7c18e02a Florent Chuffart
38 7c18e02a Florent Chuffart
// Sorting field(s)
39 2059046b Florent Chuffart
$opts['sort_field'] = array('name');
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
$opts['fdd']['name'] = array(
127 7c18e02a Florent Chuffart
  'name'     => 'Name',
128 7c18e02a Florent Chuffart
  'select'   => 'T',
129 7c18e02a Florent Chuffart
  'maxlen'   => 100,
130 7c18e02a Florent Chuffart
  'sort'     => true
131 7c18e02a Florent Chuffart
);
132 7c18e02a Florent Chuffart
$opts['fdd']['description'] = array(
133 7c18e02a Florent Chuffart
  'name'     => 'Description',
134 7c18e02a Florent Chuffart
  'select'   => 'T',
135 7c18e02a Florent Chuffart
  'maxlen'   => 4294967295,
136 7c18e02a Florent Chuffart
  'textarea' => array(
137 7c18e02a Florent Chuffart
    'rows' => 5,
138 7c18e02a Florent Chuffart
    'cols' => 50),
139 7c18e02a Florent Chuffart
  'sort'     => true
140 7c18e02a Florent Chuffart
);
141 7c18e02a Florent Chuffart
$opts['fdd']['origin'] = array(
142 7c18e02a Florent Chuffart
  'name'     => 'Origin',
143 7c18e02a Florent Chuffart
  'select'   => 'T',
144 7c18e02a Florent Chuffart
  'maxlen'   => 4294967295,
145 7c18e02a Florent Chuffart
  'textarea' => array(
146 7c18e02a Florent Chuffart
    'rows' => 5,
147 7c18e02a Florent Chuffart
    'cols' => 50),
148 7c18e02a Florent Chuffart
  'sort'     => true
149 7c18e02a Florent Chuffart
);
150 7c18e02a Florent Chuffart
$opts['fdd']['type'] = array(
151 7c18e02a Florent Chuffart
  'name'     => 'Type',
152 7c18e02a Florent Chuffart
  'select'   => 'D',
153 7c18e02a Florent Chuffart
  'values'   => array(
154 7c18e02a Florent Chuffart
          'table'  => 'cl_type',
155 7c18e02a Florent Chuffart
        'column' => 'type'),
156 7c18e02a Florent Chuffart
  'maxlen'   => 100,
157 7c18e02a Florent Chuffart
  'sort'     => true
158 7c18e02a Florent Chuffart
);
159 ecebbb6d Florent Chuffart
$opts['fdd']['Author'] = array(
160 ecebbb6d Florent Chuffart
  'name'     => 'Author',
161 ecebbb6d Florent Chuffart
  'select'   => 'D',
162 ecebbb6d Florent Chuffart
  'maxlen'   => 10,
163 ecebbb6d Florent Chuffart
  'sort'     => true,
164 ecebbb6d Florent Chuffart
  'values'   => array(
165 ecebbb6d Florent Chuffart
          'table'  => 'lab_members',
166 ecebbb6d Florent Chuffart
        'column' => 'id')
167 ecebbb6d Florent Chuffart
);
168 7c18e02a Florent Chuffart
169 e45ece5c Florent Chuffart
// TRIGGER
170 e45ece5c Florent Chuffart
$opts['triggers']['select']['pre'][]    = 'cl_name.MVC.php';
171 e45ece5c Florent Chuffart
$opts['triggers']['update']['pre'][]    = 'cl_name.MVC.php';
172 e45ece5c Florent Chuffart
173 7c18e02a Florent Chuffart
require("footers.php");
174 7c18e02a Florent Chuffart
?>