Chapter 6 Admin.php

Cottsie · March 28th, 2013, 01:30 PM

Hi all

I am completely new to PHP and I have taken the code directly from the download source of this publishing book. I wanted to see it all working first before I delved in. So I can display my admin.php which shows a table with the add, edit and delete options visible. As soon as I select either the add or edit option, I get the following error

The web page at http://localhost:8080/movies/movie.php?action=add might be temporarily down or it may have moved permanently to a new web address.
Error 103 (net::ERR_CONNECTION_ABORTED): Unknown error.

Reading this above I understand that it is trying to go to the movie.php but cannot get there. I can confirm that movie.php is there.

Yet if I pick the delete option it does ask me do I want to delete the record, which tells me that the delete.php is been read.

Bear with me, as this might just be an easy answer, but I am completely new.

Thanks

Cottsie

David 2 · August 17th, 2013, 06:19 AM

Code:

hi
may it will help you:

<?php
$db=mysql_connect('localhost', 'bp6am', 'bp6ampass') or die('Unable to connect. Check your connection parameters!');
mysql_select_db('moviesite', $db) or die(mysql_error($db));
if($_GET['action'] == 'edit') {

			//retrieve the recordâs information
			$query='SELECT
				movie_name, movie_type, movie_year, movie_leadactor,
				movie_director
				FROM
				movie
				WHERE
				movie_id = ' . $_GET['id'];
			$result=mysql_query($query, $db) or die(mysql_error($db));
			extract(mysql_fetch_assoc($result));

} else {
	//Set velues to blank ESEIGI $_GET['action'] == [ADD]-s amitom qvedebi arian 0-ebi anu carielebi rom airchio shenit
	$movie_name='';
	$movie_type=0;
	$movie_year=date("Y");
	$movie_leadactor=0;
	$movie_director=0;
}
?>

<html>
<head><title><?php echo ucfirst($_GET['action']); ?> Movie</title>
</head>
<body>

<form action="commit.php?action=<?php echo $_GET['action']; ?>& type=movie"
method="post">
<table>
	<tr>
	<td>Movie Name</td>
	<td><input type="text" name="movie_name"	value="<?php echo $movie_name; ?>" /></td>
						<!--value="..." imitoa ase rom tu $_GET['action']==[EDIT] name velshi 							dagxvdes "axla shecvlamde" arsebuli "movie_name"-i, romelic "movie" table-shia-->
	</tr><tr>
	<td>Movie Type</td>
	<td><select name="movie_type">
<?php
	// select the movie type information
$query='SELECT 
	movietype_id, movietype_label
	FROM
	movietype
	ORDER BY 
	movietype_label';
$result=mysql_query($query, $db) or die(mysql_error($db));
	// populate the select options with the results

while ($row = mysql_fetch_assoc($result)) {
foreach ($row as $value) {
	if($row['movietype_id'] == $movie_type) {
echo '<option value="' . $row['movietype_id'] . '
	"selected=selected">';
	} else {
echo '<option value="' . $row['movietype_id'] . '">';
	}
echo $row['movietype_label'] . '</option>';
}
}
?>
</select></td>
</tr><tr>
	<td>Movie Year</td>
	<td><select name="movie_year">
<?php
	// populate the select options with years
for($yr=date("Y"); $yr >=1970; $yr--) {
	if($yr == $movie_year) {
	echo '<option value="' . $yr . '" selected="selected">' .
		$yr . '</option>';
	} else {
		echo '<option value="' . $ye . '">' . $yr . '</option>';
	}
}
?>
</select></td>
	</tr><tr>
	<td>Lead Actor</td>
	<td><select name="movie_leadactor">
<?php
$query='SELECT
	people_id, people_fullname
	FROM
	people
	WHERE
	people_isactor= 1
	ORDER BY
	people_fullname';
$result=mysql_query($query, $db) or die(mysql_error($db));

	// populate the select options with the results
while($row=mysql_fetch_assoc($result)) {	
	foreach($row as $value) {
		if($row['people_id'] == $movie_leadactor) {
		     echo '<option value="' . $row['people_id'] . '" selected="selected">';
		} else {
	echo '<option value="' . $row['people_id'] . '">'; 
		}
	echo $row['people_fullname'] . '</option>';
	}
}
?>
</select></td>
	</tr><tr>
	<td>Movie Director</td>
	<td><select name="movie_director">
<?php
	// select director records
$query='SELECT
	people_id, people_fullname
	FROM
	people
	WHERE
	people_isdirector = 1
	ORDER BY
	people_fullname';
$result=mysql_query($query, $db) or die(mysql_error($db));

	// populate the select options with the results
while($row=mysql_fetch_assoc($result)) {
	foreach($row as $value) {
		if($row['people_id'] == $movie_director) {
	echo '<option value="' . $row['people_id'] . '" selected="selected">';
		} else {
		echo '<option value="' . $row['people_id'] . '">';
		}
	echo $row['people_fullname'] . '</option>';
	}	
}
?>
</select></td>
</tr>
<tr>
<td colspan="2" style="text-align: center;">
		<?php
		if($_GET['action'] == 'edit') {
			echo '<input type="hidden" value="' . $_GET['id'] . '"  name="movie_id" />';
		}
		?>

	<input type="submit" name="submit" value="<?php echo ucfirst($_GET['action']); ?>" />
</td>
</tr>
</table>
</form>
</body>
</html>

David 2 · August 17th, 2013, 10:47 AM

P.S.
if select boxes will list items show twice - please remove foreach(...) fonctions in the While () loops