Getting value from HREF

Question

wish02 0 Newbie Poster

13 Years Ago

Hi! Im planning to make the entries of the Ticket # links to view the ticket information. But how do i pass the value of the clicked ticket# to the next page? thanks in advance!

<?php
session_start();
	if(!session_is_registered(myusername)){
		header("Location:main_login.php");
 	}
?>

<html>
<head>
<title>Employee</title>

<style type="text/css">
<!--
.tableContent {
    font-family:Euphemia;
    font-size: 13px;
    font-style: normal;
    color: #000;
}
.tableHead2 {	
    font-family: "Myriad Pro Light", "Myriad Pro";
	font-size: 14px;
	font-style: normal;
	font-weight: bold;
	color: #FFF;
}
-->
</style>

</head>


<body>
<tr>

</br>
  <table width="926" height="25" border="0"  style="text-align: center; font-weight: normal; border-collapse:collapse; border:1px solid #346198" cellpadding="2" cellspacing="2" id="myTable">
    <tr class="tableHead2">
      <td width="95" height="20" bgcolor="#346198"><div align="center">Ticket #</div></td>
      <td width="73" bgcolor="#346198"><div align="center">Asset ID</div></td>
      <td width="152" bgcolor="#346198"><div align="center">User</div></td>
      <td width="149" bgcolor="#346198"><div align="center">Location</div></td>
      <td width="95" bgcolor="#346198"><div align="center">Date Reported</div></td>
      <td width="77" bgcolor="#346198"><div align="center">Priority</div></td>
      <td width="78" bgcolor="#346198"><div align="center">Days Open</div></td>
      <td width="155" bgcolor="#346198"><div align="center">Requires Action Of</div></td>
    </tr>
     <?php
			include "..\configdb.php";
			include "..\opendb.php";
			
			$userId = $_SESSION['userId'];
			
			//GET ticket number
			$result = mysql_query("SELECT _ticketNum, _assets_id
								  FROM  trouble_ticket
								  WHERE _user_accounts_id='$userId' 
								  AND _ticketStatus='New' OR _ticketStatus='Open'");
			if(!$result) {
				echo 'Could not run query: ' . mysql_error();
				exit;
			}
			while($row=mysql_fetch_array($result))
			{
				$i;
				echo "<tr align='center' class='tableContent'>";   
				echo "<td>";
				if(strcmp($row['_ticketStatus'],'New'))
				{echo "<font color='#FF0000'> NEW </font>";}
				echo $row['_ticketNum'];
				echo "</td>";
				
						//GET asset control number
						$idAsset = $row['_assets_id'];
						$result1 = mysql_query("SELECT _controlNum
										  FROM  assets
										  WHERE _id='$idAsset'");
						while($row=mysql_fetch_array($result1))
						{
							$i;
							echo "<td>";
							echo $row['_controlNum'];
							echo "</td>";
							$controlNumber = $row['_controlNum'];
							$i++;
						}
						//GET user's name
						$result2 = mysql_query("SELECT _firstName, _lastName
									  FROM user_accounts
									  WHERE _id = '$userId'");
						while($row=mysql_fetch_array($result2))
						{
							$i;
							echo "<td>";
							echo $row['_firstName']." ".$row['_lastName'];
							echo "</td>";
							$i++;
						}	// end while loop
						//GET branch
						$result3 = mysql_query("SELECT _branchName 
											  FROM branch 
											  WHERE _id = (SELECT _branch_id FROM user_accounts WHERE _id='$userId')");
						while($row=mysql_fetch_array($result3))
						{
							$i;
							echo "<td>";
							echo $row['_branchName'];
							echo "</td>";
							$i++;
						}	// end while loop
				
						//GET date, priority, days open, ticket stat
						$result4= mysql_query("SELECT _dateReported, _priority, _daysOpen, _ticketStatus
											  FROM  trouble_ticket
											  WHERE _user_accounts_id='$userId' 
											  AND _ticketStatus='New' OR _ticketStatus='Open'");
						if($row=mysql_fetch_array($result4))
						{	
							echo "<td>";
							echo $row['_dateReported'];
							echo "</td>";
							echo "<td>";
							echo $row['_priority'];
							echo "</td>";
							echo "<td>";
							echo $row['_daysOpen'];
							echo "</td>";
							
							$stat = $row['_ticketStatus'];
							if(!strcmp($stat,"New"))
							{
								echo "<td>";
								echo "Technician";
								echo "</td>";
							}
						}
							
				
				echo "</tr>";
				$i++;
			}	// end while loop
      include "..\closedb.php";
	  ?>
  </table>
  </td>
  </tr>
  <tr>
    <td align="right">&nbsp;</td>
</body>
</html>

php

Edited 13 Years Ago by wish02 because: n/a

3 Contributors
7 Replies
113 Views
10 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by ayesha789

All 7 Replies

CFROG 9 Posting Pro in Training

13 Years Ago

If you are dealing with a single record, ticket #, link, etc.

<a href="http://mysite.com/view_ticket.php?id=<?php echo $row['_ticketNum']; ?>">Click Here</a>

On the next page (view_ticket.php)

$ticket_id = $_GET['id'];

If your are dealing with multiple ticket #'s and hyperlinks at the same time the process would be the same except it will be necessary to create your hyperlink from within the same loop that contains the ticket #.

Edited 13 Years Ago by CFROG because: n/a

CFROG 9 Posting Pro in Training

13 Years Ago

echo '<a href="itheadCMAssign_New_Ticket.php?id="'. $row['_ticketNum'];.'"">'.$row['_ticketNum'].'</a>';
//removed the second echo

There is a real good chance that iframe is the problem there, sorry I can't give you a definite answer on that one. I never use iframes for anything. IMHO Ajax is the better way to go.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

wish02 0 Newbie Poster · Answer 1 · 2010-06-16T09:49:50+00:00

echo '<a href="itheadCMAssign_New_Ticket.php?id="'.echo $row['_ticketNum'];.'"">'.$row['_ticketNum'].'</a>';

Parse error: syntax error, unexpected T_ECHO in C:\xampp\htdocs\joycee\ithead\itheadCM_New_Tickets.php on line 62

wish02 0 Newbie Poster · Answer 2 · 2010-06-16T10:00:17+00:00

i did this in the first page

$i;
                $ticketNum = $row['_ticketNum'];
				echo "<tr align='center' class='tableContent'>";
				echo "<td>";
                echo "<input type='radio' name='ticketNum' value='$ticketNum' />";
                echo "</td><td>";
				$ticket = $row['_ticketNum'];
				echo '<a href="itheadCMAssign_New_Ticket.php?id=$ticket">'.$row['_ticketNum'].'</a>';
				echo "</td>";

and this one on the next page

$ticketNum = $_GET['id'];
			$result = mysql_query("SELECT _assets_id, _user_accounts_id
								  FROM  trouble_ticket
								  WHERE _ticketNum ='$ticketNum'");

but it shows no results. it should show me the details but nothing appears on the screen

wish02 0 Newbie Poster · Answer 3 · 2010-06-16T10:04:04+00:00

does the iframe affect this problem? the url doesn't change, it is always the url of the main page that is shown in the address bar.

wish02 0 Newbie Poster · Answer 4 · 2010-06-16T11:00:50+00:00

wish02 0 Newbie Poster

13 Years Ago

oh okay.thanks!

ayesha789 7 Posting Pro in Training · Answer 5 · 2010-06-16T12:25:46+00:00

ayesha789 7 Posting Pro in Training

13 Years Ago

Please mark it as solved .

Getting value from HREF

Recommended Answers Collapse Answers

All 7 Replies

Recommended Answers