Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
For this, use FIND_IN_SET() in MySQL and use the value from a custom variable. Let us first create a −mysql> create table DemoTable1411 -> ( -> Value int -> ) -> ; Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert −mysql> insert into DemoTable1411 values(10); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1411 values(50); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1411 values(60); Query OK, 1 row affected (0.08 sec)Display all records from the table using select −mysql> select * from DemoTable1411;This will produce ... Read More
To mask data fields, use CONCAT() along with REPEAT(). Here, we will mask data fields with #. Let us first create a −mysql> create table DemoTable1410 -> ( -> Password varchar(80) -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert −mysql> insert into DemoTable1410 values('John12345678'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1410 values('Carol_897'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1410 values('David_5647383'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select −mysql> select * from DemoTable1410;This will produce ... Read More
The event.delegateTarget property in jQuery is used to return the element where the currently-called jQuery event handler was attached.SyntaxThe syntax is as follows −event.delegateTargetExampleLet us now see an example to implement the jQuery event.delegateTarget property − $(document).ready(function(){ $("div").on("click", "button", function(event){ $(event.delegateTarget).css("color", "red"); }); }); Demo Heading Change color by clicking on below button. This is demo text. Click to change color OutputThis will produce the following output −Above, click on the button to change the text color −
The nextAll() method in jQuery is used to return all next sibling elements of the selected element.ExampleLet us now see an example to implement the jQuery nextAll() method − .demo * { display: block; border: 3px solid yellow; padding: 3px; margin: 25px; } .one { border: 2px solid blue; } $(document).ready(function(){ $("span.test").nextAll().addClass("one"); }); Heading One This is our demo text in div. child grandchild grandchild grandchild grandchild ... Read More
The next() selector in jQuery is used to return the next sibling element of the selected element.SyntaxThe syntax is as follows −$(selector).next(filter)Above, the parameter filter is a selector expression to narrow down the next sibling searchExampleLet us now see an example to implement the jQuery next() selector − .demo * { display: block; border: 3px dashed red; padding: 3px; margin: 25px; } .one { border: 2px solid yellow; } $(document).ready(function(){ $("span.test").next().addClass("one"); ... Read More
The contents() method in jQuery is used to return all direct children, including text and comment nodes, of the selected element.SyntaxThe syntax is as follows −$(selector).contents()ExampleLet us now see an example to implement the jQuery contents() method − $(document).ready(function(){ $("button").click(function(){ $("div").contents().filter("p").wrap(""); }); }); Products 90% of the products are sold. 10% of the products are still waiting to get dispatched. Text Nodes OutputThis will produce the following output −Now, click on the “Text Nodes” button −
The children() method in jQuery is used to return all direct children of the selected element.ExampleLet us now see an example to implement the jQuery children() method − .demo * { display: block; border: 2px solid blue; padding: 10px; margin: 25px; } .one { border: 2px solid yellow; } $(document).ready(function(){ $("div").children().addClass("one"); }); Heading One This is our demo text in div. child grandchild grandchild child grandchild ... Read More
The add() method in jQuery is used to add elements to an existing group of elements.SyntaxThe syntax is as follows −$(selector).add(ele, context)Above, ele is the selector expression, whereas context specifiesfrom where the selector expression should begin matching.ExampleLet us now see an example to implement the jQuery add() method − .one { color: white; background-color: blue; } $(document).ready(function(){ $("h2").add("p").addClass("one"); }); Products Out-of-stock products Let us now see some products. We had Accessories We also had Books, which are now ... Read More
The before() method in jQuery is used to insert specified content before the selected elements.ExampleLet us now see an example to implement the before() method in jQuery − $(document).ready(function(){ $("#btndemo").click(function(){ $("img").before("Text inserted before!"); }); }); Insert specified content OutputThis will produce the following output −Click on “Insert specified content” −
The after() method in jQuery is used to insert specified content after the selected elements.ExampleLet us now see an example to implement the jQuery after() method − $(document).ready(function(){ $("#btndemo").click(function(){ $("img").after("Text inserted after!"); }); }); Insert specified content OutputThis will produce the following output −Click on the above button to display the text −