Little problems:
1: Your php version is hideously out of date.
2:line 21 </stlye> change to </style>
3:line 23 movie,php:action=add change to movie.php:action=add
4: line 36/37 a href change to <a href
Big problems and fix.
Line 7:
mysql_select_db("db_name", $connect); // No connection declared.
Show that it is working:
http://filedrop.test-platform.co.uk/php/db_test.php
Codešchanged and working)
<?php
$connect = mysql_connect("SERVER","DATABASE","PASSWORD") or die ("Hey Loser check your server connection.");
mysql_select_db("DATABASE", $connect);
?>
<html>
<head>
<title>Movie Database</title>
<style type="text/css">
th { background-color: #999;}
.odd_row { bacground-color: #EEE;}
.even_row { background-color: #FFF;}
</style>
</head>
<body>
<table style="width:100%;">
<tr>
<th colspan="2">Movies <a href="movie,php:action=add">[ADD]</a></th>
</tr>
<?php
$query= 'SELECT * FROM movie';
$results=mysql_query($query) or die ("Error in |$query| " . mysql_error());
$odd=true;
while ($row=mysql_fetch_assoc($results)) {
echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
$odd= !$odd;
echo '<td style="width:75%;">';
echo $row['movie_name'];
echo '</td><td>';
echo '<a href="movie.php?action=edit&id=' . $row['movie_id'] . '">[EDIT]</a>';
echo '<a href="delete.php>type=moivie&id=' . $row['movie_id'] . '">[DELETE]</a>';
echo '</td></tr>';
}
?>
<tr>
<th colspan="2">People<a href="people.php?action=add"> {ADD}</a></th>
</tr>
<?php
$query= 'SELECT * FROM people';
$results=mysql_query($query) or die ("Error in |$query| " . mysql_error());
$odd= true;
while ($row = mysql_fetch_assoc($results)) {
echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
$odd= !$odd;
echo '<td style="width: 25%;">';
echo $row['people_fullname'];
echo '</td><td>';
echo ' <a href="people.php?action=edit&id=' . $row['people_id'] . '"> [EDIT]</a>';
echo ' <a href="delete.php?type=people&id=' . $row['people_id'] . '"> {DELETE]</a>';
echo '</td></tr>';
}
?>
</table>
</body>
</html>
SQL that i used to test it:
CREATE TABLE IF NOT EXISTS `movie` (
`movie_id` int(11) NOT NULL AUTO_INCREMENT,
`movie_name` varchar(90) NOT NULL,
PRIMARY KEY (`movie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `movie` (`movie_id`, `movie_name`) VALUES
(1, 'Predator'),
(2, 'Predator 2');
CREATE TABLE IF NOT EXISTS `people` (
`people_id` int(11) NOT NULL AUTO_INCREMENT,
`people_fullname` varchar(90) NOT NULL,
PRIMARY KEY (`people_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `people` (`people_id`, `people_fullname`) VALUES
(1, 'Arnold Schwarznegger'),
(2, 'Sylvester Stallone');
