Lab assignment: PHP
Book's exercise page number 150 number 4
xi. PHP program to display the sum of two numbers
<?php
$a = 10;
$b = 20;
$sum = $a + $b;
echo "Sum = $sum";
?>
xii. PHP program to display Name, Class and Faculty using
echo
<?php
echo "Name: Ram Sharma";
echo "Class: 12";
echo "Faculty: Science";
?>
xiii. PHP program to display all numbers from 1 to 100
<?php
for($i = 1; $i <= 100; $i++)
{
echo $i .
"<br>";
}
?>
xiv. PHP program to display Name and Address using print
statement
<?php
print "Name: Sita Thapa";
print "Address: Kathmandu";
?>
xv. PHP program to display all even numbers from 2 to 100
<?php
for($i = 2; $i <= 100; $i += 2){
echo $i .
"<br>";
}
?>
xvi. PHP program to display the smallest among three
numbers
<?php
$a = 10;
$b = 5;
$c = 7;
if($a < $b && $a < $c)
echo
"Smallest = $a";
elseif($b < $c)
echo
"Smallest = $b";
else
echo
"Smallest = $c";
?>
xvii. PHP program to display factorial of a given number
<?php
$n = 5;
$fact = 1;
for($i = 1; $i <= $n; $i++){
$fact *= $i;
}
echo "Factorial of $n = $fact";
?>
xviii. JavaScript function to check Name, Age, Password
(not blank & password ≥ 8
characters)
<script>
function validateForm() {
let name =
document.myform.name.value;
let age =
document.myform.age.value;
let pass =
document.myform.password.value;
if(name ==
"" || age == "" || pass == "") {
alert("Name, Age and Password cannot be blank");
return
false;
}
if(pass.length
< 8) {
alert("Password must be at least 8 characters long");
return
false;
}
return true;
}
</script>
xix. PHP program illustrating database connectivity
<?php
$conn =
mysqli_connect("localhost","root","","testdb");
if(!$conn){
die("Connection failed: " . mysqli_connect_error());
}
echo "Database connected successfully";
?>
xx. PHP code to insert (Ramesh, Bhaktapur, 3.5) into
student table of college DB
<?php
$conn = mysqli_connect("localhost",
"root", "", "college");
if(!$conn){
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO student(Name, Address, Gpa)
VALUES('Ramesh', 'Bhaktapur', 3.5)";
if(mysqli_query($conn, $sql)){
echo
"Record inserted successfully";
} else {
echo
"Error inserting record";
}
?>
xxi. PHP program to display records whose GPA > 3 from
database “college”,
table “result”
<?php
$conn = mysqli_connect("localhost",
"root", "", "college");
$sql = "SELECT * FROM result WHERE gpa > 3";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){
echo
"Symbol No: " . $row['symbol_no'] . "<br>";
echo
"Name: " . $row['name'] . "<br>";
echo
"Class: " . $row['class'] . "<br>";
echo "GPA:
" . $row['gpa'] . "<br><br>";
}
?>