Mkotla has Published 97 Articles

Style input type button with CSS

mkotla

mkotla

Updated on 24-Jun-2020 06:12:18

4K+ Views

The input type button can be a submit button or reset button. With CSS, we can style any button on a web page.You can try to run the following code to style input type button:ExampleLive Demo                    input[type=button] {   ... Read More

Selects every element whose href attribute value ends with ".htm" with CSS

mkotla

mkotla

Updated on 24-Jun-2020 05:47:59

445 Views

Use the [attribute$=”value”] selector to select elements whose attribute value ends with a specified value i.e. “.htm” here.You can try to run the following code to implement the CSS [attribute$="value"] Selector, ExampleLive Demo                    [href$ = htm] {     ... Read More

Set a delay for the CSS transition effect

mkotla

mkotla

Updated on 24-Jun-2020 05:33:49

178 Views

Use the transition-delay property to set a delay for the transition effect with CSS. You can try to run the following code to set a 1-second delay of transition:ExampleLive Demo                    div {             width: 150px; ... Read More

Usage of CSS [attribute] Selector

mkotla

mkotla

Updated on 23-Jun-2020 15:03:03

276 Views

Use the [attribute] selector to select elements with an attribute, for example, an alt attribute or a target attribute, etc.You can try to run the following code to implement the CSS[attribute] selector,ExampleLive Demo                    img[alt] {             border: 3px solid orange;          }                              

How to write PHP script by using MySQL JOINS inside it to join two MySQL tables?

mkotla

mkotla

Updated on 22-Jun-2020 14:11:18

5K+ Views

We can use the syntax of MySQL JOIN for joining two tables into the PHP function – mysql_query(). This function is used to execute the SQL command and later another PHP function – mysql_fetch_array() can be used to fetch all the selected data.To illustrate it we are having the following ... Read More

Which PHP function is used to establish MySQL database connection using PHP script?

mkotla

mkotla

Updated on 22-Jun-2020 13:23:44

214 Views

PHP provides mysql_connect() function to open a database connection. This function takes five parameters and returns a MySQL link identifier on success or FALSE on failure. Its syntax is as follows −Syntaxconnection mysql_connect(server, user, passwd, new_link, client_flag);Following table give us the parameters used in the syntax above −Sr.NoParameter & Description1ServerOptional ... Read More

Intersect Method in C#

mkotla

mkotla

Updated on 22-Jun-2020 12:58:45

495 Views

Use the Intesect method to get the common elements −Create lists −var list1 = new List{99, 87}; var list2 = new List{56, 87, 45, 99};Now, use the Intersect() method to get the common elements from the above list −list1.Intersect(list2);Here is the complete code −Example Live Demousing System.Collections.Generic; using System.Linq; using System; ... Read More

C# Equivalent to Java Functional Interfaces

mkotla

mkotla

Updated on 22-Jun-2020 12:50:16

2K+ Views

Equivalent of Java’s Functional Interfaces in C# is Delegates.Let us see the implementation of functional interface in Java −Example@FunctionalInterface public interface MyInterface {    void invoke(); } public class Demo {    void method(){       MyInterface x = () -> MyFunc ();       x.invoke();    } ... Read More

How can we simulate the MySQL MINUS query?

mkotla

mkotla

Updated on 22-Jun-2020 12:47:50

622 Views

Since we cannot use the MINUS query in MySQL, we will use JOIN to simulate the MINUS query. It can be understood with the help of the following example −ExampleIn this example, we are two tables namely Student_detail and Student_info having the following data −mysql> Select * from Student_detail; +-----------+---------+------------+------------+ ... Read More

How can we enter characters as Hexadecimal (HEX) number in MySQL statement?

mkotla

mkotla

Updated on 22-Jun-2020 12:25:02

1K+ Views

Following are the two approaches with the help of which we can enter characters as a Hexadecimal number −By prefix ‘X’In this approach we need to quote hexadecimal numbers within single quotes with a prefix of X. Then HEX number string will be automatically converted into a character string.Examplemysql> Select ... Read More

Advertisements