Stuti Kumar

1
Stuti Kumar
PHP with MSSQL
2
Topics to cover in day

• Validation (Regular Expression)
• View the value
• Upload Photo and display the same
• Class and Object
• File handling - Directory Function, File type
• Mail to
• Dynamic functin

3
Dynamic
http//localhost/mssql/dynamic-listbox.php
4
Create a small database in MSSQL
5
Code
6
Upload a photo in our database
Extra column in database http//localhost/mssql/a
dd-photo.php
7
Source code of the insert file
8
Function move_upload_file
http//localhost/mssql/add-photo2.php
9
Validation Regular expression
10
Fetch_row
11
Browse this file

• http//localhost/mssql/insert2.php
• To view the contents in the textfield write
• the value Report extra

12
Data correction in two pages
http//localhost/mssql/passing-between-pages.php
http//localhost/mssql/insert.php
13
Search on the database

• Classes are little more than a container for
  variables and functions affecting those
  variables, but they can be very useful for
  building small components - almost miniture
  programs. The difference is that you dont need
  to shell out to them or anything, and they can be
  plugged into most scripts with ease - Just a
  require or include statement at the top. A class
  describes an 'object'. An object is a collection
  of smaller objects, just like in a class.
• Hinglish Whatever you see around -the computer,
  projector, table are all objects.
• Class is the Blueprint, specification Function
  Properties

14
Object
An object is something that has State Behavior Id
entity Objects have state, behavior, and
identity State is private to each object
changing one objects state doesnt change
another objects state Behavior defines what the
object is capable of doing Identity is what
allows us to refer to each object Encapsulation
hides the how we implement the state behind the
behavior we present to the outside world
15
Class not in real time it has properties
function

• -gt property resolution operator
• this Self referencing operator

16
Procedure to use a class
http//localhost/mssql/oops/sample.php
http//localhost/mssql/oops/page.php
17
Explaining class Again
18
PDF

• http//fpdf.org