PROGRAMMING SOLUTION

Select bettwen in Where condition in mysql

In my MySQL to select between data

Example:

SELECT id, current_role_in_khmer
FROM currentrole
WHERE id NOT BETWEEN 11 AND 14
AND id NOT BETWEEN 18 AND 19
AND `status`=1

in codeigniter

      $this->db->select('*');
      $this->db->from('currentrole');
      $this->db->where('status', '1');
      $this->db->where('id !=',1 );
      $this->db->where("id BETWEEN 2 and 4");
      $data['get_currentrole_leader']=$this->db->get()->result();

The Tomcat connector configured to listen on port 8080 failed to start in IntelliJ

***************************
APPLICATION FAILED TO START
***************************

Description:

The Tomcat connector configured to listen on port 8080 failed to start. The port may already be in use or the connector may be misconfigured.

Action:

Verify the connector's configuration, identify and stop any process that's listening on port 8080, or configure this application to listen on another port.

Anwser

Configure another port number in /src/main/resources/application.properties

server.port=8181

I can't insert anything on Intellij IDE

If we can not insert anything on Intellij IDE such as back key..
issue like that :

On the top menu, go to Tools > Vim Emulator

HTML CODE

PHP CODE (update.php)

<?php

//update.php

$connect = mysqli_connect("localhost", "root", "", "X-editable");

$query = "

UPDATE employee SET ".$_POST["name"]." = '".$_POST["value"]."'

WHERE id = '".$_POST["pk"]."'";

mysqli_query($connect, $query);

JAVASCRIPT CODE

$('#dob').editable({
format: 'yyyy-mm-dd',
viewformat: 'dd/mm/yyyy',
url: '/post', defaultValue: "11/11/2012"
})

Datatables warning(table id = 'example'): cannot reinitialise data table

https://stackoverflow.com/questions/13708781/datatables-warningtable-id-example-cannot-reinitialise-data-table

mcrypt_get_iv_size Error

$config['sess_encrypt_cookie'] = TRUE;
change to $config['sess_encrypt_cookie'] = FALSE;

SELECT *

FROM table

WHERE CONCAT( lastName, ' ', FristName) LIKE '%Rachana%'