User Profile

Collapse

Profile Sidebar

Collapse
bytM3
bytM3
Last Activity: Nov 29 '21, 12:50 AM
Joined: May 3 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bytM3
    started a topic mysqli prepared update
    in Software Development

    mysqli prepared update


    hi, new to this. Will someone tell me why this doesn't update?

    Code:
    <?php
// Include config file
include 'getprerentdb.php';

$amtdue = 0.00;  // ****************************************
$duedate='duedate';
$prevbal=0.00;
$latechg=0.00;
$secdep=0.00;
$damage=0.00;
$courtcost=0.00;
$nsf=0.00;
$paidsum=0.00;
$id="id";
    ...
    See more | Go to post
    • bytM3
      started a topic add 1 month to date
      in General

      add 1 month to date

      ok guys, another learning experience....I want to add 1 month to a duedate and update. How to include:

      (SET duedate = DATE_ADD(duedat e, INTERVAL 1 month )

      into this:

      $sql = "UPDATE payfile SET
      amtpaid=?, duedate=?, prevbal=?, latechg=?, secdep=?, damage=?, courtcost=?, nsf=?, hudpay=?, datepaid=?, paidsum=?
      WHERE id=?"; ...
      See more | Go to post
      • bytM3
        started a topic defining variables as numeric
        in General

        defining variables as numeric

        Hi guys,
        I enter my HTML form:
        record a payment
        Unit: apt1 Amt paid: 530.00 Hudpay: 0.00 Date paid: - yyyy-mm-dd: 2021-07-10
        ---------------------------------------------------------------------------------
        and get this result:
        receipt # is 0
        For:
        tenant paying: apt1 - Amount paid: 530.00 - Date paid: 2021-07-10 - Amount due: 530
        -----------------------------------------------------------------------------------...
        See more | Go to post
        • bytM3
          started a topic (t_constant_encapsed_string)
          in General

          (t_constant_encapsed_string)

          Hi itsme again. I have this prob I can't get past. This is a program to pay a fee and print a receipt.
          I enter the unit and payment into a form and get the message:
          Parse error: syntax error, unexpected ''; ' (T_CONSTANT_ENC APSED_STRING) on line 62.
          Please advise. Thanks!
          Code:
          <!DOCTYPE html><html>
<body><center>
<img src="apt-pic.jpg" alt="apartment" height=75 width=200><br>
          ...
          See more | Go to post
          • bytM3
            started a topic How to redirect
            in General

            How to redirect

            Will you tell what I'm doing wrong. It goes straight to "expiredpage.ht ml" even though the value
            of "expiry" is more than 0. I keep studying redirection and variable definition but nothing works. It does
            update.
            Code:
            <?php
$link = mysqli_connect("localhost", "root", "", "prerentdb"); 
// Check connection
if($link === false){ die("ERROR: Could
            ...
            See more | Go to post
            • bytM3
              started a topic redirect to receipt with variables
              in General

              redirect to receipt with variables

              I make a payment using form. I then want(I think) to redirect to receipt with variables, tenant, rentpaid and
              rentdue to show on receipt. Suggestions please. this is offline application.
              Here are codes, payments.html, payments.php and rentreceipt.php :

              Code:
              <!DOCTYPE html><html lang="en">
    <head>
    </head>
    <body bgcolor="#ccffff"><center>
              ...
              See more | Go to post
              Last edited by Niheel; May 17 '21, 07:42 AM.
              No activity results to display
              Show More
              Working...