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'");
?>

   <script type = "text/javascript">

        var ddlText, ddlValue, ddl, lblMesg;

        function CacheItems() {

            ddlText = new Array();

            ddlValue = new Array();

            ddl = document.getElementById("<%=ddlItems.ClientID %>");

            lblMesg = document.getElementById("<%=lblMessage.ClientID%>");

            for (var i = 0; i < ddl.options.length; i++) {

                ddlText[ddlText.length] = ddl.options[i].text;

                ddlValue[ddlValue.length] = ddl.options[i].value;

            }

        }

        window.onload = CacheItems;



        function FilterItems(value) {

            ddl.options.length = 0;

            for (var i = 0; i < ddlText.length; i++) {

                if (ddlText[i].toLowerCase().indexOf(value) != -1) {

                    AddItem(ddlText[i], ddlValue[i]);

                }

            }

            lblMesg.innerHTML = ddl.options.length + " items found.";

            if (ddl.options.length == 0) {

                AddItem("No items found.", "");

            }

        }



        function AddItem(text, value) {

            var opt = document.createElement("option");

            opt.text = text;

            opt.value = value;

            ddl.options.add(opt);

        }

</script>

 <asp:TextBox ID="txtSearch" runat="server" 

         onkeyup = "FilterItems(this.value)"></asp:TextBox><br />

    <asp:DropDownList ID="ddlItems" runat="server" DataTextField="Description" DataValueField="NumericCode" >
      
       

    </asp:DropDownList>