Translate

Search This Blog

SQL Tutorial

SQL Tutorial

Easy way to learn

SQL stands for Structured Query Language. SQL is a database intended for the recovery and administration of information in a social database. This instructional exercise will give you a quick start begin to SQL. It covers a large portion of the themes required for an essential understanding of SQL.
This instructional exercise is prepared for beginners to help them understand the basic as well as the advanced concepts related to SQL languages. This instructional exercise will give you enough understanding on the various components of SQL along with examples and Video Lessons.

SQL Lessons

SQL Connection


In this SQL utorial you'll learn How to Connect SQL Server database using PHP.

Create database


In this tutorial you'll learn How to Create database in sql server using PHP.

Create mysql table


In this tutorial you'll learn how to create mysql table using PHP.

insert data in table


In this tutorial you'll learn ho to insert data in table in SQL Database using PHP.

How to insert data into database


In this tutorial you'll learn How to insert data into database in SQL using PHP HTML Form.

Update database table


In this tutorial you'll learn how to update database tables in a SQL table using PHP.

How to search sql database


In this tutorial you'll learn how to search SQL database using PHP.
Import data from Excel to SQL
In this tutorial you'll learn how to Import data from Excel to SQL Server using PHP.



how to connect to a sql server database

SQL

SQL, which is a shortening for Structured Query Language, is a dialect to ask for information from a database, to include, refresh, or expel information inside a database, or to control the metadata of the database.

How to connect to a sql server database

connect to mysql Video tutorial




The following is a basic PHP content to show how to associate with a MS SQL database utilizing the php MS SQL driver.


    $dbhost = 'localhost:3306';
    

//SERVER:
//Optional − The host name running the database server. If not specified, then the default value will be localhost:3306.

    $dbuser = ‘client';
      

//User:
//Optional − The username accessing the database. If not specified, then the default will be the name of the user that owns the server process.

  
    $dbpass = ‘client123';
     

// Passwd:

//Optional − The password of the user accessing the database. If not specified, then the default will be an empty password.

        
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
     

//new_link:
//Optional − If a second call is made to mysql_connect() with the same arguments, no new connection will be established; instead, the identifier of the already opened connection will be returned.

     
    if(! $conn ) {
     die('Could not connect: ' . mysql_error());
  }
   

// If connection could not established then show “Could not connect”

     
 echo 'Connected successfully';
  

//If connection established then show “Connected Successfully”

 <  ?php
   
 $dbhost = 'localhost:3306';
       
    $dbuser = ‘client';
         
    $dbpass = ‘client123';
         
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
        
    if(! $conn ) {
     die('Could not connect: ' . mysql_error());
  }
      
 echo 'Connected successfully';
          
  mysql_close($conn);
      
? >


Free Computer video Teaching course, you can easily learn computer to sit at home. Each course consists of more than fifty video tutorials in your own language.

online exam page and go through the test, after passing the exam, receive our certificate.


SQL Tutorial

SQL Tutorial Easy way to learn SQL stands for Structured Query Language. SQL is a database intended for the recovery and ad...