Php mysql single display

felgus · October 22, 2008

I want to display info from a specific table row that matches the firstname and lastname in order to display the data.

matching these: $_SESSION['User_firstname']} {$_SESSION['User_lastname']}

with these:

CREATE TABLE `unica_admin`.`cust_info` (

`id` INT( 4 ) NOT NULL AUTO_INCREMENT ,

`firstname` VARCHAR( 20 ) NOT NULL ,

`lastname` VARCHAR( 20 ) NOT NULL ,

`address` VARCHAR( 40 ) NOT NULL ,

`phone` VARCHAR( 40 ) NOT NULL ,

`phone2` VARCHAR( 40 ) NOT NULL ,

`email` VARCHAR( 40 ) NOT NULL ,

`jobtype` VARCHAR( 40 ) NOT NULL ,

`jobtitle` VARCHAR( 50 ) NOT NULL ,

`jobnotes` VARCHAR( 100 ) NOT NULL ,

`latestup` VARCHAR( 100 ) NOT NULL ,

`joppix` VARCHAR( 100 ) NOT NULL ,

`associate` VARCHAR( 20 ) NOT NULL ,

`supervisor` VARCHAR( 20 ) NOT NULL ,

`crew` VARCHAR( 20 ) NOT NULL ,

`review` VARCHAR( 100 ) NOT NULL ,

`level` VARCHAR( 20 ) NOT NULL ,

PRIMARY KEY ( `id` )

) ENGINE = InnoDB

trq · October 22, 2008

And your question is?

felgus · October 22, 2008

My question is how to display a single row of data that matches the session variable called firstname and lastname with the fields from the db called firstname and lastname.....

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);

?>

Twister1004 · October 22, 2008

Might be easier with a while loop.

Sign In

Php mysql single display

Recommended Posts

felgus

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

felgus

Link to comment

Share on other sites

Twister1004

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information