Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [MySQL][PHP] Problem z bazą danych, przykład z książki php5 od podstaw
Forum PHP.pl > Forum > Przedszkole
Bjorg
9.03.2013, 18:10:54
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 
  1. link= mysql_connect("localhost", "root", "");
  2.  
  3. mysql_select_db("moviesite");
  4.  
  5. $query= "SELECT movie_name, movie_director, movie_leadactor " .
  6. 	"FROM movie";
  7.  
  8. 	$result = mysql_query($query, $link)  
  9. 	or die (mysql_error());
  10.  
  11. 	$num_movies = mysql_num_rows($result);
  12.  
  13. $movie_header = <<<EOL
  14. <h2> <center> Baza Danych Recenzji filmow </center> </h2>
  15. <table width = "70%" border="1" cellpadding="2" cellspacing="2" align = "center" >
  16.  
  17. <tr> 
  18. <th> Tytul filmu </th>
  19. <th> Rezyser</th>
  20. <th> Glowny aktor </th>
  21. </tr>
  22.  
  23. EOL;
  24.  
  25. function get_director (){
  26. global $movie_director;
  27. global $director;
  28.  
  29. $query_d = "SELECT people_fullname ".
  30. 	"FROM people ".
  31. 	"WHERE people_id = '$movie_director'";
  32.  
  33. 	$result_d = mysql_query($query_d) or die (mysql_error());
  34. 	$row_d = mysql_fetch_array($result_d);
  35. 	extract($row_d);
  36. 	$director=$people_fullname;
  37.  
  38. }
  39.  
  40.  
  41. function get_leadactor (){
  42. global $movie_leadactor;
  43. global $leadactor;
  44.  
  45. $query_z = "SELECT people_fullname ".
  46. 	"FROM people ".
  47. 	"WHERE people_id = '$movie_leadactor'";
  48.  
  49. 	$result_z = mysql_query($query_z) or die (mysql_error());
  50. 	$row_z = mysql_fetch_array($result_z);
  51. 	extract($row_z);
  52. 	$leadactor=$people_fullname;
  53.  
  54. }
  55.  
  56. get_director();
  57. get_leadactor();
  58. $movie_details = ' ';
  59. while ($row = mysql_fetch_array($result)){
  60. $movie_name= $row['movie_name'];
  61. $movie_director = $row['movie_director'];
  62. $movie_leadactor= $row['movie_leadactor'];
  63. $movie_details .=<<<EOD
  64. <tr>
  65. <td>$movie_name</td>
  66. <td>$director</td>
  67. <td>$leadactor</td>
  68. </tr>
  69. EOD;
  70. }
  71.  
  72. $movie_details .=<<<EOD
  73. <tr>
  74. <td>&nbsp</td>
  75. </tr>
  76. <tr>
  77. <td>Laczenie filmow: $num_movies</td>
  78. </tr>
  79. EOD;
  80.  
  81.  
  82.  
  83. $movie_footer= "</table>";
  84.  
  85. $movie =<<<MOVIE
  86. 		$movie_header
  87. 		$movie_details
  88. 		$movie_footer
  89.  
  90.  
  91. MOVIE;
  92.  
  93. echo "W bazie danych znajduje sie $num_movies filmow";
  94. echo $movie;
[PHP] pobierz, plaintext


Baza: 
[PHP] pobierz, plaintext 
  1. <?php
  2. $connect = mysql_connect("localhost", "root", "") or die ("sprawdz polaczenie");
  3.  
  4. $create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") 
  5. or die(mysql_error());
  6.  
  7.  
  8.  
  9.  
  10. mysql_select_db("moviesite");
  11.  
  12.  
  13.  $movie = "CREATE TABLE movie (
  14.     movie_id int(11) NOT NULL auto_increment,
  15.     movie_name varchar(255) NOT NULL,
  16.     movie_type tinyint(2) NOT NULL 
  17.     \default 0,
  18.     movie_year int(4) NOT NULL default 0,
  19.     movie_leadactor int(11) NOT NULL default 0,
  20.     movie_director int(11) NOT NULL default 0,
  21.     PRIMARY KEY (movie_id),
  22.     KEY movie_type (movie_type,movie_year)
  23.     )";
  24.  
  25.  
  26. $results = mysql_query($movie);
  27.  
  28.  $movietype ="CREATE TABLE movietype (
  29.  movietype_id int(11) NOT NULL auto_increment,
  30.  movietype_label varchar (100) NOT NULL,
  31.  PRIMARY KEY (movietype_id)
  32.  )";
  33.  
  34.  
  35.  $results= mysql_query($movietype) ;
  36.  
  37.  $people ="CREATE TABLE people (
  38.  people_id int(11) NOT NULL auto_increment,
  39.  people_fullname varchar(255) NOT NULL,
  40.  people_isactor tinyint(1) NOT NULL default 0,
  41.  people_isdirector tinyint(1) NOT NULL default 0,
  42.  PRIMARY KEY (people_id)
  43.  )";
  44.  
  45.  $results=mysql_query($people) or die (mysql_error());
  46.  
  47.  echo "pp";
  48.  
  49. ?>
[PHP] pobierz, plaintext


I wypełnienie:
[PHP] pobierz, plaintext 
  1. <?php
  2. $connect = mysql_connect("localhost", "root", "") or die ("sprawdz polaczenie");
  3.  
  4. $create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") 
  5. or die(mysql_error());
  6.  
  7.  
  8.  
  9.  
  10. mysql_select_db("moviesite");
  11.  
  12.  
  13.  $movie = "CREATE TABLE movie (
  14.     movie_id int(11) NOT NULL auto_increment,
  15.     movie_name varchar(255) NOT NULL,
  16.     movie_type tinyint(2) NOT NULL 
  17.     \default 0,
  18.     movie_year int(4) NOT NULL default 0,
  19.     movie_leadactor int(11) NOT NULL default 0,
  20.     movie_director int(11) NOT NULL default 0,
  21.     PRIMARY KEY (movie_id),
  22.     KEY movie_type (movie_type,movie_year)
  23.     )";
  24.  
  25.  
  26. $results = mysql_query($movie);
  27.  
  28.  $movietype ="CREATE TABLE movietype (
  29.  movietype_id int(11) NOT NULL auto_increment,
  30.  movietype_label varchar (100) NOT NULL,
  31.  PRIMARY KEY (movietype_id)
  32.  )";
  33.  
  34.  
  35.  $results= mysql_query($movietype) ;
  36.  
  37.  $people ="CREATE TABLE people (
  38.  people_id int(11) NOT NULL auto_increment,
  39.  people_fullname varchar(255) NOT NULL,
  40.  people_isactor tinyint(1) NOT NULL default 0,
  41.  people_isdirector tinyint(1) NOT NULL default 0,
  42.  PRIMARY KEY (people_id)
  43.  )";
  44.  
  45.  $results=mysql_query($people) or die (mysql_error());
  46.  
  47.  echo "pp";
  48.  
  49. ?>
[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 
  1. <?php
  2. $link =mysql_connect("localhost", "root", "")
  3. 	or die(mysql_error());
  4. mysql_select_db("moviesite")
  5. 	or die(mysql_error());
  6. 	$query = "SELECT movie_name, movie_director, movie_leadactor " .
  7. 			"FROM movie";
  8.  
  9. $result = mysql_query($query, $link)
  10. 	or die(mysql_error());
  11. $num_movies = mysql_num_rows($result);
  12. $movie_header=<<<EOD
  13. <h2><center>Movie Review Database</center</h2>
  14. <table width="70%" border="1" cellpadding="2"
  15. 	cellspacing="2" align="center">
  16. 		<tr>
  17. 			<th>Movie Title</th>
  18. 			<th>Year of Release</th>
  19. 			<th>Movie Director</th>
  20. 			<th>Movie Lead Actor</th>
  21. 			<th>Movie Type</th>
  22. 		</tr>
  23.  
  24. EOD;
  25.  
  26. function get_director(){
  27. 	global $movie_director;
  28. 	global $director;
  29.  
  30. 	$query_d = "SELECT people_fullname " .
  31. 				"FROM people " .
  32. 				"WHERE people_id = '$movie_director'";
  33. 	$results_d = mysql_query($query_d)
  34. 		or die(mysql_error());
  35. 	$row_d = mysql_fetch_array($results_d);
  36. 	extract($row_d);
  37. 	$director = $people_fullname;
  38. }
  39. function get_leadactor(){
  40. 	global $movie_leadactor;
  41. 	global $leadactor;
  42.  
  43. 	$query_a = "SELECT people_fullname" .
  44. 				"FROM people " .
  45. 				"WHERE people_id = '$movie_leadactor'  ";
  46. 	$results_a = mysql_query($query_a)
  47. 		or die(mysql_error());
  48. 	$row_a = mysql_fetch_array($results_a);
  49. 	extract($row_a);
  50. 	$leadactor = $people_fullname;
  51. }
  52. $movie_details = '';
  53. while ($row = mysql_fetch_array($result)){
  54. 	$movie_name = $row['movie_name'];
  55. 	$movie_director = $row['movie_director'];
  56. 	$movie_leadactor = $row['movie_leadactor'];
  57.  
  58. 	get_director();
  59. 	get_leadactor();
  60.  
  61. 	$movie_details .=<<<EOD
  62. 		<tr>
  63. 			<td>$movie_name</td>
  64. 			<td>$director</td>
  65. 			<td>$leadactor</td>
  66. 		</tr>
  67. EOD;
  68. }
  69. 	$movie_details .=<<<EOD
  70. 		<tr>
  71. 			<td>&nbsp</td>
  72. 		</tr>
  73. 		<tr>
  74. 			<td>Total :$num_movies Movies</td>
  75. 		</tr>
  76. EOD;
  77. $movie_footer ="</table>";
  78. $movie=<<<MOVIE
  79. 	$movie_header
  80. 	$movie_details
  81. 	$movie_footer
  82. MOVIE;
  83. echo "There are $num_movies movies in our database";
  84. echo $movie;
  85. ?>
[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.
Bjorg
9.03.2013, 18:35:29
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 
  1. <?php
  2. $link= mysql_connect("localhost", "root", "");
  3.  
  4. mysql_select_db("moviesite");
  5.  
  6. $query= "SELECT movie_name, movie_director, movie_leadactor " .
  7. 	"FROM movie";
  8.  
  9. 	$result = mysql_query($query, $link)  
  10. 	or die (mysql_error());
  11.  
  12. 	$num_movies = mysql_num_rows($result);
  13.  
  14. $movie_header = <<<EOL
  15. <h2> <center> Baza Danych Recenzji filmow </center> </h2>
  16. <table width = "70%" border="1" cellpadding="2" cellspacing="2" align = "center" >
  17.  
  18. <tr> 
  19. <th> Tytul filmu </th>
  20. <th> Rezyser</th>
  21. <th> Glowny aktor </th>
  22. </tr>
  23.  
  24. EOL;
  25.  
  26. function get_director() {
  27. 	global $movie_director;
  28. 	global $director;
  29. 	$query_d = "select people_fullname " .
  30. 			   "from people " .
  31. 			   "where people_id='$movie_director'";
  32. 	$results_d = mysql_query($query_d)
  33. 		or die(mysql_error());
  34. 	$row_d = mysql_fetch_array($results_d);
  35. 	extract($row_d);
  36. 	$director = $people_fullname;
  37. }
  38.  
  39.  
  40. function get_leadactor() {
  41. 	global $movie_leadactor;
  42. 	global $leadactor;
  43.  
  44. 	$query_a = "select people_fullname " .
  45. 			   "from people " .
  46. 			   "where people_id ='$movie_leadactor'";
  47.  
  48. 	$results_a = mysql_query($query_a)
  49. 		or die(mysql_error());
  50.  
  51.  
  52. 	$row_a = mysql_fetch_array($results_a);
  53. 	extract($row_a);
  54. 	$leadactor = $people_fullname;
  55. }
  56.  
  57.  
  58. $movie_details = ' ';
  59. while ($row = mysql_fetch_array($result)){
  60. $movie_name= $row['movie_name'];
  61. $movie_director = $row['movie_director'];
  62. $movie_leadactor= $row['movie_leadactor'];
  63. get_director();
  64. get_leadactor();
  65. $movie_details .=<<<EOD
  66. <tr>
  67. <td>$movie_name</td>
  68. <td>$director</td>
  69. <td>$leadactor</td>
  70. </tr>
  71. EOD;
  72. }
  73.  
  74. $movie_details .=<<<EOD
  75. <tr>
  76. <td>&nbsp</td>
  77. </tr>
  78. <tr>
  79. <td>Laczenie filmow: $num_movies</td>
  80. </tr>
  81. EOD;
  82.  
  83.  
  84.  
  85. $movie_footer= "</table>";
  86.  
  87. $movie =<<<MOVIE
  88. 		$movie_header
  89. 		$movie_details
  90. 		$movie_footer
  91.  
  92.  
  93. MOVIE;
  94.  
  95. echo "W bazie danych znajduje sie $num_movies filmow";
  96. echo $movie;
  97. ?>
[PHP] pobierz, plaintext


Temat uważam za wyczerpany.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.