Mysql database eke Data form ekak Textbox wala display karana widiya(PHP)

praveendpa

Active member
  • Jan 18, 2007
    827
    215
    43
    Mata loku udawwak one.Form ekaka 1st text box eke ona karana item code eka type karala search karama, database eke adala record eka search wela ena hati karaganna puluwan(fectch_object).

    KOHOMADA EE DATA TIKA FORM EKE TEXTBOX WALA PENNA GANNE?
    (TABLE EKAK DALA PENNA GANNA DANNAWA.)

    MATA ONE TEXTBOX WALA PENNA GANNA. UPDATE KARANNA PULUWANN WENA WIDIYATA.

    PHP5.5 Mysqli walin, karana widiya denaganna one.

    dANNA KENEK INNAWANAO KIYANNA PULUWANDA?.
    THANK YOU
     

    Lakshan-Seram

    Well-known member
  • May 31, 2011
    24,718
    12,629
    113
    127.0.0.1:8080/Kandy
    Oya wede nam PHP, AJAX thama karanna wenne theruna hetiyata.

    HTML:
    http://www.w3schools.com/php/php_ajax_database.asp

    Oka balapan mata custom code liyanna taram welawak na me week eke busy.
     

    Lakshan-Seram

    Well-known member
  • May 31, 2011
    24,718
    12,629
    113
    127.0.0.1:8080/Kandy
    DATABASE EKEN ENA DATA TEXTBOX EKAKA DISPLAY KARAGANNA ONE YALU.

    Ithin
    PHP:
    <input type="text" value="<?= $var; ?>" name="name" />
    dapan ko

    Ajax walin nam itath lesi ne.. PHP script eken JSON encode karala array ekakin values ganing.. Aye JavaScript walin decode / parse karala value eka load karapan.
     
    Last edited:

    praveendpa

    Active member
  • Jan 18, 2007
    827
    215
    43
    mama mee hoyanne project ekak karala iwarakarala danna. godak danne ne.meka weda karanne ne. poddak hadala denna puluwanda?

    <?php
    // Start the session
    session_start();
    ?>
    <html>
    <body>
    <form method="post" action="">
    <input type="text" value = "<? echo $_SESSION["name"]; ?>" >

    </form>
    <?php
    $_SESSION["name"] = "saman";

    ?>

    </body>
    </html>


    variable ekaka tiyena deyak hari, session wariyabal ekak hari text box ekaka pennaganna puluwann unoth, database eke ewa, variable ekata dala, eka textbox wala pennanna puluwan. meee da beri nisa, hirawela inne.
     

    Lakshan-Seram

    Well-known member
  • May 31, 2011
    24,718
    12,629
    113
    127.0.0.1:8080/Kandy
    mama mee hoyanne project ekak karala iwarakarala danna. godak danne ne.meka weda karanne ne. poddak hadala denna puluwanda?

    <?php
    // Start the session
    session_start();
    ?>
    <html>
    <body>
    <form method="post" action="">
    <input type="text" value = "<? echo $_SESSION["name"]; ?>" >

    </form>
    <?php
    $_SESSION["name"] = "saman";

    ?>

    </body>
    </html>


    variable ekaka tiyena deyak hari, session wariyabal ekak hari text box ekaka pennaganna puluwann unoth, database eke ewa, variable ekata dala, eka textbox wala pennanna puluwan. meee da beri nisa, hirawela inne.

    PHP:
    <input type="text" value="<?php echo $_SESSION["name"]; ?>">

    or

    PHP:
    <input type="text" value="<?= $_SESSION["name"]; ?>">
     

    praveendpa

    Active member
  • Jan 18, 2007
    827
    215
    43
    yanthan hadagaththa

    test7.php




    <?php
    // Start the session
    session_start();
    ?>

    <form method="post" action="">
    First Name:
    <input type="text" value="<?php echo $_SESSION["first_name"]; ?>"><br>
    Last Name:
    <input type="text" value="<?php echo $_SESSION["last_name"]; ?>"><br>
    Tel No:
    <input type="text" value="<?php echo $_SESSION["tel"]; ?>"><br>
    Marks:
    <input type="text" value="<?php echo $_SESSION["marks"]; ?>"><br>
    Grade :
    <input type="text" value="<?php echo $_SESSION["grade"]; ?>"><br>
    </form>

    <?php

    $db=new mysqli('localhost','root','','test2');

    $nm = "";
    if ($_SERVER["REQUEST_METHOD"] == "POST")

    {
    $nm = htmlspecialchars(trim(stripslashes($_POST["first_name"])));

    if($result=$db->query("SELECT * FROM people m INNER JOIN marks n
    ON (m.first_name = n.first_name) WHERE m.first_name='$nm'"))

    {
    if($count=$result->num_rows)
    {
    //echo '<p>',$count, '</p>';

    echo "Student Details",'<br>';

    while($row = $result->fetch_object())
    {


    $_SESSION["first_name"] = $row->first_name;
    //$lnm = $row->last_name;



    $_SESSION["last_name"] = $row->last_name;

    $_SESSION["tel"] = $row->tel;
    $_SESSION["marks"] = $row->marks;
    $_SESSION["grade"] = $row->grade;



    }
    }
    }

    include ("form3.php");


    }
    else
    {
    include ("form5.php");
    echo "please Enter Your Name";
    }




    //$nm="roshan";



    ?>

    form7.php

    <?php
    // Start the session
    session_start();
    ?>
    <form action="test7.php" method="POST">
    Name: <input type="text" name="first_name"><br>
    <input type="submit" value="Search">
    </form>

    <?php
    function test_input($data) {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
    }
    ?>