Ad:

PHP Discussion Thread
Unsolved
Views: 2046

Sep 27th, 2008

Please help me with sorting column heading

Expand Post »

Dear All,

I am a new web, I would like all of you kindly help me with code of sorting column heading.

Thanks in advance!

Kindly regards,

Bunhok

Similar Threads

Open In New Window Php in PHP
Sorting by dates in MySQL
Collapsible table sorting problem in JavaScript / DHTML / AJAX
javascript works in IE but not working in firefox in JavaScript / DHTML / AJAX
can anyone make this tree table sort correctly? in JavaScript / DHTML / AJAX

Bunhok

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Sep 2008

Permalink

Sep 28th, 2008

Re: Please help me with sorting column heading

Click to Expand / Collapse Quote originally posted by Bunhok ...

Dear All,

I am a new web, I would like all of you kindly help me with code of sorting column heading.

Thanks in advance!

Kindly regards,

Bunhok

I would start out with something like this. You might find some of this a little confusing, let me know if you any questions.

php Syntax (Toggle Plain Text)
<? include("connection.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?
$searchquery = ""; //if you intend to add search to this page
 
// columns that you can order by
$orderbycols = array();
$orderbycols["fname"] = "first name";
$orderbycols["lname"] = "last name";
$orderbycols["phone"] = "phone";
$orderbycols["username"] = "user name";
$orderbycols["address"] = "address";
 
// columns that are dificult to order by
$nonorderbycols = array();
$nonorderbycols["hobbies"] = "favorite hobbies";
$nonorderbycols["signature"] = "signature";
 
// merge the column names for the query
$querysel = array_merge($orderbycols, $nonorderbycols);
 
// declare order by variable
$orderby = "";
if(isset($_GET['order']) && in_array(strtolower($_GET['order']), array_keys($orderbycols)))
{
	$orderby .= " order by '" . strtolower($_GET['order']) . "'";
	// if we are ordering by desc values
	if(isset($_GET['desc']) && $_GET['desc'] == "true")
	{
		$orderby .= " desc";
	}
}
 
// main query
$query = "select " . implode(", ", array_keys($querysel)) . " from table inner join other_table using(colname_pk)" . $searchquery . $orderby;
$result = mysql_query($query);
?>
 
<body>
	<table>
		<tr>
			<?
			// columns that can be ordered
			foreach($orderbycols as $key=>$value)
			{
			?>
				<td><?
					$hreforder = "";
					if(trim($orderby) != "" && strtolower($_GET['order']) == $key)
					{
						$hreforder = isset($_GET['desc']) && $_GET['desc'] == "true"?"":"&desc=true";
					}
				?><a href="<? echo basename($_SERVER['PHP_SELF']); ?>?order=<? echo $key . $hreforder; ?>"><? echo ucwords($value); ?></a></td>
			<?
			}
			?>
			<?
			// columns that cannot be ordered
			foreach($nonorderbycols as $key=>$value)
			{
			?>
				<td><? echo ucwords($value); ?></td>
			<?
			}
			?>
		</tr>
		<?
			// display database loop here
		?>
	</table>
</body>
</html>
<?
mysql_close();
?>
<? include("connection.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?
$searchquery = ""; //if you intend to add search to this page

// columns that you can order by
$orderbycols = array();
$orderbycols["fname"] = "first name";
$orderbycols["lname"] = "last name";
$orderbycols["phone"] = "phone";
$orderbycols["username"] = "user name";
$orderbycols["address"] = "address";

// columns that are dificult to order by
$nonorderbycols = array();
$nonorderbycols["hobbies"] = "favorite hobbies";
$nonorderbycols["signature"] = "signature";

// merge the column names for the query
$querysel = array_merge($orderbycols, $nonorderbycols);

// declare order by variable
$orderby = "";
if(isset($_GET['order']) && in_array(strtolower($_GET['order']), array_keys($orderbycols)))
{
	$orderby .= " order by '" . strtolower($_GET['order']) . "'";
	// if we are ordering by desc values
	if(isset($_GET['desc']) && $_GET['desc'] == "true")
	{
		$orderby .= " desc";
	}
}

// main query
$query = "select " . implode(", ", array_keys($querysel)) . " from table inner join other_table using(colname_pk)" . $searchquery . $orderby;
$result = mysql_query($query);
?>

<body>
	<table>
		<tr>
			<?
			// columns that can be ordered
			foreach($orderbycols as $key=>$value)
			{
			?>
				<td><?
					$hreforder = "";
					if(trim($orderby) != "" && strtolower($_GET['order']) == $key)
					{
						$hreforder = isset($_GET['desc']) && $_GET['desc'] == "true"?"":"&desc=true";
					}
				?><a href="<? echo basename($_SERVER['PHP_SELF']); ?>?order=<? echo $key . $hreforder; ?>"><? echo ucwords($value); ?></a></td>
			<?
			}
			?>
			<?
			// columns that cannot be ordered
			foreach($nonorderbycols as $key=>$value)
			{
			?>
				<td><? echo ucwords($value); ?></td>
			<?
			}
			?>
		</tr>
		<?
			// display database loop here
		?>
	</table>
</body>
</html>
<?
mysql_close();
?>

Last edited by R0bb0b; Sep 28th, 2008 at 1:16 am.

R0bb0b

Reputation Points: 358

Solved Threads: 89

Posting Shark

Offline

986 posts
since Jun 2008

Permalink

Oct 5th, 2008

Re: Please help me with sorting column heading

Dear sir,

It still has an error with this code.

It appears like this.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\working\sorting.php on line 74

What should we use loop? with while right?

Click to Expand / Collapse Quote originally posted by R0bb0b ...

PHP Syntax (Toggle Plain Text)
		<?
 
// display database loop here
while($item = mysql_fetch_array($result))		?>
 
<tr><td><?=$item['Jobid']?>"></td></tr>
 
<? // display database loop here while($item = mysql_fetch_array($result)) ?> <tr><td><?=$item['Jobid']?>"></td></tr>

Thanks so much for supporting me.

Kindly regards,

Bunhok

Bunhok

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Sep 2008

Permalink

Oct 5th, 2008

Re: Please help me with sorting column heading

Did you modify the code I provided to match your database?

R0bb0b

Reputation Points: 358

Solved Threads: 89

Posting Shark

Offline

986 posts
since Jun 2008

Permalink

Oct 5th, 2008

Re: Please help me with sorting column heading

Dear sir,

I modify ready but not sorting the databse now it display connectly

Quote ...

<? require("Dbconnect/db_connect.php"); ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?
$searchquery = ""; //if you intend to add search to this page

// columns that you can order by
$orderbycols = array();
$orderbycols["Jobtitle"] = "Job Title";
$orderbycols["Jobcompany"] = "Jobcompany";

// declare order by variable
$orderby = "";
if(isset($_GET['order']) && in_array(strtolower($_GET['order']), array_keys($orderbycols)))
{
$orderby .= " order by '" . strtolower($_GET['order']) . "'";
// if we are ordering by desc values
if(isset($_GET['desc']) && $_GET['desc'] == "true")
{
$orderby .= " desc";
}
}

// main query
$query = "select " . implode(", ", array_keys($orderbycols)) . " from tbljob" . $searchquery . $orderby;
$result = mysql_query($query);
?>

<body>
<table>
<tr>
<?
// columns that can be ordered
foreach($orderbycols as $key=>$value)
{
?>
<td><?
$hreforder = "";
if(trim($orderby) != "" && strtolower($_GET['order']) == $key)
{
$hreforder = isset($_GET['desc']) && $_GET['desc'] == "true"?"":"&desc=true";
}
?><a href="<? echo basename($_SERVER['PHP_SELF']); ?>?order=<? echo $key . $hreforder; ?>"><? echo ucwords($value); ?></a></td>
<?
}
?>

</tr>
<?

$sql = "SELECT * FROM tbljob order by Jobid desc";
$result = mysql_query($sql);
while($item = mysql_fetch_array($result))
{
$bgc=($bgc=="#F7F7F7")?"#ffffff" : "#F7F7F7";

?>

<tr><td>
<?=$item['Jobtitle']?>

</tr>

<? }

?>

</body>
</html>
<?
mysql_close();
?>

Bunhok

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Sep 2008

Permalink

Oct 5th, 2008

Re: Please help me with sorting column heading

This works, didn't realize that you would have capitals in your column names.

php Syntax (Toggle Plain Text)
<?
if($dbconn = mysql_connect('servername', 'username', 'pass'))
{
	mysql_select_db('dbname', $dbconn);
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?
$searchquery = ""; //if you intend to add search to this page
 
// columns that you can order by
$orderbycols = array();
$orderbycols["Jobtitle"] = "Job Title";
$orderbycols["Jobcompany"] = "Jobcompany";
 
// declare order by variable
$orderby = "";
if(isset($_GET['order']) && in_array($_GET['order'], array_keys($orderbycols)))
{
	$orderby .= " order by " . strtolower($_GET['order']);
	// if we are ordering by desc values
	if(isset($_GET['desc']) && $_GET['desc'] == "true")
	{
		$orderby .= " desc";
	}
}
 
// main query
$query = "select " . implode(", ", array_keys($orderbycols)) . " from tbljob" . $searchquery . $orderby;
echo $query . "<br />";
$result = mysql_query($query);
?>
 
<body>
<table>
<tr>
<?
// columns that can be ordered
foreach($orderbycols as $key=>$value)
{
?>
	<td><?
	$hreforder = "";
	if(trim($orderby) != "" && $_GET['order'] == $key)
	{
		$hreforder = isset($_GET['desc']) && $_GET['desc'] == "true"?"":"&desc=true";
	}
	?><a href="<? echo basename($_SERVER['PHP_SELF']); ?>?order=<? echo $key . $hreforder; ?>"><? echo ucwords($value); ?></a></td>
	<?
}
?>
 
</tr>
<?
$bgc = "";
while($item = mysql_fetch_array($result))
{
	$bgc=($bgc=="#F7F7F7")?"#ffffff" : "#F7F7F7";	
	?>	
	<tr>
	<td><?=$item['Jobtitle']?></td>
	<td><?=$item['Jobcompany']?></td>	
	</tr>
	<? 
}
 
?>
</body>
</html>
<?
mysql_close();
?>
<?
if($dbconn = mysql_connect('servername', 'username', 'pass'))
{
	mysql_select_db('dbname', $dbconn);
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?
$searchquery = ""; //if you intend to add search to this page

// columns that you can order by
$orderbycols = array();
$orderbycols["Jobtitle"] = "Job Title";
$orderbycols["Jobcompany"] = "Jobcompany";

// declare order by variable
$orderby = "";
if(isset($_GET['order']) && in_array($_GET['order'], array_keys($orderbycols)))
{
	$orderby .= " order by " . strtolower($_GET['order']);
	// if we are ordering by desc values
	if(isset($_GET['desc']) && $_GET['desc'] == "true")
	{
		$orderby .= " desc";
	}
}

// main query
$query = "select " . implode(", ", array_keys($orderbycols)) . " from tbljob" . $searchquery . $orderby;
echo $query . "<br />";
$result = mysql_query($query);
?>

<body>
<table>
<tr>
<?
// columns that can be ordered
foreach($orderbycols as $key=>$value)
{
?>
	<td><?
	$hreforder = "";
	if(trim($orderby) != "" && $_GET['order'] == $key)
	{
		$hreforder = isset($_GET['desc']) && $_GET['desc'] == "true"?"":"&desc=true";
	}
	?><a href="<? echo basename($_SERVER['PHP_SELF']); ?>?order=<? echo $key . $hreforder; ?>"><? echo ucwords($value); ?></a></td>
	<?
}
?>

</tr>
<?
$bgc = "";
while($item = mysql_fetch_array($result))
{
	$bgc=($bgc=="#F7F7F7")?"#ffffff" : "#F7F7F7";	
	?>	
	<tr>
	<td><?=$item['Jobtitle']?></td>
	<td><?=$item['Jobcompany']?></td>	
	</tr>
	<? 
}

?>
</body>
</html>
<?
mysql_close();
?>

R0bb0b

Reputation Points: 358

Solved Threads: 89

Posting Shark

Offline

986 posts
since Jun 2008

Permalink

Oct 6th, 2008

Re: Please help me with sorting column heading

Dear Mr. R0bb0b,

Thanks so much for your kind support me all the time. Now it works fine.

Thanks you som much from the bottom of my heart.

Kindly regards,

Bunhok

Bunhok

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Ternary Operator

Next Thread in PHP Forum Timeline: Passing variable sql php

DaniWeb Message

Cancel Changes

User Name
Password