Jump to content

Array for status:

3raser

By 3raser
in PHP Coding Help

Recommended Posts

3raser Advanced Member

3raser

Posted
Posted

Problem:

 

I'm trying to make it so the array responds to the integer of status in the database. So, to check if it's one, I try this:

 

$get["status"]["1"] = "Message here...";

 

But, on my result, I'm just getting WWTT - And the value in the database for the ticket is 0. I'm not sure if I'm using the array correctly.

 

My full code:

 

<?php
session_start();
include("../includes/mysql.php");
include("../includes/config.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" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div id="container">
<div id="content">
	<div id="left">
		<div class="menu">
			<?php include("../includes/navigation.php"); ?>
			<div class="menufooter"></div>
		</div>
		<?php include("../includes/menu.php"); ?>
	</div>
	<div id="middle">
		<?php
		$existing = $_POST['existing'];

		$query = mysql_query("SELECT COUNT(id),id,status,date,question,title FROM tickets WHERE id='$existing'");
		$get = mysql_fetch_assoc($query);

		if(!$existing)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>You have not enetered in a ticket ID. Please go back and do so.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		elseif($get['COUNT(id)'] < 1)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>The ticket ID you are trying to use doesnt exist. Please go back or submit another ticket.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		else
		{
		$get["status"]["0"] = "Waiting for support...";
		$get["status"]["1"] = "Waiting for user...";
		$get["status"]["2"] = "Ticket Closed...";
		$get["status"]["3"] = "Ticket Opened...";

		echo 
		'
		<div class="post">
			<div class="postheader"><h1>View Ticket Status - ID '. $get["id"] .'</h1></div>
			<div class="postcontent">
				<p>Title: '. $get["title"] .' - Posted on: '. $get["date"] .'</p>
				<p>Ticket Status: '. $get["status"] .'</p>
				<p>Question: '. nl2br($get["question"]) .'</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';

		}
		?>
		</div>
	</div>
</div>
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/
Share on other sites
wildteen88 Regular Member

wildteen88

Posted
Posted

You're not displaying your status properly as these variables

			$get["status"]["0"] = "Waiting for support...";
		$get["status"]["1"] = "Waiting for user...";
		$get["status"]["2"] = "Ticket Closed...";
		$get["status"]["3"] = "Ticket Opened...";

Will overwrite the value from your database . Instead of using $get['status'] name your array as $status, eg

			$status[0] = "Waiting for support...";
		$status[1] = "Waiting for user...";
		$status[2] = "Ticket Closed...";
		$status[3] = "Ticket Opened...";

Now change

					<p>Ticket Status: '. $get["status"] .'</p>

to

					<p>Ticket Status: '. $status[$get["status"]] .'</p>

Now it should echo out the correct status message depending on the value of the status field.

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1095318
Share on other sites
3raser Advanced Member

3raser

Posted
  • Author
Posted

Thank you guys!

 

And one more question, since I don't need to create a new topic:

 

$query = mysql_query("SELECT COUNT(tickets.id),tickets.id,tickets.status,tickets.date,tickets.question,tickets.title,users.position FROM tickets,users WHERE tickets.id='$existing' users.username='$username'");

 

How do I get it so it selects data from the table tickets where id='$existing', but I also want to get a user's (who is viewing the ID) position (rank). $username is a session. So, any thoughts on how I would do so?

 

My updated code:

 

<?php
session_start();
include("../includes/mysql.php");
include("../includes/config.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" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div id="container">
<div id="content">
	<div id="left">
		<div class="menu">
			<?php include("../includes/navigation.php"); ?>
			<div class="menufooter"></div>
		</div>
		<?php include("../includes/menu.php"); ?>
	</div>
	<div id="middle">
		<?php
		$existing = $_POST['existing'];
		$ip = $_SERVER['REMOTE_ADDR'];
		$username = $_SESSION['user'];

		$query = mysql_query("SELECT COUNT(tickets.id),tickets.id,tickets.status,tickets.date,tickets.question,tickets.title,users.position FROM tickets,users WHERE tickets.id='$existing' OR users.username='$username'");
		$get = mysql_fetch_assoc($query);

		if(!$existing)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>You have not enetered in a ticket ID. Please go back and do so.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		elseif($get['COUNT(id)'] < 1)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>The ticket ID you are trying to use doesnt exist. Please go back or submit another ticket.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		elseif($get['tickets.ip']==$ip || $get['user.position'] >= 1)
		{
		$status["tickets.status"]["0"] = "Waiting for support...";
		$status["tickets.status"]["1"] = "Waiting for user...";
		$status["tickets.status"]["2"] = "Ticket Closed...";
		$status["tickets.status"]["3"] = "Ticket Opened...";

		echo 
		'
		<div class="post">
			<div class="postheader"><h1>View Ticket Status - ID '. $get["id"] .'</h1></div>
			<div class="postcontent">
				<p>Title: '. $get["tickets.title"] .' - Posted on: '. $get["tickets.date"] .'</p>
				<p>Ticket Status: '. $status[$get["tickets.status"]] .'</p>
				<p>Question: '. nl2br($get["tickets.question"]) .'</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';

		}
		else
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>This is not your ticket. You only have permission to view your tickets. Please go back.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		?>
		</div>
	</div>
</div>
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1095319
Share on other sites
3raser Advanced Member

3raser

Posted
  • Author
Posted

You're not displaying your status properly as these variables

			$get["status"]["0"] = "Waiting for support...";
		$get["status"]["1"] = "Waiting for user...";
		$get["status"]["2"] = "Ticket Closed...";
		$get["status"]["3"] = "Ticket Opened...";

Will overwrite the value from your database . Instead of using $get['status'] name your array as $status, eg

			$status[0] = "Waiting for support...";
		$status[1] = "Waiting for user...";
		$status[2] = "Ticket Closed...";
		$status[3] = "Ticket Opened...";

Now change

					<p>Ticket Status: '. $get["status"] .'</p>

to

					<p>Ticket Status: '. $status[$get["status"]] .'</p>

Now it should echo out the correct status message depending on the value of the status field.

 

It doesn't work. :(

 

		$status["status"][0] = "Waiting for support...";
		$status["status"][1] = "Waiting for user...";
		$status["status"][2] = "Ticket Closed...";
		$status["status"][3] = "Ticket Opened...";

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1095747
Share on other sites
sinista Member

sinista

Posted
Posted

not sure that im reading this correctly  but your pulling an value from a database, to control the error message?

 

does this work?

 

<?php
//status messgaes
$get["status"]["0"] = "Waiting for support...";
$get["status"]["1"] = "Waiting for user...";
$get["status"]["2"] = "Ticket Closed...";
$get["status"]["3"] = "Ticket Opened...";

//value pulled from database i.e. $a = row['value'], from a request $a = $_GET['value']
$a =1;

echo "<p>Ticket Status: ".$get["status"][$a]."</p>";
?>

 

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1095760
Share on other sites
wildteen88 Regular Member

wildteen88

Posted
Posted

You're not displaying your status properly as these variables

			$get["status"]["0"] = "Waiting for support...";
		$get["status"]["1"] = "Waiting for user...";
		$get["status"]["2"] = "Ticket Closed...";
		$get["status"]["3"] = "Ticket Opened...";

Will overwrite the value from your database . Instead of using $get['status'] name your array as $status, eg

			$status[0] = "Waiting for support...";
		$status[1] = "Waiting for user...";
		$status[2] = "Ticket Closed...";
		$status[3] = "Ticket Opened...";

Now change

					<p>Ticket Status: '. $get["status"] .'</p>

to

					<p>Ticket Status: '. $status[$get["status"]] .'</p>

Now it should echo out the correct status message depending on the value of the status field.

 

It doesn't work. :(

 

		$status["status"][0] = "Waiting for support...";
		$status["status"][1] = "Waiting for user...";
		$status["status"][2] = "Ticket Closed...";
		$status["status"][3] = "Ticket Opened...";

Get rid of ["status"]

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1096013
Share on other sites
3raser Advanced Member

3raser

Posted
  • Author
Posted

You're not displaying your status properly as these variables

			$get["status"]["0"] = "Waiting for support...";
		$get["status"]["1"] = "Waiting for user...";
		$get["status"]["2"] = "Ticket Closed...";
		$get["status"]["3"] = "Ticket Opened...";

Will overwrite the value from your database . Instead of using $get['status'] name your array as $status, eg

			$status[0] = "Waiting for support...";
		$status[1] = "Waiting for user...";
		$status[2] = "Ticket Closed...";
		$status[3] = "Ticket Opened...";

Now change

					<p>Ticket Status: '. $get["status"] .'</p>

to

					<p>Ticket Status: '. $status[$get["status"]] .'</p>

Now it should echo out the correct status message depending on the value of the status field.

 

It doesn't work. :(

 

		$status["status"][0] = "Waiting for support...";
		$status["status"][1] = "Waiting for user...";
		$status["status"][2] = "Ticket Closed...";
		$status["status"][3] = "Ticket Opened...";

Get rid of ["status"]

 

If I get rid of status, it wont know what I'm trying to grab from the database...

 

<?php
session_start();
include("../includes/mysql.php");
include("../includes/config.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" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div id="container">
<div id="content">
	<div id="left">
		<div class="menu">
			<?php include("../includes/navigation.php"); ?>
			<div class="menufooter"></div>
		</div>
		<?php include("../includes/menu.php"); ?>
	</div>
	<div id="middle">
		<?php
		if(!$_POST['existing'])
		{
		$existing = $_GET['existing'];
		}
		else
		{
		$existing = $_POST['existing'];
		}

		$reply = $_POST['answer'];
		$ip = $_SERVER['REMOTE_ADDR'];
		$username = $_SESSION['user'];

		$query_user = mysql_query("SELECT position FROM users WHERE username='$username'");
		$get_position = mysql_fetch_assoc($query_user);

		$query = mysql_query("SELECT COUNT(id),id,status,date,question,title,username FROM tickets WHERE id='$existing'");
		$get = mysql_fetch_assoc($query);

		if(!$existing)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>You have not enetered in a ticket ID. Please go back and do so.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		elseif($get['COUNT(id)'] < 1)
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>The ticket ID you are trying to use doesnt exist. Please go back or submit another ticket.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		elseif($get['ip']==$ip || $get_position['position'] >= 1)
		{
		$get["status"][0] = "Waiting for support...";
		$get["status"][1] = "Waiting for user...";
		$get["status"][2] = "Ticket Closed...";
		$get["status"][3] = "Ticket Opened...";

		if($username==$get["username"])
		{
			$message = "<p><a href='view.php?close=". $get['id'] ."&existing=". $get['id'] ."'>[CLOSE]</a></p>";
		}

		echo 
		'
		<div class="post">
			<div class="postheader"><h1>View Ticket Status - ID '. $get["id"] .'</h1></div>
			<div class="postcontent">
				'. $message .'
				<p>Title: '. $get["title"] .'<br/>Posted on: '. $get["date"] .'<br/>Posted by: '. $get["username"] .'</p>
				<p>Ticket Status: '. $get["status"]['. $get["status"] .'] .'</p>
				<p>Question: '. nl2br($get["question"]) .'</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
			if(!$reply)
			{
			if(!$_GET['reply'])
			{

			echo 
			'
			<div class="post">
				<div class="postheader"><h1>Replies</h1></div>
				<div class="postcontent">
				<p><a href="view.php?reply='. $get["id"] .'&existing='.  $existing .'">Reply</a></p>
			';

			$replies = mysql_query("SELECT username,date,message FROM replies WHERE tid='{$get["id"]}'");
			while ($row = mysql_fetch_assoc($replies))
			{
				echo '<p>Username: '. $row["username"] .' Post Date: '. $row["date"] .'<br/>
				'. nl2br($row["message"]) .'
				</p>';
			}

			echo
			'
				<p><a href="view.php?reply='. $existing .'&existing='. $existing .'">Reply</a></p>
				</div>
				<div class="postfooter"></div>
			</div>
			';

			}
			else
			{
			echo '
				<div class="post">
				<div class="postheader"><h1>Post a reply</h1></div>
				<div class="postcontent">
				<p>Replying to Ticket ID '. $get["id"]. '...</p>

				<center><form action="view.php" method="POST"><table border="0">
				<input type="hidden" name="existing" value="'.  $existing .'">
				<tr><th>Reply/Answer</th><td><textarea name="answer" rows="10" cols="25" maxlength="1000"></textarea></td></tr>
				<tr><th></th><td><input type="submit" value="Submit"></td></tr>
				</center></table></form>
				</div>
				<div class="postfooter"></div>
			</div>
			';
			}
			}
			else
			{
			$date = date("m-d-y");
			mysql_query("INSERT INTO replies VALUES ('', '$existing', '$date', '$reply', '$username')");

			echo '	<div class="post">
				<div class="postheader"><h1>Posted</h1></div>
				<div class="postcontent">
				<p>Your reply has been added! <a href="view.php?existing='. $existing .'">Return to Ticket</a></p>
				</div>
				<div class="postfooter"></div>
			</div>
			';
			}
		}
		else
		{
		echo 
		'
		<div class="post">
			<div class="postheader"><h1>Error</h1></div>
			<div class="postcontent">
				<p>This is not your ticket. You only have permission to view your tickets. Please go back.</p>
			</div>
			<div class="postfooter"></div>
		</div>
		';
		}
		?>
		</div>
	</div>
</div>
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1096508
Share on other sites
wildteen88 Regular Member

wildteen88

Posted
Posted

You've got it all wrong.

			$get["status"][0] = "Waiting for support...";
		$get["status"][1] = "Waiting for user...";
		$get["status"][2] = "Ticket Closed...";
		$get["status"][3] = "Ticket Opened...";

Here you're overwriting the value coming from your database ($get['status']) as you're redefining the variable $get['status'] to an array, variables with the same name cannot store two different values.

 

This is why I suggested you to define your various status messages within a separate array ($status), as I posted earlier

			$status[0] = "Waiting for support...";
		$status[1] = "Waiting for user...";
		$status[2] = "Ticket Closed...";
		$status[3] = "Ticket Opened...";

 

Now the variable $get['status'] holds the array index that corresponds to a status message within the $status array. To display the status message you'd use 

echo $status[$get['status']];

 

So if $get['status'] is set to the value of 2, then the above will display "Ticket Closed...", if it was set to 1 then it'll display "Waiting for user..." etc.

Link to comment
https://forums.phpfreaks.com/topic/209835-array-for-status/#findComment-1096562
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.