Online Cultivation and Information System

In the world there are above 700 core people. Everyone needs food for survival. It’s the rule of the world that we need to full-fill the infinity demand by using definite asset. Everyone needs to fulfill his/her essential balanced diet which is need for healthy body maintaining.

So we need to learn about right cultivation system that we can grow hygienic food and provide better food for our body and full-fill foods demand all over of the world’s people and plant many tree for the green world. From this site a visitor can know can know all of the part about agriculture like Fishing,not only fish but also their name,sea fish,deshi fish,carp fish,dry fish ,cultivate way,hachary,fishing project,their picture,food etc.in this way they can know about food crop,economical crop,poltry,fruit tree,wood tree,agriculture news,picture of fields,ponds,fish,poltry,fruits,foods etc which very important for the children.Visitors can give their opinion and can be a member of the site.They can know about update news mission,vision and can get service from this site.

 Explanation of Project necessity:

Many of people are interested in gardening but they have no proper knowledge about this. Cause

  • They don’t know how they can prepare the field.
  • How much fertilizer should be mixed?
  • Which field is appropriate for which seeds?
  • They need sunny or shade?
  • Which fertilizer is appropriate for that?
  • Which insect is essential or which not?
  • Which insect killer is useful or not.
  • Which ponds are appropriate for fishing?
  • How they can prepare it.
  • Which fish is appropriate for those ponds?
  • Farming is also my concept.
  • Tree plantation and their essentiality etc.

Initial Statement of Proposed System:

In the proposed site, I am going to establish a site where`s a farmer, student, a researcher, a teacher and all kinds of people can fulfill their need. I keep here a option for them who wants to be a member.I keep here a search option,a feedback option,a coment option.Most important is that I deveolop this site in Bengali and English version that every person of the world can visit this site. The most Common information I handle here:

  • Member Information: I going to take the entire member’s information in the database. It is including- id, first_name, email, login, password city etc.
  • Cultivation Information: I going to take all the necessary information about necessary crops in the site. I divide it into difference part like food crops and economical crops
  • Poltry Information: I going to take all the necessary information about Poltry in the site. I divide it into difference part like Hen and Duck.
  • Fishing Information: I going to take all the necessary information about fish in the site. I divide it into difference part like country, carp, sea, dry fish.
  • Dairy Information: I going to take all the necessary information about dairy industry and cow firm in the site.
  • Tree plantation Information: I going to take all the necessary information about tree in the site. I divide it into difference part like fruit and wood.
  • Animal Planet Information: I going to take all the necessary information about animal in the site. I divide it into difference part pet, wild and other.
  • Mission & Vission Information: I also established here my mission and vision why I established my site.
  • Photo Gallery Information: I going to take all the necessary photo here.It helps all kinds of people specially children that they can know about their culture and food.
  • Data & Research Information: Here a man can get help all the information if they want to research about our agri site.
  • News Information: Here a man get news update about agriculture.
  • Opinion Information: Here a man can express his opinion.
  • Service: A farmer can get service from this site

Development Specification:

The development specification of the proposed system is initiated. The specification of those parts is given bellow:

  • Project Language: I am going to establish this system in PHP. For implement my knowledge about PHP and for practice, I want to use PHP in this system.
  • Methodology: To complete this system, I have chosen, the RAD (Rapid Application Deveolopment). Because, this is the most widely used structured analysis method. Though, I want to use object-oriented language (PHP) in this system. I have a proper knowledge in RAD. So, I think it is very much predictable to use it in my project development.

The aim of this site Online Cultivation And Information System is to establish a paperless educational area with maximum utilization of time and money. The target motto of this project is- “Minimum Input and Maximum Output”.

Fact-Finding:

After approving my project proposal, I have started the fact-finding stage of the project development. In the fact-finding segment of this project, I have considered four methods for finding the required information of this organization. The methods are:

  • Background Reading;
  • Observation;
  • Interview

Background Reading:

In the fact-finding part, at first, I have completed the background reading of agriculture and visit the agricultural sites.

  • 70% People of the country makes their livelihood from this occupation.
  • Many business are depends on it.
  • A farmer works every day in his field.
  • Some peoples are work in this area for part time as a labor.
  • Paltry now a most important in project in our country.
  • Our meat and eggs demand we can get from this field.
  • In our country new its one kind of revaluation.
  • Many unemployment people works here so unemployment people rate are going downward.
  • Sometimes ladies can grow vegetables in their garden.
  • Firming is very important from our country development and people’s life leading way. We can get meat, milk from this.
  • Oxygen is the life because we can’t survive without Oxygen. And our environment is fully depending on three. So tree plantation is very important for our environment.

Description of the Current Site:

There are some agricultural site about Bangladesh agriculture.But theres no fulfill information about any thing.They don’t describe about about climate,soil,weather that is appropriate for our agriculture.Theres no site where has a photo gallery that has educational part about agriculture.Theres no more site that’s anged with poultry ,fishing,tree plantation,cultivation.There is no site where has a photo gallery that has educational part about agriculture with photos.And its very important for the children specially for the city children.Theres many few site that describe theway of gardening in the roof,tob e.t.c

current site

Object:  

Discuss about National Agricultural Technology project and Agricultural transfer project.

Sitemap:

  • Home
  • About BARC
  • Organization
  • Management
  • Publications
  • Project
  • Newsletter
  • Mail
  • Press Releases

Design Specify:

  • Regulation: This web Regulation Support minimum 800 X 600 pixels.
  • Color Combination: Color Combination is very good.
  • Layout: This web use 2 column liquid left sidebar, header and footer.
  • Navigation Menu: This web site maintains proper navigation.

Strength:

  • They discus about agricultural technology
  • They use some report.

Weakness:

  •  They  use line justify.

Color Combination:

  • Color combination is good.

Object: 

Discuss about Bangladesh Agricultural development  And their services.

Sitemap:

  • Home
  • About BADC
  • Ongoing Activities
  • Seed Price And Sales Center
  • Fertilizer And Sales Stock
  • Irrigation Equipment
  • Publications
  • Newsletter
  • Forms
  • Contacts
  • Notice Boards

Design Specify:

  • Regulation: This web Regulation Support minimum 800 X 600 pixels.
  • Color Combination: Color Combination is very good.
  • Layout: This web use 2 column liquid left sidebar, header and footer.
  • Navigation Menu: This web site maintains proper navigation.

Strength:

  • They discus about agricultural technology
  • They use some report.
  • They use polling system.

Weakness:

  •  They  use line justify.

Color Combination:

  • Color combination is good.

agriculture site

Object: 

Discuss about Agricultural project, problem, revenue budget, development pattern.

Sitemap:

  • Home
  • Statics
  • Marketing
  • Policy
  • Projects
  • Crop
  • Fertilizer
  • Projects

Design Specify:

  • Regulation: This web Regulation Support minimum 800 X 600 pixels.
  • Color Combination: Color Combination is very good.
  • Layout: This web use 2 column liquid left sidebar, header and footer.
  • Navigation Menu: This web site maintains proper navigation.

Strength:

  • They discus about agricultural technology
  • They use some report.
  • They use some slogans

Weakness:

  •  They  use line justify.
  • They use some picture

Color Combination:

  • Color combination is good.

Analysis of the current sites:

There are some problems which are

Criticism:

After the investigation of the current site, I have recognized that there is much latency. The problems are described below:

  • Theres no site where every crops has individual description.
  • Some site has picture but that are not sufficient
  • They don’t discuss the whole part of agriculture.
  • Some sites discuss about cultivation another discuss their activity
  • No sites are not fulfilled

Comments:

After finding the problems, I have tried to find the way I which they can recover. To fix this type of problems, my comments for those sites are given bellow:

  • Every sites need to be describe about our climate.
  • They should discuss every part of our agriculture.
  • In this competitive world they should give the idea about modern technological way that farmer can produce more crops.
  • In every site should be published about disease and how the farmer or visitor can prevent those.
  • They should give update news about farming,fishing,poltry,tree,fruits market price advise,agri news  and make a awareness about our agri side.
  • Should give real picture about every step of cultivating,ponds,fish,fish feeding etc.

Requirement Specification:

Module Name: Member Model

Operations:

  • Add Member record;
  • Delete Member record;
  • Edit Member record;
  • View Member details;
  • Update Member details;
  • Module Name: Admin Model

Operations:

  • Add Member record;
  • Delete Member record;
  • Edit Member record;
  • View Member details;
  • Update Member details;

Description of New Sites:

Here I want to established a site where a man can get everything that he need in agri side. He can get about cultivation, fishing, poltry,tree,animal,and their disease,time, etc.Here a man  can be a member.

context diagram of the site

The entities of the system are:

  • Student
  • Teacher
  • Housewife
  • Farmer
  • Researcher
  • Member
  • Poultry Farmer
  • Interested Person etc.

High Level Implementation:

In this section I have produced-

Structural Design

  • Logical Design
  • Physical Design

Data Design

flowchart

Check Email from Database Flowchart

email from data base flowchart

Physical Design:

Index Page Design:

index page design

Data Input Form

data input form

login and feedback form

Data Design:

In this section I have produced-

  • Data Dictionary;
  • Entity Relationship Diagram;

Data dictionary:

Table: Member Information

Field

Type

Format

Key

Extra

Constraints

IdInt(10)99999PriAuto_incrementNot Duplicate, auto increment and primary key
first_nameVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
middle_nameVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
Last_nameVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
AddressVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
PhoneVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
GenderVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
IpVarchar(60)99999  must be valid and    Cannot be more than size
CityVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
CountryVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
Post_codeVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
Log_inVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
EmailVarchar(60)xxxxxxxxUni Not Duplicate, must be valid and not null
PasswordVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
Facebook_idVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
Activation_codeVarchar(60)99999  must be valid and    Cannot be more than size
InactiveTinyint(10)99999  must be valid and    Cannot be more than size
Created_onDatetimeXxxxxxxx  must be valid and    Cannot be more than size

 Attributes: Member Information table

  • File Name         : Member Information. txt
  • File Type           : Binary
  • Record Name    : Member Information
  • Record Size       : (65*2)+4=134 bites

Functions: Member information. txt

  • Add record
  • Edit record
  • Delete record
  • List
  • Search

Table: admin Information

FieldTypeFormatKeyExtraConstraints
IdInt(10)9999999PRIauto_incrementNot Duplicate, auto increment and primary key
NameVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size
loginVarchar(60)xxxxxxxxUni must be valid and    Cannot be more than size
passwordVarchar(60)xxxxxxxx  must be valid and    Cannot be more than size

 Attributes: Admin Information table

  •      File Name         : Member Comments Information. txt
  •      File Type           : Binary
  •      Record Name    : Member Comments Information
  •      Record Size       : (65*2)+4=134 bites
  •      File size             :

Functions: Member Comments Information. txt

  •      Add record
  •      Edit record
  •      Delete record
  •      List

Entity Relationship Diagram:

entry diagram

Low Level Implementation

In this section I have produce-

  • Coding Standard;
  • Coding Sampling.

 Coding Standard:

  • Programming Language: I have used PHP-MYSQL for this system development. It’s a standard way for system developing.
  • Component: I have used many useful components of JavaScript,CSS,Ajax,HTML etc.
  • Variables: I have used meaningful variables throughout the system coding.
  • Comments: I have produced necessary comments throughout the system coding.

Coding Sampling:

For sampling coding, I have produced the main screen code bellow:

The Code:

Index .php

Php session_start();

require_once(“api/db.inc.php”);

error_reporting(E_ALL ^ E_NOTICE);

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<Head>

<Meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />

<Title>Online Cultivation & Information System</title>

<script type=”text/javascript” language=”javascript” src=”ajax.js”></script>

<link rel=”stylesheet” href=”css/master.css” type=”text/css” />

</head>

<Body>

                <table id=”container” align=”center” cellspacing=”0″ cellpadding=”0″ >

                                <td colspan=”3″ valign=”top”><?php include(“modules/banner.php”)?></td>

                                <td colspan=”3″>

                                                                <table width=”100%” style=”background:#1d8cba URL(images/glossy_repeat.png) repeat-x; background-position:0 -2px;”>

             <td id=”menuSection” width=”170″ valign=”top”>

                    <?php include(“menu/mlmenu.php”);?>

             <td id=”printContent” width=”510″ valign=”top” bgcolor=”#FFFFFF” align=”center”>

                     <?php include(“print_content.php”);?>

             <td width=”180″ valign=”top”>

                <Table>

                        <Th style=”color:#FF0F09″><?php include(“log_show.php”);?></Th>

                        <th colspan=”3″ style=”background-color:#E6E6E6; height:30px; border-top:1px sp;od #999;”><strong><?php include(“modules/footer.php”)?></strong></th>

                                </TR>

</table>

</body>

</html>

Sign_up.php:

<?php

                                If(isset($_POST[“btnSubmit”])){

                                $last_name=$_POST[“txtLastName”];

                                $address=$_POST[“txtAddress”];

                                $phone=$_POST[“txtPhone”];

                                $gender=$_POST[“select”];

                                $country=$_POST[“cselect”];

                                $city=$_POST[“txtCity”];

                                $post_code=$_POST[“txtPostCode”];

                                $log_in=$_POST[“txtLogin”];

                                $email=$_POST[“txtEmail”];

                                $password=$_POST[“pwdPassword”];

                                                //print_r($_POST[“txtFacebook”]);

                                                ddl(“insert into member(first_name,middle_name,last_name,address,phone,gender,country,city,post_code,log_in,email,password,facebook_id)values (‘$first_name’,’$middle_name’,’$last_name’,’$address’,’$phone’,’$gender’,’$country’,’$city’,’$post_code’,’$log_in’,’$email’,’$password’,’$facebook_id’)”);

Define(“LOCATION”,”load”);

 $file_name=$_FILES[“file”][“name”];

 $file_type=$_FILES[“file”][“type”];

 $file_tmp_name=$_FILES[“file”][“tmp_name”];

 $file_size=$_FILES[“file”][“size”];

 $up=move_uploaded_file($file_tmp_name,LOCATION.”/”.$r->insert_id.”.Jpg”);

 Echo “Congratulations!! Data Submited Successfully “.$r->insert_id;

 $msg=””;

                If(!preg_match(“/^[^0-9]{2,}$/”,$first_name)){

                                                $msg.=”First name must be in alpha.<br/>”;

                If(!preg_match(“/^[^0-9]{2,}$/”,$last_name)){

                                                $msg.=”Last name must be in alpha.<br/>”;

                                If(!preg_match(“/^[^0-9][a-zA-Z0-9_]+([.][A-zA-Z0-9_]+)*[@][a-zA-Z0-9_]+([.][A-zA-Z0-9_]+)*[.][A-zA-Z]{2,4}$/”,$email)){

                                 $msg.=”Email is not valid.<br/>”;

                if(!preg_match(“/^[0-9]{7,25}$/”,$phone)){

                                                $msg.=”Phone number must be number.<br/>”;

                If(!preg_match(“/^[A-Za-z0-9_]{2,}$/”,$city)){

                                $msg.=”City must be alpha character.<br/>”;

                If(!preg_match(“/^[0-9]{4,}$/”,$post_code)){

                                $msg.=”Post code must be numberic at least 4 character.<br/>”;

                If(!preg_match(“/^[A-Za-z]{2,}$/”,$country)){

                                $msg.=”Country must be alpha character.<br/>”;

If($msg==””){

                $db=new mysqli(SERVER,USER,PASSWORD,DATABASE);

                $sql=”insert into customer(first_name,last_name,gender,occupation,date_birth,email,phone,city,post_code,country) values(‘$first’,’$last’,’$gender’,’$occupation’,’$birth’,’$mail’,’$phone’,’$city’,’$post_code’,’$country’)”;

                $rs=$db->query($sql);

                Echo “<font color=’green’><h4>successfully saved</h4></font>”;

<Body>

<fieldset style=”width:510px; border:1px solid #e3e3e3;”>

<Legend>Sign up</legend>

<form action=”#” method=”post”  enctype=”multipart/form-data” style=”color:#666; font-size:11px; background-color:#f2f2f2;”>

<table border=”0″ align=”center” >

                <Caption><?php

                If(!$msg==””){

                Echo “<font color=’red’>”.$msg.”</font>”;

                ?></caption>

  <TR>

    <Td>First Name</td>

    <Td><input type=”text” name=”txtFirstName” /></td>

  </TR>

  <TR>

    <Td>Last Name</td>

    <Td><input type=”text” name=”txtLastName”/></td>

  </TR>

  <TR>

    <Td>Address</td>

    <Td><input type=”text” name=”txtAddress”/></td>

  </TR>

  <tr>

    <td>Phone</td>

    <td><input type=”text” name=”txtPhone”/></td>

  </tr>

  <tr>

    <td>Gender</td>

    <td><select name=”cselect”>

                                <option>Bangladesh</option>

                                 <option>Bahrain</option>

             <option>Chaina</option>

             <option>DomenicanRepublic</option>

             <option>England</option>

             <option>Finland</option>

             <option>Germany</option>

             <option>Spen</option>

             <option>Thailand</option>

             <option>Roanda</option>

             <option>Poland</option>

               </select></td>

    <td>Post Code</td>

      <td>Email</td>

      <td><input type=”text” name=”txtEmail” onBlur=”ajaxGET(‘mail’,’get_file.php?email=’+txtEmail.value)” /><span id=”mail”></span></td>

    Password:

    <td colspan=”2″ align=”center”><input type=”submit” name=”btnSubmit” value=”Submit”/>

   <input type=”reset” name=”btnReset” value=”Reset” /></td>

  </tr>

</table>

</form>

</fieldset>

</body>

sign_up.php

<?php

                                if(isset($_POST[“btnSubmit”])){

                                //print_r($_POST);

                               $first_name=$_POST[“txtFirstName”];

                                $last_name=$_POST[“txtLastName”];

                                $address=$_POST[“txtAddress”];

                                $phone=$_POST[“txtPhone”];

                                $gender=$_POST[“select”];

                                $country=$_POST[“cselect”];

                                $city=$_POST[“txtCity”];

                                $post_code=$_POST[“txtPostCode”];

                                $log_in=$_POST[“txtLogin”];

                                $email=$_POST[“txtEmail”];

                                $password=$_POST[“pwdPassword”];

                                                //print_r($_POST[“txtFacebook”]);

                                ddl(“insert into member(first_name,middle_name,last_name,address,phone,gender,country,city,post_code,log_in,email,password,facebook_id)values (‘$first_name’,’$middle_name’,’$last_name’,’$address’,’$phone’,’$gender’,’$country’,’$city’,’$post_code’,’$log_in’,’$email’,’$password’,’$facebook_id’)”);

                define(“LOCATION”,”load”);

 $file_name=$_FILES[“file”][“name”];

 $file_type=$_FILES[“file”][“type”];

 $file_tmp_name=$_FILES[“file”][“tmp_name”];

 $file_size=$_FILES[“file”][“size”];

 $up=move_uploaded_file($file_tmp_name,LOCATION.”/”.$r->insert_id.”.jpg”);

 echo “Congratulations!! Data Submited Successfully “.$r->insert_id;

 $msg=””;

                if(!preg_match(“/^[^0-9]{2,}$/”,$first_name)){

                                                $msg.=”First name must be in alpha.<br/>”;

                if(!preg_match(“/^[^0-9]{2,}$/”,$last_name)){

                                                $msg.=”Last name must be in alpha.<br/>”;

                if(!preg_match(“/^[^0-9][a-zA-Z0-9_]+([.][a-zA-Z0-9_]+)*[@][a-zA-Z0-9_]+([.][a-zA-Z0-9_]+)*[.][a-zA-Z]{2,4}$/”,$email)){

                                 $msg.=”Email is not valid.<br/>”;

                if(!preg_match(“/^[0-9]{7,25}$/”,$phone)){

                                                $msg.=”Phone number must be number.<br/>”;

                if(!preg_match(“/^[A-Za-z0-9_]{2,}$/”,$city)){

                                $msg.=”City must be alpha character.<br/>”;

                if(!preg_match(“/^[0-9]{4,}$/”,$post_code)){

                                $msg.=”Post code must be numberic at least 4 character.<br/>”;

                if(!preg_match(“/^[A-Za-z]{2,}$/”,$country)){

                                $msg.=”Country must be alpha character.<br/>”;

if($msg==””){

                $db=new mysqli(SERVER,USER,PASSWORD,DATABASE);

                $sql=”insert into customer(first_name,last_name,gender,occupation,date_birth,email,phone,city,post_code,country) values(‘$first’,’$last’,’$gender’,’$occupation’,’$birth’,’$mail’,’$phone’,’$city’,’$post_code’,’$country’)”;

                $rs=$db->query($sql);

                echo “<font color=’green’><h4>Successfully saved</h4></font>”;

<body>

<fieldset style=”width:510px; border:1px solid #e3e3e3;”>

<legend>Sign up</legend>

<form action=”#” method=”post”  enctype=”multipart/form-data” style=”color:#666; font-size:11px; background-color:#f2f2f2;”>

<table border=”0″ align=”center” >

                <caption><?php

                if(!$msg==””){

                echo “<font color=’red’>”.$msg.”</font>”;

                ?></caption>

    <td>First Name</td>

    <td><input type=”text” name=”txtFirstName” /></td>

    <td>Last Name</td>

    <td><input type=”text” name=”txtLastName”/></td>

    <td>Address</td>

    <td><input type=”text” name=”txtAddress”/></td>

    <td>Phone</td>

    <td><input type=”text” name=”txtPhone”/></td>

    <td>Gender</td>

                                 <select name=”select”>

                                <option>Male</option>

                                 <option>Female</option>

                                </select>

    <td>Country</td>

    <td><select name=”cselect”>

                                <option>Bangladesh</option>

                                 <option>Bahrain</option>

             <option>Chaina</option>

             <option>DomenicanRepublic</option>

             <option>England</option>

             <option>Finland</option>

             <option>Germany</option>

             <option>Spen</option>

             <option>Thailand</option>

             <option>Roanda</option>

             <option>Poland</option>

              </select></td>

    <td>City</td>

    <td><input type=”text” name=”txtCity”/></td>

    <td>Post Code</td>

    <td><input type=”text” name=”txtPostCode”/></td>

      <td>Email</td>

      <td><input type=”text” name=”txtEmail” onBlur=”ajaxGET(‘mail’,’get_file.php?email=’+txtEmail.value)” /><span id=”mail”></span></td>

    Password:

                </td>

                <td>

                <input type=”password” name=”pwdPassword”   />

                </td>

                </tr>

                <td>Upload_File</td>

                <td><input type=”file” name=”file” /></td>

                </tr>

    <td colspan=”2″ align=”center”><input type=”submit” name=”btnSubmit” value=”Submit”/>

   <input type=”reset” name=”btnReset” value=”Reset” /></td>

  </tr>

</table>

</form>

</fieldset>

</body>

update_member.php

<?php

                if(isset($_SESSION[‘member_id’])){

                                $member=$_SESSION[‘member_id’];

                $record=get_record(“select first_name,last_name,address,phone,gender,country,city,post_code,log_in,email,password from member where id=’$member'”);

                $first_name=$record[0];

                $last_name=$record[1];

                $address=$record[2];

                $phone=$record[3];

                $gender=$record[4];

                $country=$record[5];

                $city=$record[6];

                $post_code=$record[7];

                $log_in=$record[8];

                $email=$record[9];

                $password=$record[10];

 if(isset($_POST[“btn_update”])){

                                 $first_name=$_POST[“txtFirstName”];

                                $last_name=$_POST[“txtLastName”];

                                $address=$_POST[“txtAddress”];

                                $phone=$_POST[“txtPhone”];

                                $gender=$_POST[“select”];

                                $country=$_POST[“cselect”];

                                $city=$_POST[“txtCity”];

                                $post_code=$_POST[“txtPostCode”];

                                $log_in=$_POST[“txtLogin”];

                                $email=$_POST[“txtEmail”];

                                $password=$_POST[“pwdPassword”];

                                                ddl(“update member set first_name=’$first_name’,last_name=’$last_name’,address=’$address’,phone=’$phone’,gender=’$gender’,country=’$country’,

                                                city=’$city’,post_code=’$post_code’,log_in=’$log_in’,email=’$email’,password=’$password'”);

                                                                echo “<font color=’green’>Successfully Updated!</font>”;

<form action=”#”  method=”post” name=”frm_update”>

<table>

    <td>Last Name</td>

    <td><input type=”text” value=”<?php echo $last_name;?>” name=”txtLastName”/></td>

    <td>Address</td>

    <td><input type=”text”  value=”<?php echo $address;?>”name=”txtAddress”/></td>

  </tr>

  <tr>

    <td>Phone</td>

    <td><input type=”text”  value=”<?php echo $phone;?>”name=”txtPhone”/></td>

    <td>Gender</td>

                                 <select name=”select”>

                                    <option><?php echo $gender;?></option>

                                <option>Male</option>

                                 <option>Female</option>

                                </select>

    <td>Country</td>

    <td><select name=”cselect”>

                                                <option><?php echo $country;?></option>

                                <option>Bangladesh</option>

                                 <option>Bahrain</option>

             <option>Chaina</option>

             <option>DomenicanRepublic</option>

             <option>England</option>

             <option>Finland</option>

             <option>Germany</option>

             <option>Spen</option>

             <option>Thailand</option>

             <option>Roanda</option>

             <option>Poland</option>

                                </select></td>

    <td>City</td>

    <td><input type=”text” value=”<?php echo $city;?>” name=”txtCity”/></td>

    <td>Post Code</td>

    <td><input type=”text” value=”<?php echo $post_code;?>” name=”txtPostCode”/></td>

    <td>Login</td>

    <td><input type=”text” value=”<?php echo $log_in;?>” name=”txtLogin”/></td>

      <td>Email</td>

      <td><input type=”text” value=”<?php echo $email;?>” name=”txtEmail” onBlur=”ajaxGET(‘mail’,’get_file.php?email=’+txtEmail.value)” /><span id=”mail”></span></td>

Password:

                </td>

                <td>

                <input type=”password” value=”<?php echo $password;?>” name=”pwdPassword”   />

                </td>

                </tr>

<tr><td></td><td><input type=”submit” value=”Update” name=”btn_update” /> </td></tr>

</table>

</form>

Ajax.js

function ajaxGET(div,url){

                var xmlhttp;

                if(window.XMLHttpRequest){

                xmlhttp=new XMLHttpRequest();

                }else{

                xmlhttp=new ActiveXObject(“Microsoft.XMLHTTP”);

xmlhttp.onreadystatechange=function(){

                if(xmlhttp.readyState==4 && xmlhttp.status==200){

               document.getElementById(div).innerHTML=xmlhttp.responseText;

                xmlhttp.open(“GET”,url,true);

                xmlhttp.send();

<?php

require_once(“api/db_config.inc.php”);

                $email=$_GET[“email”];

                $db=new mysqli(SERVER,USER,PASSWORD,DATABASE);

                $result=$db->query(“select count(*) from member where email=’$email'”);

                $row=$result->fetch_array(MYSQLI_BOTH);

                                if($row[0]==1){

                                echo “<font color=’red’>Already exist </font>”;

                                }else{

                                echo “<font color=’green’>OK </font>”;

sign_out

<?php session_start();

unset($_SESSION[“member_id”]);

unset($_SESSION[“member_name”]);

echo “<script>window.location=’index.php'</script>”;

//session_destroy();

//header(“location:./index.php”);

log_show.php

  <?php

                     if(isset($_SESSION[“member_id”])){

                       echo “<img src=’/members/$_SESSION[member_id].jpg’ height=’100′ />”.”<br/>”.”Name: ” .$_SESSION[“member_name”].”<br/>”.”Address : “.$_SESSION[“member_address”].”<br/>”.”Phone : “.$_SESSION[“member_phone”].”<br/>”.”Gender : “.$_SESSION[“member_gender”].”<br/>”.”Country :

login_menu.php

<?php if(isset($_SESSION[“member_id”])){

<a  href=”index.php?id=2″>Login</a> | <a  href=”index.php?id=3″>Signup</a>

print_content.php

<?php

   if($_GET[“id”]==2){

      include(“pages/log_in.php”)

   }else if($_GET[“id”]==3){

      include(“pages/sign_up.php”);

   }else if($_GET[“id”]==4){

      include(“pages/forget_password.php”);

   }else if($_GET[“id”]==7){

      include(“poltry/hen/local_hen.php”);

   }else if($_GET[“id”]==8){

      include(“poltry/hen/boiler.php”);

   }else if($_GET[“id”]==5){

      include(“poltry/hen/layer.php”);

   }else if($_GET[“id”]==10){

      include(“contact_ui.php”);

   }else if($_GET[“id”]==11){

      include(“complain.php”);

   }else if($_GET[“id”]==9){

      include(“fishing/country_fish.php”);

   }else if($_GET[“id”]==16){

      include(“option2/mission.php”);

   }else if($_GET[“id”]==15){

      include(“photo_gallery/agri.php”);

   }else if($_GET[“id”]==86){

      include(“photo_gallery/animal.php”);

   }else if($_GET[“id”]==87){

      include(“photo_gallery/fish.php”);

   }else if($_GET[“id”]==17){

      include(“fishing/carp.php”);

   }else if($_GET[“id”]==18){

      include(“option2/news.php”);

   }else if($_GET[“id”]==19){

      include(“option2/research.php”);

   }else if($_GET[“id”]==20){

      include(“complain.php”);

   }else if($_GET[“id”]==21){

      include(“fishing/dry_fish.php”);

   }else if($_GET[“id”]==22){

      include(“fishing/sea_fish.php”);

   }else if($_GET[“id”]==23){

      include(“dairy/cow_firm.php”);

   }else if($_GET[“id”]==24){

      include(“dairy/about dairy.php”);

   }else if($_GET[“id”]==25){

      include(“tree_plantation/fruit.php”);

   }else if($_GET[“id”]==26){

      include(“tree_plantation/wood.php”);

   }else if($_GET[“id”]==27){

      include(“animal_planet/pet_animal.php”);

   }else if($_GET[“id”]==28){

      include(“animal_planet/wild_animal.php”);

   }else if($_GET[“id”]==29){

      include(“animal_planet/others.php”);

   }else if($_GET[“id”]==30){

      include(“poltry/duck.php”);

   }else if($_GET[“id”]==31){

      include(“option/information.php”);

   }else if($_GET[“id”]==32){

      include(“option/service.php”);

   }else if($_GET[“id”]==35){

      include(“cultivating/food_crops/rice.php”);

   }else if($_GET[“id”]==36){

      include(“cultivating/food_crops/wheat.php”);

   }else if($_GET[“id”]==37){

      include(“cultivating/food_crops/barley.php”);

   }else if($_GET[“id”]==39){

      include(“cultivating/food_crops/maize.php”);

   }else if($_GET[“id”]==47){

      include(“cultivating/food_crops/bean.php”);

   }else if($_GET[“id”]==41){

      include(“cultivating/food_crops/bottle_guard.php”);

   }else if($_GET[“id”]==40){

      include(“cultivating/food_crops/bringal.php”);

   }else if($_GET[“id”]==42){

      include(“cultivating/food_crops/ladies_finger.php”);

   }else if($_GET[“id”]==45){

      include(“cultivating/food_crops/potato.php”);

   }else if($_GET[“id”]==46){

      include(“cultivating/food_crops/tomato.php”);

   }else if($_GET[“id”]==49){

      include(“cultivating/food_crops/pulse.php”);

   }else if($_GET[“id”]==50){

      include(“cultivating/food_crops/vegetable.php”);

   }else if($_GET[“id”]==48){

      include(“cultivating/food_crops/spinach.php”);

   }else if($_GET[“id”]==47){

      include(“cultivating/food_crops/tomato.php”);

   }else if($_GET[“id”]==71){

      include(“tree_plantation/fruit/mango.php”);

   }else if($_GET[“id”]==72){

      include(“tree_plantation/fruit/banana.php”);

   }else if($_GET[“id”]==73){

      include(“tree_plantation/fruit/apple.php”);

   }else if($_GET[“id”]==74){

      include(“tree_plantation/fruit/orange.php”);

   }else if($_GET[“id”]==75){

      include(“tree_plantation/fruit/cherry.php”);

   }else if($_GET[“id”]==76){

      include(“tree_plantation/fruit/jackfruit.php”);

   }else if($_GET[“id”]==77){

      include(“tree_plantation/fruit/papaya.php”);

   }else if($_GET[“id”]==78){

      include(“tree_plantation/fruit/pineapple.php”);

   }else if($_GET[“id”]==79){

      include(“tree_plantation/fruit/pear.php”);

   }else if($_GET[“id”]==80){

      include(“tree_plantation/fruit/peach.php”);

   }else if($_GET[“id”]==82){

      include(“animal_planet/pet_animal.php”);

   }else if($_GET[“id”]==83){

      include(“animal_planet/wild_animal.php”);

   }else if($_GET[“id”]==84){

      include(“animal_planet/others.php”);

   }else if($_GET[“id”]==51){

      include(“cultivating/economical_crop/tea.php”);

   }else if($_GET[“id”]==52){

      include(“cultivating/economical_crop/jute.php”);

   }else if($_GET[“id”]==53){

      include(“cultivating/economical_crop/coffe.php”);

   }else if($_GET[“id”]==54){

      include(“cultivating/economical_crop/cotton.php”);

   }else if($_GET[“id”]==55){

      include(“cultivating/economical_crop/peanut.php”);

   }else{

      include(“home.php”);

time.php

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />

<title>Untitled Document</title>

<script language=”javascript” type=”text/javascript”>

</script>

</head>

<body onload=”showTime();”>

<div id=”time” >

</div>

</body>

</html>

contact_ui.ph

<?php

if(isset($_POST[“btnFeedback”])){

//print_r($_POST);

$name=$_POST[“txtName”];

$phone=$_POST[“txtPhone”];

$email=$_POST[“txtEmail”];

$complain=$_POST[“txtComplain”];

$err=””;

 if(!preg_match(‘/^[^0-9]{2,}$/’,$name)){

                 $err.=”Invlid Name<br/>”;

if($err==””){

                //you have to save complain to database first here//

                $file=fopen(“complain.csv”,”at”);

           $record=htmlentities($name).”|”.htmlentities($phone).”|”.htmlentities($email).”|”.htmlentities($complain).”|”.date(“d-m-Y”).”\n”;

                fwrite($file,$record);

                fclose($file);

echo “<div style=’color:green;’>Successfully Submitted Your Complain!</div>”;

    // header(“location:contact_ui.php?suc=$succ”);

}else{

                echo “<div style=’color:red;’>”.$err.”</div>”;

                // header(“location:index.php?id=10&err=$err”);

<fieldset style=”width:300px;; padding:1em; background-color:#828282;”>

<table width=”300px” height=”30px;” bgcolor=”#FFFFFF”><tr><td colspan=”2″ align=”center”>Please Give Your Opinion </td></tr></table>

<form action=”index.php?id=10″ method=”post”>

<table width=”200″ border=”0″ align=”center”>

<td valign=”top”>Complain</td>

<td><textarea name=”txtComplain” id=”txtComplain” cols=”25″ rows=”5″></textarea></td>

</tr>

<tr>

<td><input type=”submit” name=”btnFeedback” id=”btnFeedback” value=”Submit” /></td>

  </tr>

</table>

</form>

</fieldset>

banner.php

<img src=”images/farmer_banner.png” width=”100%” style=”margin-bottom:2px;”  />

Footer.php

<p> Coppright &copy IDB-BISEW</p>

Testing

In this section I have Produce-

  • Testing Plan;
  • Test Log Sample;
  • Analysis of Test results.

Test Plan

I have a plan for test the system properly. This plan contains four steps. They are

  • Step 1: At first I have decided what I want to see as output;
  • Step 2: To get required output, what data should be as input;
  • Step 3: Trying the input data;
  • Step 4: Check the result;
  • Step 5: Check all the input form are ok;
  • Step 6: If there is any error, I have to find out the error and should solve it.
  • Step 7: Show the testing status.

Analysis of Test Result:

  • Testing 1: Save operation of Visitor Sign_up Form
  • Given input: Any row of data from test log.
  • Required Output: The form can save data in the Database.

 sign up

Final Documentation:

Critical Appraisal:

I have developed the site for helping others. I try my best to make this site user and visitor friendly. But it has some critical limitations, which are describe in bellow:

Documentation: This documentation is very rich. So a user can’t easily understand the development of this project but not impossible.

       Testing: Testing is very expensive, so everything is not possible to test. Main part have completed to test.

Conclusion:

I have made this site, with the kindest help of our Instructor,our project co-ordinator and those person who always help me to give information about total agriculture.  I tried my best to make this site easy and user friendly. I hope that this site will provide the user best help to do their job properly. This site helps the visitor to provide their essential.

Sign_up new_mail_account