PHP inserting problem / edit help needed / Comments on coding~

Associate
Joined
14 May 2008
Posts
130
Hi,

Just came across a problem for a site i made for a friend, seems everytime i add a record it seems to add 'Array' into the database for one of the fields and i cant figure out why since it was working a few days ago~

In addition was wondering how i would go about an edit function, since my mate has to update one of the fields depending on his progress along with an echo that it has been edited on the page so any decent guides/help would be appreciated.

On a personal note would appreciate any comments on how to tidy my code up / better methods of doing what i done, since im still learning.

Kind regards
IS7doji

manage.png


PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<title>Manage Commission Status</title>
	<link rel="stylesheet" type="text/css" href="css/core-style.css" />
</head>
<body>
	<div id = "Container">
	<div id = "Title"></div>
	<div id = "Banner"></div>	
	<div id = "Menu">
		<ul>
			<li><a title="Home" href="update.php">Updates</a></li>
			<li><a title="Home" href="manage_commission_status.php">Manage Commission Status</a></li>
			<li><a title="Home" href="manage_concept_art.php">Manage Concept Art</a></li>
			<li><a title="Home" href="upload_concept_art.php">Upload Concept Art</a></li>
		</ul>
	</div>
	
	<div id = "Content">
		<h1>Manage Commission Status</h1>
		
		<?php
		if($_GET['ac'])
		{
		$link = mysql_connect('127.0.0.1', 'USERNAME', 'PASSWORD')
		or die('Connection Failed');
		mysql_select_db('USERNAME_DB') or die('Could not select database');

		$query = 'DELETE FROM DB_commission_status WHERE ticket_number="' . $_GET['ticket_number'] . '"';
		$result = mysql_query($query) or die('Query Failed');

		mysql_close($link);
		}
		else if($_POST['submit'])
		{
		$link = mysql_connect('127.0.0.1', 'USERNAME', 'PASSWORD') or die('Connection Failed');
		mysql_select_db('USERNAME_DB') or die('Could not select database');


		$sql="INSERT INTO DB_commission_status (ticket_number, name, suit, status, waiting_list) VALUES ('$_POST[ticket_number]','$_POST[name]','$_POST[suit]','$_POST[status]', '$_POST		[waiting_list]')";

		if (!mysql_query($sql,$link))
	 	{
	 		die('Error: ' . mysql_error());
	 	}
		echo "1 record added";
		mysql_close($link);
		}

		$text = "<hr>Delete a record from the status<br /><br/><table>";

		$link = mysql_connect('127.0.0.1', 'USERNAME', 'PASSWORD')	or die('Connection Failed');
		mysql_select_db('USERNAME_DB') or die('Could not select database');

		$query = 'SELECT * FROM DB_commission_status ORDER BY ticket_number';
		$result = mysql_query($query) or die('Query Failed');

		while($row = mysql_fetch_array($result, MYSQL_ASSOC))
		{
		$text = $text . "
		<tr class =$status><td>{$row['ticket_number']}</td>" .
		"<td>{$row['name']}</td>" .
		"<td>{$row['suit']}</td>" .
		"<td>{$row['status']}</td>" .
		"<td>{$row['waiting_list']}</td>" .
		"<td><a href='manage_commission_status.php?ac=del&ticket_number={$row['ticket_number']}'>Delete</a></td></tr>";
	}

		$text = $text . "</table>

		<form method='post' action='manage_commission_status.php'>

		<br />
		<hr>
		Add status

	<table>
	<tr>
		<td>ticket number:</td>
		<td><input type='text' name='ticket_number'></td>
	</tr>
	<tr>
		<td>name:</td>
		<td><input type='text' name='name'></td>
	</tr>
	<tr>
		<td>suit:</td>
		<td><input type='text' name='suit'></td>
	</tr>
	<tr>
		<td>status:</td>
		<td><input type='text' name='status'></td>
	</tr>
	<tr>
		<td>waiting list:</td>
		<td><input type='text' name='waiting_list'></td>
	</tr>
	<tr>
		<td><input type='submit' name='submit' value='submit'></td>
	</tr>
	</table>
	</form>
	<br/><br/>
	";

	echo $text;
	?>
		

	</div>
	
	<div id = "Footer"> </div>
	
	</div>

</body>
</html>
 
Thanks will have a read of that tomorrow =] and do some updates to the input form. Will try echo the variables out tomorrow aswell to see if there being stored properly tho dont know why one day it works the next it stops tho xD
 
Back
Top Bottom