Hello hello,
this is one of the final things I need to do for my site!
I currently have a page that allows users to edit movies, code here:
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/connect.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/func.php';
$genrecheck = mysqli_query($link, 'SELECT genre_abbreviation, id FROM genres');
if (!$genrecheck)
{
$error = 'Error fetching info from database.';
include 'error.php';
exit();
}
while ($row = mysqli_fetch_array($genrecheck))
{
$genres[] = array('genre_abbreviation' => $row['genre_abbreviation'], 'id' => $row['id']);
}
$userid = mysqli_query($link, "SELECT id FROM members WHERE username = '$username'");
$row = mysqli_fetch_assoc($userid);
if (!$row)
{
$error = 'Error.';
include 'error.php';
exit();
}
$userid = $row['id'];
$moviecheck = mysqli_query($link, "SELECT movieid, moviename FROM movies WHERE userid='$userid'");
if (!$moviecheck)
{
$error = 'Error fetching info from database.';
include 'error.php';
exit();
}
while ($row = mysqli_fetch_array($moviecheck))
{
$movies[] = array('movieid' => $row['movieid'], 'moviename' => $row['moviename']);
}
?>
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/connect.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/func.php';
if(isset($_POST['editmovie_submit'])) {
$username = mysqli_real_escape_string($link, $_SESSION['username']);
$userid = mysqli_real_escape_string($link, $_SESSION['userid']);
$movieid = $_POST['movie'];
$genre = mysqli_real_escape_string($link, $_POST['genre']);
$region = mysqli_real_escape_string($link, $_POST['region']);
$status = mysqli_real_escape_string($link, $_POST['status']);
$wishlist = mysqli_real_escape_string($link, $_POST['wishlist']);
$date = html($_POST['year'] . '-' . $_POST['month'] . '-' . $_POST['day']);
$editmovie = mysqli_query($link, "UPDATE movies SET genreid='$genre', movieregion='$region', moviestatus='$status', wishlist='$wishlist', wishlistdate='$date' WHERE movieid='$movieid'");
if (!$editmovie)
{
$error = 'Error.';
include 'error.php';
exit();
}
else
header('Location: /movies.php?user=' . $username . '');
}
if(isset($_POST['editmovie_delete'])) {
$username = safe($link, $_SESSION['username']);
$movieid = $_POST['movie'];
$deletemovie = mysqli_query($link, "DELETE FROM movies WHERE movieid='$movieid'");
if (!$deletemovie)
{
$error = 'Error.';
include 'error.php';
exit();
}
else
header('Location: /movies.php?user=' . $username . '');
}
?>
<?php
if ($_GET['user'] != $_SESSION['username']) {
$error = 'Cannot add to or edit other users collections.';
include 'error.php';
exit();
}
?>
<form action="editmovie.php" method="post">
<label for="moviename"><strong>Select Movie:</strong></Label><br/>
<select name="movie" id="movies"/><br/>
<?php foreach ($movies as $movie): ?>
<option value="<?php echo $movie["movieid"]; ?>" name="movie"><?php echo $movie["moviename"]; ?></option>
<?php endforeach; ?>
</select><br/>
</div>
<strong>Region</strong><br/>
<input type="radio" name="region" id="regionUS" value="US" CHECKED /><label for="regionUS"> US</label>
<input type="radio" name="region" id="regionJP" value="JP"/><label for="regionJP"> JP</label>
<input type="radio" name="region" id="regionAU" value="AU"/><label for="regionAU"> AUSTRALIA</label>
<label for="genre"><strong>Genre</strong></Label>
<br/>
<select name="genre" id="genres">
<?php foreach ($genres as $genre): ?>
<option value="<?php htmlout($genre['id']); ?>" name="genre"><?php htmlout($genre['genre_abbreviation']); ?></option>
<?php endforeach; ?>
</select>
<label for="status"><strong>Status</strong></label><br/>
<input type="radio" name="status" value="UNWATCHED" CHECKED /> Unwatched
<input type="radio" name="status" value="WATCHED"/> Watched
<label for="wishlist"><strong>Wishlist?</strong></label><br/>
<input type="checkbox" name="wishlist" value="1"/>
<label for="date"><strong>Release Date (YYYY-MM-DD) (LEAVE BLANK IF MOVIE IS RELEASED):</strong></Label><br/>
<label for="year"><strong>Year:</strong></Label>
<label for="month"><strong>Month:</strong></Label>
<label for="day"><strong>Day:</strong></Label>
<input type="text" name="year" maxlength="4"/>
<input type="text" name="month" maxlength="2"/>
<input type="text" name="day" maxlength="2"/>
<input type="submit" name="editmovie_submit" value="Update Movie"/>
<input type="submit" name="editmovie_delete" value="Remove Movie"/>
but I am wondering if it possible for me to have only the ‘SELECT MOVIE’ option set come up, this part:
<label for="moviename"><strong>Select Movie:</strong></Label><br/>
<select name="movie" id="movies"/><br/>
<?php foreach ($movies as $movie): ?>
<option value="<?php echo $movie["movieid"]; ?>" name="movie"><?php echo $movie["moviename"]; ?></option>
<?php endforeach; ?>
</select><br/>
with a ‘select movie’ button added, and when that button is pressed, the page is reloaded and the rest of the form options appear and are filled out with the information from the selected movie in the ‘select movie’ form.
My question is, is this possible, and can I do it with just some changes to my current page or will I have to have another page to include or something?
Thanks for any tips!