www.webdeveloper.com
Results 1 to 3 of 3

Thread: Unable to fetch data from textfield

  1. #1
    Join Date
    May 2013
    Posts
    3

    Question Unable to fetch data from textfield

    Hello ,

    I have to files
    Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>index page</title>
    </head>
    
    <body>
    
    <form method="post" action="billing.php">
    
    <div id="wrapper">
    	<div class="data">
        	<div class="label">
            Society
            </div>
            <div class="textfield">
            <input type="text" name="society"  />
            </div>
        
        	<div class="label">
            Customer id
            </div>
            <div class="textfield">
            <input type="text" name="customer_id"  />
            </div>
            
            <div class="label">
            Customer name
            </div>
            <div class="textfield">
            <input type="text" name="customer_name"  />
            </div>
            
            <div class="label">
           	Wing
            </div>
            <div class="textfield">
            <input type="text" name="wing"  />
            </div>
            
            <div class="label">
            Flat no
            </div>
            <div class="textfield">
            <input type="text" name="flat_no"  />
            </div>
            
            <div class="label">
            Previous reading
            </div>
            <div class="textfield">
            <input type="text" name="previous_reading"  />
            </div>
            
            <div class="label">
            Previous date
            </div>
            <div class="textfield">
            <input type="text" name="previous_date"  />
            </div>
            
            <div class="label">
            Current reading
            </div>
            <div class="textfield">
    		<input type="text" name="current_reading"  />       
            </div>
            
            <div class="label">
            Current date
            </div>
            <div class="textfield">
            <input type="text" name="current_date"  />
            </div>
            
            
        </div>
        
        <input type="submit" name="submit" value="submit"  />
    </div>
    </form>
    
    </body>
    </html>
    and second file
    Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Billing</title>
    </head>
    
    <body>
    <?php
    include "connect.php";
    ?>
    
    <?php
    	
    	$society=$_POST['society'];
    	$id=$_POST['customer_id'];
    	$name=$_POST['customer_name'];
    	
    	$wing=$_POST['wing'];
    	$flat_no=$_POST['flat_no'];
    	
    	$previous_reading=$_POST['previous_reading'];
    	$previous_date=$_POST['previous_date'];
    	
    	$current_date=$_POST['current_date'];
    	$current_reading=$_POST['current_reading'];
    
    	if($current_reading=" ")
    	{
    		echo "current date:".$current_date."<br><br>";
    	}
    
    	else
    	{
    		echo "current reading:".$current_reading."<br><br>";
    		echo "previous reading:".$previous_reading."<br><br>";
    		
    		$units=($current_reading-$previous_reading);
    		echo "units".$units."<br><Br>";
    		
    		$rate= mysql_query("select per_unit_rate from charges where society=".$society);
    		
    		$amount = $units * $rate;
    		
    		$service_charge=mysql_query("select service_charge from charges where society=".$society);
    		
    		$net_bill=$amount+$service_charge;
    		
    		echo "The amount of net bill is:".$net_bill;
    		
    		mysql_query("insert into report values ('$id', '$current_date', '$net_bill','$units')");
    	}
    ?>
    
    
    <?php
    include "connect.php";
    ?>
    
    </body>
    </html>
    I a not been able to fetch data from "current_reading" text field. (bold and red) Each and every other field is working fine. What can be the error.
    Last edited by NogDog; 05-21-2013 at 10:42 PM. Reason: added [code] tags around code

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,312
    Welcome to the forums. In the future, you can help us to help you by making use of the forum's [code], [php], and [html] bbcode tags around your code snippets. (I added some [code] tags for you, as that's the only one of the three that works with text formatting inside of it.)

    Anyway, I suspect your current problem is this line:
    PHP Code:
    if($current_reading=" "
    You are assigning a value instead of comparing if they are equal, which would be:
    PHP Code:
    if($current_reading == " "
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    May 2013
    Posts
    3
    Thank you very much for the help and I apologize for not using bbbcode tags.

    Your answer worked very fine.

    Thank you again.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles