Forum PHP.pl

Witam, mam problem z pewnym zadaniem z książki PHP5 Apache i MySql od podstaw. Niestety po wielu godzinach bezsensownej straty czasu na szukanie rozwiązania muszę zwrócic się do bardziej doswiadczonych.


Zapytania i wywołanie (tu jest problem):

[PHP] pobierz, plaintext 
link= mysql_connect("localhost", "root", "");
 
mysql_select_db("moviesite");
 
$query= "SELECT movie_name, movie_director, movie_leadactor " .
	"FROM movie";
 
	$result = mysql_query($query, $link)  
	or die (mysql_error());
 
	$num_movies = mysql_num_rows($result);
 
$movie_header = <<<EOL
<h2> <center> Baza Danych Recenzji filmow </center> </h2>
<table width = "70%" border="1" cellpadding="2" cellspacing="2" align = "center" >
 
<tr> 
<th> Tytul filmu </th>
<th> Rezyser</th>
<th> Glowny aktor </th>
</tr>
 
EOL;
 
function get_director (){
global $movie_director;
global $director;
 
$query_d = "SELECT people_fullname ".
	"FROM people ".
	"WHERE people_id = '$movie_director'";
 
	$result_d = mysql_query($query_d) or die (mysql_error());
	$row_d = mysql_fetch_array($result_d);
	extract($row_d);
	$director=$people_fullname;
 
}
 
 
function get_leadactor (){
global $movie_leadactor;
global $leadactor;
 
$query_z = "SELECT people_fullname ".
	"FROM people ".
	"WHERE people_id = '$movie_leadactor'";
 
	$result_z = mysql_query($query_z) or die (mysql_error());
	$row_z = mysql_fetch_array($result_z);
	extract($row_z);
	$leadactor=$people_fullname;
 
}
 
get_director();
get_leadactor();
$movie_details = ' ';
while ($row = mysql_fetch_array($result)){
$movie_name= $row['movie_name'];
$movie_director = $row['movie_director'];
$movie_leadactor= $row['movie_leadactor'];
$movie_details .=<<<EOD
<tr>
<td>$movie_name</td>
<td>$director</td>
<td>$leadactor</td>
</tr>
EOD;
}
 
$movie_details .=<<<EOD
<tr>
<td>&nbsp</td>
</tr>
<tr>
<td>Laczenie filmow: $num_movies</td>
</tr>
EOD;
 
 
 
$movie_footer= "</table>";
 
$movie =<<<MOVIE
		$movie_header
		$movie_details
		$movie_footer
 
 
MOVIE;
 
echo "W bazie danych znajduje sie $num_movies filmow";
echo $movie;
[PHP] pobierz, plaintext 

Baza:

[PHP] pobierz, plaintext 
<?php
$connect = mysql_connect("localhost", "root", "") or die ("sprawdz polaczenie");
 
$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") 
or die(mysql_error());
 
 
 
 
mysql_select_db("moviesite");
 
 
 $movie = "CREATE TABLE movie (
    movie_id int(11) NOT NULL auto_increment,
    movie_name varchar(255) NOT NULL,
    movie_type tinyint(2) NOT NULL 
    \default 0,
    movie_year int(4) NOT NULL default 0,
    movie_leadactor int(11) NOT NULL default 0,
    movie_director int(11) NOT NULL default 0,
    PRIMARY KEY (movie_id),
    KEY movie_type (movie_type,movie_year)
    )";
 
 
$results = mysql_query($movie);
 
 $movietype ="CREATE TABLE movietype (
 movietype_id int(11) NOT NULL auto_increment,
 movietype_label varchar (100) NOT NULL,
 PRIMARY KEY (movietype_id)
 )";
 
 
 $results= mysql_query($movietype) ;
 
 $people ="CREATE TABLE people (
 people_id int(11) NOT NULL auto_increment,
 people_fullname varchar(255) NOT NULL,
 people_isactor tinyint(1) NOT NULL default 0,
 people_isdirector tinyint(1) NOT NULL default 0,
 PRIMARY KEY (people_id)
 )";
 
 $results=mysql_query($people) or die (mysql_error());
 
 echo "pp";
 
?>
[PHP] pobierz, plaintext 

I wypełnienie:

[PHP] pobierz, plaintext 
<?php
$connect = mysql_connect("localhost", "root", "") or die ("sprawdz polaczenie");
 
$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") 
or die(mysql_error());
 
 
 
 
mysql_select_db("moviesite");
 
 
 $movie = "CREATE TABLE movie (
    movie_id int(11) NOT NULL auto_increment,
    movie_name varchar(255) NOT NULL,
    movie_type tinyint(2) NOT NULL 
    \default 0,
    movie_year int(4) NOT NULL default 0,
    movie_leadactor int(11) NOT NULL default 0,
    movie_director int(11) NOT NULL default 0,
    PRIMARY KEY (movie_id),
    KEY movie_type (movie_type,movie_year)
    )";
 
 
$results = mysql_query($movie);
 
 $movietype ="CREATE TABLE movietype (
 movietype_id int(11) NOT NULL auto_increment,
 movietype_label varchar (100) NOT NULL,
 PRIMARY KEY (movietype_id)
 )";
 
 
 $results= mysql_query($movietype) ;
 
 $people ="CREATE TABLE people (
 people_id int(11) NOT NULL auto_increment,
 people_fullname varchar(255) NOT NULL,
 people_isactor tinyint(1) NOT NULL default 0,
 people_isdirector tinyint(1) NOT NULL default 0,
 PRIMARY KEY (people_id)
 )";
 
 $results=mysql_query($people) or die (mysql_error());
 
 echo "pp";
 
?>
[PHP] pobierz, plaintext 

Sama baza i wypełnienie działa, utknąłem na wypełnianiu tabeli.

Stosujac przedstawiony wyżej kod otrzymuje:

Warning: extract() expects parameter 1 to be array, boolean given in C:\a\xampp\htdocs\nauka\r1\tabel1.php on line 36

Notice: Undefined variable: people_fullname in C:\a\xampp\htdocs\nauka\r1\tabel1.php on line 37

Warning: extract() expects parameter 1 to be array, boolean given in C:\a\xampp\htdocs\nauka\r1\tabel1.php on line 52

Notice: Undefined variable: people_fullname in C:\a\xampp\htdocs\nauka\r1\tabel1.php on line 53



Stosujac kod znaleziony gdzies w necie:

[PHP] pobierz, plaintext 
<?php
$link =mysql_connect("localhost", "root", "")
	or die(mysql_error());
mysql_select_db("moviesite")
	or die(mysql_error());
	$query = "SELECT movie_name, movie_director, movie_leadactor " .
			"FROM movie";
 
$result = mysql_query($query, $link)
	or die(mysql_error());
$num_movies = mysql_num_rows($result);
$movie_header=<<<EOD
<h2><center>Movie Review Database</center</h2>
<table width="70%" border="1" cellpadding="2"
	cellspacing="2" align="center">
		<tr>
			<th>Movie Title</th>
			<th>Year of Release</th>
			<th>Movie Director</th>
			<th>Movie Lead Actor</th>
			<th>Movie Type</th>
		</tr>
 
EOD;
 
function get_director(){
	global $movie_director;
	global $director;
 
	$query_d = "SELECT people_fullname " .
				"FROM people " .
				"WHERE people_id = '$movie_director'";
	$results_d = mysql_query($query_d)
		or die(mysql_error());
	$row_d = mysql_fetch_array($results_d);
	extract($row_d);
	$director = $people_fullname;
}
function get_leadactor(){
	global $movie_leadactor;
	global $leadactor;
 
	$query_a = "SELECT people_fullname" .
				"FROM people " .
				"WHERE people_id = '$movie_leadactor'  ";
	$results_a = mysql_query($query_a)
		or die(mysql_error());
	$row_a = mysql_fetch_array($results_a);
	extract($row_a);
	$leadactor = $people_fullname;
}
$movie_details = '';
while ($row = mysql_fetch_array($result)){
	$movie_name = $row['movie_name'];
	$movie_director = $row['movie_director'];
	$movie_leadactor = $row['movie_leadactor'];
 
	get_director();
	get_leadactor();
 
	$movie_details .=<<<EOD
		<tr>
			<td>$movie_name</td>
			<td>$director</td>
			<td>$leadactor</td>
		</tr>
EOD;
}
	$movie_details .=<<<EOD
		<tr>
			<td>&nbsp</td>
		</tr>
		<tr>
			<td>Total :$num_movies Movies</td>
		</tr>
EOD;
$movie_footer ="</table>";
$movie=<<<MOVIE
	$movie_header
	$movie_details
	$movie_footer
MOVIE;
echo "There are $num_movies movies in our database";
echo $movie;
?>
[PHP] pobierz, plaintext 

Błąd wyswietla: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE people_id = '1'' at line 1.

Proszę o jakąs pomoc.

Problem rozwiązałęm, wywołanie funkcji powinno być w pętli while.

Dla wszystkich którzy będą mieli podobne problemy w przyszłosci:

[PHP] pobierz, plaintext 
<?php
$link= mysql_connect("localhost", "root", "");
 
mysql_select_db("moviesite");
 
$query= "SELECT movie_name, movie_director, movie_leadactor " .
	"FROM movie";
 
	$result = mysql_query($query, $link)  
	or die (mysql_error());
 
	$num_movies = mysql_num_rows($result);
 
$movie_header = <<<EOL
<h2> <center> Baza Danych Recenzji filmow </center> </h2>
<table width = "70%" border="1" cellpadding="2" cellspacing="2" align = "center" >
 
<tr> 
<th> Tytul filmu </th>
<th> Rezyser</th>
<th> Glowny aktor </th>
</tr>
 
EOL;
 
function get_director() {
	global $movie_director;
	global $director;
	$query_d = "select people_fullname " .
			   "from people " .
			   "where people_id='$movie_director'";
	$results_d = mysql_query($query_d)
		or die(mysql_error());
	$row_d = mysql_fetch_array($results_d);
	extract($row_d);
	$director = $people_fullname;
}
 
 
function get_leadactor() {
	global $movie_leadactor;
	global $leadactor;
 
	$query_a = "select people_fullname " .
			   "from people " .
			   "where people_id ='$movie_leadactor'";
 
	$results_a = mysql_query($query_a)
		or die(mysql_error());
 
 
	$row_a = mysql_fetch_array($results_a);
	extract($row_a);
	$leadactor = $people_fullname;
}
 
 
$movie_details = ' ';
while ($row = mysql_fetch_array($result)){
$movie_name= $row['movie_name'];
$movie_director = $row['movie_director'];
$movie_leadactor= $row['movie_leadactor'];
get_director();
get_leadactor();
$movie_details .=<<<EOD
<tr>
<td>$movie_name</td>
<td>$director</td>
<td>$leadactor</td>
</tr>
EOD;
}
 
$movie_details .=<<<EOD
<tr>
<td>&nbsp</td>
</tr>
<tr>
<td>Laczenie filmow: $num_movies</td>
</tr>
EOD;
 
 
 
$movie_footer= "</table>";
 
$movie =<<<MOVIE
		$movie_header
		$movie_details
		$movie_footer
 
 
MOVIE;
 
echo "W bazie danych znajduje sie $num_movies filmow";
echo $movie;
?>
[PHP] pobierz, plaintext 

Temat uważam za wyczerpany.