Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, December 6, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  problems: checkbox and unable-entries

phpMyEdit Configuration     problems: checkbox and unable-entries
Post new topic   Reply to topic   Goto page 1, 2, 3, 4  Next  
 
jan99     Joined: 23 Jan 2008   Posts: 13  
Post Posted: 2008-02-14 19:20
Back to top  Reply with quote     

Hi !

i test some configurations and i have some problemes. i would be very happy, wenn somebody can help me.

1.) i had a table and there is the entry CHECKBOX with in the edit-dialog should looks like a options-controll.

2.) there is the field VALUE1 - this sould be unable to edit in die edit-dialog / but show in the view-form.

at the button i posted my database an the code.

regards jan :-)


--------- database ----------

Quote:
CREATE TABLE `pme_data_1` (
`id` smallint(5) NOT NULL auto_increment,
`checkbox` tinyint(1) NOT NULL,
`value1` varchar(50) collate latin1_general_ci NOT NULL,
`value2` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle `pme_data_1`
--

INSERT INTO `pme_data_1` VALUES (1, 0, 'tadasdf', 'asdfadf');
INSERT INTO `pme_data_1` VALUES (2, 1, 'sadfasdf', 'kljhlj');



--------- pme-code ----------

Code:
<style type="text/css">
   hr.pme-hr           { border: 0px solid; padding: 0px; margin: 0px; border-top-width: 1px; height: 1px; }
   table.pme-main         { border: #004d9c 1px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
   table.pme-navigation { border: #004d9c 0px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
   td.pme-navigation-0, td.pme-navigation-1 { white-space: nowrap; }
   th.pme-header        { border: #004d9c 1px solid; padding: 4px; background: #add8e6; }
   td.pme-key-0, td.pme-value-0, td.pme-help-0, td.pme-navigation-0, td.pme-cell-0,
   td.pme-key-1, td.pme-value-1, td.pme-help-0, td.pme-navigation-1, td.pme-cell-1,
   td.pme-sortinfo, td.pme-filter { border: #004d9c 1px solid; padding: 3px; }
   td.pme-buttons { text-align: left;   }
   td.pme-message { text-align: center; }
   td.pme-stats   { text-align: right;  }
</style><?php

/*
* IMPORTANT NOTE: This generated file contains only a subset of huge amount
* of options that can be used with phpMyEdit. To get information about all
* features offered by phpMyEdit, check official documentation. It is available
* online and also for download on phpMyEdit project management page:
*
* http://platon.sk/projects/main_page.php?project_id=5
*
* This file was generated by:
*
*                    phpMyEdit version: unknown
*       phpMyEdit.class.php core class: 1.204
*            phpMyEditSetup.php script: 1.50
*              generating setup script: 1.50
*/

// MySQL host name, user name, password, database, and table
$opts['hn'] = 'xxxxxxxxxx';
$opts['un'] = 'xxx';
$opts['pw'] = '';
$opts['db'] = 'xxxxxxxxxx';
$opts['tb'] = 'pme_data_1';

// Name of field which is the unique key
$opts['key'] = 'id';

// Type of key field (int/real/string/date etc.)
$opts['key_type'] = 'int';

// Sorting field(s)
$opts['sort_field'] = array('id');

// Number of records to display on the screen
// Value of -1 lists all records in a table
$opts['inc'] = 15;

// Options you wish to give the users
// A - add,  C - change, P - copy, V - view, D - delete,
// F - filter, I - initial sort suppressed
$opts['options'] = 'ACPVDF';

// Number of lines to display on multiple selection filters
$opts['multiple'] = '4';

// Navigation style: B - buttons (default), T - text links, G - graphic links
// Buttons position: U - up, D - down (default)
$opts['navigation'] = 'DB';

// Display special page elements
$opts['display'] = array(
   'form'  => true,
   'query' => true,
   'sort'  => true,
   'time'  => true,
   'tabs'  => true
);

// Set default prefixes for variables
$opts['js']['prefix']               = 'PME_js_';
$opts['dhtml']['prefix']            = 'PME_dhtml_';
$opts['cgi']['prefix']['operation'] = 'PME_op_';
$opts['cgi']['prefix']['sys']       = 'PME_sys_';
$opts['cgi']['prefix']['data']      = 'PME_data_';

/* Get the user's default language and use it if possible or you can
   specify particular one you want to use. Refer to official documentation
   for list of available languages. */
$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'] . '-UTF8';

/* Table-level filter capability. If set, it is included in the WHERE clause
   of any generated SELECT statement in SQL query. This gives you ability to
   work only with subset of data from table.

$opts['filters'] = "column1 like '%11%' AND column2<17";
$opts['filters'] = "section_id = 9";
$opts['filters'] = "PMEtable0.sessions_count > 200";
*/

/* Field definitions
   
Fields will be displayed left to right on the screen in the order in which they
appear in generated list. Here are some most used field options documented.

['name'] is the title used for column headings, etc.;
['maxlen'] maximum length to display add/edit/search input boxes
['trimlen'] maximum length of string content to display in row listing
['width'] is an optional display width specification for the column
          e.g.  ['width'] = '100px';
['mask'] a string that is used by sprintf() to format field output
['sort'] true or false; means the users may sort the display on this column
['strip_tags'] true or false; whether to strip tags from content
['nowrap'] true or false; whether this field should get a NOWRAP
['select'] T - text, N - numeric, D - drop-down, M - multiple selection
['options'] optional parameter to control whether a field is displayed
  L - list, F - filter, A - add, C - change, P - copy, D - delete, V - view
            Another flags are:
            R - indicates that a field is read only
            W - indicates that a field is a password field
            H - indicates that a field is to be hidden and marked as hidden
['URL'] is used to make a field 'clickable' in the display
        e.g.: 'mailto:$value', 'http://$value' or '$page?stuff';
['URLtarget']  HTML target link specification (for example: _blank)
['textarea']['rows'] and/or ['textarea']['cols']
  specifies a textarea is to be used to give multi-line input
  e.g. ['textarea']['rows'] = 5; ['textarea']['cols'] = 10
['values'] restricts user input to the specified constants,
           e.g. ['values'] = array('A','B','C') or ['values'] = range(1,99)
['values']['table'] and ['values']['column'] restricts user input
  to the values found in the specified column of another table
['values']['description'] = 'desc_column'
  The optional ['values']['description'] field allows the value(s) displayed
  to the user to be different to those in the ['values']['column'] field.
  This is useful for giving more meaning to column values. Multiple
  descriptions fields are also possible. Check documentation for this.
*/

$opts['fdd']['id'] = array(
  'name'     => 'ID',
  'select'   => 'T',
  'options'  => 'AVCPDR', // auto increment
  'maxlen'   => 5,
  'default'  => '0',
  'sort'     => true
);
$opts['fdd']['checkbox'] = array(
  'name'     => 'Checkbox',
  'select'   => 'C',
  'maxlen'   => 1,
  'sort'     => true
);
$opts['fdd']['value1'] = array(
  'name'     => 'Value1',
  'select'   => 'T',
  'options'   => 'R',
  'maxlen'   => 50,
  'sort'     => true
);
$opts['fdd']['value2'] = array(
  'name'     => 'Value2',
  'select'   => 'T',
  'maxlen'   => 50,
  'sort'     => true
);

// Now important call to phpMyEdit
require_once 'phpMyEdit.class.php';
new phpMyEdit($opts);

?>





Quote:


 
jan99     Joined: 23 Jan 2008   Posts: 13  
Post Posted: 2008-02-23 13:56
Back to top  Reply with quote     

ok !

i found the way ...

i did not use checkbox - but drop-down

manuall: 4.5 / simple restriction

regards Jan :-)

 
fibykas     Joined: 31 Oct 2020   Posts: 1  
Post Posted: 2020-10-31 10:51
Back to top  Reply with quote     

Do not use Check Box but Drop-Down then you can resolve your problem. If you still feel anything wrong then visit cv writer uk as they have the best way to resolve this with proper steps.

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-01-25 09:28
Back to top  Reply with quote     

All you need to know about African Mangoo fully explained. Canada visumans&#248;gning

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-02-04 11:24
Back to top  Reply with quote     

One of the most lucrative fields that you can get into as a salesperson is selling to other businesses and especially selling merchant accounts. how to start a credit card processing business

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-02-09 10:01
Back to top  Reply with quote     

Hey, You make great use of your words in this article. I am impressed with the valid points of interest you make here and I agree. In time your site will discover its potential. Later. ETA Visa za Novo Zelandijo

 
soveda4966     Joined: 24 Nov 2021   Posts: 1167  
Post Posted: 2022-02-16 11:40
Back to top  Reply with quote     

Hey you. I do not know whether it&#8217;s acceptable, but this blog is really well designed. Canadian Visa Application Online

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-02-17 10:25
Back to top  Reply with quote     

Read the Timeshare Exit Team review to get insight into the lawsuit. ... 2012 but also goes by a few other names like 'Reed Hein & Associates' and '321Exit timeshare compliance

 
norih95349     Joined: 02 Feb 2022   Posts: 169  
Post Posted: 2022-03-01 14:02
Back to top  Reply with quote     

Thanks, I have recently been hunting for info about this subject matter for ages and yours is the best I have located so far. Visa para India

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-03-09 13:28
Back to top  Reply with quote     

If you're looking to buy Instagram followers, you're not alone. Many companies offer these services. Picuki

 
firisi1000     Joined: 04 Dec 2021   Posts: 4612  
Post Posted: 2022-03-09 13:33
Back to top  Reply with quote     

Healthy Habits | Building a healthy online lifestyle is necessary to survive in the internet world. Here are some tips that can help you out ... Skyward fbisd

 
Goldyy     Joined: 08 Nov 2020   Posts: 79  
Post Posted: 2022-03-28 20:20
Back to top  Reply with quote     

Hello! Need help with assignment writing? Stuck with piles of homework and the weekend looks quite exciting for a road trip? College life is quite exciting with memories to make and parties to attend. Why miss out on all the fun while we are here to ease your academic burden. Pro writers from www.writemyessays.org working with us work round the clock, ready to work on your order.

 
oncasino123     Joined: 04 Aug 2022   Posts: 49  
Post Posted: 2022-09-22 10:00
Back to top  Reply with quote     

I'm so happy to finally find a post with what I want. You have inspired me a lot. If you are satisfied, please visit my website and leave your feedback.
https://majorcasino.org/

 
oncasino123     Joined: 04 Aug 2022   Posts: 49  
Post Posted: 2022-09-29 07:23
Back to top  Reply with quote     

It is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post. But by chance looking at your post solved my problem! I will leave my blog, so when would you like to visit it?!
https://oncasino.io/

 
nguoi lao dong     Joined: 05 Feb 2023   Posts: 51  
Post Posted: 2023-04-16 09:58
Back to top  Reply with quote     

I would like to thank you for the efforts you have put in penning this site. I&#8217;m hoping to view the same high-grade content by you later on as well. In truth, your creative writing abilities has motivated me to get my own, personal website now. https://tojino.io/

 
Post new topic   Reply to topic   Goto page 1, 2, 3, 4  Next  

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy