Assalam-o-Alaikuim! Dear friends today we will learn about PHP arrays. We often need to select records from database. There are different methods to select data from Database. But today we will learn something difficult. Problem: Suppose you have following string data that you want to convert into an array to perform action on it: $string = “one,two,three,four”; and you need ... Read More »
Author Archives: Muhammad Faryad
Finding Values in Comma Separated String Using MySQL
In most cases, We give the various options of choices to choose on websites in form of checkbox and stores various values of choices in a column of MySQL database as a comma separated . For example we store user’s preferred hobby in user table’s hobbies(varchar(250)) field(column). Value stored in this field may be like 1,2,5,6,1 or may be ‘sports’,’gardening’,’cooking’,’reading’. ... Read More »
How to Calculate Date of Birth in PHP
Assalam-o-Alaikum! Today we are going to learn that “How to Calculate Date of Birth in PHP“. I am giving simple code you should change values in code and see the result. Code is here: [crayon-64834454ae477431066162/] Now save this file and run it. Read More »
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 »