Web Technology Experts Notes

Sunday 29 March 2020

How do I copy to the clipboard in JavaScript?

Step 1: Add Following javascript function in Web page.

    function selectAllData(id) {
    var obj = document.getElementById(id);
        var text_val=eval(obj);
        text_val.focus();
        text_val.select();
        if (!document.all) return; // if IE return;
        r = text_val.createTextRange();
        r.execCommand('copy');
    }

Step 2: call selectAllData('id') function with passing the id of the container. See Example

<input onclick="return selectAllData('textareaId')" type="button" value="Select All" />

Following are consolidate Code:


<script type="text/javascript"> function selectAllData(id) { var obj = document.getElementById(id); var text_val=eval(obj); text_val.focus(); text_val.select(); if (!document.all) return; // if IE return; r = text_val.createTextRange(); r.execCommand('copy'); }</script> <textarea cols="30" id="textareaId" row="50"> javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers javascript interview questions and answers </textarea> <input onclick="return selectAllData('textareaId')" type="button" value="Select All" />

See demo:

Question: What is the most efficient way to deep clone an object in JavaScript?

const a = {
  string: 'string',
  number: 123,
  bool: false,
  nul: null,
  date: new Date(), 
}
console.log(a);
console.log(typeof a.date);  // Date object
const clone = JSON.parse(JSON.stringify(a));
console.log(clone);

General error: 1364 Field city_id doesn't have a default value

I have upgraded the MySQL from 5.5 to 5.6 and then getting below type of errors.
General error: 1364 Field 'city_id' doesn't have a default value

(I was not getting such type of error, it must come after upgrading my MySQL Version from 5.5 to 5.6)

Solution: It have 3 Solutions

In Your Code (PHP), always set a default value (if no value) before save.

$objSaveData->saveData(
    array(
        'id'=>111,
        'name'=>'New user',
        'city_id'=>0, //default value
    );
);

Create fields with default values set in datatable. It could be empty string, which is fine for MySQL server running in strict mode.
like below:
```
ALTER TABLE `users` CHANGE `city_id` `city_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';
```
Disable MySQL Strict Mode (Most appropriate)
Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL.

Look for the following line:
```
sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
```
Change it to:
```
sql-mode="" 
```
Restart the MySQL Service.

Sunday 29 March 2020

How do I copy to the clipboard in JavaScript?

Best Related Posts are Following:

General error: 1364 Field city_id doesn't have a default value

Solution: It have 3 Solutions