Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    TBL - Nama - Program: HTML Head Script Type Getxmlhttpobject XMLHTTP Null

    Uploaded by

    Ardie Gucci
    This document describes how to create a dropdown menu populated from a database that displays the cost of selected items in a text box using AJAX. It includes the database structure, JavaScript code to make an AJAX call on change of the dropdown, PHP code to populate the dropdown from the database and retrieve the cost on change, and an explanation of how the components work together. When an item is selected from the dropdown, the id is passed via AJAX to a PHP file that queries the database for the corresponding cost and displays it in the text box.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    TBL - Nama - Program: HTML Head Script Type Getxmlhttpobject XMLHTTP Null

    Uploaded by

    Ardie Gucci
    18 views3 pages
    This document describes how to create a dropdown menu populated from a database that displays the cost of selected items in a text box using AJAX. It includes the database structure, JavaScript code to make an AJAX call on change of the dropdown, PHP code to populate the dropdown from the database and retrieve the cost on change, and an explanation of how the components work together. When an item is selected from the dropdown, the id is passed via AJAX to a PHP file that queries the database for the corresponding cost and displays it in the text box.

    Original Description:

    PHP

    Original Title

    Combo Autocomplete

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes how to create a dropdown menu populated from a database that displays the cost of selected items in a text box using AJAX. It includes the database structure, JavaScript code to make an AJAX call on change of the dropdown, PHP code to populate the dropdown from the database and retrieve the cost on change, and an explanation of how the components work together. When an item is selected from the dropdown, the id is passed via AJAX to a PHP file that queries the database for the corresponding cost and displays it in the text box.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    18 views3 pages

    TBL - Nama - Program: HTML Head Script Type Getxmlhttpobject XMLHTTP Null

    Uploaded by

    Ardie Gucci
    This document describes how to create a dropdown menu populated from a database that displays the cost of selected items in a text box using AJAX. It includes the database structure, JavaScript code to make an AJAX call on change of the dropdown, PHP code to populate the dropdown from the database and retrieve the cost on change, and an explanation of how the components work together. When an item is selected from the dropdown, the id is passed via AJAX to a PHP file that queries the database for the corresponding cost and displays it in the text box.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Jadi kasusnya gini,

    Ada 1 buah combobox dan 1 buah textbox


    Combobox digunakan untuk memilih program
    dan textbox digunakan untuk menampilkan biaya dari program yang dipilih pada combobox.

    struktur databasenya seperti ini :


    tbl_nama_program
    - id_nama_program,
    - nama_nama_program
    - biaya_nama_program
    - status_nama_program

    <html>
    <head>
    <script type="text/javascript">
    function GetXmlHttpObject()
    {
    var xmlHttp=null;
    try
    {
    xmlHttp=new XMLHttpRequest();
    }
    catch (e)
    {
    try
    {
    xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
    }
    catch (e)
    {
    xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
    }
    }
    return xmlHttp;
    }

    function kirim(id)
    {
    var xmlHttp=GetXmlHttpObject()
    var url="proses.php";
    url1=url+"?id="+id;
    xmlHttp.onreadystatechange=result;
    function result()
    {
    if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
    {
    document.getElementById("biaya").innerHTML=xmlHttp.responseText;
    }
    else
    {
    alert("Problem retrieving data:" + xmlhttp.statusText);
    }
    }
    xmlHttp.open("GET",url1,true);
    xmlHttp.send(null);
    }
    </script>
    </head>
    <body>

    <select OnChange="kirim(this.value)">
    <?php
    echo "<OPTION>Pilih Porgram";
    $conn = mysql_connect("localhost:3306","root","");
    $sukses = mysql_select_db("namadatabasenya", $conn);
    $sql = "SELECT * FROM tbl_nama_program WHERE status_nama_program='1'";
    $query = mysql_query($sql,$conn);
    while($data = mysql_fetch_array($query))
    {
    echo "<OPTION VALUE=$data[id_nama_program]>$data[nama_nama_program]</OPTION>";
    }
    ?>
    </select>

    <div id="biaya">
    </div>
    </body>
    </html>

    file proses.php
    PHP Code:
    <?php
    $conn = mysql_connect("localhost:3306","root","");
    $sukses = mysql_select_db("namadatabasenya", $conn);
    $id_program =$_GET['id'];
    $sql = "SELECT biaya_nama_program FROM tbl_nama_program WHERE id_nama_program = '$id_program' AND sta
    tus_nama_program='1'";
    $query = mysql_query($sql,$conn);
    $data = mysql_fetch_array($query);
    echo "<input type=text value=$data[biaya_nama_program]>";
    ?>

    You might also like