PHP MySQL select Query Syntax From the Table with MySQLi Example Code
June 15th, 2019 
Nilesh Chaurasia
PHP Select Data in MySQL To select data from the table select query is used. To select all row so you have to use ” * ” symbol. But if you want to select a particular row or column so you have to put the name of a particular row or column. Example – 1 […]
Arduino Serial read, available Function Example and UART Loopback
June 15th, 2019 Nilesh Chaurasia 
Arduino Serial read Arduino serial library have in-built function to receive the data over serial port. To test the receive function in Arduino you have to send data from PC/Laptop with serial monitor program. In this article we will tell you more about serial communication in the Arduino to implement receive function. Arduino library have […]
PHP MySQL insert Query Syntax into the Table with MySQLi Example Code
June 15th, 2019 Nilesh Chaurasia
PHP Insert Data Into MySQL To insert a data in the MySQL database you have to use insert query. In other words Insert is used to add new records. Important points The string must be quoted. Numeric values must not be quoted. The word NULL must not be quoted. In the previous artical we created […]
Arduino Serial Communication Port Test Example with write and begin Function
June 15th, 2019 Nilesh Chaurasia 
Arduino Serial Port Communication Arduino Serial Communication is used to communicate over serial port with terminal devices over UART like PC. Understanding the serial communication in the Arduino is very important because these days many devices uses UART interface, like GPS, ESP8266, GSM and RFID modules. The UART serial communication is a full duplex, means […]
PHP MySQL Create Table Query With MySQLi Example Code and MySQLi_query Function
June 15th, 2019 Nilesh Chaurasia
Create a MySQL Table Using MySQLi The CREATE TABLE statement is used to create a table in MySQL. We will create a table named “User”, with five columns: “id”, “firstname”, “lastname”, “email_id” and “age”: Example – 1 Create a MySQL Table Example ` Important points of the table above: The data type specifies what type […]
PHP MySQL Connection With MySQLi Example Code and mysqli_connect Function
June 15th, 2019 Nilesh Chaurasia 
How to Drop Table in phpMyAdmin From the PHP script if you want to access the MySQL Database you have to first create a connection to the database server with the help of mysqli_connect mysqli function. MySQL Examples in Both MySQLi and PDO Syntax In this, and in the following chapters we demonstrate three ways […]
Arduino LED Fade Code with analogWrite function on Analog Output or PWM Pins of Uno Board
June 15th, 2019 Nilesh Chaurasia 
Arduino LED Fade with PWM Arduino LED Fade Code is used to test the PWM feature of board. Fading mainly uses analogWrite function on Analog Output Pins of Arduino Board. Arduino does not have DAC (Digital to Analog Converter) capability, but in place of DAC it is having PWM (Pulse Width Modulation) capability. The PWM […]
How to Use phpMyAdmin and How select, insert, update, delete and drop table
June 15th, 2019 Nilesh Chaurasia 
How to Use phpMyAdmin Through phpMyAdmin, you can perform many operations like insert, select, update, delete and drop in the table. These operations are done through the SQL Queries. How to Insert in phpMyAdmin If you want to add the new information to a column then you have to use insert SQL Query. Step 1 […]
Arduino Button or Switch Interface Circuit without Pull Up Resistor
June 14th, 2019 Nilesh Chaurasia 
Arduino Button or Switch Interface Circuit To take digital input we have to interface button or switch with the Arduino board. Interfacing switch is requires a resistor and it is known as pull up resistor. Figure 1 below shows the circuit diagram of button interfacing. It is having a 10k resistance which is connected with […]
phpMyAdmin Create Table
June 14th, 2019 Nilesh Chaurasia 
phpMyAdmin Create Table MySQL Stored data in the table form or row-column format. So you have to create a table first in the phpMyAdmin interface. Step 1 – To create a table you have to create a database first. After creating a database you have to write table name to the Name block and select […]
