Hej avminarm,
Undskylder den lange svartid, men har haft travlt. Har prøvet at rette lidt i koden, men der er sgu mange ting jeg ikke kan finde ud af. :o(
listDVDs.php ser nu sådan ud:
***** START *****
<?php
include './include/header.php';
session_start();
// is the one accessing this page logged in or not?
if (!isset($_SESSION['db_is_logged_in'])
|| $_SESSION['db_is_logged_in'] !== true) {
// not logged in, move to login page
header('Location: index.php');
exit;
}
include './include/opendb.php';
// Get all the data from the "dvds" table
$result = mysql_query("SELECT * from dvds ORDER BY title")
or die(mysql_error());
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">";
echo "<tr> <th> </th> <th> </th> <th class=\"listheading\">title</th> <th class=\"listheading\">genre</th> <th class=\"listheading\">Rating</th> <th class=\"listheading\">Year</th> <th class=\"listheading\">Version</th> <th class=\"listheading\">Sound</th> <th class=\"listheading\">Region</th> </tr>";
// keeps getting the next row until there are no more to get
$class = false;
while($row = mysql_fetch_array( $result ))
{
if($class == "odd")
{
$class = "even";
}
else
{
$class = "odd";
}
// Print out the contents of each row into a table
echo "<tr><td class=\"tablelist".$class."\">";
echo "<a href=\"editDVD.php?edit=$row[catalogue_number]\">Edit</a>";
echo "</td><td class=\"tablelist".$class."\">";
echo "<a href=\" SQL HJÆLP HER: SELECT * FROM dvds WHERE catalogue_number = '".$_GET['catalogue_number']."' \">Delete</a>";
echo "</td><td class=\"tablelist".$class."\">";
echo $row['title'];
echo "</td><td class=\"tablelist".$class."\">";
echo $row['genre'];
echo "</td><td class=\"tablelist".$class."\">";
echo ("<img src=\"./graphic/".$row['rating'].".gif\" alt=\"\">\n");
echo "</td><td class=\"tablelist".$class."\">";
echo $row['year_produced'];
echo "</td><td class=\"tablelist".$class."\">";
echo $row['version'];
echo "</td><td class=\"tablelist".$class."\">";
echo $row['sound_format'];
echo "</td><td class=\"tablelist".$class."\">";
echo $row['region'];
echo "</td></tr>";
}
echo "</table>";
include './include/closedb.php';
?>
</body>
</html>
***** SLUT *****
editDVD.php ser nu sådan ud (ved godt det ikke er rigtigt, men jeg har prøvet med så meget af din kode jeg forstod. Jeg har brug for lidt flere hints for at komme videre.):
***** START *****
<?php
include './include/header.php';
session_start();
// is the one accessing this page logged in or not?
if (!isset($_SESSION['db_is_logged_in'])
|| $_SESSION['db_is_logged_in'] !== true) {
// not logged in, move to login page
header('Location: index.php');
exit;
}
if(isset($_POST['add']))
{
include './include/opendb.php';
$catalogue_number = $_POST['catalogue_number'];
$title = $_POST['title'];
$genre = $_POST['genre'];
$year_produced = $_POST['year_produced'];
$sound_format = $_POST['sound_format'];
$region = $_POST['region'];
$version = $_POST['version'];
$rating = $_POST['rating'];
$date = date('y-m-d H:i:s');
$query = "INSERT INTO dvds (catalogue_number, title, genre, year_produced, sound_format, region, version, rating, date_created) VALUES ('$catalogue_number', '$title', '$genre', '$year_produced', '$sound_format', '$region', '$version', '$rating', '$date')";
mysql_query($query) or die(mysql_error());
include './include/closedb.php';
echo "New DVD added";
}
else
{
if(isset($_GET['edit'])){
$res = mysql_query("SELECT * FROM dvds WHERE catalogue_number = '".$_GET['catalogue_number']."'") or die(mysql_error());
while($row = mysql_fetch_array($res)){
$title = $row['title'];
$genre = $row['genre'];
}
}
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?do=edit">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100" class="formcaption">Catalogue Number</td>
<td><input name="catalogue_number" type="text" id="" value="<?php echo $_GET['catalogue_number']?>"></td>
</tr>
<tr>
<td width="100" class="formcaption">Title</td>
<td><input name="title" type="text" id=""value="<?php echo $title; ?>"></td>
</tr>
<tr>
<td width="100" class="formcaption">Genre</td>
<td>
<select name="genre" id="">
<option value ="Action">Action</option>
<option value ="Adventure">Adventure</option>
<option value ="Animation">Animation</option>
<option value ="Dokumentar">Dokumentar</option>
<option value ="Drama">Drama</option>
<option value ="Erotik">Erotik</option>
<option value ="Eventyr">Eventyr</option>
<option value ="Familiefilm">Familiefilm</option>
<option value ="Gangsterfilm">Gangsterfilm</option>
<option value ="Gyser">Gyser</option>
<option value ="Komedie">Komedie</option>
<option value ="Krigsfilm">Krigsfilm</option>
<option value ="Krimi">Krimi</option>
<option value ="Musical">Musical</option>
<option value ="Musik">Musik</option>
<option value ="Romance">Romance</option>
<option value ="Science Fiction">Science Fiction</option>
<option value ="Standup">Standup</option>
<option value ="Tegnefilm">Tegnefilm</option>
<option value ="Thriller">Thriller</option>
<option value ="Western">Western</option>
</select>
</td>
</tr>
<tr>
<td width="100" class="formcaption">Production year</td>
<td>
<select name="year_produced" id="">
<option value ="2006">2006</option>
<option value ="2005">2005</option>
<option value ="2004">2004</option>
<option value ="2003">2003</option>
<option value ="2002">2002</option>
<option value ="2001">2001</option>
<option value ="2000">2000</option>
<option value ="1999">1999</option>
<option value ="1998">1998</option>
<option value ="1997">1997</option>
<option value ="1996">1996</option>
<option value ="1995">1995</option>
<option value ="1994">1994</option>
<option value ="1993">1993</option>
<option value ="1992">1992</option>
<option value ="1991">1991</option>
<option value ="1990">1990</option>
<option value ="1989">1989</option>
<option value ="1988">1988</option>
<option value ="1987">1987</option>
<option value ="1986">1986</option>
<option value ="1985">1985</option>
<option value ="1984">1984</option>
<option value ="1983">1983</option>
<option value ="1982">1982</option>
<option value ="1981">1981</option>
<option value ="1980">1980</option>
<option value ="1979">1979</option>
<option value ="1978">1978</option>
<option value ="1977">1977</option>
<option value ="1976">1976</option>
<option value ="1975">1975</option>
<option value ="1974">1974</option>
<option value ="1973">1973</option>
<option value ="1972">1972</option>
<option value ="1971">1971</option>
<option value ="1970">1970</option>
<option value ="1969">1969</option>
<option value ="1968">1968</option>
<option value ="1967">1967</option>
<option value ="1966">1966</option>
<option value ="1965">1965</option>
<option value ="1964">1964</option>
<option value ="1963">1963</option>
<option value ="1962">1962</option>
<option value ="1961">1961</option>
<option value ="1960">1960</option>
</select>
</td>
</tr>
<tr>
<td width="100" class="formcaption">Sound format</td>
<td>
<select name="sound_format" id="">
<option value ="Dolby Digital 1.0 (Mono)">Dolby Digital 1.0 (Mono)</option>
<option value ="Dolby Digital 2.0 (Stereo)">Dolby Digital 2.0 (Stereo)</option>
<option value ="Dolby Digital 5.0">Dolby Digital 5.0</option>
<option value ="DTS">DTS</option>
</select>
</td>
</tr>
<tr>
<td width="100" class="formcaption">Region code</td>
<td>
<select name="region" id="">
<option value ="0">0</option>
<option value ="1">1</option>
<option value ="2">2</option>
<option value ="3">3</option>
<option value ="4">4</option>
<option value ="5">5</option>
<option value ="9">9</option>
</select>
</td>
</tr>
<tr>
<td width="100" class="formcaption">Version</td>
<td>
<select name="version" id="">
<option value ="Standard">Standard</option>
<option value ="Box Set">Box Set</option>
<option value ="Collectors Edition">Collectors Edition</option>
<option value ="Directors Cut">Directors Cut</option>
<option value ="Extended Edition">Extended Edition</option>
<option value ="Limited Edition">Limited Edition</option>
<option value ="Special Edition">Special Edition</option>
<option value ="Ultimate Edition">Ultimate Edition</option>
<option value ="Superbit Version">Superbit Version</option>
</select>
</td>
</tr>
<tr>
<td width="100" class="formcaption">Rating</td>
<td>
<select name="rating" id="">
<option value ="0">0</option>
<option value ="1">1</option>
<option value ="2">2</option>
<option value ="3">3</option>
<option value ="4">4</option>
<option value ="5">5</option>
<option value ="6">6</option>
</select>
</td>
</tr>
<tr>
<td width="100"> </td>
<td> </td>
</tr>
<tr>
<td width="120"> </td>
<td><input name="add" type="submit" id="" value="Finish editing DVD"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
***** SLUT *****
P.t. når jeg forsøger at editere en DVD, få jeg nedenstående fejl. Der er altså et eller andet adgangsproblem med den profil der bruges til at rette i DB'en. Det forstår jeg så ikke helt, for jeg bruger root konto'en:
***** START *****
Notice: Undefined index: catalogue_number in C:\Apache2\htdocs\dvd\editDVD.php on line 39
Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Apache2\htdocs\dvd\editDVD.php on line 39
Warning: mysql_query(): A link to the server could not be established in C:\Apache2\htdocs\dvd\editDVD.php on line 39
Access denied for user 'ODBC'@'localhost' (using password: NO)
***** SLUT *****
/Greg
