How to create a data table in bootstrap PHP and MySQL ?

What is Bootstrap Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive and mobile friendly website .  Bootstrap helps web developers build website faster as they don’t need to worry about basic commands and functions. Bootstrap became popular very quickly, and not without reason. Web designers and web developer like bootstrap because it … Read more

How to DELETE Data Into MySQL Database Using PHP ?

The DELETE statement is used to delete records from a table. you can delete records from a table using the SQL DELETE statement. It is typically used in conjugation with the WHERE clause to delete only those records that matches specific criteria or condition. Syntax : DELETE FROM table_nameWHERE some_column = some_value ; Implementation of the Delete Query … Read more

How to Create MySQL user and Grant permission ?

Introduction : MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.  It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world. Prerequisites : A Linux … Read more

How to Remove spaces from string in MySQL ?

MySQL String Functions : MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description: Name Description CONTACT Concatenate two or more strings into a single string INSTR Return the position of the first occurrence of a substring in a string ASCII Returns the ASCII … Read more

How to Insert Data Into MySQL Database Using PHP

INSERT : The INSERT INTO statement is used to add new records to a MySQL table . Syntax : NSERT INTO table_name (column1, column2, column3,…)VALUES (value1, value2, value3,…) PHP MySQL INSERT Query : SQL query using the INSERT INTO statement with appropriate values, after that we will execute this insert query through passing it to the PHP Mysqli_query function to insert … Read more

What is MySQL SELECT Statement And Example of MySQL SELECT Query

MySQL SELECT Statement : The select statement is used to select data from a database. The SELECT statement in MySQL is used to fetch data from one or more tables. We can retrieve records of all fields or specified fields that match specified criteria using this statement. Syntax : SELECT column1, column2, …FROM table_nameWHERE condition; You can use one or more tables separated by … Read more