Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Jquery highlighting values on assigned table

I'd be glad if a jquery expert can help me with this code really.

Web Development javascript javascript-jquery
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Jquery highlighting values on assigned table

I have some html tables on the page, and some checkboxes whose values to be highlighted on the assigned table. The example code can be seen here : https://jsfiddle.net/9kq5djwr/

What I need to do is only the assigned table values to be highlighted by that specific checkbox group. So when first checkbox group is clicked, values on table1 will be highlighted. and it goes on like that. The HTML tables have the same values, only their table id is unique and different.

This is just an example fiddle, there will be more checkbox groups and tables. I seek a way to do this automatically, without any manual change every time. since the checkbox values will be updated regularly. Can I get any help on this? please.

Web Development javascript javascript-jquery
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Query to get column names in select box and display in table

I'd like to get all of a mysql table's col names in a select box, and display the selected column name in a table. I just want to select one column at a time to display it in a single column table. I am assuming this can be done with a single query for all columns because they all will be displayed in the same table format. What I did so far is this:

<html> <head> </head> <body> <table id="tbresult"> <tr> <th>Column</th> </tr> <?php

include ("config.php");

$sql = "SHOW COLUMNS FROM mytable";

$result = mysqli_query($conn,$sql);

while($row = mysqli_fetch_array($result)){
 echo "<tr><td>" . $row["Column"] ."</td></tr>";
}

    echo "</table>";

} else { echo "0 results"; }
$conn->close();

    ?> </table>
Web Development javascript mysql php
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Working with multiple cell colors

I have this code which I want to use but its color switching function doesn't work the way I want. Once I highlighted the target cells with one color, I also would like to highlight again with a different color without changing the color of the previously highlighted cells. Can somone help me with this, please? Here is a working example https://jsfiddle.net/a05nwahr/ I can only work with one color here only. Please ignore the messiness in the code, I hope you can see the problem in jquery. thanks.

// JavaScript Document
$(document).ready(function() {

$('.selector').each(function() {
    $(this).on('click', check); 
});
    $('.all').each(function() {
       $(this).on('click', all); 
    });

function all(event) {

        if($(this).is(':checked')){  $("input:checkbox:not(:checked)",$(this).parents('form')).not(this).prop("checked","checked");
    } else {
        $("input:checkbox(:checked)",$(this).parents('form')).not(this).prop("checked","");
    }

    //$('.selector').prop("checked", this.name === "SelectAll");

    check(event);
}

function check(event) {
    var checked = $(".selector:checked").map(function () {
        return this.name
    }).get()
    $('td').css('background', '#fff').filter(function () {
        return $.inArray($(this).text(), checked) >= 0
    }).css('background', $('#nextColor').val())
    if ($(this).is(".selector"))
        $('.all').not(this).prop("checked", false)

}

 $( "#Hidden").on( "click", function() {
        $(".selector").toggle();
    });

});
Web Development javascript-jquery
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Changing highlight colors

Thanks again. I didn't know it'd make such difference.

Web Development javascript
cereal commented: You're welcome! +15
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Changing highlight colors

I am sorry, but What am I doing wrong here? it works on fiddle, when I try it on html, it doesn't work. I couldn't figure it out. I just copy & pasted, didn't change anything.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta name="robots" content="noindex, nofollow">
<meta name="googlebot" content="noindex, nofollow">
<script type="text/javascript" src="jquery-2.1.4.js"></script>

<style type="text/css">
body {
font-family:Arial, sans-serif;
}

#wrapper {

margin-left:300px;
}

.column {
  float: left;
}

.column div {
  border: 1px solid #000;
  padding: 4px;
  margin: 2px;
  width: 15px;
  height: 15px;
  text-align: center;
  cursor: pointer;
}

</style>

<title>Example</title>

        <script type='text/javascript'>

// variables
var buttons = document.getElementsByClassName('btn_colors');
var numbers = document.querySelectorAll('.column > div');
var current_color = document.getElementById('green').getAttribute('data-color');

// listener for button clicks
for (let i = 0, c = buttons.length; i < c; i++)
  buttons[i].addEventListener('click', set_color, {
    passive: false
  });

// listener for number cells
for (let i = 0, c = numbers.length; i < c; i++)
  numbers[i].addEventListener('click', set_bg, {
    passive: false
  });

// functions
function set_color(event) {
  event.preventDefault();
  current_color = this.getAttribute('data-color');
}

function set_bg(event) {
    if(this.classList.contains('clicked'))
  {
    this.classList.remove('clicked');
    this.style.backgroundColor = 'transparent';
    return ;
  }

  this.style.backgroundColor = current_color;
  this.classList.add('clicked');
}

</script>

</head>

<body>

<div id="wrapper">

 <div id="Content">
  <p>
    <input class="btn_colors" data-color="#007FFF" type="button" name="blue" id="blue" value="Blue" />
    <input class="btn_colors" data-color="#F2B400" type="button" name="yellow" id="yellow" value="Yellow" />
    <input class="btn_colors" data-color="#66B447" type="button" name="green" id="green" value="Green" />
  </p>
  <div class="column">
    <div>20</div>
    <div>60</div>
  </div>
  <div class="column">
    <div>72</div>
    <div>71</div>
  </div>
  <div class="column">
    <div>88</div>
    <div>87</div>
  </div>
  <div class="column">
    <div>64</div>
    <div>53</div>
  </div>
  <div class="column">
    <div>90</div>
    <div>79</div>
  </div>
  <div class="column"> …
Web Development javascript
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Changing highlight colors

Thanks @Cereal, this script works great.

Web Development javascript
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Changing highlight colors

I have this code which highlights the selected table cell in green color by default.

I am seeking help with a function where there will be three buttons for three different colors, so when I click one of these buttons, the default highlight color will change to that selected color. I have fiddle here too : https://jsfiddle.net/eLb9x2pp/ Any help will be appreciated, I am not very familiar with javascript. And this is what I tried and did so far. but here highlighting doesn't work because of changes I made. https://jsfiddle.net/r94m7o8c/

Web Development javascript
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

Ok, thanks, Cereal. I will look into RJ's approach too.

Databases mysql sql
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

Cereal, thanks for your valuable time, and coding. This is more than I expected, actually I didn't expect that much coding. I'll need to learn mysql deeper to understand and implement this code.

Databases mysql sql
cereal commented: You're welcome! +15
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

Thanks for your advice, Jim.

Databases mysql sql
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

The numbers represented by B1,B2,B3,B4,B5,B6. For example on this example data the pair 3,4 is repeated 3 times. 

    ID   B1 B2
    5    3   4
    9    3   4
    14   3   4

Each row of table has 6 unique numbers. Note: I made a mistake in ID:5 row, there are two 4s. Numbers don't repeat in the rows.

Databases mysql sql
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

For most common pairs. If it is possible, it would be nice to have a threshold level. for example if threshold is set to 5, then it would list only the most common pairs that occur at least 5 times.

Databases mysql sql
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Re: Mysql query to list all most common pairs with their IDs

Thanks Jim. Here is some Data:

ID  B1  B2  B3  B4  B5  B6
1   6   8   10  26  27  36
2   2   5   10  11  32  42
3   20  21  23  24  29  38
4   3   4   17  19  33  49
5   2   17  20  23  33  41
6   1   12  13  20  31  48
7   20  21  26  41  44  47
8   3   4   43  44  46  47
9   6   7   20  23  29  46
10  1   5   13  20  46  40
11  2   5   10  18  47  40
12  20  21  23  24  37  39
13  3   4   17  25  38  41
14  5   17  20  29  30  41
15  12  14  28  31  32  43

Results would be like: 

Count   B1  B2   ID(1)  ID(2)   ID(3)   ID(4)   ID(5)   ID(6)   ID(7)   ID(8) ID(9)etc.
      5     1   2     10     25     45      90   220                    
      8     11   36    4      12      13        19    40     42     89      90
Databases mysql sql
Member Avatar for Mati_1
Mati_1 30 Newbie Poster
Mysql query to list all most common pairs with their IDs

I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks.

Databases mysql sql