reload page with updated information

[bajer]

is there a way to change $variable in database, refresh the page and show it again?

I use below method, and once I post it goes to NEW page, and I cannot reload the main page as it is password protected..

<td class='smalltxt3' align='center'><a href='paidyesno.php?invoice=$invoice&paid=$paid'><B>$paid</B></a></form></td>

Thanks

[adi]

Could you explain more?

[bajer]

database displays all the information:

INVOICE | CLIENT | DATE | PAID?
4545454 | BOBY | 23-09-03 | NO
4545455 | BOBY | 24-09-03 | YES

now I want to be able to click on NO, and for the database to update to YES (and I have that code already), but it will load new page telling me that I have updated what I wanted.

What I want is to refresh this page and show me updated status....

I hope its more clear now

Thanks

[ofSHIZ]

You would probably be able to use some javascript to make the page refresh.. maybe the meta tags..

[bajer]

Yeah that's what I did now....

POPUP window, I guess I have no choice 🙁

Thx

[adi]

You have a table into your page who shows payment information and you want to get it to change the payment state into the database from "not payed" to "payed"
when you click on the "NO".
If this is your problem then use this code:

<?php
include("conect.php");
if (isset($_GET['invoice'])) 
{
mysql_query("UPDATE payments SET payed='yes' WHERE invoice='".$_GET['invoice']."'" );
$result1=mysql_query("SELECT * FROM payments ");
print'<table border="1">';
print'<tr><td>Invoice</td><td>Client</td><td>Date</td><td>Payed</td></tr>';

while ($row=mysql_fetch_array($result1))
{
print'<tr><td>';
print ''.$row['invoice'].'' ;
print'</td><td>';
print''.$row['client'].'';
print'</td><td>';
print''.$row['date'].'';
print'</td><td>';
if (''.$row['payed'].'' ==no)
 {
print '<a href="payments.php?invoice='.$row['invoice'].'" >'.$row['payed'].'</a>';
print'</td></tr>';
 }
  else
  {
   print'yes';
   print'</td></tr>';
  }
print'</td></tr>';
}
print'</table>';
print "Invoice  ".$_GET['invoice']."  payed!"   ;
}
else
{
$result=mysql_query("SELECT * FROM payments ");
print'<table border="1">';
print'<tr><td>Invoice</td><td>Client</td><td>Date</td><td>Payed</td></tr>';
while ($row=mysql_fetch_array($result))
{
print'<tr><td>';
print ''.$row['invoice'].'' ;
print'</td><td>';
print''.$row['client'].'';
print'</td><td>';
print''.$row['date'].'';
print'</td><td>';
if (''.$row['payed'].'' ==no)
 {
print '<a href="payments.php?invoice='.$row['invoice'].'" >'.$row['payed'].'</a>';
print'</td></tr>';
 }
  else
  {
   print'yes';
   print'</td></tr>';
  }
}
 print'</table>';
}
?>

Let me know if this is what you need.
Adi

[bajer]

Thanks ADI

This probably works for single Invoice; you think its possible to do it with multiple?

I will show you my code; I tried putting your code into it; but I get an error:
Parse error: parse error, unexpected T_ELSE in /home/blah/pg.php on line 102

Perhaps I could improve the code, but I am slowly getting there...
I used JAVA to make the change, no I switched to your idea...perhaps you could tell me what could be wrong...thx

<?php
$name = $_POST['name'];
$password = $_POST['password'];
$e_name = md5($name);
$e_password = md5($passwordnew);

include 'config.inc.php';

$check = mysql_query("SELECT * FROM pass1234 WHERE username='$e_name' AND password='$e_password'");
$rows = mysql_num_rows($check);

if ($rows==0) {

print "Sorry you cannot ACCESS this page!";

} else {

if (isset($_GET['invoice']))  

{ 
mysql_query("UPDATE pginvoice SET paid='YES' WHERE invoice='".$_GET['invoice']."'" ); 

$query = "SELECT * FROM `pginvoice` WHERE 1";
$result = mysql_query($query)
	or die ("nie pokazalo nic");

include 'menu.htm';

echo "<table border='1' cellpadding='5' cellspacing='1' bordercolor='silver'><tr><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>INVOICE #</td><td class='certbanner' align='center'>CLIENT NAME</td><td class='certbanner' align='center'>DATE</td><td class='certbanner' align='center'>AMOUNT</td><td class='certbanner' align='center'>PAID</td><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>TEXT</td>";
echo "<form action='removeinvoice.php' method='post'>";
	while ($row = mysql_fetch_array($result)) {
	extract($row);
		$queryaddress = "SELECT company FROM `pginvoiceaddress` WHERE addressid='$addressid' LIMIT 0, 1 ";
		$resultaddress = mysql_query($queryaddress);
		$rowaddress = mysql_fetch_array($resultaddress);
		extract($rowaddress);
echo "<tr><td class='certbanner3'><input type='radio' name='invoice' value='$invoice'></td>
<td class='certbanner3' align='right'><a href='pginvoice.php?invoice=$invoice'>$invoice</a></td>
<td class='certbanner'>$company</td>
<td class='certbanner3'>$date</td>
<td class='certbanner2' align='right'>$$amount</td>
<td class='certbanner' align='center'>";

if ('$paid' == 'NO') 
 { 
echo "<a href='pg.php?invoice=$invoice'>$paid</a></td>"; 
 } 
  else 
  { 
	echo "YES</td>"; 
  } 
echo "</td><td class='certbanner3' align='right'><a href='updateinvoice.php?invoice=$invoice'>UPDATE</a></td>
<td class='certbanner3' align='right'>$period1</td>";
echo "</tr>";
	}
}
echo "</table>";
echo "<input type='submit' value='Remove Invoice!!'>\n";
echo "</form>\n";
print "Invoice ".$_GET['invoice']." paid!" ;
}
else
{
$query9 = "SELECT * FROM `pginvoice` WHERE 1";
$result = mysql_query($query9)
	or die ("nie pokazalo nic");

include 'menu.htm';

echo "<table border='1' cellpadding='5' cellspacing='1' bordercolor='silver'><tr><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>INVOICE #</td><td class='certbanner' align='center'>CLIENT NAME</td><td class='certbanner' align='center'>DATE</td><td class='certbanner' align='center'>AMOUNT</td><td class='certbanner' align='center'>PAID</td><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>TEXT</td>";
echo "<form action='removeinvoice.php' method='post'>";
	while ($row = mysql_fetch_array($result)) {
	extract($row);
		$queryaddress = "SELECT company FROM `pginvoiceaddress` WHERE addressid='$addressid' LIMIT 0, 1 ";
		$resultaddress = mysql_query($queryaddress);
		$rowaddress = mysql_fetch_array($resultaddress);
		extract($rowaddress);
echo "<tr><td class='certbanner3'><input type='radio' name='invoice' value='$invoice'></td>
<td class='certbanner3' align='right'><a href='pginvoice.php?invoice=$invoice'>$invoice</a></td>
<td class='certbanner'>$company</td>
<td class='certbanner3'>$date</td>
<td class='certbanner2' align='right'>$$amount</td>
<td class='certbanner' align='center'>";

if ('$paid' == 'NO') 
 { 
echo "<a href='pg.php?invoice=$invoice'>$paid</a></td>"; 
 } 
  else 
  { 
	echo "YES</td>"; 
  } 
echo "</td><td class='certbanner3' align='right'><a href='updateinvoice.php?invoice=$invoice'>UPDATE</a></td>
<td class='certbanner3' align='right'>$period1</td>";
echo "</tr>";
	}
echo "</table>";
echo "<input type='submit' value='Remove Invoice!!'>\n";
echo "</form>\n";



}

?>

[adi]

Works for multiple invoices to.
Anyway...

I moved one bracket in your code. Try it now:

<?php
$name = $_POST['name'];
$password = $_POST['password'];
$e_name = md5($name);
$e_password = md5($passwordnew);

include 'config.inc.php';

$check = mysql_query("SELECT * FROM pass1234 WHERE username='$e_name' AND password='$e_password'");
$rows = mysql_num_rows($check);

if ($rows==0) {

print "Sorry you cannot ACCESS this page!";

} else {

if (isset($_GET['invoice']))
{
mysql_query("UPDATE pginvoice SET paid='YES' WHERE invoice='".$_GET['invoice']."'" );

$query = "SELECT * FROM `pginvoice` WHERE 1";
$result = mysql_query($query)
    or die ("nie pokazalo nic");

include 'menu.htm';

echo "<table border='1' cellpadding='5' cellspacing='1' bordercolor='silver'><tr><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>INVOICE #</td><td class='certbanner' align='center'>CLIENT NAME</td><td class='certbanner' align='center'>DATE</td><td class='certbanner' align='center'>AMOUNT</td><td class='certbanner' align='center'>PAID</td><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>TEXT</td>";
echo "<form action='removeinvoice.php' method='post'>";
    while ($row = mysql_fetch_array($result)) {
    extract($row);
        $queryaddress = "SELECT company FROM `pginvoiceaddress` WHERE addressid='$addressid' LIMIT 0, 1 ";
        $resultaddress = mysql_query($queryaddress);
        $rowaddress = mysql_fetch_array($resultaddress);
        extract($rowaddress);
echo "<tr><td class='certbanner3'><input type='radio' name='invoice' value='$invoice'></td>
<td class='certbanner3' align='right'><a href='pginvoice.php?invoice=$invoice'>$invoice</a></td>
<td class='certbanner'>$company</td>
<td class='certbanner3'>$date</td>
<td class='certbanner2' align='right'>$$amount</td>
<td class='certbanner' align='center'>";

if ('$paid' == 'NO')
 {
echo "<a href='pg.php?invoice=$invoice'>$paid</a></td>";
 }
  else
  {
    echo "YES</td>";
  }
echo "</td><td class='certbanner3' align='right'><a href='updateinvoice.php?invoice=$invoice'>UPDATE</a></td>
<td class='certbanner3' align='right'>$period1</td>";
echo "</tr>";
    }
//} i think here was the problem
echo "</table>";
echo "<input type='submit' value='Remove Invoice!!'>\n";
echo "</form>\n";
print "Invoice ".$_GET['invoice']." paid!" ;
}
else
{
$query9 = "SELECT * FROM `pginvoice` WHERE 1";
$result = mysql_query($query9)
    or die ("nie pokazalo nic");

include 'menu.htm';

echo "<table border='1' cellpadding='5' cellspacing='1' bordercolor='silver'><tr><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>INVOICE #</td><td class='certbanner' align='center'>CLIENT NAME</td><td class='certbanner' align='center'>DATE</td><td class='certbanner' align='center'>AMOUNT</td><td class='certbanner' align='center'>PAID</td><td class='certbanner'>&nbsp;</td><td class='certbanner' align='center'>TEXT</td>";
echo "<form action='removeinvoice.php' method='post'>";
    while ($row = mysql_fetch_array($result)) {
    extract($row);
        $queryaddress = "SELECT company FROM `pginvoiceaddress` WHERE addressid='$addressid' LIMIT 0, 1 ";
        $resultaddress = mysql_query($queryaddress);
        $rowaddress = mysql_fetch_array($resultaddress);
        extract($rowaddress);
echo "<tr><td class='certbanner3'><input type='radio' name='invoice' value='$invoice'></td>
<td class='certbanner3' align='right'><a href='pginvoice.php?invoice=$invoice'>$invoice</a></td>
<td class='certbanner'>$company</td>
<td class='certbanner3'>$date</td>
<td class='certbanner2' align='right'>$$amount</td>
<td class='certbanner' align='center'>";

if ('$paid' == 'NO')
 {
echo "<a href='pg.php?invoice=$invoice'>$paid</a></td>";
 }
  else
  {
    echo "YES</td>";
  }
echo "</td><td class='certbanner3' align='right'><a href='updateinvoice.php?invoice=$invoice'>UPDATE</a></td>
<td class='certbanner3' align='right'>$period1</td>";
echo "</tr>";
    }
echo "</table>";
echo "<input type='submit' value='Remove Invoice!!'>\n";
echo "</form>\n";



}
}//i moved it  here
?>

Let me know...
Adi

[bajer]

This works perfectly.....wow....

Thank you; this is exactly what I was looking for....

[adi]

Was it the bracket afterall?

[bajer]

Yes...it was that bracket; and now it works perfectly....
I just have to change from '$paid' to $paid in the if statments, and that's it....
I didn't think it was possible, but thanks to you, it was...

Thanks alot!!!!!

[adi]

Glad to help!
🙂