Web Development

    <?php
echo "<center>";echo date('m/d/y');echo "</center>";
$id="''";
 $periodic = '';
 $duedate = '';
$con=mysqli_connect("localhost","user","passwd","mydb");
// ============== check connectiont
    if(mysqli_errno($con))
    {echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
    {echo "connected to database</br>";}
 
 // -----------------------------------------  
    $fetch="SELECT 
acctno, recur, pd, payrec, bname, duedate, datepaid, purpose, amtdue 
FROM testbl 
WHERE recur = 'Y' AND payrec = 'P'";
    $result = mysqli_query($con,$fetch);
    if(!$result)
    {echo "Error:".(mysqli_error($con));}
else
    {echo "database table selected</br>";}

// ----------------------------------------

   // output data of each row
   while($data=mysqli_fetch_row($result))
   {

// ----------------------------------------
          if($periodic == 1)
           { $duedate = date('Y-m-d', strtotime('+4 week')) ."\n"; }
           if($periodic == 6)
           { $duedate = date('Y-m-d', strtotime('+25 week')) ."\n"; }
        $pd = 'P'; $dayslate = 0; 
   
// -------------------------------------------------
         $sql = "UPDATE testbl SET
         duedate = $duedate,
         pd = $pd,      
         dayslate = $dayslate,              
         datepaid = NOW()
        WHERE recur = 'Y' AND payrec = 'P'";

// ------------------------------------------------
 }
header( "refresh:3;url='http://localhost/invoice/autolist.php'");
?>