Object-Oriented -Programming In PHP For Insert ,Update ,Delete ,Display Code Guidance

COMPARISON    CODE     PRACITCE    for  BASIC   PHP  AND ADVANCE  PHP  CODEING :

first create table Example:
SQL>create table example
(id int,
name  varchar(200));

SIMPLE CONNECTIVITY CODE :
(1)write  code for simple_connect.php file:
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("mandar",$con);
if(!$con)
{
echo      “not connected ”;
}
?>




ADVANCE CONNECTIVITY CODE:

(1)write code for  advance_connect.php file:

<?php
class db
{
                var $host="localhost";
                var $user="root";
                var $password="";
                var $database="mandar";
                var   $con;

function __construct()

{
                $this->con=mysql_connect($this->host,$this->user,$this->password);
               
                if(!$this->con)
                {
                echo "not connected";
               
                }
               
                mysql_select_db($this->database,$this->con) or die(mysql_error());

}
               
}
$obj=new db();   // CONSTRUCTOR AUTOMATICLY CALLED WHEN OBJECT IS CREATED

?>



SIMPLE    INSERT    EXAMPLE:

(1)write code for simple_inset.html  file:

<form action="simple_insert.php" method="post">
Id <input type="text" name="id">
Name <input type="text" name="name">
<input type="submit" name="submit" value="insert">
(2)write code for  simple_insert.php file:

<?php
include("simple_connect.php");

$id=$_POST['id'];
$name=$_POST['name'];
$sql="insert into example(id,name)values('$id','$name')";

$result=mysql_query($sql);

if($result)
{
echo "Inserted";
}
else
{
echo "Not Inserted";
}

?>

ADVANCE INSERT EXAMPLE:

(1)write code for advance_insert.html:

<form action="advance_insert.php" method="post">
Id <input type="text" name="id">
Name <input type="text" name="name">
<input type="submit" name="submit" value="insert">


(2) write  code for   advance_insert.php  file :
<?php
include("advance_connect.php");

class  myinsert

{

function  insert()
{
$id=$_POST['id'];
$name=$_POST['name'];

$sql="insert into example(id,name)values('$id','$name')";

$result=mysql_query($sql);
if($result)
{
echo "record inserted";               
               
}
else
{
               
echo "record not inserted";       
}

}

}

$myobj=new myinsert();
$myobj->insert();

?>



SIMPLE     UPDATE EXAMPLE:

(1)write code for  simple _udate.html file:

<form action="simple_update.php" method="post">
Id <input type="text" name="id">
Name <input type="text" name="name">
<input type="submit" name="submit" value="update">
(2)write code for simple_update.php file:

<?php
$id=$_POST['id'];
$name=$_POST['name'];

include("simple_connect.php");

$sql="update example set id='$id' where name='$name'";

$result=mysql_query($sql);
if($result)
{
echo "Reccord Update Successfully";
}
else
{
echo "Not Update";
}

?>

NOW WRITE CODE FOR   ADVANCE     UPDATE EXAMPLE:

(1)write code for advance_update.html file:

<form action="advance_update.php" method="post">
Id <input type="text" name="id">
Name <input type="text" name="name">
<input type="submit" name="submit" value="update">
(2)write   code   for advance_update.php file:

<?php
include(advance_connect.php);

class updateclass
{
function update()

{
$id=$_POST['id'];
$name=$_POST['name'];

$sql="update example set id='$id' where name='$name'";

}
}

$obj=new updateclass();
$obj->update();

?>



SIMPLE   DELETE  EXAMPLE:

(1)write code for simple_delete.html file:

<form action="simple_delete.php" method="post">
Id <input type="text" name="id">
<input type="submit" name="submit" value="submit">



(2)write   code   for   simple_delete.php      file:
<?php

$id=$_POST['id'];

include("simple_connect.php");

$sql="delete from example where id='$id'";

$result=mysql_query($sql) or die(mysql_error());

if($result)
{
echo "deleted";
}
else
{
echo "not deleted";
}

?>

ADVANCE  DELETE  EXAMPLE :

(1)write code for  advance _delete.html  file:

<form action="advance_delete.php" method="post">
Id <input type="text" name="id">
<input type="submit" name="submit" value="submit">
(2) write   code   for  advance_delete.php     file :

<?php

include('advance_connect.php');

class  deleteclass
{
function delete()
{
$id=$_POST['id'];

$sql="delete from example where id='$id'";



$result=mysql_query($sql);
if ($result)
{
echo "deleted";
}
else
{
echo "not deleted";
}
}
}

$obj=new  deleteclass();
$obj->delete();
?>

NOW  SIMPLE  DISPLAY EXAMPLE :

(1)write code  simple_display.php  file :

<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("mandar",$con);

$sql="select *from example";

$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
echo $row['id']." ";
echo $row['name']." ";
echo '<br>';
}

?>
ADVANCE   DISPLAY   EXAMPLE  :

(2)write    code for  advance _display.php file :

<?php
include('advance_connect.php');

class displayclass
{
function display()
{
$sql="select *from example";

$result=mysql_query($sql) or die(mysql_error());

while($row=mysql_fetch_array($result))
{
echo $row['id']." ";
echo $row['name']." ";
echo '<br>';
}
}
}
$obj=new displayclass();
$obj->display();

?>


SIMPLE  SEARCH EXAMPLE :

(1)write code for simple_search.html file:

<form action="simple_search.php" method="post">
Name <input type="text" name="name">
<input type="submit" name="submit" value="search">

(2)write   code for simple_search.php file:

<?php
$name=$_POST['name'];
$con=mysql_connect("localhost","root","");
mysql_select_db("mandar",$con);

$sql="select *from example where name='$name'";

$result=mysql_query($sql)or die(mysql_error());
$num=mysql_num_rows($result);
if($num>0)
{
while($row=mysql_fetch_array($result))
{
echo $row['id']." ";
echo $row['name']." ";
echo '<br>';
}
}
else
{
echo "no record match";

}


?>

NOW   FOR   ADVANCE SEARCH EXAMPLE:

(1)write code for advance_search.html file:

<form action="advance_search.php" method="post">
Name <input type="text" name="name">
<input type="submit" name="submit" value="search">
(2)now  write code for advance_search.php file:

<?php
include('advance_connect.php');
class searchclass
{
function search()
{
$name=$_POST['name'];
$sql="select *from example where name='$name'";

$result=mysql_query($sql) or die(mysql_error());

while($row=mysql_fetch_array($result))
{
echo $row['id']." ";
echo $row['name']." ";
echo '<br>';
}

}
}
$myobj=new searchclass();
$myobj->search();
?>

Comments

Post a Comment

Popular posts from this blog

Query to get concurrent Program details with Parameter list and value set attached to parameter.

Image
Query : SELECT fcpt.user_concurrent_program_name,   fcp.concurrent_program_name,   fcp.concurrent_program_id,   fav.application_short_name,   fav.application_name,   fav.application_id,   fdfcuv.column_seq_num,   fdfcuv.end_user_column_name,   fdfcuv.form_left_prompt prompt,   ffvs.flex_value_set_name,   fdfcuv.enabled_flag,   fdfcuv.required_flag,   fdfcuv.display_flag FROM apps.fnd_concurrent_programs fcp,   apps.fnd_concurrent_programs_tl fcpt,   apps.fnd_descr_flex_col_usage_vl fdfcuv,   apps.fnd_application_vl fav,   apps.fnd_flex_value_sets ffvs WHERE fcp.concurrent_program_id       = fcpt.concurrent_program_id AND fav.application_id                = fcp.application_id AND fcpt.language                     = 'US' AND ffvs.flex_value_set_id           ...
Read more

AR and OM link in oracle apps / AR transaction and Sales Order join query

SELECT rcta.customer_trx_id, rcta.trx_number, rcta.trx_date, ac.customer_name, rctla.line_number inv_line_number, rctla.unit_selling_price inv_unit_selling_price, ooha.header_id, ooha.order_number, oola.line_number so_line_number, oola.line_id, oola.ordered_item, oola.ordered_quantity * oola.unit_selling_price so_amount FROM apps.ra_customer_trx_all rcta, apps.ra_customer_trx_lines_all rctla, apps.ar_customers ac, apps.oe_order_headers_all ooha, apps.oe_order_lines_all oola WHERE 1 = 1 AND rcta.customer_trx_id = rctla.customer_trx_id AND rcta.bill_to_customer_id = ac.customer_id AND ooha.header_id = oola.header_id AND rctla.interface_line_attribute6 = TO_CHAR(oola.line_id) AND rctla.interface_line_attribute1 = TO_CHAR(ooha.order_number) AND rcta.trx_number = nvl(:p_trx_number,rcta.trx_number) AND ooha.order_number = nvl(:p_order_number,ooha.order_number);
Read more

Japan Style: Architecture Interiors Design

Image
Enter the world of the stylish Japanese house, where every object in sight is a work of art. Japan Style introduces 20 special residences. With more than 200 color photographs, this book showcases the stunning beauty of old homes, and reveals how they are cared for by their owners. Traditional Japanese homes, with superbly crafted fine wood, great workmanship and seasonal interior arrangements, have an aesthetic of infinite simplicity. Unlike Japanese inns and historical buildings, the houses featured in this book are private property and are not open to public viewing. Japan Style offers a rare glimpse into the intimate world of the everyday Japanese and fascinating insight into the traditional architecture of Japan download link http://libgen.io/_ads/E7F3D5D3E376CB1E116D00AFC8E89AC4 .
Read more