SLSOFT | Educational Network

What is PHP? Simple Definition

noreply@blogger.com (Kaveesha Ekanayake) — Sun, 09 Aug 2020 07:25:00 +0000

Definition

PHP ( acronym for PHP: Hypertext Preprocessor). It is a widely-used, open source scripting language that especially used for web development.

PHP can collect form data, generate dynamic page content, or send and receive cookies. It can add, delete, modify data in database. Also PHP can create, open, read, write, delete, and close files on the server and encrypt data.

Simple PHP code:

   <?php
            echo"hello world!"
   ?>

Output:

hello world!

PHP can be embedded into HTML.

Example:

<!DOCTYPE html>
<html>
    <head>
        <title>Example</title>
    </head>
    <body>

        <?php
            echo "hello world!";
        ?>

    </body>
</html>

PHP is free. You can download it from : www.php.net

How to create a database in local host server step by step

noreply@blogger.com (Kaveesha Ekanayake) — Fri, 07 Aug 2020 08:43:00 +0000

What is a Database?

Simply a database is an organized collection of data.

What is Localhost?

When developing websites, there are two main places where you are going to work.

First one is web server. Web server is the computer that broadcasts web page and its content the Internet. We can create a database in web server.

Second one is local machine, such as laptop or desktop computer. Web developers usually use it to develop and test run sites. This is commonly called localhost.

However, personal computer is not a server. So, We have to run a web server on our machine.

Let's see how to create a database in localhost step by step.

Step 1 - Install a server to your computer.

XAMPP server can be download and install Windows / Mac / Linux from XAMPP Homepage.

Install it using the install wizard.

Step 2 - Run XAMPP Server and make sure Apache and MySQL running.

If not running, you need to click Start buttons to run.

Step 3 - Open your web browser and type http://localhost or http://127.0.0.1

Click the enter. after you will see a page like this.

Step 4 - Go to phpMyAdmin.

Step 5 - Click New.

Step 6 - Enter your database name and create it.

Give any name here and click create button.

After you will see like this.

Now your database created successfully.

But still not created any database table. We need to create some tables for our database to store data.

I will tell you how to create database tables in another post.

What is SQL? Simple Definition

noreply@blogger.com (Kaveesha Ekanayake) — Wed, 05 Aug 2020 08:35:00 +0000

image source : (takethiscourse)

Definition

SQL is a structured query language designed to retrieve and manage data in relational database.

There are four basic SQL operations

SELECT – selects data from database tables.

UPDATE – updates existing data into database tables.

INSERT – inserts new data into database tables.

DELETE – deletes existing data from database tables.

image source : (techskill)

Simple Examples of SQL query:

SELECT

SELECT * FROM Users;

UPDATE

UPDATE Users

SET name="Nimal"

WHERE userID=1;

INSERT

INSERT INTO table_name(colum1,colum2)

VALUES (value1,value2);

DELETE

DELETE

FROM Users

WHERE userID=1;

You can work with SQL when installing database software .

Free Database Software

What is HTML? Simple Definition

noreply@blogger.com (Kaveesha Ekanayake) — Mon, 03 Aug 2020 11:22:00 +0000

Definition

HTML is a hypertext markup language.It allows the user to create web pages and web application. HTML describes the structure of a web page and it consists of a series of elements.

Simple example of HTML

<!DOCTYPE>

<html>

<head>

<title>This is web page title</title>

</head>

<body>

<h1>This is Heading 1</h1>

<p>This is paragraph</p>

</body>

</html>

Browser view

This is web page title

This is Heading 1

This is paragraph