sangkrit

Free Access

Any mobile device running on android for accessing this homeschool program of internet age SANGKRIT.net, could always get reviewed here if that simplifies the process in the hands of our users.

Contact: System at Sangkrit dot Net

Easily Backup Your Complete WordPress Site

Keeping a backup of your WordPress site keeps your content safe. Know how to complete backup your WP site including backup of wp-content directory, plugins, themes etc.

[...]

MySQL 5.6 includes built in memecached daemon with…

MySQL 5.6 includes built-in memecached daemon with InnoDB backing

How To Grant Privilege To Any MySQL Database User ?

GRANT command is be used for giving privilege to any user for accessing database.

GRANT PRIVILEGES ON DATABASE OBJECTS TO USER@HOST IDENTIFIED BY ‘PASSWORD’;

Example:

For granting privilege to user admin Use:

GRANT ALL PRIVILEGES ON *.* TO ‘admin@localhost’ IDENTIFIED BY ‘secret’;

Listing MySQL Databases

For showing all database:

SHOW DATABASES;

In case you need to filter database by name:

SHOW DATABASES LIKE ‘pattern’;

For complex filtering of database use WHERE Clause:

SHOW DATABASES WHERE conditions;

With WHERE clause one can use regular expressions like ‘<’ [...]

One Command LAMP Server Installation

Installing LAMP Server

Open your Linux Terminal. Type: sudo apt-get install lamp-server^ Press Enter

Checking the Installation

Open a web browser Type: http://localhost/ If your browser shows the message: “It Works” then you have successfully installed LAMP

Tasksel Method

Other than the above given method you may [...]

Essential PHP Functions

Ceil() float ceil (float value) Rounds up the supplied float value to the next integer and returns the result.

Example:

<?php $a = 2.444; echo ceil($a); // 3 ?>

Can also be used to check if a number divides evenly with another

Example:

<?php $num1 = 5; $num2 = 7; $div = $num2 / [...]

MySQL: Data Manipulation

Inserting value1 into Column1, value2 into Column2, and value3 into Column3:

INSERT INTO TableName (Column1, Column2, Column3) VALUES (value1, value2, value3)

Insert one record (values are inserted in the order that the columns appear in the database):

INSERT INTO TableName VALUES (value1, value2, value3)

Insert two records:

INSERT INTO TableName VALUES (value1, value2, value3), (value4, [...]

MySQL Granting Privileges To User

Grant command is used for this purpose:

GRANT PRIVILEGES ON DATABASE OBJECTS TO USER@HOST IDENTIFIED BY ‘PASSWORD’;

For example:

GRANT ALL PRIVILEGES ON *.* TO ‘lamp@localhost’ IDENTIFIED BY ‘secret’;

It will create the user lamp that can access anything locally. To change to the lamp user at MySQL command prompt, type:

exit

Then start MySQL [...]

Connecting Database

You need to connect MySQL database before assessing it. This is done by mysql_connect function.

You should know the following terms before getting connected to MySQL server:

Name of the server. The default server name is localhost. Username and Password.

<?php

$con = mysql_connect(“localhost”,”Admin”,”1234″);

*above given server name, username and password are just examples. Practically [...]

Page 1 of 4123...Last »