4th semester – Page 2

PHP || College Papers solutions

August 3, 2021BIM NotesLeave a Comment

ASain 2073 1. What are the different ways of writing comments in PHP →// and /* are the different ways of writing comments in PHP 2. Write the function to convert given array to string. Give examples → mysql_fetch_array() is the function to convert given array to string 3. How do you connect to database […]

PHP || old paper solutions 2015

August 3, 2021BIM NotesLeave a Comment

year 2015 Group B 11. Write a program in PHP to add three numbers.

<body>
<form action="" method="post">
<label>First Number</label>
<input type="number" name="first_num" /> <br />
<label>Second Number</label>
<input type="number" name="second_num" /> <br />
<label>Third Number</label>
<input type="number" name="third_num" />
<input type="submit" name="" value="Submit" />
</form>
</body>
<?php
if($_POST){
$first_num = $_POST['first_num'];
$second_num = $_POST['second_num'];
$third_num = $_POST['third_num'];
$sum = $first_num + $second_num + $third_num;
echo 'Sum: '.$sum;
}
?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

<body>

<label>First Number</label>

<label>Second Number</label>

<label>Third Number</label>

</form>

</body>

<?php

if($_POST){

$first_num = $_POST['first_num'];

$second_num = $_POST['second_num'];

$third_num = $_POST['third_num'];

$sum = $first_num + $second_num + $third_num;

echo 'Sum: '.$sum;

}

?>

12. Write a PHP program to display first and last character of a string.

<body>
<form action="" method="post">
<label>Enter a string</label>
<input type="text" name="text" />
<input type="submit" name="" value="submit" />
</form>
</body>
<?php
if($_POST){
$string = trim($_POST['text']);
$length = strlen($string);
for($i = ($length - 1); $i >= 0; $i--){
if($i == ($length-1)){
echo 'Last character is: '.$string[$i];
}
if($i == 0){
echo '<br />First character is: '.$string[$i];
}
}
}
?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

<body>

<label>Enter a string</label>

</form>

</body>

<?php

if($_POST){

$string = trim($_POST['text']);

$length = strlen($string);

for($i = ($length - 1); $i >= 0; $i--){

if($i == ($length-1)){

echo 'Last character is: '.$string[$i];

}

if($i == 0){

echo '<br />First character is: '.$string[$i];

}

?>

13. Create two integer array of size 5 each with data item in them. Then display sum of all the number of both […]

PHP || old paper solution 2016

August 3, 2021BIM NotesLeave a Comment

Group A 1.List out the advantage of using PHP PHP runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.) PHP is compatible with almost all servers used today (Apache, IIS, etc.) PHP supports a wide range of databases PHP is free. Download it from the official PHP resource: php.net PHP is easy to […]

PHP || old paper solution 2017

August 3, 2021BIM NotesLeave a Comment

Group A 1. Register_global variablesis an internal PHP setting which registers the $_REQUEST array’s elements as variables. If you submit a value in a form, via POST or GET, the value of that input will automatically be accessible via variable in the PHP script, named after the name of the input field. 2. To create […]

Database || Old paper solution 2019

August 3, 2021BIM NotesLeave a Comment

x

Database || Old Paper solution 2017

August 3, 2021BIM NotesLeave a Comment

13. a. select pname from parts as p, suppliers as s, catalog as c where p.pid = c.pid and c.sid = s.sid GROUP by s.sid having count(p.pid) = 1; b. select sname from suppliers as s, catalog as c, parts as p where c.sid = s.sid and p.color = ‘red’; c. update catalog set cost […]