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>

HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.
Detailed Error Information 

Module
 IIS Web Core

Notification
 MapRequestHandler

Handler
 ASPClassic

Error Code
 0x80070002

Requested URL
 <a href="http://<redacted>/default.asp">http://<redacted>/default.asp</a>

Physical Path
 C:\inetpub\wwwroot\<redacted>\default.asp

Logon Method
 Anonymous

Logon User
 Anonymous