PHP, JS, Ajax දන්න අයගෙන් උදව්වක් ඕනේ

geeko · Aug 17, 2021

HTML Form එකක Select box එකකින් select කරන value එකක් (Form එක Submit කරන්න කලින් Onchange) javascript function එකක් හරහා MySQL Query එකකකට යවන්නෙ කොහොමද. Ajax වලින් Try කලා Success Alert එක එනවා එත් value එක PHP කෝඩ් එකට Pass වෙන්නේ නෑ. මේක වෙන්න ඕනේ එකම ෆයිල් එකක.

HTML FORM PART


<select name="brand" id="brand" onChange="make()" required>

JS AND AJAX PART


<script>
function make() {
  var x = document.getElementById("brand").value;
 $.ajax({          
            url: "cardetails.php",
            type: "POST",
            data: {x:x},
            success: function(response){
                alert("success");
            },
            error: function (xhr, ajaxOptions, thrownError) {
               alert("fail");
            }
        });
}
</script>

PHP MySQL PART



<?php

$br =$_POST['x'];
echo $br;

$sql="select * from model where s_name = '$br' ";

?>

delmar · Aug 17, 2021

HTML form eke thyana data kelinma PHP haraha MySQL database ekakata yawanna puluwan bro.
Javascript use karanne form eka validate karanna witharai.

geeko · Aug 17, 2021

delmar said:
HTML form eke thyana data kelinma PHP haraha MySQL database ekakata yawanna puluwan bro.
Javascript use karanne form eka validate karanna witharai.

Form එක Submit කරන්නේ නෑ මචන් Selectbox එකේ Option එකක් select කරපු ගමන් (OnChange) ඒ Value එක Mysql Query එකට යන්න ඕනේ

delmar · Aug 17, 2021

geeko said:
Form එක Submit කරන්නේ නෑ මචන් Selectbox එකේ Option එකක් select කරපු ගමන් (OnChange) ඒ Value එක Mysql Query එකට යන්න ඕනේ

ah ela.
form.html

HTML:

<form>
           <select name="brand" id="brand" onChange="make()" required>
           <div id="results"></div>
</form>

<script>
  function make() {
          jQuery.ajax({
          url: "query.php",
          data:'brand='+$("#brand").val(),
          type: "POST",
          success:function(data){
          $("#results").html(data);
          },
          error:function (){}
          });


      }


  </script>

query.php
meke POST method eken form data call kara database eka update karanna.
ekatath code eka onenam kiyanna

Mr.Sawyer · Aug 17, 2021

Ajax request 1k vidihata adala php file 1a serve karanna dapan, request karaddi select wechcha eke value 1th ajax request 1a karapan.

geeko · Aug 17, 2021

delmar said:

ah ela.
form.html

HTML:

<form>
           <select name="brand" id="brand" onChange="make()" required>
           <div id="results"></div>
</form>

<script>
  function make() {
          jQuery.ajax({
          url: "query.php",
          data:'brand='+$("#brand").val(),
          type: "POST",
          success:function(data){
          $("#results").html(data);
          },
          error:function (){}
          });


      }


  </script>

query.php
meke POST method eken form data call kara database eka update karanna.
ekatath code eka onenam kiyanna

Meke form ekai, js ekai, php ekai 3 ma query.php kiyana ekeda thiyenne? ekama file eke venna one bro. mokada a yavana value eken mysql query ekak run karala eken ganna value ekakin a form ekema thiyena vena select box ekaka options venas karannai one

Mr.Sawyer said:
Ajax request 1k vidihata adala php file 1a serve karanna dapan, request karaddi select wechcha eke value 1th ajax request 1a karapan.

sample code ekak evanna puluwanda
------ Post added on Aug 17, 2021 at 11:13 AM

delmar · Aug 17, 2021

geeko said:
Meke form ekai, js ekai, php ekai 3 ma query.php kiyana ekeda thiyenne? ekama file eke venna one bro. mokada a yavana value eken mysql query ekak run karala eken ganna value ekakin a form ekema thiyena vena select box ekaka options venas karannai one

html form ekai script ekai eka page eke thiyenna one.
form ekai script ekai thiyana page eke <head></head> tags athulata me code eka daanna.
Meken wenne jquery library eka import wenawa page ekata. meka aniwa one script eka run wenna.
wena js files thiyanawanam ewata udin daanna

HTML:

<script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>

php eka wena page ekakata daanna.
habai e daana page eka script eke wenas karanna one.
script eke url: "query.php" kiyala refer karala thiyenne e page eka.

mulu page ekama dammanam thamai machan mata hari idea ekak ganna puluwan wenne

geeko · Aug 17, 2021

delmar said:
php eka wena page ekakata daanna.
habai e daana page eka script eke wenas karanna one.
script eke url: "query.php" kiyala refer karala thiyenne e page eka.

hari machan. ethakota query.php kiyana php file eken apahu html form eka thiyena file ekata a value eka pass karanne kohomada

Sonique · Aug 17, 2021

php danne na. Man nan karanne wena page ekata ajax walin data yawala eke query karala json haraha data set eka genna ganna eka original page ekata

Lakshan-Seram · Aug 17, 2021

HTML:

<select name="brand" id="brand" onChange="make(this)" required>

JavaScript:

<script>
function make(el) {
var x = el.value;
$.ajax({
url: "cardetails.php",
type: "POST",
data: {x:x},
dataType : 'html', // Whatever your data type eg: json
success: function(response){
alert(response);
},
error: function (xhr, ajaxOptions, thrownError) {
alert("fail");
}
});
}
</script>

PHP:

<?php
$br =@$_REQUEST['x'];
die( $br );
//$sql="select * from model where s_name = '$br' ";
?>

geeko said:
hari machan. ethakota query.php kiyana php file eken apahu html form eka thiyena file ekata a value eka pass karanne kohomada

JavaScript:

success: function(response){
alert(response);
},

response variable eke thama data tiyenne.

json encode karala ganna array ekak.

ethakota response.message, response.data wage data godak ganna puluwan.
------ Post added on Aug 17, 2021 at 11:40 AM

lkzombie · Aug 17, 2021

php coding waradi
me example eka balanna

PHP:

if($_POST)
{
    if(!isset($_POST['brand'])) exit();
    $brand         = $_POST['brand'];
 
    header("HTTP/1.1 200 Request Accepted");
    echo($brand);
}
else
{
    header("HTTP/1.1 403 Access Denied");
}

HTML element eke ma onchange event eka liyanna ona na

JavaScript:

// OPEN MEMBERS
    $("#brand").on('change', function(e) {
        var tbrand = this.value;
        jQuery.ajax({
            type: "POST",
            url: '',
            dataType: 'json',
            data: {brand: tbrand }
           
        }).done(function(response){
          /*
            $('input[name="FF_COMPANYNAME"]').val(response[0].member_name);
            $('input[name="FF_REGISTRATION_NO"]').val(response[0].member_registration_id);
            $('input[name="FF_REGISTRATION_DATE"]').val(response[0].member_registration_date);
         */
                                   
        });
    });

Lakshan-Seram · Aug 17, 2021

JavaScript:

$.ajax( {
            url: stGlobals.ajaxUrl,
            type: 'POST',
            dataType: 'json',
            data: $( this ).serialize(),
            success: function( result ) {
                
                /** Returned data */
                var success = result.success;
                var message = result.message;
                var html = result.html;
}
});

PHP:

$json = json_encode ( array (
        'success' => $success,
        'message' => $message,
        'html' => $html
    ) );
    die( $json );

geeko · Aug 17, 2021

lkzombie said:

php coding waradi
me example eka balanna

PHP:

if($_POST)
{
    if(!isset($_POST['brand'])) exit();
    $brand         = $_POST['brand'];
 
    header("HTTP/1.1 200 Request Accepted");
    echo($brand);
}
else
{
    header("HTTP/1.1 403 Access Denied");
}

HTML element eke ma onchange event eka liyanna ona na

JavaScript:

// OPEN MEMBERS
    $("#brand").on('change', function(e) {
        var tbrand = this.value;
        jQuery.ajax({
            type: "POST",
            url: '',
            dataType: 'json',
            data: {brand: tbrand }
         
        }).done(function(response){
          /*
            $('input[name="FF_COMPANYNAME"]').val(response[0].member_name);
            $('input[name="FF_REGISTRATION_NO"]').val(response[0].member_registration_id);
            $('input[name="FF_REGISTRATION_DATE"]').val(response[0].member_registration_date);
         */
                                 
        });
    });

meka karanna ba machan. mokada me javascript eken ganna value eken mysql query ekak run karanna one (WHERE ekata dala) ita passe a ena value ekenuth thawa mysql query ekak run karanna one. javascript value eka php variable ekak widihata gannama one eka karanna

undefined · Aug 17, 2021

MEKE post ekak danawata wada google karana eka lesi ne oi..

geeko · Aug 17, 2021

Sonique said:
php danne na. Man nan karanne wena page ekata ajax walin data yawala eke query karala json haraha data set eka genna ganna eka original page ekata

ppodi example ekak danna puluwanda

undefined said:
MEKE post ekak danawata wada google karana eka lesi ne oi..

davas ganak google kala eka eka widihata solution ekak na bro. kiyala thiyena eka widihakwath hariyanne na
------ Post added on Aug 17, 2021 at 12:13 PM

lkzombie · Aug 17, 2021

geeko said:
meka karanna ba machan. mokada me javascript eken ganna value eken mysql query ekak run karanna one (WHERE ekata dala) ita passe a ena value ekenuth thawa mysql query ekak run karanna one. javascript value eka php variable ekak widihata gannama one eka karanna

oke php variable ekata oyage walue eka aran thiyenne ($brand). ethanin ehata liyagena yanna thiyenne.

mama class use karala liyapu project ekaka podi code kallak

PHP:

try
{
    $classDB        = new cls_database();
    $db             = $classDB->_connect();
    $cnn            = null;
          
    $cnn = $db->prepare("CALL sp_members(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,1);");
    $cnn->execute(array("LIST", $this->member_id,$this->member_name,$this->member_registration_id, $this->member_registration_date, $this->member_attachments, $this->member_membership_type, $this->member_list_on_web, $this->member_nature,$this->member_address,$this->member_city,$this->member_country,$this->member_email,$this->member_telephone,$this->member_fax,$this->member_web,$this->member_password));
                        
    $records = $cnn->fetchAll(PDO::FETCH_ASSOC);
            
    return $records;
}
catch(exception $ex)
{
    $this->error = $ex;
    return false;
}

MachoMan · Aug 17, 2021

Sonique said:
php danne na. Man nan karanne wena page ekata ajax walin data yawala eke query karala json haraha data set eka genna ganna eka original page ekata

I use this too

geeko · Aug 17, 2021

delmar said:

ah ela.
form.html

HTML:

<form>
           <select name="brand" id="brand" onChange="make()" required>
           <div id="results"></div>
</form>

<script>
  function make() {
          jQuery.ajax({
          url: "query.php",
          data:'brand='+$("#brand").val(),
          type: "POST",
          success:function(data){
          $("#results").html(data);
          },
          error:function (){}
          });


      }


  </script>

query.php
meke POST method eken form data call kara database eka update karanna.
ekatath code eka onenam kiyanna

a code ekath evannako balanna

lkzombie said:
oke php variable ekata oyage walue eka aran thiyenne ($brand). ethanin ehata liyagena yanna thiyenne.

a php code eka dammama ethanin ehata page eka pennanne na bro. blank venawa
------ Post added on Aug 17, 2021 at 12:16 PM

MachoMan said:
I use this too

example code please
------ Post added on Aug 17, 2021 at 12:18 PM

lkzombie · Aug 17, 2021

data php file ekata post wenawada?

MachoMan · Aug 17, 2021

On change,
Grab the parameters and make the ajax call
Sent it to differnt page on ajax call, run the mysql query and get the data on JSON
Pass it to main page.
Grab date from JSON
Dispaly hidden div with query data...

Try this, hope this work..

PHP, JS, Ajax දන්න අයගෙන් උදව්වක් ඕනේ

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Similar threads