Display single db row that matches other variables

felgus · October 22, 2008

I want to display only the row of the db that matches the firstname and lastname stored in the session....

right now it is displaying all items on the table....

here it is the code

<?php require_once('../Connections/unica.php'); ?>

<?php

if (!isset($_SESSION)) {

session_start();

}

$MM_authorizedUsers = "";

$MM_donotCheckaccess = "true";

// *** Restrict Access To Page: Grant or deny access to this page

function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {

// For security, start by assuming the visitor is NOT authorized.

$isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.

// Therefore, we know that a user is NOT logged in if that Session variable is blank.

if (!empty($UserName)) {

// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.

// Parse the strings into arrays.

$arrUsers = Explode(",", $strUsers);

$arrGroups = Explode(",", $strGroups);

if (in_array($UserName, $arrUsers)) {

$isValid = true;

}

// Or, you may restrict access to only certain users based on their username.

if (in_array($UserGroup, $arrGroups)) {

$isValid = true;

}

if (($strUsers == "") && true) {

$isValid = true;

}

return $isValid;

}

$MM_restrictGoTo = "login.php";

if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {

$MM_qsChar = "?";

$MM_referrer = $_SERVER['PHP_SELF'];

if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";

if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)

$MM_referrer .= "?" . $QUERY_STRING;

$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);

header("Location: ". $MM_restrictGoTo);

exit;

}

?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_rsclient = 10;

$pageNum_rsclient = 0;

if (isset($_GET['pageNum_rsclient'])) {

$pageNum_rsclient = $_GET['pageNum_rsclient'];

}

$startRow_rsclient = $pageNum_rsclient * $maxRows_rsclient;

mysql_select_db($database_unica, $unica);

$query_rsclient = "SELECT * FROM client_info ORDER BY lastname ASC";

$query_limit_rsclient = sprintf("%s LIMIT %d, %d", $query_rsclient, $startRow_rsclient, $maxRows_rsclient);

$rsclient = mysql_query($query_limit_rsclient, $unica) or die(mysql_error());

$row_rsclient = mysql_fetch_assoc($rsclient);

if (isset($_GET['totalRows_rsclient'])) {

$totalRows_rsclient = $_GET['totalRows_rsclient'];

} else {

$all_rsclient = mysql_query($query_rsclient);

$totalRows_rsclient = mysql_num_rows($all_rsclient);

}

$totalPages_rsclient = ceil($totalRows_rsclient/$maxRows_rsclient)-1;

$maxRows_rsJob = 10;

$pageNum_rsJob = 0;

if (isset($_GET['pageNum_rsJob'])) {

$pageNum_rsJob = $_GET['pageNum_rsJob'];

}

$startRow_rsJob = $pageNum_rsJob * $maxRows_rsJob;

mysql_select_db($database_unica, $unica);

$query_rsJob = "SELECT * FROM cust_info ORDER BY lastname ASC";

$query_limit_rsJob = sprintf("%s LIMIT %d, %d", $query_rsJob, $startRow_rsJob, $maxRows_rsJob);

$rsJob = mysql_query($query_limit_rsJob, $unica) or die(mysql_error());

$row_rsJob = mysql_fetch_assoc($rsJob);

if (isset($_GET['totalRows_rsJob'])) {

$totalRows_rsJob = $_GET['totalRows_rsJob'];

} else {

$all_rsJob = mysql_query($query_rsJob);

$totalRows_rsJob = mysql_num_rows($all_rsJob);

}

$totalPages_rsJob = ceil($totalRows_rsJob/$maxRows_rsJob)-1;

$queryString_rsJob = "";

if (!empty($_SERVER['QUERY_STRING'])) {

$params = explode("&", $_SERVER['QUERY_STRING']);

$newParams = array();

foreach ($params as $param) {

if (stristr($param, "pageNum_rsJob") == false &&

stristr($param, "totalRows_rsJob") == false) {

array_push($newParams, $param);

}

if (count($newParams) != 0) {

$queryString_rsJob = "&" . htmlentities(implode("&", $newParams));

}

$queryString_rsJob = sprintf("&totalRows_rsJob=%d%s", $totalRows_rsJob, $queryString_rsJob);

$queryString_rsclient = "";

if (!empty($_SERVER['QUERY_STRING'])) {

$params = explode("&", $_SERVER['QUERY_STRING']);

$newParams = array();

foreach ($params as $param) {

if (stristr($param, "pageNum_rsclient") == false &&

stristr($param, "totalRows_rsclient") == false) {

array_push($newParams, $param);

}

if (count($newParams) != 0) {

$queryString_rsclient = "&" . htmlentities(implode("&", $newParams));

}

$queryString_rsclient = sprintf("&totalRows_rsclient=%d%s", $totalRows_rsclient, $queryString_rsclient);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<head>

<title>Client List</title>

<!--

.style1 {

color: #4088B8;

font-weight: bold;

}

body {

margin-left: 0px;

margin-right: 0px;

}

-->

</style>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

<p><?php

echo "Welcome {$_SESSION['User_firstname']} {$_SESSION['User_lastname']}";

?>

to Unica Construction website.

<p>

<p>You can view your current job status by clicking in the My Account section of the menu.

<tr>

<td width="129">firstname</td>

<td width="119">lastname</td>

<td width="109">jobtype</td>

</tr>

<?php do { ?>

<tr>

<td><div align="center">Delete</div></td>

</tr>

<?php } while ($row_rsJob = mysql_fetch_assoc($rsJob)); ?>

</table>

<br />

<tr>

<td><?php if ($pageNum_rsJob > 0) { // Show if not first page ?>

<a href="<?php printf("%s?pageNum_rsJob=%d%s", $currentPage, 0, $queryString_rsJob); ?>">First</a>

<?php } // Show if not first page ?>

</td>

<td><?php if ($pageNum_rsJob > 0) { // Show if not first page ?>

<a href="<?php printf("%s?pageNum_rsJob=%d%s", $currentPage, max(0, $pageNum_rsJob - 1), $queryString_rsJob); ?>">Previous</a>

<?php } // Show if not first page ?>

</td>

<?php } // Show if not last page ?>

</td>

<?php } // Show if not last page ?>

</td>

</tr>

</table>

Records <?php echo ($startRow_rsJob + 1) ?> to <?php echo min($startRow_rsJob + $maxRows_rsJob, $totalRows_rsJob) ?> of <?php echo $totalRows_rsJob ?>

</form>

<p>

</div>

<h2>Welcome Message!</h2>

<p>Thank for visitin our website please fell free to contact us anytime at 770-955-4533</p>

<p>Thank you </p>

<p>Unica Construction Staff.</p>

</div>

</div>

</body>

</html>

<?php

mysql_free_result($rsclient);

mysql_free_result($rsJob);

?>

Maq · October 22, 2008

1) Please use code tags (the # sign icon).

2) Have you tried debugging the situation? Echo out your variables in the query.

3) Could you give us the piece of code causing the issue so we don't have to read plain text. It's probably your sql query.

revraz · October 22, 2008

Starters, this is not required

if (!isset($_SESSION)) {

session_start();

}

session_start() will start a session if one is not started and resume one that is.

Onto your question, when you find your match in the DB for the user, store their ID in a session, then you can retrieve just that ID anytime you wish.

Sign In

Display single db row that matches other variables

Recommended Posts

felgus

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information