teleren/devto huggingface dataset:
Understand PHP | SQL Connectivity (Easily)
Published: 2020-08-14 13:18:36

Hello friends, I have seen that many people facing difficulty during connectivity of PHP with SQL, So today we see how we will resolve this problem easily.

Note:- Please read the whole blog to avoid any inconvenience.

* Step 1 : 
Create a file or open your favorite notepad generally for programming or scripting developers use notepad++ you can use any.

* Step 2 : 
Trigger your server or localhost if you have a XAMPP then you need to press Apache or MYSQL buttons until it will turn into green.

* Step 3 :
Write commands like below 

``` 
<?php
	$servername = "localhost";
	$username = "root";
	$password = "";
	
	$connect = mysqli_connect($servername , $username, $password);
	
	if(!$connect)
	{
		die("Connection Failed".mysqli_connect_error());
	}
	
	echo "Connected Successfully";
	
	mysqli_close($connect);
	
	
?>

```

* Step 4: 
Let's understand the above code
first we all know we need to write our PHP logic under <?php ---- ?> tag. So in this module, we simply declaring 3 variables that are mandatory during connectivity.
```
    $servername = "localhost";
	$username = "root";
	$password = "";

```
variables like servername, username and password.
This variable is used to storing our XAMPP credentials make sure you enter your credentials according to your XAMPP data.

After that, We store a function that names 
``` 
mysqli_connect();
```
in a variable let's say $connect
so we storing a predefined function provided by PHP in a variable to use easily and which also helps for validation.

* Step 5:
Here we connected with our SQL server, We just need to validate ourself
For validating or Ensuring we use conditional statement that provides boolean value

```
if(!$connect)
	{
		die("Connection Failed".mysqli_connect_error());
	}
	
	echo "Connected Successfully";
```
Here we in If statement we checking if our $connect variables is negative (i.e, False) so simply call die function and write a message according to your convenience and also concatenate mysqli_connect_error() function for more satisfation using . operator which is used for concatenate in PHP.

* Step 6:
Finally we closing our server using mysqli_close() for better practices.

I hope you learned from my post if any query visit my GitHub page for discussion.
<a style="border : 1px solid black; color : white ; background : cyan;" href="https://github.com/ItsFRZ">ItsFRZ</a>

And if you found my work is helpfull please do share
Why White Label Travel Portal is advised for the new business? 
Tags: travel
Published: 2020-08-14 13:04:20

Business is consistently a hazard. While going for another speculation, the individual can never be certain whether he will receive a benefit in return or will be at misfortune. A similar idea and a similar situation goes in the Travel Portal development startup also. The travel industry is a field that baits financial professionals. Businessman thinks it is simple speculation and simple and easy return business. Numerous people attempt their fate in the travel industry by persisting with a travel web portal. There is no uncertainty in this that the travel business is nothing without a travel web portal. In the prior era when there was no online method of correspondence then physical location should be the purpose of business however the discovery of technology has moved the objectives to on the web. 

A well responsive travel web portal is all that is required for a new investor to attempt his fortune in the business. Presently, in thought with the interest of the business then as per the current necessity the travel portal should be technology-empowered, with all the cutting edge means and current administrations taught in the equivalent. One of the extremely conspicuous prerequisites for the travel web portal is a coordinated quest page for showing the different services provided by the company that is accessible on the site. There are two programming answers for a similar one is [Direct API](https://travelportalsolution.com/flight-booking-api/) and the subsequent one is [White Label Travel Portal](https://travelportalsolution.com/white-label-travel-portal/). 

There is a colossal distinction between the speculation, and both of these administrations nearly show a similar outcome. The main downside in White Label Travel Portal is that it shows the indistinguishable page with the other entryway that settled on White Label Travel Portal from a similar travel portal development [organization](https://travelportalsolution.com/). So while thinking about the factor of no benefit and no misfortune and the outcome showed; it generally comes out to be the resolution that White Label Travel Portal is the best proposal for new businesses.
Discord Bot Tutorial- Get started in 5 minutes
Tags: javascript, node, webdev, tutorial
Published: 2020-08-14 12:58:27

Want to make a bot for your Discord server but don't know where to start? In this video we'll get your bot up and running in 5 minutes, and then move onto more advanced stuff like:

* Basic message response
* Deleting old messages and accepting parameters with your bot
* Filtering words from your server
* Joke Bot using API calls
* Moderation bot for banning or kicking users
* Updated features for V12 of DiscordJS

[Written version of this Discord Bot Tutorial](https://codeburst.io/discord-bot-tutorial-2020-a8a2e37e347c)

{% youtube P6K58U-MSvA%}
Bogged down by Blogging
Tags: blogging, beginners
Published: 2020-08-14 12:46:25

What is it about us software engineers? 

On the one hand we're the good kind of lazy, we love optimisation and efficiency. We automate the most menial tasks so we don't need to waste time on them ever again. If you've a product mindset, you're no stranger to the concept of Minimum Viable Product. You're always asking the why's, using TDD to drive design evolution, and only reaching for abstraction when there's a need. Yet, when it comes to our own private projects - we're all in on the over engineering. 

We love a good meaty problem, the curlier the more intriguing. And there's nothing wrong with over engineering if your goal is experimentation, learning and fun right? But what about when that's a form of procrastination?

For five years my sad old blog has lay in that dusty, dark corner of the internet where all neglected blogs lie, never a visitor, unloved. I have dreamed of resurrecting it. You'd be forgiven for thinking, when I say "resurrect", that I wrote more than a "hello world" post and a follow up. You'd be wrong, it's a vacuous collection of broken CSS, despite being lovingly composed with the best of intentions.

It was 2015 (the good old days) I hadn't learned to code yet, this was my first foray into learning to code as a hobby. Fresh faced, innocent (some might say naive), eyes glittering, I rolled up my sleeves to get started. Finally I was practicing what I (had myself) preached in many presentations to junior developers on how to break into the industry.

> *"Focus on the three Ps; Practice, Persistence and Presence."*

I needed a blog for that last P, I needed Presence and pronto!

Without hesitation, I reached for [Jekyll](https://jekyllrb.com/), it's a fantastic and simple open source static site generator, not complex when you have some experience under your belt.

I learned a lot as I experimented and broke things. About CSS and the feels associated with cascading down into those pits of despair. About infrastructure and how much I loved understanding how the internet evened. I served my blog from AWS s3, configured route53 for my DNS, and to this day it's up (with minimal costs associated). So it was a success of types.

What I didn't do was continue to blog and that's because my choice of tool didn't serve my needs. I was hung up on a particular solution rather than asking "what are you trying to achieve?".

I wanted to practice writing about technical subject matter, to sharpen and hone my skills, to share and help others who were struggling with similar issues.

After an inspirational conversation with [@KaslinFields](https://twitter.com/kaslinfields) and laughing at my failure I'm heeding her advice of "Do it!" with a renewed vigor and a more fitting tool for my needs. Use whatever tool is right for you, there's no need to over complicate things. 

**Always be the right kind of lazy (and smart)!**
YouTube Video | CSS3 in 10 days — Day 4
Tags: youtube, html, css, webdev
Published: 2020-08-14 12:44:42

This series contains some practical examples which you can learn and directly use CSS in your projects. We will create awesome components and other things in 10 days.

On day 4 we will learn to create 8-Bit Mario, then we will create an awesome looking Pricing Table. Lastly, we look into CSS Variables.

![Mario](https://res.cloudinary.com/dxkxvfo2o/image/upload/v1597481534/mario_a65ajp.gif)*Mario*

This is the fourth part of the series.

{% youtube lAjMjQrD5Kg %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
YouTube Video | CSS3 in 10 days — Day 3
Tags: youtube, css, html, webdev
Published: 2020-08-14 12:42:29

This series contains some practical examples which you can learn and directly use CSS in your projects. We will create awesome components and other things in 10 days.

This is the third part of the series.

{% youtube OmpuR0g9dCw %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
How to Use IMSUM Function in MS Excel 365? – (With Examples)
Tags: excelfunctions, imsumfunctioninexcel
Published: 2020-08-21 17:00:50

---
title: How to Use IMSUM Function in MS Excel 365? – (With Examples)
published: true
date: 2020-08-14 12:36:54 UTC
tags: ExcelFunctions,IMSUMFunctioninExcel
canonical_url: https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/
---

## IMSUM Function in Excel?

In this article, we are going to learn how to use **IMSUM Function in Excel 365** with its syntax, explanation, and examples. Leave your **feedback** in the comment section. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 

## **IMSUM – Function Explanation:**

- This function is used to **find the sum of the two complex numbers**.
- Generally, the complex number is in the form of **X+Yi** or **X+Yj**.
- Where X and Y are real numbers, and i or j is an imaginary number.
- **X** is a **real** part, **Yi** is an **imaginary** part.
- The sample complex numbers are 9+3i,  4-i.

## **Syntax:**

**=IMSUM(inumber 1, number 2)**

### Argument Explanation:

**Inumber 1 and Inumber 2** – Both are complex numbers.

### **Note:**

- The difference of two complex numbers is calculated as follows.
- **“(a+bi)+(c+di) = (a + c) + (b + d)i”**
- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

## **Examples:**

Let’s see some examples below.

- The two Complex numbers have been listed in **Column A** and **Column B**.
- The SUM of the two complex numbers is listed in **Column C**.

![SUM of two complex numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-30.png)<figcaption id="caption-attachment-11709">SUM of two complex numbers</figcaption>

- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

![COMPLEX Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/COMPLEX-Function.png)<figcaption id="caption-attachment-11660">COMPLEX Function</figcaption>

## **Verdict:**

In the above article, you can learn the usage of **IMSUM Function in Excel 365** with its syntax, description, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- **IMSUB Function in Excel 365**
- **IMPOWER Function**
- **IMPRODUCT Function**
- **IMREAL Function**

### Read Also:

- [How to Use HEX2BIN Function in MS Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-hex2bin-function-in-ms-excel-365-with-examples/)
- [How to Use BITXOR Function in Microsoft Excel 365? – [With Examples]](https://geekexcel.com/how-to-use-bitxor-function-in-microsoft-excel-365-with-examples/)
How to Use IMSUB Function in MS Excel 365? – { With Examples }
Tags: excelfunctions, imsubfunctioninexcel
Published: 2020-08-21 16:49:38

---
title: How to Use IMSUB Function in MS Excel 365? – { With Examples }
published: true
date: 2020-08-14 12:33:54 UTC
tags: ExcelFunctions,IMSUBFunctioninExcel
canonical_url: https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/
---

## IMSUB Function in Excel:

In this tutorial, We will guide you to know the usage of **IMSUB Function in Excel 365** with its syntax, description, and examples. Let’s see them below. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 ## **IMSUB – Function Description:**

- **IMSUM** function returns the **difference between two complex numbers**.
- The complex number is in the form of **X+Yi** or **X+Yj**.
- Where X and Y are real numbers, and i or j is an imaginary number.
- **X** is a **real** part, **Yi** is an **imaginary** part.
- The sample complex numbers are 2+3i, 4-2i.

## **Syntax:**

**=IMSUB(inumber 1, number 2)**

### Argument Explanation:

**Inumber 1 and Inumber 2** – Both are complex numbers.

### **Note:**

- The difference of two complex numbers is calculated as follows.
- **“( a+bi ) – ( c+di ) = ( a – c ) + ( b – d )i”**
- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

## **Examples:**

Let’s see some examples to make it clear.

- In the below screenshot, you can see the complex numbers in **Column A** and **Column B**.
- The difference between the two complex numbers has been listed in **Column C**.

![Difference between two complex numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-29.png)<figcaption id="caption-attachment-11702">Difference between two complex numbers</figcaption>

- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

![COMPLEX Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/COMPLEX-Function.png)<figcaption id="caption-attachment-11660">COMPLEX Function</figcaption>

## **Summary:**

In this tutorial, we guided you to learn the usage of **IMSUB Function in Excel 365** with its syntax, description, and examples. Kindly, give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- **IMSUM Function in Excel **
- **IMSUB Function**
- **IMPOWER Function**
- **IMPRODUCT Function **

### Read Also:

- [How to Use HEX2BIN Function in MS Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-hex2bin-function-in-ms-excel-365-with-examples/)
- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)
How to Use “IMABS Function” in Microsoft Excel 365?
Tags: excelfunctions, imabsfunctioninexcel
Published: 2020-08-21 16:48:38

---
title: How to Use “IMABS Function” in Microsoft Excel 365?
published: true
date: 2020-08-14 12:29:39 UTC
tags: ExcelFunctions,IMABSFunctioninExcel
canonical_url: https://geekexcel.com/how-to-use-imabs-function-in-microsoft-excel-365/
---

## IMABS Function in Excel:

In this article, we are going to see how to use **IMABS Function in Excel 365** with its syntax, explanation, and examples. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 
## **IMABS – Function Explanation:**

- IMABS Function **returns the absolute value** of the complex number.
- Generally, a complex number is in the form of ( **X+Yi** ) or ( **X+Yj** ).
- For example, ( 2+3i), (6-2i) like that. The IMABS function will return positive absolute values of the complex numbers with negative signs. Example: “6-2i” will return the absolute value “6.32455532”.

## **Syntax:**

**=IMABS(inumber)**

### Argument Explanation:

**Inumber** – The complex number for which you want to find the absolute value.

### **Note:**

- The absolute value of the Complex number is calculated as follows.
- **IMABS** ( **z** ) = | **Z** | = **√x² + y²** where ( **Z = X+Yi** )
- X and Y are real numbers, and i or j is an imaginary number.
- **X** is a **real** part, **Yi** is an **imaginary** part.
- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

## **Examples:**

Let’s see an example to understand how it works.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-26.png)<figcaption id="caption-attachment-11657">Example</figcaption>

From the above screenshot, you can see the complex numbers in **Column A** and their Absolute values in **Column B**. The absolute value of ** I** is always 1 ( when a complex number contains only I ).

- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

![COMPLEX Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/COMPLEX-Function.png)<figcaption id="caption-attachment-11660">COMPLEX Function</figcaption>

## **Wrap-Up:**

In this article, you can understand how to use **IMABS Function in Excel 365** with its syntax, description, and examples. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- **IMPOWER Function**
- **IMREAL Function **
- **IMSUM Function**
- **IMSUB Function**

### Read Also:

- [How to Use PHONETIC Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-phonetic-function-in-microsoft-excel-365/)
- [How to Use BITOR Function in MS Excel 365? – { with Examples }](https://geekexcel.com/how-to-use-bitor-function-in-ms-excel-365-with-examples/)
What would you guys like to see me stream?
Tags: livecoding, javascript, poll, twitch
Published: 2020-08-14 12:28:33

---
title: What would you guys like to see me stream?
published: true
description: 
tags: livecoding, javascript, poll, twitch
//cover_image: https://direct_url_to_image.jpg
---
Hi all 👋
If you weren't aware, I stream on the weekends over at [twitch](https://twitch.tv/iamflowz). To kick things off I'm [running a poll on Twitter](https://twitter.com/FastFlowZ/status/1294239216369623041?s=19) to figure out what I'll be doing on stream. Drop a vote then drop by my channel to see it all in action 😁

---
Find me on [Twitter](https://twitter.com/FastFlowZ) | [LinkedIn](https://www.linkedin.com/in/dakota-lewallen/) | [Twitch](https://twitch.tv/iamflowz)
Sponsor me on [Github](https://github.com/iamflowz)
Like the article? [Buy me a coffee!](https://www.buymeacoffee.com/iamflowz)
IMAGINE CUP
Tags: msftstudentambassador
Published: 2020-08-14 12:24:12

The MICROSOFT IMAGINE CUP is an annual event where students from all over the world showcase their innovations and take part in global technology. The event has the aim to empower every student in the entire world to achieve more.Once spoke to Clinton Oduor who participated last year with WildEye Ke and he said it was the opportunity of a lifetime.

https://imaginecup.microsoft.com                                                                                          

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dfazjhhdel01dwd7gssd.png)

The cup is a free to join event that has existed over the last seventeen years. With it peoples lives have been changed and they have begun their own startups from the cash awards they win and the knowledge garnered. They have also connected with other peers from around the world that share the same passion for technology and most of all gained experience. 

The imagine cup believes in "DREAM IT. BUILD IT. LIVE IT." As a DEV, we can dream up countless solution. We have the capability to come up with them from scratch and most of all through the cup we can definately live the dream like a hollywood star. No matter what ones age (from 13 years and above) is, everything is possible as we also have the Imagine Cup Junior. 
https://imaginecup.microsoft.com/en-us/junior
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/62wvw28u7c53wrbpl90b.jpg)

Imagine Cup Junior is tailored to cater for those between the age of 13-18 years old. This year's global challenge had to do with AI. Introducing AI to young learners and also engage them in AI for Good initiatve.
 
The MLSA Kenyan Community will launch an Imagince cup community to create more awareness as they make an impact through coding, collaboration and competition. The community aims to also encourage passionate innovations that tackle global issues and bring your tech solution to life through the imagine cup.

Next time you dream it. Do not be afraid to build it and showcase it to the world and Live it.

Lilian Patience Mbithe
 Microsoft Learn Student Ambassador.
Strategy in PHP [Design pattern with examples]
Tags: php, designpattern, strategypattern, composition
Published: 2020-08-14 12:24:04

---
title: Strategy in PHP [Design pattern with examples]
published: true
description: The amazing way to use composition over inheritance
tags: php, designPattern, strategyPattern, composition
cover_image: https://anastasionico.uk/img/blog/strategy-in-php-design-pattern-with-examples.jpg
---

I have been coding (seriously) for almost 10 years now,
Like everyone, as soon as I started to make my first little projects work I thought I was already amazing.

**What a natural talent!**

Only a while later I realized that the career of a web developer is composite by several milestones.

From your first "Hello World" to learning a framework and getting your head around the MVC principles.

Reaching these milestones let you say: "Today I have improved my skills".

One of these milestones that defined a programmer as a better programmer than before was when he finally understand the concept of composition.

you see, 
In Object-oriented Programming 101, you learn the advantages of inheritance.
but what they do not tell you is that this practice is not very scalable and there is a better way to write your code.

It is incredibly crucial to develop a project and be confident that you WON'T CRY when you need to update it a few months from now.

for this reason:
In this week's article, you are going to discover why Composition is so important and how to use it while implementing the Strategy design pattern.

[READ THE FULL ARTICLE HERE](https://anastasionico.uk/blog/strategy-in-php-design-pattern-with-examples)