[Resolved] simple and stupid question

chr158

I have a login form that is used to login onto a MSSQL 2K DB. This uses the db securities and controls access to certian rows and tables etc etc etc....

From my first page (login) to the next (main table details) it works fine. however when clicking on any link from there to add edit or delete records, my connection to the server seems to be lost and the variables are also lost stating they are undefined even though they are passed from login to ----> main view.

I can echo out username on the first page and it's there. Globals are on (should be off i think).

Any ideas? I am gettiing frsustrated now.

cheers in advance

ajmoore

How are you passing variables from page to page? using sessions? Could we see an example of your code to access the variables?

chr158

<?php

if (empty($submit)) {
$submit=0;
}

if($submit)
{
echo "log in";
}

else
{
?>

<table width="75%" border="0" align="center" bgcolor="#CCCCCC">
<tr>
<td>
<div align="right"><font size="3" face="Arial">User Name:</font></div>
</td>
<td>
<input type="Text" name="username">
</td>
</tr>
<tr>
<td>
<div align="right"><font size="3" face="Arial">Password: </font></div>
</td>
<td>
<input type="Password" name="password">
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="Submit" name="submit" value="Login">
<input type="Reset" name="reset" value="Reset">
</div>
</td>
</tr>
</table>
</form>

<?
}
?>
<?php include ("header/footer.php"); ?>

MAIN PAGE:
<?php include ("header/headermain.php"); ?>

<table width="75%" border="1" align="center" bgcolor="#CCCCCC">
<tr>
<td>
<div align="center"><a href="input.php">Add A New Record</a></div></td>
<td>
<div align="center"><a href="update1.php">Update An Existing Record</a></div></td>
<td>
<div align="center"><a href="delete1.php">Remove An Existing Record</a></div></td> </tr>
</table>
<hr>

<?php

TRANSACTIONS

$sql_trans_start = mssql_query("BEGIN TRANSACTION;");
$sql_trans_set = mssql_query("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;");

$sql = "SELECT * FROM TABLE order by SOMETHING asc ";
$sql_result = mssql_query($sql) or die("Couldn't execute query.");

$num = @mssql_num_rows($sql_result);
$row = @mssql_fetch_array($sql_result);

#END THE TRANSACTION
$sql_trans_end = @mssql_query("COMMIT TRANSACTION");

if ($num ==0)
{
echo "
<table width=\"650\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#CCCCCC\">
<tr>
<td align=\"center\"><B>No Records Have Been Found - Please Try Later</B></td>
</tr>
</table>

";
}

else
{
echo "
<table width=\"650\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#CCCCCC\">
<tr>
<td align=\"center\"><B>Country</B></td>
<td align=\"center\"><B>Rate</B></td>
<td align=\"center\"><B>Code</B></td>
<td align=\"center\"><B>Description</B></td>
</tr>
<tr>
";

while ($row = mssql_fetch_array($sql_result) )
{
$Country = $row["COUNTRY"];
$Rate = $row["RATE"];
$Code = $row["CODE"];
$Description = $row["DESC"];

echo "

<td align=\"center\"> $Country      </td>
<td align=\"center\"> $Rate         </td>
<td align=\"center\"> $Code         </td>
<td align=\"center\"> $Description  </td>
</tr>

";
}
echo "
</TABLE>
";
}
?>

<?php include ("header/footer.php"); ?>

HEADERMAIN PAGE:

<html>
<head>
<title>Result Group - VAT Update Routine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
$myServer = "SERVER";
$myUser = "$username";
$myPass = "$password";
$myDB = "DB";

$s = @mssql_connect($myServer, $myUser, $myPass)
or die("No Connection Can Be Made To The SQL Server on $myServer");

$d = @mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
?>

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" height="65">
<tr>
<td bgcolor="#FFFFFF" width="100%">
<div align="center"><img src="../images/logo.gif">
</div>
</td>
</tr>
<tr>
<td>
<?
$today = date("l, F d, Y");
echo "<p align=\"center\">$today"
?>
</td>
</tr>
</table>

<?php
echo" Welcome $myUser";
?>

chr158

<?php

if (empty($submit)) {
$submit=0;
}

if($submit)
{
echo "log in";
}

else
{
?>

<?
}
?>
<?php include ("header/footer.php"); ?>

MAIN PAGE:
<?php include ("header/headermain.php"); ?>

<?php

TRANSACTIONS

$sql_trans_start = mssql_query("BEGIN TRANSACTION;");
$sql_trans_set = mssql_query("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;");

$sql = "SELECT * FROM TABLE order by SOMETHING asc ";
$sql_result = mssql_query($sql) or die("Couldn't execute query.");

$num = @mssql_num_rows($sql_result);
$row = @mssql_fetch_array($sql_result);

#END THE TRANSACTION
$sql_trans_end = @mssql_query("COMMIT TRANSACTION");

";
}

while ($row = mssql_fetch_array($sql_result) )
{
$Country = $row["COUNTRY"];
$Rate = $row["RATE"];
$Code = $row["CODE"];
$Description = $row["DESC"];

echo "

<td align=\"center\"> $Country      </td>
<td align=\"center\"> $Rate         </td>
<td align=\"center\"> $Code         </td>
<td align=\"center\"> $Description  </td>
</tr>

";
}
echo "
</TABLE>
";
}
?>

<?php include ("header/footer.php"); ?>

HEADERMAIN PAGE:

<html>
<head>
<title>Result Group - VAT Update Routine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
$myServer = "SERVER";
$myUser = "$username";
$myPass = "$password";
$myDB = "DB";

$s = @mssql_connect($myServer, $myUser, $myPass)
or die("No Connection Can Be Made To The SQL Server on $myServer");

$d = @mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
?>

<?php
echo" Welcome $myUser";
?>

Norman_Graham

Look at this:

$myUser = "$username"; 
$myPass = "$password";

The inverted commas make these values into strings, so the value of $myuser is "$username" as opposed to "John Smith". Get rid of the quotes.

Norman

chr158

<?php

if (empty($submit)) {
$submit=0;
}

if($submit)
{
echo "log in";
}

else
{
?>

<?
}
?>
<?php include ("header/footer.php"); ?>

MAIN PAGE:
<?php include ("header/headermain.php"); ?>

<?php

TRANSACTIONS

$sql_trans_start = mssql_query("BEGIN TRANSACTION;");
$sql_trans_set = mssql_query("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;");

$sql = "SELECT * FROM TABLE order by SOMETHING asc ";
$sql_result = mssql_query($sql) or die("Couldn't execute query.");

$num = @mssql_num_rows($sql_result);
$row = @mssql_fetch_array($sql_result);

#END THE TRANSACTION
$sql_trans_end = @mssql_query("COMMIT TRANSACTION");

";
}

while ($row = mssql_fetch_array($sql_result) )
{
$Country = $row["COUNTRY"];
$Rate = $row["RATE"];
$Code = $row["CODE"];
$Description = $row["DESC"];

echo "

<td align=\"center\"> $Country      </td>
<td align=\"center\"> $Rate         </td>
<td align=\"center\"> $Code         </td>
<td align=\"center\"> $Description  </td>
</tr>

";
}
echo "
</TABLE>
";
}
?>

<?php include ("header/footer.php"); ?>

HEADERMAIN PAGE:

<html>
<head>
<title>Result Group - VAT Update Routine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
$myServer = "SERVER";
$myUser = "$username";
$myPass = "$password";
$myDB = "DB";

$s = @mssql_connect($myServer, $myUser, $myPass)
or die("No Connection Can Be Made To The SQL Server on $myServer");

$d = @mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
?>

<?php
echo" Welcome $myUser";
?>

Norman_Graham

Could you stop posting the code - you've done it three times now.

Thanx

Norman 😃

chr158

Yes - I am sorry about that, was getting virused and windows opened everywhere.

SORRY and THANK YOU

chr158

I removed the "" but didn't work. i had tried that before.
thanks anyway - this is a simple thing but my head is now getting sore from banging it against the walls

FrozNic

on the main page:

add a hidden var that will pass it through to the next page. set's the var and i believe sends it using the post method... (not through the url)

you can do this with any var.

<input type="hidden" name="MyVar" value"<? $MyVar; ?>"> (to catch a var you've already defined in that page and send it again)

example:

page 1 (login):

form (post to page 2)
$user="user";
$pass="pass";
$age="10";
submit button

page 2 (post vars):
print $_REQUEST['age'];
(prints "10")

and the var $age is lost in that page unless you define it again

hence

form (post to page 3)
<input type="hidden" name="age" value"<? $_REQUEST['age']; ?>">
submit

in your link to whatever page you are going to:

passing morevars and age on to the next page as well.

you can also do this process with sessions, but i don't know that much about it to go off on it like i just did. good luck

chr158

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' on line 9

<?php
echo"
Username: $myUser

<br>
Password: $myPass
<br>
Line 9 $_REQUEST['myUser']
";
?>

FrozNic

usually that's because of uneeded quotes, post lines 8-10 and i'll take a look!

chr158

the lines are there.

I have decided as a work around for now, to attach my connection script to every page that seems to have fixed the problems, just messy now though.

thanks for your help - if you know a quick solution it would be much appreciated

FrozNic

that's actually what i do... include an incdatabase.php file with a class so that everytime i need to connect i just call the class and connect!