PHP danna aya podakata awanan

A.L.I.E.N

Well-known member
  • Dec 9, 2018
    558
    537
    93
    8
    Andromeda I
    Code:
    if (isset($_POST['find'])){
            
            include_once 'dbh.inc.php';
    
            $m_id = mysqli_real_escape_string($conn, $_POST['m_id']);
    
                    $sql = "SELECT m_name, m_address, m_pnumber, m_date FROM members WHERE m_id='$m_id'";
                    $result = mysqli_query($conn, $sql);
                    
                    if(mysqli_num_rows($result)<0){
    
                        while($row = mysqli_fetch_array($result))
                        {
                            $m_name = $row('m_name');
                            $m_address = $row('m_address');
                            $m_pnumber = $row('m_pnumber');
                            $m_date = $row('m_date'); 
                        }
    
                        echo($m_name);
                        echo($m_address);
                        echo($m_pnumber);
                        echo($m_date);
    
                    }
                
                
        }

    meka view karanna luwe data
    view wena na ne hathwalame
     

    thilaapiya

    Well-known member
  • Oct 16, 2015
    1,062
    287
    83
    Code:
    if (isset($_POST['find'])){
            
            include_once 'dbh.inc.php';
    
            $m_id = mysqli_real_escape_string($conn, $_POST['m_id']);
    
                    $sql = "SELECT m_name, m_address, m_pnumber, m_date FROM members WHERE m_id='$m_id'";
                    $result = mysqli_query($conn, $sql);
                    
                    if(mysqli_num_rows($result)<0){
    
                        while($row = mysqli_fetch_array($result))
                        {
                            $m_name = $row('m_name');
                            $m_address = $row('m_address');
                            $m_pnumber = $row('m_pnumber');
                            $m_date = $row('m_date'); 
                        }
    
                        echo($m_name);
                        echo($m_address);
                        echo($m_pnumber);
                        echo($m_date);
    
                    }
                
                
        }

    meka view karanna luwe data
    view wena na ne hathwalame

    oya where clause eka my sql wala run karala balapan issella ekata data enawada kiyala
     

    SagaxConatusV

    Well-known member
  • Oct 1, 2014
    1,264
    208
    63
    Gedara
    if(mysqli_num_rows($result)<0){

    oya comparison sign eka anik pattata gahanna meheme >

    tawa oya where clause eke variable name eken single quotes einkaralath balanna. single quote atule variable eka evaluate wenne ne ne. (escape karanna awashya da manda meke tikak sure ne)
     
    Last edited: