Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Thursday, July 25, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  checkboxes for values from another table

phpMyEdit General     checkboxes for values from another table
Post new topic   Reply to topic   Goto page 1, 2, 3, 4, 5  Next  
 
dutchak     Joined: 12 Nov 2011   Posts: 1  
Post Posted: 2011-11-12 09:32
Back to top  Reply with quote     

Hi all,
Maybe I'm missing something, but I have tried all founded solutions on this forum an no results unfortunatelly.
The task is seems to be simple:
Code:

$opts['fdd']['price_id'] = array(
'name'     => 'Fixed price:',
'select'   => 'C');
$opts['fdd']['price_id']['values']['table'] = 'services';
$opts['fdd']['price_id']['values']['column'] = 'service_id';
$opts['fdd']['price_id']['values']['description'] = 'service_name';
$opts['fdd']['price_id']['values']['filters'] = 'service_group_id in (7)';

There should be checkboxes, but system forceing me to use Dropdown list only.
I'll appreciate any help on this.

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2011-11-12 17:42
Back to top  Reply with quote     

Set 'select' to M for multiple-select. Checkboxes are not an option.

 
trister     Joined: 01 Dec 2010   Posts: 15  
Post Posted: 2011-11-17 10:03
Back to top  Reply with quote     

A solution I did for the checkbox problem was this :

main file :
Code:
$opts['fdd']['assign_to_notify_only'] = array(
  'name'     => 'assign to name',
  'select'   => 'T',
  'select|CA'   => 'C', // Multiple Selection only under EDIT (C) and Add (A) 
  'sort'     => true
);
//The Following line includes some PHP code that creates a [values2] entry.
include "trister/query_values2_multiselect.php";

Included file :
query_values2_multiselect.php

Code:
<?php
//To DO use better mysql connect
$db_link = mysql_connect($opts['hn'],$opts['un'],$opts['pw']);
mysql_select_db($opts['db'],$db_link);
/* SET NAMES 'utf-8' COLLATE 'collation_name' */
@mysql_query("SET NAMES 'utf8'",$db_link);   

$array_names='';
$query='SELECT name FROM assign_names';
  $name_templist = '';
  $res = mysql_query($query,$db_link);
  while ($row = @mysql_fetch_array($res)) {
      $name_temp = $row['name'];
      $array_names[$name_temp]=$name_temp;
  }
  mysql_close($db_link);
 
$opts['fdd']['assign_to_notify_only']['values2']=$array_names;
  ?>


It is a workarround that works ok for me.
I hope this helps people.
Any suggestions /corrections are welcome.
Note: I am using this with the latest CVS version.

 
trister     Joined: 01 Dec 2010   Posts: 15  
Post Posted: 2011-11-28 11:23
Back to top  Reply with quote     

Fix to checkbox Filtering problem.
The solution I posted had a problem during filtering.

My solution was to hack phpMyEdit.class.php and
replace this line :
Code:
= array('oper'  => 'IN', 'value' => '('.join(',', $ids).')');

With this

Code:
=array('oper' => 'LIKE', 'value' => "'$afilter'");


I haven't tried to see if this breaks anything else but It have solved the checkbox add/edit/filter search problem[/code]

 
tom0099     Joined: 12 Jul 2021   Posts: 20  
Post Posted: 2021-07-12 14:09
Back to top  Reply with quote     

Hello friends we here the right website free fortnite skin i hope you like and enjoy to play this free online game.

 
Kaylee9921     Joined: 29 Jun 2021   Posts: 36  
Post Posted: 2021-11-16 02:27
Back to top  Reply with quote     

Based on our review, the service is definitely one of the very best ones there online. When it comes to writers, there are so many experts to choose https://royalessays.co.uk/blog/narrative-essay-outline from depending on your subject. That means there&#8217;s always someone ready to assist you with your assignment. As for the support staff, not only are they highly-competent but also professional.

 
andrewsaw1     Joined: 07 Sep 2022   Posts: 50  
Post Posted: 2022-09-07 08:15
Back to top  Reply with quote     

Whether you&#8217;re in need of a small repair, or are embarking on an entire kitchen remodel, our team of tile experts have a tile solution for you! Experience the difference professional service can make.
Camarillo Green Tree Service

 
danverseak2     Joined: 07 Sep 2022   Posts: 72  
Post Posted: 2023-01-06 02:46
Back to top  Reply with quote     

Don&#8217;t suffer in the heat&#8212;let us bring back that Arctic chill to your truck&#8217;s cabin today.

Kenner On-Site Truck Repair

 
lilycollins9x     Joined: 23 Feb 2023   Posts: 9  
Post Posted: 2023-02-23 08:50
Back to top  Reply with quote     

Checkboxes for values from another table can be used to allow users to select one or more options from a list of values that are stored in a separate bitlife table. This is commonly used in database applications to create a many-to-many relationship between two tables.

 
Emaan     Joined: 12 Mar 2023   Posts: 2  
Post Posted: 2023-03-13 05:13
Back to top  Reply with quote     

The most common way to unclog a toilet without a plunger is with hot water. Start by boiling a large pot of water, then carefully pour the water into the toilet bowl. The hot water should help to break up the clog and flush it down the drain. https://toiletneeds.com/best-toto-toilet/

 
keagan     Joined: 04 Oct 2022   Posts: 12  
Post Posted: 2023-06-28 04:47
Back to top  Reply with quote     

Put a M in the'select' box to enable multiple selection. It is not possible to use checkboxes. basketball stars

 
indiadigital     Joined: 28 Jun 2023   Posts: 64  
Post Posted: 2023-06-28 06:42
Back to top  Reply with quote     

Digital India Solutions

Digital India Solutions offers Website Designing, Website Development, Search Engine Optimization, Mobile App Development, IT Security Audit, Online Marketing, Graphic Designing, Corporate Identity, Software Development, Website Promotion, Domain + Hosting services in India at very affordable rates maintaining the best quality and on-time completion policy.

https://www.indiadigitalsoluution.in

 
ClaraTilla     Joined: 27 Mar 2022   Posts: 53  
Post Posted: 2023-06-29 20:09
Back to top  Reply with quote     

The availability of hire professional writing essay services provides individuals with access to a diverse pool of talented writers, increasing the likelihood of finding the perfect match for their essay needs.

 
Zombies     Joined: 12 Dec 2022   Posts: 711  
Post Posted: 2023-07-03 08:22
Back to top  Reply with quote     

I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. mécanique localité de Radisson

 
fedada     Joined: 03 Oct 2022   Posts: 1071  
Post Posted: 2023-07-23 07:32
Back to top  Reply with quote     

I went over this website and I believe you have a lot of wonderful information, saved to my bookmarks Langit69 Daftar

 
Post new topic   Reply to topic   Goto page 1, 2, 3, 4, 5  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