Friday , 19 July 2024
Breaking News
Home > 2017 > December

Monthly Archives: December 2017

How to Get SUM of Values Matching Item ID from another Table with INNER JOIN

Assalam-o-Alaikum! Dear friends today we will learn about INNER JOIN and GROUP BY. Sometimes you need to calculate some value that relates to another table or you need to pull some data from another table, for this you need Joining method. Here is a problem that we will solve. Problem: Suppose you have two tables, one is Items and second ... Read More »

How to Get Records From Multiple Tables and Show Into One Column

Assalam-o-Alaikum! Dear friends hope you will be fine. Today we will discuss on a problem which will make our work easy. Our some coding of PHP will reduce. Today we are going to learn a MySQL query technique in which you will fetch records from multiple tables and show in one column. So let’s start. Problem: Suppose you have three ... Read More »

How to work with Multiple WeMos and Sensors

Assalam-o-Alaikum! Friends you know that every WeMos works independently if you power it. If you have multiple WeMos and have sensor on it and you want to run all these WeMos and sensors at a time then don’t worry it is very easy job. Problem: Let’s suppose you have two WeMos and there is sensor on each WeMos and now ... Read More »

How to control DHT11 sensor data with PHP and MySQL

Assalam-o-Alaikum! Today’s topic is very interesting because today we will work on PHP and MySQL to control DHT11 data. We will write a code that get status from MySQL and based on that information you can stop receiving data or start receiving data. Problem: Here is a problem. Let’s suppose you need a system that stores Sensors On/Off status into ... Read More »

How to read data from database with PHP for WeMos EPS8266

Assalam-o-Alaikum! Dear friends today we will learn more interesting thing. We are going to pull out data from Database using PHP for WeMos. It is very important step for creating project for accessing devices status online. Problem: Let’s suppose you are going to design a project that have several electronics instruments and you need a web based software that will ... Read More »

How to Assign Static IP to WeMos ESP8266

Assalam-o-Alaikum! How are you friends, hope you will be fine. Today we are going to discuss on Static IP in WeMos. You will be able to assign static IP to WeMos after reading this tutorial. So let’s start. Friends as you know that WeMos is used to connect via WiFi and it can also be access by the IP. You ... Read More »

How to get MAC and IP address of Windows System with PHP

Assalam-o-Alaikum! Friends today I am going to that ‘How to get MAC address and IP address of Windows”. Trick is very simple, you have to run ‘ipconfig/all’ command through ‘System’ programme and then you will capture output and save into variable with ‘ob_get_contents()’ function. It will  return you an array and from this array you have to pull out your ... Read More »

Read Multiple DHT11 Temperature Sensor with single Wemos

Assalam-o-Alaikum! Once again welcome to my Temperature sensor tutorials series. As you know we are working on DHT11 temperature sensor, previously we successfully completed our sensor programming with MySQL and PHP programming. We added our sensor data into database and then retrieved it using PHP. In today’s tutorial we are going to read multiple sensors and then we will save ... Read More »

How to Calculate Days, Months and Years in PHP

Assalam-o-Alaikum! Friends today I am going to tell you about an interesting function of PHP that will calculate date difference between two dates. You can find days, months and years between two dates. You can use this function where you need to count days for billing or for the expiration of user etc. For example, you want to calculate days between two ... Read More »

Some Useful Math Functions in MySQL

Assalam-o-Alaikum! Dear visitors today I will tell you about some maths functions available in MySQL. In past, I often used PHP functions to calculate desired values but later I realized that MySQL has powerful functions that calculate data based on given criteria. We are not going to discuss all functions here but some basic and useful functions will be discussed today. ... Read More »

Ad Test