0% found this document useful (0 votes)

12 views25 pages

Php&Mysql Lab Record

The document outlines a certificate for practical work completed by a student at J.M.J College for Women, detailing various PHP programming exercises. It includes practical tasks such as creating web pages, performing calculations, and demonstrating PHP functions related to variables and strings. The document also provides sample code and expected outputs for each practical exercise.

Uploaded by

JMJ College Computer department

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

12 views25 pages

Php&Mysql Lab Record

Uploaded by

JMJ College Computer department

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

You are on page 1/ 25

J.M.

J COLLEGE FOR WOMEN (AUTONOMOUS): TENALI

DEPARTMENT OF COMPUTER SCIENCE

CERTIFICATE

This is certified that bonafide record of practical work done by

__________________________________________________________ with

Regd. No: _of Course___ during

the year ______________________

Total number of experiments done: _______________________

Lecturer in-charge Head of the Department

PHP & MySQL INDEX

Practical 1: Create a php webpage and print “hello world”.

Practical 2: Create a php program to find odd or even number from given number.
Practical 3: Write a php program to find maximum of three numbers.
Practical 4: Write a PHP program to swap two numbers.
Practical 5: Write a PHP Program to demonstrate the variable function:Gettype():
Practical 6: Write a PHP Program to demonstrate the variable unction: Settype()
Practical 7: Write a PHP Program to demonstrate the variable function:isset()
Practical 8: Write a PHP Program to demonstrate the variable function:unset()
Practical 9: Give the example of variable function:strval()
Practical 10: Give the example of variable function: print_r()
Practical 11: Give the example of string function: substr():
Practical 12: Give the example of string function: strcmp()
Practical 13: Give the example of string function: strpos():1
Practical 14: Write a PHP program that demonstrate form element(input elements).
Practical 15: Write a PHP program that demonstrate passing variable using URL.
Practical 16: Write a PHP program that demonstrate use of session:1
Practical 17: Write a program that demonstrate use of cookies: 1
Practical 18: Write a PHP program to create a database using MySQL.
Practical 19:
Practical 20: Create a student Registration in PHP and Save and Display the student
Records.
Practical-1
AIM: - Create a php webpage and print “hello world”.
<Html>
<Head>
<Title> My Simple Program </Title> </head>
<Body>
<?php
echo "Hello World" ?>
</Body>
</Html>
O/P:
Hello World

Practical-2
AIM: - Create a php program to find odd or even number from given number.
<Html>
<Head>
<Title> Find out odd or even number. . ! </title> </Head >
<body>
<?php
$a = 10;
if ($a % 2==0)
{
echo "Given number is" . " " . "EVEN" ;
}
else
{
echo "Given number is" . " " . "ODD";
}
?>
</body> </html>

O/P:
Given number is
EVEN
Practical-3
AIM: - Write a php program to find maximum of three numbers.
<html>
<head>
<title> Max out of three </title> </head>

<body>
<?php $a = 1; $b = 4; $c = 3; if($a > $b)

{
if($a > $c)
echo "Maximum num a = $a"; else
echo "Maximum num c = $c";
}
else
{
if($c > $b)
echo "Maximum num c = $c"; else
echo "Maximum num b = $b";
}
?>
</body>
</html>

O/P:
Maximum num b =4

Practical-4
AIM: - Write a PHP program to swap two numbers.
<html>
<head>
<title>
Swapping of two numbers. . ! </title>
</head>
<Body>
<?php
$a = 10; $b = 20;
echo "a = $a"." "."b = $b"." "; $a = $a + $b;
$b = $a - $b; $a = $a - $b;
echo "After Swapping"." "." a = $a"." "."b = $b";
?>
</body>
</html>
O/P:
a=10
b=20
After Swapping
a=20
b=10
Practical-5
5.1AIM: - Write a PHP Program to demonstrate the variable function:Gettype():

<html>
<head>
<title>
Variable function:gettype:1 </title>
</head>

<body>
<?php $no = 5;
$value = 13.5;
$name = "Bipin R. Prajapati"; $var = true;
$myarray= array(110,45," Bipin",1.5,true);

echo gettype($no)." "; echo gettype($value)." "; echo gettype($name)." "; echo

gettype($var)." "; echo gettype($myarray)." ";
?>
</body>
</html>

O/P:
integer double string boolean array

5.2AIM: - Write a PHP Program to demonstrate the variable function:Gettype():

<html>
<head>
<title> Variable function:gettype:2 </title> </head>

O/P:
integer double
NULL string object Boolean
Practical-6
AIM: Write a PHP Program to demonstrate the variable unction: Settype()
<html>
<head>
<title> Variable function:Settype:1 </title> </head>
<body>
<?php
$var1 ="anil";
$var3 = "1Bipin"; $var4 = "anil1"; $var2 = true;
settype($var1, "integer"); settype($var2, "string"); settype($var3, "integer"); settype($var4,
"integer");
echo gettype($var1).""; echo gettype($var2).""; echo gettype($var3).""; echo
gettype($var4)."";
echo $var1.""; echo $var2.""; echo $var3.""; echo $var4."";
?>
</body>
</html>

O/P:
integer string integer integer 0 1 1 0

7.2Write a PHP Program to demonstrate the variable unction:isset()

<html>
<head>
<title>
Variable function:isset:2 </title>
</head>
<body>
<?php
$data = array('$no'=>9,'$name'=>"Bipin",'$marks'=>10.5)

foreach($data as $val1)
{
echo $val1." ";
}

foreach($data as $val2)
{
echo isset($val2)." ";
}

?>
</body>
</html>
O/P:
9 Bipin 10.5 1 1 1
Practical-8
8.1AIM: Write a PHP Program to demonstrate the variable unction:unset()
<html>
<head>
<title> Variable function:unset:1 </title> </head>
<body>
<?php function unset_val1()
{
global $val1; echo $val1; unset($val1);
}
$val1 = "Bipin"; unset_val1();
?>
</body>
</html>
O/P:
Bipin
( ! ) Notice: Undefined variable: val1 in C:\wamp\www\@nil_09\Pr-8\unset2.php on line 19

Call Stack

#Time Memory Function Location

1 0.0007 365344{main}( ) ..\unset2.php:0

8.2AIM: Write a PHP Program to demonstrate the variable unction:unset()

<html>
<head>
<title> Variable function:unset:2 </title>
</head>
<body>
<?php function unset_val1()
{
global $val1;
echo $val1;
unset($GLOBALS['val1']);
}
$val1 = "Bipin";
unset_val1();
echo isset($val1);
echo $val1;?>
</body>
</html>

O/P:
Before unset(): 1,After unset(): 55
Before unset(): 2,After unset(): 55
Before unset(): 3,After unset(): 55
Practical-9
AIM:- Give the example of variable function:strval()
<html>
<head>
<title>
Variable Function:Strval() </title>
</head>
<body>
<?php
$val1 = 22.110; echo strval($val1);
?>
</body>
</html>
O/P:
22.11

9.2 AIM:- Give the example of variable function:floatval()

<html>
<head>
<title>
Variable Function:Floatval() </title>
</head>
<body>
<?php
$val1 = "3.14pie"; echo floatval($val1);
?>
</body>
</html>
O/P:
3.14

AIM:- Give the example of variable function:intval()

<html>
<head>
<title>
Variable Function:intval() </title>
</head>
<body>
<?php
echo intval(102).' '; echo intval(102.22).' '; echo intval('102').' '; echo intval(+102).' ';
echo intval(-102).' '; echo intval(0102).' '; echo intval('0002').' '; echo intval(1e20).' '; echo
intval(0x1B).' '; echo intval(10200000).' ';
echo intval(10200000000000000000).' '; echo intval(10,2).' ';
echo intval('10',2).' ';
?>
</body>
</html>
O/P:
102
102 102 102 - 10266 2 0 27 10200000 0 10 2
Practical-10
AIM: - Give the example of variable function: print_r()

<html>
<head>
<title>
Variable Function:print_r() </title>
</head>

<body>
<pre>
<?php
$data = array('e_no'=>106680307009,'e_name'=>'Bipin R.
Prajapati','S.P.I'=>array('1st'=>7.75,'2nd'=>8.27,'3rd'=>8.20,'4th'=>7.57));
print_r ($data);
?>
</pre>
</body>
</html>

O/P:

Array
(
[e_no] => 106680307009
[e_name] => Bipin R. Prajapati [S.P.I] => Array
(
[1st] => 7.75 [2nd] => 8.27 [3rd] => 8.2 [4th] => 7.57
)

)
10.2 AIM:- Give the example of variable function: var_dump()

<html>
<head>
<title>
Variable Function:var_dump() </title>
</head>

O/P:
int 678

string 'a678' (length=4)

string '678' (length=3)

string 'BetterThanLike.com' (length=18)

float 698.99

float 125689.66
Practical-11
AIM: - Give the example of string function: substr():

<html>
<head>
<title> String Function:Substr():1 </title> </head>

<body>
If the start is non-negative, the returned string will start at the start'th position in string,
start from 0. 
<?php
echo "Substring with positive start:".substr("abcdef",2)." ";?> If the start is
negative, the returned string will start at the start'th character in
string, from the end of the string. <?php
echo "Substring with negative start:".substr("abcdef",-2)." ";?> If the start is less
than or equal to start characters long, false will
return 
<?php
echo "start is <= string".substr("abcdef",7)." "; echo "Finish";
?>
</body>
</html>

O/P:
If the start is non-negative, the returned string will start at the start'th position in string, start
from 0.

Substring with positive start:cdef

If the start is negative, the returned string will start at the start'th character in string, from the
end of the string.

Substring with negative start:ef

If the start is less than or equal to start characters long, false will return start is <= string
Finish
11.2 AIM:- Give the example of string function:substr():2
<html>
<head>
<title> String Function:Substr():2 </title> </head>
<body>
If the length is non-negative, the returned string will start at the start'th position in string
AND count the length. 
<?php
echo "Substring with positive length:".substr("abcdef",2,2)." ";?>

<?php
echo "Substring with positive length:".substr("NBPATELPILUDARA",2,4)." "; ?>

<?php
echo "Substring with positive length:".substr("abcdef",-3,2)." "; ?>

<?php
echo "Substring with positive length:".substr("NBPATELPILUDARA",- 5,2)." ";?>

If the length is negative, the returned string will start at the start'th position in string AND
count the length. 
<?php
echo "Substring with negative length:".substr("abcdef",2,-2)." ";?> <?php
echo "Substring with negative length:".substr("NBPATELPILUDARA",2,- 4)." ";?>
<?php
echo "Substring with negative length:".substr("abcdef",-2,-2)." ";?> <?php
echo "Substring with negative length:".substr("NBPATELPILUDARA",-2,-4)." ";?>
<?php
echo "Substring with negative length:".substr("NBPATELPILUDARA",-4,-2)." ";?>
<?php
echo "Substring with negative length:".substr("NBPATELPILUDARA",-5,-4)." ";?>
</body> </html>

O/P:

If the length is non-negative, the returned string will start at the start'th position in string AND
count the length.

Substring with positive length:cd

Substring with positive length:PATE

Substring with positive length:de

Substring with positive length:UD

If the length is negative, the returned string will start at the start'th position in string AND
count the length.

Substring with negative length:cd

Substring with negative length:PATELPILU

Substring with negative length:

Substring with negative length:DA

Substring with negative length:U

11.3 AIM:- Give the example of string function:substr():3

<<html>
<head>
<title> String Function: Substr():3 </title> </head>

<body>
<?php

echo substr("Bipin R. Prajapati",0,1)." "; echo substr("Bipin R. Prajapati",1,3)." "; echo

substr("Bipin R. Prajapati",5,2)." "; echo substr("Bipin R. Prajapati",8,9)." "; echo

substr("Bipin R. Prajapati",-3,3)." ";echo substr("Bipin R. Prajapati",-9,-3)." ";echo

substr("Bipin R. Prajapati",1,-10)." ";

?>
</body>
</html>

O/P:
B ipi
R Prajapat ati Prajap ipin R.
Practical-12
AIM: - Give the example of string function: strcmp()
<html>
<head> <title> String Function:strcmp() </title> </head> <body>
<?php
$str1 = 'a'; $str2 = 'b';
echo strcmp($str1, $str2)." "; $str3 = 'b';
$str4 = 'a';
echo strcmp($str3, $str4)." "; $str5 = "Anil";
$str6 = "anil";
echo strcmp($str5, $str6)." "; ?>
</body></html>
O/P:
-11 -1

12.2 AIM:- Give the example of string function:strcasecmp()

<html>
<head> <title> String Function:strcasecmp() </title> </head> <body>
<?php
$str1 = "Anil"; $str2 = "anil";
echo strcasecmp($str1, $str2)." "; $str3 = "anil";
$str4 = "anil";
echo strcasecmp($str3, $str4)." ";
?> </body> </html>

O/P:
0
0
Practical-13
AIM: - Give the example of string function: strpos():1
<html>
<head> <title>String Function:strpos():1</title> </head> <body>
<?php
$string = "I am anil";
$pos = strpos($string,"nil"); if($pos === false)
{
echo "Not found.";
}
Else { echo "Found..!"; }
?> </body> </html>
O/P:
Found..!

13.2 AIM:- Give the example of string function:strpos():2

<html>
<head>
<title> String Function:strpos():2 </title> </head>
<body>
<?php
$string = "I am anil";
$pos = strpos($string,"i"); if($pos === false)
{
echo "Not found.";
}
else
{
echo "Found at $pos. .!";
}
?>
</body>
</html>

O/P:
Found at 7. .!
13.3 AIM:- Give the example of string function:strpos():3

<html>
<head>
<title>
String Function:strpos():3 </title>
</head>

O/P:
Found at 5. .!
Practical-14
AIM: - Write a PHP program that demonstrate form element(input elements).
<html>
<head>
<title>general form</title> </head>
<body bgcolor="aakk"> <form>
Name:
<input type = "text" name = "txtname"> 
 Roll no.:
<input type = "text" name = "txtr_no"> 
 
Hobby: 
<input type = "checkbox" name = "hobbies" value = "sport"> Reading 
<input type = "checkbox" name = "hobbies" value = "sport"> Playing games 
<input type = "checkbox" name = "hobbies" value = "sport"> internet surffing 
 
Gender:
<input type = "radio" name = "Gender" value = "Male"> Male <input type = "radio" name =
"Gender" value = "Female"> Female 
 
Branch:
<select name = "Branches"> <option>C.E.</option> <option>Mech</option> <option>E.C.</option>
<option>I.T.</option> <option>E.E.</option>
</select>

<input type = "Submit" value = "Save"> <input type = "Reset" value = "Cancle"> </form>
</body>
</html>
O/P:
Practical-15
AIM: - Write a PHP program that demonstrate passing variable using URL.
<html>
<head>
<title>Query String</title> </head>
<body>
<form>
Hello Frendzz. . . ! I am
<?php
echo $_GET["Name"];
echo $_GET["L_name"];
?>
</form>
</body>
</html>
O/P:
Localhost/@nil_09/querystr.php?Name=Bipin&L_name=Prajapati Hello Frendzz. . . !
I am Bipin Prajapati

Practical-16
AIM: - Write a PHP program that demonstrate use of session:1
<html>
<head>
<title>Session</title>
</head>
<body>
<?php session_start();
$_SESSION["name"]="Anil"; $_SESSION["Password"]="nil";
?>
</body>
</html>

16.2 AIM:- Write a program that demonstrate use of session:2 <html>

<head>
<title>Session</title>
</head>
<body>
<?php
session_start();
echo "Welcome ".$_SESSION["name"]." "; echo "your Password:".$_SESSION["Password"];
?>

</body>
</html>

O/P:
Welcome Anil your Password: nil
Practical-17

AIM: - Write a program that demonstrate use of cookies: 1

<html>
<head>
<title>Examle of cookies. . !</title> </head>
<body>
<?php
setcookie("name","Anil Basantani",time()+3600,"/","",0); setcookie("age","21",time()+3600,"/","",0);
echo "set cookies";
?>
</body>
</html>
O/P:
set cookies
17.2 AIM:- Write a program that demonstrate use of cookies:2
<html>
<head>
<title>Access cookies. . !</title> </head>
<body>
<?php
echo $_COOKIE["name"]." "; echo $_COOKIE["age"]." ";
?>
</body>
</html>
O/P:
Anil Basantani 21

Practical-18
AIM: - Write a PHP program to create a database using MySQL.
<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";
$query = "create database std"; $crdb = mysql_query($query,$con); if(!$crdb)
{
die("not created. .!".mysql_error());
}
echo "database created.. !";
?>
</body>
</html>
O/P:
Connection open database created.. !
18.2 AIM: - Write a PHP program to drop a database using MySQL.
<html>
<head>
<title>Drop Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";
$query = "drop database std"; $crdb = mysql_query($query,$con); if(!$crdb)
{
die("not droped. .!" .mysql_error());
}
echo "database droped.. !";
?>
</body>
</html>
O/P:
Connection open database droped.. !

18.3 AIM: - Write a PHP program to create a table in MySQL.

<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";

$db = mysql_select_db("studinfo",$con); if(!$db)

{
die("Database not found".mysql_error());
}
echo "Database is selected"."";

$query = "create table computer(id INT not null,name varchar(50),branch varchar(50))";

$crtb = mysql_query($query,$con); if(!$crtb)
{
die(" table not created. .!".mysql_error());
}
echo "table created.. !"."";?>
</body></html>
O/P:
Connection open Database is selected table created.. !
18.4 AIM: - Write a PHP program to insert record into a table using MySQL.
<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";

$db = mysql_select_db("studinfo",$con); if(!$db)

{
die("Database not found".mysql_error());
}
echo "Database is selected"."";

$query = "insert into computer values(7009,'Anil J Basantani','Sadhana colony

Jamnagar')";

$insrtb = mysql_query($query,$con); if(!$insrtb)

{
die("Record not inserted.".mysql_error());
}
echo "Record inserted successfully. . .!"."";
?>
</body>
</html>
O/P:
Connection open
Database is selected
Record inserted successfully. . .!

18.5 AIM:- Write a PHP program to drop table using MySQL.

<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";

$db = mysql_select_db("studinfo",$con); if(!$db)

{
die("Database not found".mysql_error());
}
echo "Database is selected"."";

$query = "drop table ce";

$crtb = mysql_query($query,$con); if(!$crtb)
{
die(" table not droped. .!".mysql_error());
}
echo "table droped.. !"."";

?>
</body>
</html>

O/P:
Connection open Database is selected table droped.. !

18.6 AIM:- Write a program to update table:6

<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";

$db = mysql_select_db("studinfo",$con); if(!$db)

{
die("Database not found".mysql_error());
}
echo "Database is selected"."";

$query = "update computer set id = 09 where id = 7009"; $crtb = mysql_query($query,$con);

if(!$crtb)
{
die(" table not updated. .!".mysql_error());
}
echo "table updated.. !"."";?>
</body>
</html>

O/P:
Connection open Database is selected table updated.. !
Practical-19
AIM:- Write a PHP program to select data and show into table format.
<html>
<head>
<title>Create Database. </title> </head>
<body>
<?php
$con = mysql_connect("localhost","root",""); if(!$con)
{
die("not opened");
}
echo "Connection open"."";

$db = mysql_select_db("studinfo",$con); if(!$db)

{
die("Database not found".mysql_error());
}
echo "Database is selected"."";

$query = "select * from computer"; $sldt = mysql_query($query,$con); if(!$sldt)

{
die("data not selected".mysql_error());
}
echo "<table border='1'> <tr>
<th>ID</th>
<th>Name</th>
<th>Branch</th>
</tr>";
while($row = mysql_fetch_array($sldt))
{
echo "<tr>";
echo "<td>".$row['id']."</td>"; echo "<td>".$row['name']."</td>"; echo "<td>".
$row['branch']."</td>"; echo "</tr>";
}

echo "</table>";
?>
</body>
</html>
O/P:
Connection open
Database is selected

ID Name Branch

9 Anil J Basantani CE

9 Anil J Basantani CE
Practical-20
AIM: - Create a student Registration in PHP and Save and Display the student Records.
<html>
<head>
<title>general form</title> </head>
<body bgcolor="aakk">
<form action = "<?php $_PHP_SELF ?>" method = "POST"> Name:
<input type = "text" name = "txtname"> 
Roll no.:
<input type = "text" name = "txtr_no"> 
Gender:
<input type = "text" name = "txtgen"> 
Address:
<textarea name = "add" type = "textarea"></textarea> 
<input type = "Submit" name = "insert" value = "Save"> <input type = "Reset" value = "Cancle">
</form>
</body>
</html>
<?php
if(isset($_POST['insert']))
{
$con = mysql_connect("localhost","root",""); if($con)
{
echo "Mysql connection ok "; mysql_select_db("studinfo",$con);

$name = strval($_POST['txtname']); $rollno = intval($_POST['txtr_no']); $gender =

strval($_POST['txtgen']); $address = strval($_POST['add']);

$insert = "insert into info values('$name',$rollno,'$gender','$address')"; if(mysql_query($insert,

$con))
{
echo "Data inserted successfully ";
}
$query = "select * from info";
$sldt = mysql_query($query,$con);
echo "<table border='1'> <tr>
<th>Name</th> <th>Roll No</th> <th>Gender</th> <th>Address</th>
</tr>";
while($row = mysql_fetch_array($sldt))
{
echo "<tr>";
echo "<td>".$row['name']."</td>"; echo "<td>".$row['rollno']."</td>"; echo "<td>".
$row['gen']."</td>"; echo "<td>".$row['address']."</td>"; echo "</tr>";
}
echo "</table>";
mysql_close($con);
}
}
?>
O/P:

PHP So
No ratings yet
PHP So
42 pages
PHP Lab Manual
100% (1)
PHP Lab Manual
41 pages
PHP MySQL Lab Manual for 6th CE
No ratings yet
PHP MySQL Lab Manual for 6th CE
44 pages
PHP Scripting
No ratings yet
PHP Scripting
113 pages
Practical 2 Teni
No ratings yet
Practical 2 Teni
10 pages
PHP PracticalSET2 KD
No ratings yet
PHP PracticalSET2 KD
15 pages
Short Answer Questions: 1. Write The Structure of PHP Script With An Example
No ratings yet
Short Answer Questions: 1. Write The Structure of PHP Script With An Example
26 pages
PHP Lab Manual for Students
No ratings yet
PHP Lab Manual for Students
101 pages
PHP Lab Manual for BCA Students
No ratings yet
PHP Lab Manual for BCA Students
46 pages
Practial 2
No ratings yet
Practial 2
43 pages
PHP & XML Basics: Variables & Data Types
No ratings yet
PHP & XML Basics: Variables & Data Types
8 pages
WT GTU Study Material Presentations Unit-7 23022020054147AM
No ratings yet
WT GTU Study Material Presentations Unit-7 23022020054147AM
42 pages
PHP Programming Examples Guide
No ratings yet
PHP Programming Examples Guide
28 pages
PHP Lab Guide for BCA Students
No ratings yet
PHP Lab Guide for BCA Students
52 pages
Sairam Vsem ALL 2022
No ratings yet
Sairam Vsem ALL 2022
70 pages
CSCTR 000
No ratings yet
CSCTR 000
58 pages
Practical No 06 (Answers)
No ratings yet
Practical No 06 (Answers)
6 pages
PHP Basics for Beginners
No ratings yet
PHP Basics for Beginners
64 pages
PHP
No ratings yet
PHP
106 pages
PHP Basics and Functions Guide
No ratings yet
PHP Basics and Functions Guide
43 pages
PHP Cheat Sheet & Quick Reference
No ratings yet
PHP Cheat Sheet & Quick Reference
29 pages
2 PHP Variable Types
No ratings yet
2 PHP Variable Types
6 pages
PHP Aayu
No ratings yet
PHP Aayu
47 pages
PHP Practical Index
No ratings yet
PHP Practical Index
4 pages
Assignments 1
No ratings yet
Assignments 1
2 pages
PHP & MySQL Assignment
No ratings yet
PHP & MySQL Assignment
2 pages
Chapter 26 - PHP: Outline
No ratings yet
Chapter 26 - PHP: Outline
107 pages
PHP Practical
No ratings yet
PHP Practical
52 pages
Unit-I PHP Notes PDF
No ratings yet
Unit-I PHP Notes PDF
14 pages
Week 2 Lecture
No ratings yet
Week 2 Lecture
38 pages
PHP 2
No ratings yet
PHP 2
127 pages
Introduction To PHP
No ratings yet
Introduction To PHP
149 pages
IT ELEC1 Prelim Discussion1234 Practice12345
No ratings yet
IT ELEC1 Prelim Discussion1234 Practice12345
102 pages
WT Notes - PHP PDF
No ratings yet
WT Notes - PHP PDF
44 pages
PHP
No ratings yet
PHP
23 pages
Course Code CS: I P, N & P
No ratings yet
Course Code CS: I P, N & P
47 pages
Synapseindia PHP Development Chaptr-2
No ratings yet
Synapseindia PHP Development Chaptr-2
107 pages
PHP Unit Test Cheatsheet
No ratings yet
PHP Unit Test Cheatsheet
12 pages
PHP Notes
No ratings yet
PHP Notes
25 pages
PHP Programming Exercises Guide
No ratings yet
PHP Programming Exercises Guide
68 pages
PHP Variables
No ratings yet
PHP Variables
7 pages
PHP Lab Final Programs
No ratings yet
PHP Lab Final Programs
26 pages
Outline: What Is PHP? Basic PHP PHP Arithmetic First PHP Sample Program Second PHP Sample Program
No ratings yet
Outline: What Is PHP? Basic PHP PHP Arithmetic First PHP Sample Program Second PHP Sample Program
12 pages
Unit - 1 PHP Fundamentals (Autosaved)
No ratings yet
Unit - 1 PHP Fundamentals (Autosaved)
94 pages
PHP Cheatsheet
No ratings yet
PHP Cheatsheet
8 pages
Tybsc Sem2 PHP Pract - Final - Set
No ratings yet
Tybsc Sem2 PHP Pract - Final - Set
25 pages
Assignment PHP
No ratings yet
Assignment PHP
43 pages
PHP Chapter 2
No ratings yet
PHP Chapter 2
56 pages
Practical of PHP
No ratings yet
Practical of PHP
14 pages
LECTURE 2-Data Types
No ratings yet
LECTURE 2-Data Types
44 pages
PHP Notes
No ratings yet
PHP Notes
46 pages
7.PHP Part 1
No ratings yet
7.PHP Part 1
38 pages
PHP Basics
No ratings yet
PHP Basics
38 pages
PHP 3
No ratings yet
PHP 3
11 pages
Zend PHP Certification Study Guide: First Printing: August 2004 06 05 04 7 6 5 4
No ratings yet
Zend PHP Certification Study Guide: First Printing: August 2004 06 05 04 7 6 5 4
9 pages
Unit 1
No ratings yet
Unit 1
20 pages
Unit 2
No ratings yet
Unit 2
14 pages
Java Lab Cycle
No ratings yet
Java Lab Cycle
32 pages
III B.com-C Programming Lab Record
No ratings yet
III B.com-C Programming Lab Record
27 pages
Unit-III (Memory Organization) - Numbered
No ratings yet
Unit-III (Memory Organization) - Numbered
27 pages
NewMediaSociety 2016 Blank Lutz 1461444816667135
No ratings yet
NewMediaSociety 2016 Blank Lutz 1461444816667135
24 pages
IBM Integration Bus: Lab 5 Using DFDL Length Prefixes
No ratings yet
IBM Integration Bus: Lab 5 Using DFDL Length Prefixes
31 pages
Seminar Report On Web Desinging
64% (11)
Seminar Report On Web Desinging
23 pages
Anytime A-Star Algorithm
No ratings yet
Anytime A-Star Algorithm
4 pages
Naveen Project
No ratings yet
Naveen Project
29 pages
Accenture Ooabap
No ratings yet
Accenture Ooabap
69 pages
Asignacion Microzonas Bog - Juan Grajales
No ratings yet
Asignacion Microzonas Bog - Juan Grajales
24 pages
Selenium Automation Q A 1725258035
No ratings yet
Selenium Automation Q A 1725258035
10 pages
Prince Sharma Resume
No ratings yet
Prince Sharma Resume
1 page
C++ Programming Course Overview
No ratings yet
C++ Programming Course Overview
2 pages
ES 1 ECE OOP MODULE 5 - Control Structures and Flowcharting
No ratings yet
ES 1 ECE OOP MODULE 5 - Control Structures and Flowcharting
46 pages
Unit 1
No ratings yet
Unit 1
111 pages
Arduino Prayer Time Reminder
No ratings yet
Arduino Prayer Time Reminder
6 pages
John Smith SWE Resume
No ratings yet
John Smith SWE Resume
2 pages
Java Calculator
No ratings yet
Java Calculator
8 pages
RPSC PROGRAMMER Unit Test - 04
No ratings yet
RPSC PROGRAMMER Unit Test - 04
6 pages
Forex Trading EA Setup
No ratings yet
Forex Trading EA Setup
8 pages
ABAP Words
No ratings yet
ABAP Words
6 pages
Apriori Report
No ratings yet
Apriori Report
16 pages
IA - DCA2103 - CO - Set 1 And2 - Dec2023
No ratings yet
IA - DCA2103 - CO - Set 1 And2 - Dec2023
1 page
Apache Derby Tutorial
No ratings yet
Apache Derby Tutorial
3 pages
Database Systems Overview
No ratings yet
Database Systems Overview
64 pages
Business Rules
No ratings yet
Business Rules
5 pages
VHDL Presentation
No ratings yet
VHDL Presentation
76 pages
Compiler Phases Explained
No ratings yet
Compiler Phases Explained
5 pages
Process Table and Process Control Block
No ratings yet
Process Table and Process Control Block
5 pages
This Script Office
No ratings yet
This Script Office
4 pages
Key Factors in Choosing A Programming Language
No ratings yet
Key Factors in Choosing A Programming Language
2 pages
FSD Exp 8
No ratings yet
FSD Exp 8
6 pages
Phil Ottewell's STL Tutorial
No ratings yet
Phil Ottewell's STL Tutorial
48 pages

Php&Mysql Lab Record

Uploaded by

Php&Mysql Lab Record

Uploaded by

J.M.

J COLLEGE FOR WOMEN (AUTONOMOUS): TENALI

This is certified that bonafide record of practical work done by

Regd. No: ___________________of Course_____________________ during

the year ______________________

Total number of experiments done: _______________________

Lecturer in-charge Head of the Department

Practical 1: Create a php webpage and print “hello world”.

echo gettype($no)."<br/>"; echo gettype($value)."<br/>"; echo gettype($name)."<br/>"; echo

5.2AIM: - Write a PHP Program to demonstrate the variable function:Gettype():

7.2Write a PHP Program to demonstrate the variable unction:isset()

#Time Memory Function Location

8.2AIM: Write a PHP Program to demonstrate the variable unction:unset()

9.2 AIM:- Give the example of variable function:floatval()

AIM:- Give the example of variable function:intval()

string 'a678' (length=4)

string '678' (length=3)

string 'BetterThanLike.com' (length=18)

Substring with positive start:cdef

Substring with negative start:ef

Substring with positive length:cd

Substring with positive length:PATE

Substring with positive length:de

Substring with positive length:UD

Substring with negative length:cd

Substring with negative length:PATELPILU

Substring with negative length:

Substring with negative length:

Substring with negative length:DA

Substring with negative length:U

11.3 AIM:- Give the example of string function:substr():3

echo substr("Bipin R. Prajapati",0,1)."<br/>"; echo substr("Bipin R. Prajapati",1,3)."<br/>"; echo

substr("Bipin R. Prajapati",5,2)."<br/>"; echo substr("Bipin R. Prajapati",8,9)."<br/>"; echo

substr("Bipin R. Prajapati",-3,3)."<br/>";echo substr("Bipin R. Prajapati",-9,-3)."<br/>";echo

12.2 AIM:- Give the example of string function:strcasecmp()

13.2 AIM:- Give the example of string function:strpos():2

16.2 AIM:- Write a program that demonstrate use of session:2 <html>

AIM: - Write a program that demonstrate use of cookies: 1

18.3 AIM: - Write a PHP program to create a table in MySQL.

$db = mysql_select_db("studinfo",$con); if(!$db)

$query = "create table computer(id INT not null,name varchar(50),branch varchar(50))";

$db = mysql_select_db("studinfo",$con); if(!$db)

$query = "insert into computer values(7009,'Anil J Basantani','Sadhana colony

$insrtb = mysql_query($query,$con); if(!$insrtb)

18.5 AIM:- Write a PHP program to drop table using MySQL.

$db = mysql_select_db("studinfo",$con); if(!$db)

$query = "drop table ce";

18.6 AIM:- Write a program to update table:6

$db = mysql_select_db("studinfo",$con); if(!$db)

$query = "update computer set id = 09 where id = 7009"; $crtb = mysql_query($query,$con);

$db = mysql_select_db("studinfo",$con); if(!$db)

$query = "select * from computer"; $sldt = mysql_query($query,$con); if(!$sldt)

$name = strval($_POST['txtname']); $rollno = intval($_POST['txtr_no']); $gender =

$insert = "insert into info values('$name',$rollno,'$gender','$address')"; if(mysql_query($insert,

You might also like

Regd. No: _of Course___ during