Creating a Database The CREATE DATABASE statement in sql is used to create a database in MySQL. In PHP,mysql_query() function is used to execute sql query like insert, delete, update, select etc. Here is an example PHP script that creates a…
PHP-MySQL Lesson – Connecting to MySQL database
Connecting to MySQL database In order to access and manage records in a database, we need first to establish a connection to the database. To connect to the MySQL database we are going to use the mysql_connect() function. Here is…
MySQL Tutorial – SQL Aggregate Functions
SQL Aggregate Functions (MIN, MAX, SUM, AVG, COUNT) MIN() – returns the minimum value of the selected field. MIN() syntax: SELECT MIN(column_name) FROM table_name; MIN() Example: SELECT MIN(salary) FROM employee_record; It will display the minimum salary.
PHP-MySQL Lesson: Introduction
PHP-MySQL Lesson: Introduction PHP and MySQL PHP is an open source scripting language used to create dynamic website. MySQL is also an open source relational database system that uses Structured Query Language (SQL). PHP supports variety of databases, but MySQL…
MySQL Tutorial – LIKE Operator
LIKE operator The LIKE operator is used to retrieve records from database table by matching pattern in SELECT SQL statement. The syntax of LIKE operator: SELECT column_name(s) FROM table_name LIKE “value”; Let’s see some example: Here is our database table:…
MySQL Tutorial – Limiting Data Retrieval
Limiting Data Retrieval The LIMIT clause is used to limit the records to be displayed in the result set. The syntax of LIMIT clause: SELECT column_name(s) FROM table_name LIMIT startingROW, valueToExtract; Let’s see some example: Here is our database table:…
MySQL Tutorial – The GROUP BY clause
The GROUP BY clause The GROUP BY clause is used to group similar data specified by a certain field in your table. The GROUP BY clause syntax: SELECT column_name(s) FROM table_name GROUP BY column_name;
Managing Plugins in WordPress
WordPress: Managing Plugins Plugins are tools to extend the functionality of WordPress. Manage plugins: 1. Login to your WordPress site using the administrator account. 2. Click Plugins in the Plugins tab in your dashboard to go to the Plugins administration…
How to modify site information in Drupal
Drupal: Site Information In this lesson we are going to learn how to change our site details information such as site name, email and slogan. Updating site information: 1. Login to your Drupal site using the administrator account.
How to make your Drupal site Offline
Drupal: Site Maintenance In this lesson we are going to learn how to turn the site in offline mode. Whenever you perform maintenance or upgrading your site sometimes you need to turn your site offline. You can display message to…