Types of MySQL tables and storages engines
MySQL storage engines A storage engine is a software module (components that handle the SQL operations for different table types. ) That is used by DBMS uses for create, read, update data from a database. Default storage engine is innodb (from version 5.5 and later). MySQL uses two types of storage engines:- 1. Transactional 2. N…
Read more
SEARCH RECORD FROM DATABASE BY PHP ON WEBPAGE
SEARCH RECORD FROM DATABASE BY PHP ON WEBPAGE 1. SEARCH RECORD (search.php) <!DOCTYPE html> <html lang="en"> <head> <title>Search Example</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link…
Read more
DELETE RECORD FROM DATABASE BY PHP ON WEBPAGE
DELETE RECORD FROM DATABASE BY PHP ON WEBPAGE 1. DELETE RECORD (delete.php ) <?php include_once 'database.php'; $result = mysqli_query($con,"SELECT * FROM emp"); ?> <!DOCTYPE html> <html> <head> <link rel="stylesheet" href="style.css"> <title>Del…
Read more
UPDATE RECORD INTO DATABASE BY PHP FROM WEBPAGE
UPDATE RECORD INTO DATABASE BY PHP FROM WEBPAGE 1. UPDATE RECORD (update.php ) <?php include_once 'database.php'; $result = mysqli_query($con,"SELECT * FROM emp"); ?> <!DOCTYPE html> <html> <head> <title> Retrive data</title> <link rel="stylesheet" href="style.css"…
Read more
Social Plugin