Code Tech

Dashboard: The dashboard serves as the main screen, offering an overview of recent posts, comments, and updates. Posts: This section facilitates the creation, editing, and management of blog posts. Categorization and tagging options enhance organization. Media: Within the Media Library, one can manage images, videos, and audio for use in posts and pages. Pages: Similar to posts, this area is dedicated to static content such as "About" or "Contact" pages, allowing hierarchical organization. Comments: Moderation and management of comments on posts, including approval, replies, edits, or deletions. Appearance: Themes: Alter the site's appearance by installing and managing themes. Customize: Real-time customization of colors, fonts, and layout based on the active theme. Widgets: Add, remove, and customize widgets in sidebars or widget-ready areas. Menus: Create and manage navigation menus for improved content accessibility. Plugins: Installation, activati...

 1. Open Notepad++, go to "Search" in the menu bar, select "Find in Files" (or use Ctrl + F ). 2.In the "Find what" field, enter the text or regular expression you want to search. In the "Directory" field, choose the folder where you want to search. 3.Optionally, in the "Filters" section, specify file types to include (e.g., *.php for PHP files). Optionally, adjust search options like case sensitivity in the "Search Mode" and "Match case" sections. 4.Click "Find All" to start the search. Review the results in the "Find result" panel at the bottom. Double-click an entry to open the corresponding file. These steps will help us to search for specific text within multiple files in a specified directory using Notepad++.

 SQL -  In database the field name should be in lowercase. Every SQL statement should end with semicolon ; Shortcut Ctrl+G is Go to line Ctrl+ENTER is to run a query  STEPS FOR WRITING MYSQL: 1. To write a query first we need to select the database. 2. Then we need to select the table. 3.Once we select both then we press "Ctrl+space", then it will show possible fields in the current table. 4. There are only two wildcards in MYSQL. They are,          i) %          ii)_

  Definition: INNER JOIN Returns rows where there is a match in both tables based on the common id. SELECT * FROM employee INNER JOIN department ON employee.id = department.id; Definition: LEFT JOIN Returns all rows from the "employee" table and matched rows from the "department" table. If there is no match, NULL values are returned for "department" columns. SELECT * FROM employee LEFT JOIN department ON employee.id = department.id; Definition: RIGHT JOIN Returns all rows from the "department" table and matched rows from the "employee" table. If there is no match, NULL values are returned for "employee" columns. SELECT * FROM employee RIGHT JOIN department ON employee.id = department.id; Definition: FULL JOIN Returns all rows when there is a match in either "employee" or "department" table. If there is no match, NULL values are returned for columns from the table without a match. SELEC...

 Some of the datatypes used in SQL are listed below: Numeric Data Types: TINYINT: Size: 1 byte Range: -128 to 127 SMALLINT: Size: 2 bytes Range: -32,768 to 32,767 INTEGER or INT: Size: 4 bytes Range: -2,147,483,648 to 2,147,483,647 MEDIUM INT: Size: 8 bytes Range: -8388608 to 8388607 BIG INT: Size: 8 bytes Range: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 DECIMAL or NUMERIC: Precision: Up to 65 digits Scale: Up to 30 digits FLOAT: Size: 4 bytes Precision: 7 digits REAL: Size: 4 bytes Precision: 7 digits DOUBLE or DOUBLE PRECISION: Size: 8 bytes Precision: 15 digits Character String Data Types: CHAR(n): Size: Fixed length of n characters. VARCHAR(n): Size: Variable length up to n characters. Range: 1 to 65,535 bytes. TEXT: Size: Variable length. Range: 1 to 65,535 bytes. Date and Time Data Types: DATE: Size: 3 bytes TIME: Size: 3 bytes DATETIME: Size: 8 bytes TIMESTAMP: Size: 4 bytes Boolean Data Type: BOOLEAN or BOOL: Values: TRUE, FALSE, or NULL Binary Da...