Explore topic-wise InterviewSolutions in Current Affairs.

The profit and loss appropriation account is an extension of profit and loss account prepared for the purpose of adjusting the transactions relating to amounts due to and amounts due from partners. It is nominal account in nature. The balance being the profit or loss is transferred to the partners’ capital or current account in the profit sharing ratio.

(c) Partners’ salary 

(a) Additional capital introduced

The partners share the Profit and losses of the business.

(d) Drawings

(a) opening capital

If in any frequency distribution of (Q₃ – Q₂) < (Q₂ – Q₁) then, the frequency distribution is negatively skewed.

Q₃ + Q₁ = 125, M = 62.5 2M = 2 (62.5) = 125

Q₃ + Q₁ = 2M Therefore, frequency – distribution is symmetric.

Database Connections:

Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function.

Syntax:

mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”);

This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name.

Managing Database Connections:

The below code snippet describes managing database connection methods and features. 

<?php

$servername = “localhost”;

$username = “username”;

$password = “password”;

$DBname = “SchoolDB”;

// Create connection

$conn = mysqli_connect($servemame, Susername, Spassword,$DB_name).

(c) mysqli_Select_data( ) Function

Managing Database Connections: The below code snippet describes managing database connection methods and features.

<?php

$servemame = “localhost”;

$username = “username”;

$password = “password”;

$DBname = “SchoolDB”;

// Create connection

Sconn = mysqli_connect($servemame, Susername, Spassword,SDBname);

// Check connection

if (! Sconn) {

die(“Ccnnection failed: “ . mysqli_connect_error( ));

}.

echo “Connected successfully”;

?>

In the above code snippet, three variables are used to connect to the Database server. 

They are 

1. $servemame → Database Server IP address

2. $usemame → Database Server User Name

3. $password → Database Server Password 

4. $DB_Name → Database Name 

The mysqli_connect function uses these variables and connect Database server from PHP scripting. If connection gets fail, output will be printed with MySQL error code. Otherwise connection is success.

Performing Queries:

The main goal of MySQL and PHP connectivity is to retrieve and manipulate the data from MySQL database server. The SQL query statements are helping with PHP MySQL extension to achieve the objective of MySQL and PHP connection. “mysqli_query” is a function, helps to execute the SQL query statements in PHP scripting language.

Syntax:

mysqli_query(“Connection Object” “SQL Query”)

Example:

$con=mysqli_connect(“localhost” , “my_user” , “my_pass word” , “Student_DB”); $sql= “SELECT

student_name,student_age FROM 

student”;mysqli_query($con,$sql);

Closing Connection:

mysqli_close( ) Function is used to close an existing opened database connection between. PHP scripting and MySQL Database Server.

Syntax:

mysqli_close(“Connection Object”);

<?php

$con=mysqli_connect(“localhost” , “$user” , “$password” , “SCHOOLDB”);

// ….some PHP code… mysqli_close($con);

?>

Example of PHP and MySQL Program:

<?php

$servemame = “localhost”;

$usemame = “username”;

$password = “password”;

$dbname = “schoolDB”;

$connection = mysqli_connect(“$servemame” , “$usemame”,“$password” “$dbname”);

if (mysqli_connect_error ( ))

{

echo “Failed to connect to MySQL:”

mysqli_connect_error( );

} 

sql stmt = “SELECT * FROM mycontacts”; //SQL select query

$result = mysqli_query($connection,$sql_stmt);//execute

SQL statement$rows = mysqli__num_r°ws($result);// get number of rows returned

if($rows)

{

while ($row = mysqli_fetch_array($result)) {

echo ‘ID:’. $row[‘id’]. ‘<br>';

Example - Object Oriented style

Perform query against a database: $mysqli = new mysqli("localhost","my_user","my_password","my_db"); // Check connection. if ($mysqli -> connect_errno) { echo "Failed to connect to MySQL: " . $

4 parameter are required for MYSQLi connect function in PHP

mysqli connect_error( ):

It returns the error description from the last connection error.

Syntax:

mysqli_connect_ertror( ):

mysql i_affected_rows( ):

mysqli_affected_rows( ) returns the number of affected rows in the previous MYSQL operation.

Syntax:

mysqli_affected_rows(connection)

(a) mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”);

mysqli_fetch_assoc( );

Fetches a result row as an associative array. 

Syntax:

mysqli_fetch_assoc(result);

2 parameter are required for MYSQLi query function in PHP

Syntax:

mysqli_query(“Connection Object’’ , “SQL Query”)

(b) $mysqli = new mysqli( )

(a) mysqli_close(“Connection Object”)

MySQLi functions:

1. The Mysqli functions allows you to access MySQL database servers.

2. For the MySQL functions to be available, you must compile PHP with support for the MySQLi extension.

Fetch assoc( ) 

mysqli_fetch_assoc( ):

Fetches a result row as an associative array.

Syntax:

mysqli fetch_assoc(result)

Affected rows( )

my sqli_affected_ro ws( ):

mysqli affected_rows( ) returns the number of affected rows in the previous MYSQL operation.

Syntax:

mysqli_affected_rows(connection)

1 parameter are required for MYSQLi Close function in PHP

(d) All the above

$sql= “SELECT student_name,student_age FROM student”;mysqli_query($con,$sql); sql stmt = “SELECT * FROM my contacts”;

$result = mysqli_query($connection,$sql_stmt).

Types of MySQL Functions in PHP:

1. Database connections

2. Managing Database connections

3. Performing Queries

4. Closing connection

1. Mysqli_connect( ) Function

2. Mysqli_close( ) Function

3. mysqli_select_db( ) Function

4. mysqli_affected_rows( ) Function

5. mysqli_connect_error( ) Function

6. mysqlifetchassoc( ) Function

Syntax:

mysqli_eonnect(“Server Name” , “User Name” , “password” , “DB Name”);

Example:

<?php

Sservername = “localhost”;

Susername = “username”;

Spassword = “password”;

$DB_name = “SchooLDB”;

// Create connection

$conn = mysqli_connect($servemame, Susername, Spassword,$DB_name);

(a) mysqli_query(“Connection Object” , “SQL Query”)

The variables are used to connect to the Database server.

They are

1. $servername → Database Server IP address

2. $usemame → Database Server User Name

3. $password → Database Server Password 

4. $DB_Name → Database Name

The mysqli connect function uses these variables and connect Database server from PHP scripting. If connection gets fail, output will be printed with MySQL error code. Otherwise connection is success.

Connection:

1. Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_ connect( ) Function.

2. This function requires 4 parameters.

Close function: 

1. mysqli close( ) Function is used to close an existing opened database connection between PHP scripting and MySQL Database Server.

2. This function requires only one parameter.

(d) Version 5.0

(a) mysqli_create_db(“Database Name”)

(c)  Hip Hop

// Check connection

if(!$conn){

die(“Connection failed: “ . mysqli_connect_error( ));

}

echo “Connected successfully”;

?>

Facebook has written alternative version of PHP

The main goal of MySQL and PHP connectivity is to retrieve and manipulate the data from MySQL database server.

1. The SQL query statements are helping with PHP MySQL extension to achieve the objective of MySQL and PHP connection.

2. “mysqli_query” is a function, helps to execute the SQL query statements in PHP scripting – language.

1. $servemame → Database Server Server IP address

2. $username → Database Server User Name 

3. $password → Database Server Password

4. $DBName → Database Name

Database Connections:

Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect( ) Function.

Syntax:

mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”);

This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name.

Managing Database Connections:

The below code snippet describes managing database connection methods and features<!--?php $servemame = “localhost”; $usemame = “username”; $password = “password”; SDB_name = “SchoolDB”;-->

<?php

$servemame = “localhost”;

$usemame = “username”;

$password = “password”;

SDB_name = “SchoolDB”;

// Create connection

$conn = mysqli_connect($servemame, Susemame, Spassword,$DB_name);

// Check connection

if(!$conn){

die(“Connection failed: “ . mysqli_connect_error( ));

}

echo “Connected successfully”;

?>

In the above code snippet, three variables are used to connect to the Database server. 

They are 

1. $servemame → Database Server Server IP address

2. $username → Database Server User Name

3. $password → Database Server Password 

4. $DBName → Database Name

The mysqli_connect function uses these variables and connect Database server from PHP scripting. If connection gets fail, output will be printed with MySQL error code. Otherwise connection is success.

HPHP is used to convert PHP code into C++

1. PHP can embed easily with HTML and client side scripting language

2. PHP has built-in function which is easily connect to MySQL database

3. PHP scripting language has been supported by many Software frameworks

Some of these include PRADO, CakePHP, Symfony, Codeigniter, Laravel, Yii Framework, Phalcon and Zend Framework, offering features similar to other web frameworks.

Our diet should supply various constituents like carbohydrates, proteins, fats, viatmins and minerals in the right proportion for proper nourishment and growth. If the diet taken lacks in some constituents over a long period of time, the person does not get proper nourishment. This leads to a condition called malnutrition . Malnutrition has serious consequence on health. Lack of sufficient quantities of proteins and carbohydrates lead to stunted growth.

1. energy 

2. leguminous 

3. nutrient richness 

4. Milk

Our energy is consumed in various types of tasks, like, playing, running, digesting food, studying etc.

We get jaggery and sugar from sugarcane.

We get energy from the food that we eat.

We get food from two main sources 

1. Plants 

2. Animals