Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The text can be found and replaced with the help of the replace() function. It is explained with the help of the following steps −First, a table is created with the help of the create command which is given as follows −mysql> CREATE table FindAndReplaceDemo -> ( -> FirstName varchar(200) -> ); Query OK, 0 rows affected (0.43 sec)After creating the above table, the records are inserted with the help of the insert command. This is given below −mysql> INSERT into FindAndReplaceDemo values('john'); Query OK, 1 row affected (0.15 sec) mysql> INSERT into FindAndReplaceDemo values('smith'); Query OK, 1 row ... Read More
Appcaches are used by the web browser to specify what files exist on your site that is relevant to the particular page the browser is visiting.Safari follows the AppCache standard more strictly and sees a request for a web address that is not in the AppCache.To avoid the requests to be blocked, use −NETWORK: * http://* https://*
To avoid the double click text issue −var canvas1 = document.getElementById('c'); canvas1.onselectstart = function () { return false; }Note − The Canvas should not fill the width of the page and it is only 100 pixels wide.
Firstly, we need to create a table with some records, then we will use pagination with the help of limit and offset.Creating a table with the help of CREATE command. The query is as follows −mysql> CREATE table limitoffsetDemo -> ( -> id int, -> FisrtName varchar(200) -> ); Query OK, 0 rows affected (0.45 sec)After creating a table, we will insert records with the help of INSERT command.Inserting recordsmysql> INSERT into limitoffsetDemo values(1, 'John'); Query OK, 1 row affected (0.11 sec) mysql> INSERT into limitoffsetDemo values(2, 'Bob'); Query OK, 1 row affected (0.16 sec) mysql> INSERT into ... Read More
To be able to playback video from a specific time using the HTML5 video tag, try these fixes.Your web server should be capable of serving the document using byte ranges. The Google Chrome web browser want this to work. If this is not worked out, then the seeking will be disabled and even if you set the currentTime, it will not work.Test your web server, if it allows this −curl --dump-header - -r0-0 http://theurl
It is not possible to reset the checkbox back to the default native style with some web browsers.You can try this and list every type of input to style −input[type="text"], input[type="password"] { border: 2px solid green; }You can also use the CSS3 pseudo-class, but it may or may not work in IE 11 −input:not([type="checkbox"]) { border: 2px solid green; }
To make it work correctly, you need to work around xhr progress event, which is fired when all list items had been already created.The xhr should know what you want to do −var a = new XMLHttpRequest(); a.upload.li = li; a.upload.addEventListener('progress', function(e) { var pc = parseInt(event.loaded / event.total * 100); this.li.find(".progressbar").width(pc); }, false);
In MySQL, the length of NULL is 0. Here, we will see how NULL can be used with SELECT statement. Let us create a table with the help of CREATE command −Creating a table −mysql> CREATE table NullWIthSelect -> ( -> Name varchar(100) -> ); Query OK, 0 rows affected (0.62 sec)Above, I have created a table successfully. Now I will insert some records with the help of INSERT command −Inserting records −mysql> INSERT into NullWIthSelect values('John'); Query OK, 1 row affected (0.16 sec) mysql> INSERT into NullWIthSelect values('Bob'); Query OK, 1 row affected (0.12 sec) mysql> INSERT ... Read More
For cross-browser HTML File Uploader, use FileDrop. It works on almost all modern web browsers.As per the official specification −FileDrop is a self-contained cross-browser for HTML5, legacy, AJAX, drag & drop, JavaScript file upload
To know the current time, we can use the now() function with SELECT statement. The query is as follows −mysql> SELECT now();After executing the above query, we will get the current time. The following is the output −+---------------------+ | now() | +---------------------+ | 2018-10-06 12:57:25 | +---------------------+ 1 row in set (0.02 sec)To set the time zone, we can use the command SET. The syntax is as follows −mysql> SET time_zone = "Some value"; Now I am applying the above query to set the time zone. ... Read More