List Menu - Redirection? - PHPBuilder Forums

List Menu - Redirection?

russellbcv

I have pdf documents located in the root folder for all users.

Does anybody know how to link this with the List Menu form?

http://midas.rbcserver.net/cview/invoices.php

</p>
      <p class="style3">To View Invoice select month:</p>
      <form name="form1" method="post" action="">
        <select name="select">
          <option>Select</option>
          <option>Feb 05</option>
          <option>Jan 05</option>
        </select>
      </form>
      <p>

paulnaj

Hi Russell,

Not really a php problem as such ... there are so many ways of achieving this ... here's one ... it might not be what you want but you'll be able to adapt it ...

<p class="style3">To View Invoice select month:</p> 
        <select name="invoice" onchange="setPDF(this)"> 
          <option value="" selected>Select</option> 
          <option value="feb05">Feb 05</option> 
          <option value="jan05">Jan 05</option> 
        </select> 
	  <script language="javascript" type="text/javascript">
	  function setPDF(sel){
	  	var strInvoice = sel.options[sel.selectedIndex].value;
		if(strInvoice != ''){
			location.href = 'http://midas.rbcserver.net/cview/' + strInvoice + '.pdf';
		} else {
			alert('Please select an invoice.');
		}
	  }
	  </script>
      <p>

Paul 🙂

russellbcv

Thanks Paul

This works perfectly!

Do you know how I can change the font size in this bit of code? I cannot seem do make any changes both in Dreamweaver or PHP ?

$list = "<table border=\"0\" cellpadding=\"5\">"; 
$list .= "<tr><th>Cli</th>";
$list .= "<th>Date</th>";  

$list .= "<th>Time</th>"; 
$list .= "<th>Number</th>"; 
$list .= "<th>Destination</th>"; 
$list .= "<th>Duration</th>"; 
$list .= "<th>Cost</th></tr>"; 
$total_duration = 0; 
$total_cost = 0; 
while( $row = mysql_fetch_array( $rs ) ) 
{ 
$total_duration += $row['duration']; 
$total_cost += $row['cost']; 
$list .= "<tr>"; 
$list .= "<td>".$row["cli"]."</td>";
$list .= "<td>".$row["date"]."</td>";
$list .= "<td>".$row["time"]."</td>"; 
$list .= "<td>".$row["number"]."</td>"; 
$list .= "<td>".$row["destination"]."</td>"; 
$list .= "<td>".$row["duration"]."</td>"; 
$list .= "<td>".$row["cost"]."</td>"; 
$list .= "</tr>"; 
$list .= "</tr>"; 
} 
$list .= "</table>"; 
} 
else{ 
header("Location: login.php"); 
} 
?>

paulnaj

Hi again Russell.

A couple of things ...

You shouldn't tag a completely separate question onto this thread :queasy: just start another one! The reason is that no-one else will benefit from seeing both the problem and the solution to the new problem just by looking at the thread headers.

Also, you should really try to have a go yourself and show what you tried even if it didn't work.

Finally, if you pare down the problem, you'll again find it's an HTML issue and nothing to do with PHP. I think you're going to struggle if you're having trouble with HTML. My advice would be to stop using Dreamweaver to build your sites, at least until you can adapt the code it produces yourself. That means a good working knowledge of HTML.

Having said all that, you'd best show the whole page ... including any <style> and/or <link> tags that DW includes ... otherwise I could mess up other parts of your design.

Paul 🙂

russellbcv

Hi Paul

I agree. I am not a web developer but an Accountant trying to do my IT Managers job!

I have started to design an online customer site which users can access using their username & password. From here they can view their call usage & historical invoices & payments & also personal details.

This is my full code:

<?php
session_start();
if ($SESSION['logged_in'] != "true"){
$username = $POST['username'];
$password = $POST['password'];
}
else {$username = $SESSION['username'];
$password = $_SESSION['password'];
}

$self = $_SERVER['PHP_SELF'];
$referer = 'login.php';

if( ( !$username ) or ( !$password ) )
{ header( "Location:$referer" ); }

$conn = @mysql_connect( "localhost", "xxxx", "xxxx" )
or die ( "Could not connect" );
$rs = @mysql_select_db( "rates", $conn )
or die( "Could not select database" );
$sql="select * from custs_uk where username = '" . $username . "'
and password = '". $password . "'";
$rs = mysql_query( $sql, $conn )
or die(mysql_error() . "Could not execute query" );
$num = mysql_numrows( $rs );

if( $num != 0 ){
$SESSION['logged_in'] = "true";
$SESSION['username'] = $username;
$_SESSION['password'] = $password;

$rs = @mysql_select_db( "rates", $conn )
or die( "Could not select database" );
$sql = "select * from cdruk where username = '" . $username . "'";
$rs = mysql_query( $sql, $conn )
or die(mysql_error() . "Could not execute query" );

$list = "<table border=\"0\" cellpadding=\"5\">";
$list .= "<tr><th>Cli</th>";
$list .= "<th>Date</th>";

$list .= "<th>Time</th>";
$list .= "<th>Number</th>";
$list .= "<th>Destination</th>";
$list .= "<th>Duration</th>";
$list .= "<th>Cost</th></tr>";
$total_duration = 0;
$total_cost = 0;
while( $row = mysql_fetch_array( $rs ) )
{
$total_duration += $row['duration'];
$total_cost += $row['cost'];
$list .= "<tr>";
$list .= "<td>".$row["cli"]."</td>";
$list .= "<td>".$row["date"]."</td>";
$list .= "<td>".$row["time"]."</td>";
$list .= "<td>".$row["number"]."</td>";
$list .= "<td>".$row["destination"]."</td>";
$list .= "<td>".$row["duration"]."</td>";
$list .= "<td>".$row["cost"]."</td>";
$list .= "</tr>";
$list .= "</tr>";
}
$list .= "</table>";
}
else{
header("Location: login.php");
}
?>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<link rel="stylesheet" href="emx_nav_left.css" type="text/css">
<script type="text/javascript">
<!--
var time = 3000;
var numofitems = 7;

//menu constructor
function menu(allitems,thisitem,startstate){
callname= "gl"+thisitem;
divname="subglobal"+thisitem;
this.numberofmenuitems = 7;
this.caller = document.getElementById(callname);
this.thediv = document.getElementById(divname);
this.thediv.style.visibility = startstate;
}

//menu methods
function ehandler(event,theobj){
for (var i=1; i<= theobj.numberofmenuitems; i++){
var shutdiv =eval( "menuitem"+i+".thediv");
shutdiv.style.visibility="hidden";
}
theobj.thediv.style.visibility="visible";
}

paulnaj

Hi russell,

I will help you out, no problem. But you're going to run into so many difficulties. In the end, you should really get someone to do this for you professionally. Otherwise, even if your site 'works' it'll be a right dog's dinner, and difficult to update or adapt.

Anyway, this should work (make a backup of your existing page first ... just checking 😉 ) ...

Change the line ...

$list = "<table border=\"0\" cellpadding=\"5\">";

... to ...

$list = "<table class=\"tblist\" border=\"0\" cellpadding=\"5\">";

Locate the block of code ...

... and add the lines ...

.tblist {
font-family: Arial, Helvetica, sans-serif;
font-size: small;
}

... just after the 'style8' line. Notice 'tblist' is the value of the 'class' attribute of the table in step 1. I've put the font-size as 'small' ... the alternatives are: xx-small, x-small, small, medium, large, x-large and xx-large.

The whole block should now read ...

</style>

Finally, you can get rid on the extraneous <font> tag. Find the block (near the end) ...

... and remove the <font> tag. It should look like ...

<p>
<?php
echo( $list );

?> </p>

Come back if you get any probs ... I could've missed something!!

Paul. 🙂

russellbcv

Hi Paul

I have made all those changes but nothing has changed.

You can take a look if you like?

http://www.rbcserver.net/cview/login.php

username: 000061m
password: dzqhs9

This is a test site I have been playing around with.

Could the "CSS" be the problem? I have used a style sheet with Dremweaver

Russ

paulnaj

Try using x-small in place of small in the style block ...

Paul.

russellbcv

Hi Paul

That worked - Thank you so much for helping me!

What do you think of my attempt? Did you take a look at my test site?

paulnaj

Hi Russell,

Glad it worked!

Yes, I did have a look ... nice and clean. And, to be honest, you've done really well if all you've used is DW.

But believe me, HTML is easy-peasy 😉 ... it's just a list of straightforward formatting and layout rules. Here's a good place to
start.

If you've had absolutely no programming experience at all, then it's pretty hard to say where the best place to start is, but PHP ain't a bad language to start with. Get yourself a 'PHP for Dummies' or something similar to get over the initial hoops a novice has to jump through. Once you're past them, it get's easier.

Paul 🙂

russellbcv

Hi Paul

Thanks for the sound advice!

There is one final thing I need to get my head around and that is finding away for users to view their invoices online.

As per my original post with regards to redirecting to a pdf document I guess is ok if you have a relatively small voulme of users - what would happen if you had many thousands. Do create individual pdfs for each user would take time and also space on the pc.

Do you know if there is a solution whereby if users wishes to view say their Feb05 invoices the pdf is generated at that moment?

paulnaj

Yes, there is.

I haven't had to do it myself ... a search on the forum will get you some relevant threads ... but we're back to what I was saying before. You won't be able to use/adapt the solutions yourself.

Paul.

russellbcv

Over the past week I have been playing around with PHP & MySQL and guess if you can extract information from a table using PHP code then surely there must be a way of creating an invoice?

Say you create a standard template (header & footer) and the main content would be extracted from the relevant table/s in MySQL.

For example all my users details i.e Name & Address would be stored in one table and the Invoice details stored in another i.e Calls, Mins, Revenue, Vat ...etc

I have already used "Session Varaibles" to hold the username name when linking pages and extracting invoice, payment & personal information within the site so could we do the same exercise for viewing invoices?