AMBUR AM40403 34
AMBUR AM90401 12
AMBUR AM70401 27
AMBUR AM40401 17
AMBUR AM70401 4
AMBUR AM70401 5

<?php
$linecount = 1;
$file_handle = fopen("input.txt", "r");
while(!feof($file_handle)) {
    $line_of_text = fgets($file_handle);
    $parts = explode(' ', trim($line_of_text)) or die ("cant divid array");

    $dbname = $parts[0];
    $GRPCODE = $parts[1];
    $TICKETNO = $parts[2];

    print "<br/>".$linecount.". DATABASE NAME: " .$dbname." GROUP CODE: ". $GRPCODE. " TICKET NO: ". $TICKETNO."<BR>";

    $db = pg_connect("host=localhost port=5432 dbname=$dbname user=postgres password=asa@123") or die("not connected");

    // fetch the data
    $rows = pg_query($db,'UPDATE TABSUBSMST SET INTIMATION='N' WHERE GRPCODE='$GRPCODE'
        AND coalesce(ticketno::numeric::text)='$ticketno'
    ') or die("problem with query") ;

    if(!$rows)
        print ("<br/>Please check! Query NOT updated! <br/>");
    else
        print ("<br/>Query updated <br/>");

    pg_close($db) or die("cant close the db");

    $linecount++;
}

fclose($file_handle);
?>