Free Source Code

Activity Diagram ,Component diagram,Collaboration Diagram  and Use case diagram of Airport Check In and security Screening in uml Collaboration Diagram Component Diagram Use Case diagram

How to add comment on column  of a table or schema in oracle  Syntax:   COMMENT ON  COLUMN table_name . column_name IS 'comment description'; For example,  create table student(s_id number primary key,s_name varchar(20) not null ); After this if you want to comment of s_id column which acn be done as below:     comment on column student . s_id   is  'abbreviation of student id'; You can remove comment by setting it to null as shown below:     comment on column student . s_id   is ' '; Add comment in Oracle sql

How to upload file or image in html form using php The source code of uploading a file is given below. <?php error_reporting ( 0 ); ? > < html > < body > < form action = "" method = "post" enctype = "multipart/form-data" > < input type = "file" name = "uploadfile" value = "" > < input type = "submit" name = "submit" value = "Upload File" > </ form > </ body > </ html > <?php $folder = "student/" ; $filename = $_FILES [ "uploadfile" ][ "name" ]; $tempname = $_FILES [ "uploadfile" ][ "tmp_name" ]; $folder = "student/" . $filename ; // To save the image at folder student/image_name //echo $folder; move_uploaded_file ( $tempname , $folder ); //temp location to destination echo "<img src=' $folde...

Login page in php ,mysql using using html form The  source code of login page in html using php and mysql connection is given below. <?php session_start (); include ( "connection.php" ); ? > < form acion = "" method = "POST" > Username: < input type = "text" name = "username" value = "" />< br >< br > Password: < input type = "password" name = "password" value = "" />< br >< br > < input type = "submit" name = "submit" value = "login" /> </ form > <?php if ( isset ( $_POST [ 'submit' ])) { $user = $_POST [ 'username' ]; $pwd = $_POST [ 'password' ]; $query = " SELECT * FROM STUDENT WHERE username = ' $user ' && password = ' $pwd ' " ; $data = mysqli_query ( $conn , $query );...

 Database table of a tennis club The following is query of the database of a tennis club with different tables ,their relationships and constraints. It has following five tables:  PLAYERS TEAMS MATCHES PENALTIES COMMITTEE_MEMBERS CREATE TABLE PLAYERS (PLAYERNO NUMBER PRIMARY KEY,NAME VARCHAR(20) NOT NULL , INITIALS VARCHAR(30) NOT NULL CHECK(INITIALS NOT LIKE '% %' AND INITIALS NOT LIKE '%.%') , BIRTH_DATE DATE NOT NULL ,SEX CHAR(1) CHECK(SEX IN ('M','F')) ,JOINED DATE CHECK(JOINED>'31-DEC-1969'), STREET VARCHAR(20),HOUSENO VARCHAR(20) NOT NULL,POSTCODE NUMBER NOT NULL CHECK(LENGTH(POSTCODE)=6), TOWN VARCHAR(20) UNIQUE,PHONENO NUMBER NOT NULL CHECK(LENGTH(PHONENO)=10),LEAGUENO NUMBER UNIQUE NOT NULL); CREATE TABLE TEAMS (TEAMNO NUMBER PRIMARY KEY,PLAYERNO NUMBER ,FOREIGN KEY(PLAYERNO) REFERENCES PLAYERS(PLAYERNO),DIVISION VARCHAR(7) CHECK(DIVISION IN ('FIRST','SECOND'))); CREATE TABLE M...

Connection of database  in  mysql using php Connection with the database can be  established using mysqli_connect() function which accepts four parameter as the argument viz. server name,username ,password and database name.   Server name -It can be url of the database or localhost in case of      on the same machine .   Username -It is the name of user (e.g. root) .   Password -Password associated with that user name .    Database -The name of database in which you want to insert the       data. The code for the same is given below. <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $dbname = "db1" ; $conn = mysqli_connect ( $servername , $username , $password , $dbname ); if ( $conn ) { echo "connection ok" ; } else { die ( "Connnetion Failed because" . mysqli_connect_error ()); } ? > Explanation: Here $conn is a vari...