<html><body><center>
<a href="avisit.php">load avisit.php</a>
</center></body></html>
<!DOCTYPE html><html>
<head>
<title>test 3</title>
</head>
<body><center>
<form id="testform" name="testform" action="" method="post" accept-charset="UTF-8">
<table border=1 cellpadding=2 cellspacing=2 bgcolor="#D4FFAA">
<tr>
<th>url</th><th>username</th><th>password</th><th>purpose</th>
<th>emailused</th><th>date-time</th><th>count</th><th>saved</th>
</tr>
<?php
$connect=mysql_connect("localhost", "root", "cookie") or die("error");
mysql_select_db("homedb", $connect);
$sql="SELECT * from emailtbl";
$result=mysql_query($sql, $connect);
$url='';;
while($res=mysql_fetch_assoc($result))
{
echo "<tr>";
echo "<td>"; echo '<input type="radio" name="url" >'; echo "</td>";
echo "<td>"; echo $res['username']>'; echo "</td>";
echo "<td>"; echo $res['password']; echo "</td>";
echo "<td>"; echo $res['purpose']; echo "</td>";
echo "<td>"; echo $res['emailused']; echo "</td>";
echo "<td>"; echo $res['date-time']; echo "</td>";
echo "<td>"; echo $res['count']; echo "</td>";
echo "<td>"; echo $res['saved']; echo "</td>";
echo "</tr>";
}
?>
</table> </form></body></html>
connect_error) die ( 'Database connection failed: ' . $db->connect_error ); $emailStmt = $db->prepare(' SELECT * FROM emailtbl WHERE id = ? '); $emailStmt->bindParam('s', $id); $emailStmt->execute(); if ($email = $emailStmt->fetch()) { echo 'Last date accessed was ', $email['date-time']; $lastStmt = $db->prepare(' UPDATE emailtbl SET date-time = NOW() WHERE id = ? '); $lastStmt->bindParam('s', $id); $lastStmt->execute(); } else die( 'No rows returned matching id ' . $id ); ?> connect_error) die ( 'Database connection failed: ' . $db->connect_error ); if (isset($_POST['url'])) { $emailStmt = $db->prepare(' SELECT url, username, password, purpose, emailused, date-time, count, saved FROM emailtbl WHERE url = ? '); $emailStmt->bindParam('s', $_POST['url']); $emailStmt->execute(); if ($email = $emailStmt->fetch()) { echo ' '; do { echo ' '; } while ($email = $emailStmt->fetch()); echo '
Email menu url username password purpose emailused date-time count saved
', $email['url'], ' ', $email['username'], ' ', $email['password'], ' ', $email['purpose'], ' ', $email['emailused'], ' ', $email['date-time'], ' ', $email['count'], ' ', $email['saved'], '
'; } else echo 'No Matches found!
'; } else echo 'You failed to fill out a required field
<html><body bgcolor="#ccffff"><center><p>
<table bgcolor=pink width="180" border=0><tr>
<td><a href="http://localhost/invoice/apdue.php">Payables Due</a><br></td>
<tr><td><a href="http://localhost/invoice/appaid.php">Payables Paid</a><br></td>
<tr><td><a href="http://localhost/invoice/ardue.php">Receivables Due</a><br></td>
<tr><td><a href="http://localhost/invoice/arpaid.php">Receivables Paid</a><br></td>
</tr></table>
</center></body</html>
"
<html><body><center>
<?php
error_reporting(0);
mysql_connect('localhost','root','cookie');
mysql_select_db('homedb') or die("Unable to select database");
$query=" SELECT * FROM oocust WHERE payrec = 'P' AND datepaid !='' ORDER BY duedate ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo date('m/d/y');
echo "<font size=+1><b><center> Accounts Payable Paid Report</font></center></b></b><br />";
?>
<table cellspacing=1 cellpadding=1 border=1>
<thead>
<tr>
<th colspan=4></th>
<th colspan=2 bgcolor="#ccffff">date</th>
<th bgcolor="#ccffff">days</th>
<th colspan=3 bgcolor="#ccffff">amt</th>
<tr>
<th bgcolor="#ccffff">recur?</th>
<th bgcolor="#ccffff">acct#</th>
<th bgcolor="#ccffff">creditor</th>
<th bgcolor="#ccffff">purpose</th>
<th bgcolor="#ccffff">d
<th bgcolor="#ccffff">paid</th>
<th bgcolor="#ccffff">late</th>
<th bgcolor="#ccffff">payable</th>
<th bgcolor="#ccffff">paid</th>
<th bgcolor="#ccffff">due</th>
</tr>
<?php
while($row = mysql_fetch_array($result))
{
$dueamt += $row['amtdue'];
$totdue += $row['amtdue'];
$totpaid += $row['paidamt'];
echo '
<tr>
<td>', $row['recur'], '</td>
<td>', $row['acctno'], '</td>
<td>', $row['bname'], '</td>
<td>', $row['purpose'], '</td>
<td>', $row['duedate'], '</td>
<td>', $row['datepaid'], '</td>
<td align=right>', $row['dayslate'], '</td>
<td align=right class="currency">$'.number_format($row['amtdue'],2).'</td>
<td align=right class="currency">$'.number_format($row['paidamt'],2).'</td>
<td align=right class="currency">$'.number_format($row['dueamt'],2).'</td>
</tr>';
}
echo '
<tr>
<th bgcolor="#ccffff" scope="row" colspan="7">Grand Total:</th>
<td bgcolor="#FFD4D4" class="currency">$'.number_format($totdue, 2, '.', ''), '</td>
<td bgcolor="#FFFFAA" class="currency">$'.number_format($totpaid, 2, '.', ''), '</td>
<td bgcolor="##FFD4D4" class="currency">$'.number_format($totdue-$totpaid, 2, '.', ''), '</td>
</tr>
</table>';
mysql_close();
?>
</body></html>
12strings wrote:All my folders are in "htdocs". If all files used in an app. are in the same folder why should I need to include them in my navigation file?
Users browsing this forum: No registered users and 238 guests