Php දන්න උන් වරෙල්ලකෝ

[DeKay]

Php දන්න උන් වරෙල්ලකෝ

CREATE TABLE IF NOT EXISTS `products` (
`id` varchar(20) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
)

Menna mehema table ekak thiyanawa.

Oya table eken retrive karan product ID eka combobox ekata assign wenawa. ita passe api select karana ID ekata adala name eka pahala textbox ekata assign karanne kohomada?

(textbox ekata assign karana widiya witharai oni) combobox ekata assign wena widiya hari

 

[Chathuranga1]

js walin arake id eka txtbox eke class ekata hari id ekata hari assign krhan..harida danne na..mata theruna widihata kiwwe

 

[DeKay]

js walin arake id eka txtbox eke class ekata hari id ekata hari assign krhan..harida danne na..mata theruna widihata kiwwe

Poddak method ekak liyala pennapanko machan puluwam nam ID ekama assign karannna puluwam Js walin. but textbox eke tyanne ID ekane. mata oni e ID ekata adala name eka ganna machan

 

[hide_spider]

CREATE TABLE IF NOT EXISTS `products` (
`id` varchar(20) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
)

Menna mehema table ekak thiyanawa.

Oya table eken retrive karan product ID eka combobox ekata assign wenawa. ita passe api select karana ID ekata adala name eka pahala textbox ekata assign karanne kohomada?

(textbox ekata assign karana widiya witharai oni) combobox ekata assign wena widiya hari

මුලින් JQUERY Dagena හිටපන් ඊට පස්සේ මේ code eka try karapan


<script>
$(document).ready(function(){
$("#COMBOBOXID").on('change',function(){
var getValue=$(this).val();
$("#TEXTBOXID").val(getValue);
});

});
</script>

 

[Lakshan-Seram]

php code eka liyapan Item no eken Item name eka ganna.. itapasse php scrit eken item name eka show karanna puluwan..

itapasse ajax use karala.. php script ekata request eka yawanna.. return value eka textbox ekata assign karanna puluwan..

karaganna beri nam db ekai code ekai ewanna.

 

[DeKay]

php code eka liyapan Item no eken Item name eka ganna.. itapasse php scrit eken item name eka show karanna puluwan..

itapasse ajax use karala.. php script ekata request eka yawanna.. return value eka textbox ekata assign karanna puluwan..

karaganna beri nam db ekai code ekai ewanna.

CREATE TABLE IF NOT EXISTS `products` (
`id` varchar(20) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Onna machan table eka


INSERT INTO `products` (`id`, `name`) VALUES
('0001', 'blue pens'),
('0002', 'A3 sheets yellow'),
('0003', 'A4 sheets blue'),
('0004', 'erasers'),
('0008', 'ex_book'),
('0009', 'red pens');

menna data



$result2=mysqli_query($con,"SELECT id from products");

$option = '';
while($row = $row=mysqli_fetch_array($result2/*8mysql_fetch_assoc($get*/))
{
$option .= '<option value = "'.$row['id'].'">'.$row['id'].'</option>';
} "$row[0]";
$result3=mysqli_query($con,"SELECT name FROM products WHERE id='$option'");
$row2=mysqli_fetch_array($result3);
?>

me machan mama try karapu code eka. combobox ekata ID assign wenawa DB eken. dan e id eke name eka textbox ekata assign wenna oni.

puluwam nam loku udawwak machan

 

[kolavari]

php code eka liyapan Item no eken Item name eka ganna.. itapasse php scrit eken item name eka show karanna puluwan..

itapasse ajax use karala.. php script ekata request eka yawanna.. return value eka textbox ekata assign karanna puluwan..

karaganna beri nam db ekai code ekai ewanna.

Ekin ekata ajax yawana eka efficient madi ban.

 

[Chathuranga1]

CREATE TABLE IF NOT EXISTS `products` (
`id` varchar(20) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Onna machan table eka


INSERT INTO `products` (`id`, `name`) VALUES
('0001', 'blue pens'),
('0002', 'A3 sheets yellow'),
('0003', 'A4 sheets blue'),
('0004', 'erasers'),
('0008', 'ex_book'),
('0009', 'red pens');

menna data



$result2=mysqli_query($con,"SELECT id from products");

$option = '';
while($row = $row=mysqli_fetch_array($result2/*8mysql_fetch_assoc($get*/))
{
$option .= '<option value = "'.$row['id'].'">'.$row['id'].'</option>';
} "$row[0]";
$result3=mysqli_query($con,"SELECT name FROM products WHERE id='$option'");
$row2=mysqli_fetch_array($result3);
?>

me machan mama try karapu code eka. combobox ekata ID assign wenawa DB eken. dan e id eke name eka textbox ekata assign wenna oni.

puluwam nam loku udawwak machan

<input type="text" name="name" size="20" value="<?php echo "$row[name]"?>">

 

[Lakshan-Seram]

Ekin ekata ajax yawana eka efficient madi ban.

Ehenam ithin array ekaka wath load karala JS walin call karanna tama wenne.. eth ekath awl.. db eke data godak tiyenawa nam.. mata oluwata enne na meeta wada wena kramayak nam....


ela ela hoda idea ekak awa.. okkoma result json format eken retun karala parse karoth?

 

[Lakshan-Seram]

CREATE TABLE IF NOT EXISTS `products` (
`id` varchar(20) NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Onna machan table eka


INSERT INTO `products` (`id`, `name`) VALUES
('0001', 'blue pens'),
('0002', 'A3 sheets yellow'),
('0003', 'A4 sheets blue'),
('0004', 'erasers'),
('0008', 'ex_book'),
('0009', 'red pens');

menna data



$result2=mysqli_query($con,"SELECT id from products");

$option = '';
while($row = $row=mysqli_fetch_array($result2/*8mysql_fetch_assoc($get*/))
{
$option .= '<option value = "'.$row['id'].'">'.$row['id'].'</option>';
} "$row[0]";
$result3=mysqli_query($con,"SELECT name FROM products WHERE id='$option'");
$row2=mysqli_fetch_array($result3);
?>

me machan mama try karapu code eka. combobox ekata ID assign wenawa DB eken. dan e id eke name eka textbox ekata assign wenna oni.

puluwam nam loku udawwak machan

epa wenawa ne ban.. mehema code ekak uba dunnahama... ara kiyapu widihata try karapan ko..


uba product ID eka database ekata danne kohomada? auto increment da? (meka ube prashneta adala na.. eth denaganna ahanne)

 

[DeKay]

epa wenawa ne ban.. mehema code ekak uba dunnahama... ara kiyapu widihata try karapan ko..


uba product ID eka database ekata danne kohomada? auto increment da? (meka ube prashneta adala na.. eth denaganna ahanne)

manually machan.

 

[kolavari]

js walin arake id eka txtbox eke class ekata hari id ekata hari assign krhan..harida danne na..mata theruna widihata kiwwe

meka hari


dan ubata select options walata values tika daganna puluwanne...karanna one e options ekkama thawa attribute ekak gahala name ekath daganna eka

Ita passe js walin eka aran ara textbx eke value ekata set karanna thiyenne

    <select onchange="return update_textbox(this.options[this.selectedIndex].getAttribute('itemname'));" name="items"> 
        <option itemname="Item 01" value="0001">click</option>
        <option itemname="Item 02" value="0002">click</option>
    </select>

ita passe js / jquery function ekak liyanna puluwan..

function update_texbox(item_name){
    $('.item_name').val(item_name);
}

mama meka nikan me sample ekak wage damme..waradi athi idea ekak witharak ganna

 

[Lakshan-Seram]

manually machan.

ehema purudu wenna epa product id eka auto increment ekak ganna primary key.. SKU kiyala hari tawa eakak ganna..

 

[kolavari]

Ehenam ithin array ekaka wath load karala JS walin call karanna tama wenne.. eth ekath awl.. db eke data godak tiyenawa nam.. mata oluwata enne na meeta wada wena kramayak nam....


ela ela hoda idea ekak awa.. okkoma result json format eken retun karala parse karoth?

ow..godak data thibboth slow wenawa thamai.. mama nam hithanne attribute ekata gahaganna eka thamai hoda kiyala..kohomath mu ara item list eka load karanawane

 

[Lakshan-Seram]

mama meka nikan me sample ekak wage damme..waradi athi idea ekak witharak ganna

ela idea eka..

 

[Lakshan-Seram]

ow..godak data thibboth slow wenawa thamai.. mama nam hithanne attribute ekata gahaganna eka thamai hoda kiyala..kohomath mu ara item list eka load karanawane

meke nam awlak netiwei mokada ekama sereta ne raw eken data ganne joins na ne..

mage laga tibba site ekak eke category list eka witarak load wenakota fast.. but thawath list ekak load wenakota slow.. table 2,3 k join karana ewa tikak slow..

 

[ftthushara]

|| BUMP ||

 

[Lakshan-Seram]

uba meka assignment ekakata wage nam karanne.. ajax use karanawata marks denawa nam.. ajax use karapan... nettam ara widiha ubata lesi.. purpose ekata anuwa script eka liyapan.. ela.. good luck..

 

[DeKay]

ehema purudu wenna epa product id eka auto increment ekak ganna primary key.. SKU kiyala hari tawa eakak ganna..

Machan ube email address ekak diyanko dropbox share karanam codes tika. mata echchara lokuwata oni na ban. campus project ekakata.

Table eken ID eka combobox ekata assign wenawa. Then api combobox eken ID ekak select kalama ekata adaala Name eka, Textbox eke fill wenna oni,

 

[DeKay]

meka hari


dan ubata select options walata values tika daganna puluwanne...karanna one e options ekkama thawa attribute ekak gahala name ekath daganna eka

Ita passe js walin eka aran ara textbx eke value ekata set karanna thiyenne

    <select onchange="return update_textbox(this.options[this.selectedIndex].getAttribute('itemname'));" name="items"> 
        <option itemname="Item 01" value="0001">click</option>
        <option itemname="Item 02" value="0002">click</option>
    </select>

ita passe js / jquery function ekak liyanna puluwan..

function update_texbox(item_name){
    $('.item_name').val(item_name);
}

mama meka nikan me sample ekak wage damme..waradi athi idea ekak witharak ganna

Thanks machan mama try karala kiyannam