Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Chandu yadav
Page 41 of 81
How to improve the ranking of your websites for search engines
Let’s assume that, you want to promote your dance academy. As the owner of the institution, you want more people to know about the types of dance forms being taught in your institute and the other facilities you are providing. The more people know about your academy, the more students you will get. So, with the help of your friends, you built a nice website to reach a wider spectrum of people in your regions which cannot be possible otherwise.Finally, you launched your website keeping your fingers crossed to see the response. A month passed, but you couldn’t see any ...
Read MoreWhy does one need a mentor in life to grow?
Either you want a growth in the current role or kick off a new business, a good mentor can pave the way for you. At your workplace, you might find many individuals who hold a treasure of leadership experiences and people just fall for their intelligence. You can make such people your mentor. Let’ dig out how you can benefit yourself from a good mentor?Who Can Be Your Mentor?Someone who takes his/her career passionately. This person carries a good deal of exposure in terms of experience and leadership and holds the ability to take you at the top from your ...
Read MoreCreate Three Equal Columns with Bootstrap grid Layout
To create three equal columns layout with Bootstrap Grid Layout, you can try to run the following code −Example Bootstrap Example Bootstrap Grid Column One Column Two Column Three Output
Read MorePriority of AND and OR operator in MySQL select query?
The AND has the highest priority than the OR operator in MySQL select query.Let us check how MySQL gives the highest priority to AND operator.The query is as followsmysql> select 0 AND 0 OR 1 as Result;The following is the output+--------+ | Result | +--------+ | 1 | +--------+ 1 row in set (0.00 sec)If you are considering the OR operator has the highest priority then MySQL will wrap up the above query like this.The query is as followsselect 0 AND (0 OR 1) as ResultFirst, solve the 0 OR 1, this will give result 1. After that ...
Read MoreDefining internet of things iot for businesses
In today’s world, the biggest technology trend is the ‘Internet of Things (IoT);’ and true enough it is defining our lives, the way we work; shaping and influencing businesses, and governments too. It is the ‘next big thing’ or is simply being termed as a revolution/progression of the web, and is being touted as far bigger than anyone has been able to fathom in technology, where machine to machine and man to machine interaction is moving towards new heights.GuesstimatesIt is estimated that by 2020 there will be around 26 billion devices (as per the firm Gartner) that will be connected ...
Read MoreHow do I add Vibrate and sound for Notification in Android?
This example demonstrate about How do I add Vibrate and sound for Notification in AndroidStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. Step 3 − Add the following code to src/MainActivity.javapackage app.tutorialspoint.com.notifyme; import android.app.NotificationManager; import android.content.Context; import android.media.RingtoneManager; import android.net.Uri; import android.support.v4.app.NotificationCompat; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.Button; import java.util.Objects; public class MainActivity extends AppCompatActivity { private final static String default_notification_channel_id = "default" ; @Override protected ...
Read MoreGet only digits using regexp in MySQL?
If you want to get only digits using REGEXP, use the following regular expression( ^[0-9]*$) in where clause.Case 1 − If you want only those rows which have exactly 10 digits and all must be only digit, use the below regular expression.SELECT *FROM yourTableName WHERE yourColumnName REGEXP '^[0-9]{10}$';Case 2 − If you want only those rows with the digit either 1 or more, the following is the syntax −SELECT *FROM yourTableName WHERE yourColumnName REGEXP '^[0-9]*$';The above syntax will give only those rows that do not have any any characters.To understand the above syntax, let us create a table. The query ...
Read MoreSystem variables vs Local Variables in MySQL?
The local variable has the scope for only a set of statements or block of statement. Whenever a set of statements or block of statement has completed then local variable goes out of scope.For ExampleLocal variable can be used in stored procedure, function etc. It is used with the DECLARE keyword.The syntax is as follows to local variables.DECLARE yourVariableName dataType;The global variables or system variables has the scope across connections until server restart. It is set using GLOBAL keyword. The syntax is as follows −SET GLOBAL max_connections=value; OR SET @@global.max_connections=value;If you know port number then you can use system variable ...
Read MoreDigital Integrated Circuits
A microprocessor is digital is a digital circuit which is built using a combination logic functions. The microprocessor package contains an integrated circuit.Integrated CircuitAn integrated circuit is electronic circuit or device that has electronic components on a small semiconductor chip. It has functionality of logic AND or amplifying of a signal. These are mainly two types of circuits: Digital or Analog. Analog ICs handle continuous signals such as audio signals and Digital ICs handle discrete signals such as binary values.Types of Integrated CircuitsThere are different types of integrated circuits based various criteria. Based on intended application, the Integrated Circuit (IC) ...
Read MoreChange date format (in DB or output) to dd/mm/yyyy in PHP MySQL?
You can change the date format in PHP using date() fucntion. The syntax is as follows −date(d/m/Y, yourDateTimeVariable);In PHP, convert string to date using strtodate(). Here is the PHP code used to format the datetime −$LogintDate = strtotime('2019-01-12'); echo date('d/m/Y', $LogintDate);The snapshot of code is as follows −The following is the output −12/01/2019You can achieve in MySQL with the help of date_format() function. The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, ’%d/%m/%Y’) as anyVariableName FROM yourTableName;To understand the above syntax, let us create a table −mysql> create table Date_FormatDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> ...
Read More