dobry vecer,
dost dlho som sa snazil vyriesit moj problem ale uz som fakt mimo.
mam lamp server na linuxe ubuntu 9.04, vytvoril som si databazu a:
-- naplnim ju :
Kód:
<?php
$spojenie = mysql_connect( "localhost", "*****", "*****" ) or
die( "skontrolujte prosim pripojenie k serveru" );
mysql_select_db( "moviesite" );
$vlozit = "INSERT INTO movie ( movie_id, movie_name, movie_type, " .
"movie_year, movie_leadactor, movie_director ) " .
"VALUES ( 1, 'Bozsky Bruce', 5, 2003, 1, 2 ), " .
"( 2, 'Malery pana Sikuly', 5, 1999, 5, 6 ), " .
"( 3, 'Grand Canyon', 2, 1991, 4, 3 )";
$vysledky = mysql_query( $vlozit ) or
die( mysql_error() );
$typ = "INSERT INTO movietype ( movietype_id, movietype_label ) " .
"VALUES ( 1, 'sci Fi' ), " .
"( 2, 'drama' ), " .
"( 3, 'dobrodruzny' ), " .
"( 4, 'vojensky' ), " .
"( 5, 'komedia' ), " .
"( 6, 'horor' ), " .
"( 7, 'akcny' ), " .
"( 8, 'detsky' )" ;
$vysledky = mysql_query( $typ ) or
die( mysql_error() );
$ludia = "INSERT INTO people ( people_id, people_fullname, " .
"people_isactor, people_isdirector ) " .
"VALUES ( 1, 'Jim Carrey', 1, 0 ), " .
"( 2, 'Tom Shadyac', 0, 1 ), " .
"( 3, 'Lawrence Kasdan', 0, 1 ), " .
"( 4, 'Kevin Kline', 1, 0 ), " .
"( 5, 'Ron Livingston', 1, 0 ), " .
"( 6, 'Mike Judge', 0, 1 )";
$vysledky = mysql_query( $ludia ) or
die( mysql_error() );
echo "vlozenie dat prebehlo uspesne";
?>
-- setko je ok, dalej chcem nieco vypisat do tabulky:
Kód:
<?php
$spojenie = mysql_connect( "localhost", "root", "programing" ) or
die( mysql_error() );
mysql_select_db( "moviesite" ) or
die( mysql_error() );
$dotaz = "SELECT movie_name, movie_director, movie_leadactor " .
"FROM movie";
$vysledok = mysql_query( $dotaz ) or
die( mysql_error() );
$pocet_filmov = mysql_num_rows( $vysledok );
$film_zahlavie = <<<EOD
<h2><center>Databaza filmovych recenzi</center></h2>
<table width="70%" border="1" cellpadding="2" cellspacing="2" align="center">
<tr>
<th>Nazov filmu</th>
<th>reziser</th>
<th>v hlavnej roli</th>
</tr>
EOD;
function zobraz_rezisera() {
global $reziser_filmu;
global $reziser;
$dotaz_d = "SELECT people_fullname " .
"FROM people " .
"WHERE people_id='$reziser_filmu'";
$vysledky_d = mysql_query( $dotaz_d ) or
die( mysql_error() );
$riadok_d = mysql_fetch_assoc( $vysledky_d );
extract( $riadok_d );
$reziser = $people_fullname;
}
function zobraz_hlavnu_rolu() {
global $hlavna_rola_vo_filme;
global $hlavna_rola;
$dotaz_a = "SELECT people_fullname " .
"FROM people " .
"WHERE people_id='$hlavna_rola_vo_filme'";
$vysledky_a = mysql_query( $dotaz_a ) or
die( mysql_error() );
$riadok_a = mysql_fetch_assoc( $vysledky_a );
extract( $riadok_a );
$hlavna_rola = $people_fullname;
}
$filmy_podrobnosti = '';
while ( $riadok = mysql_fetch_array( $vysledok ) ) {
$nazov_filmu = $riadok[ 'movie_name' ];
$reziser_filmu = $riadok[ 'movie_director' ];
$v_hlavnej_roli_filmu = $riadok[ 'movie_leadactor' ];
zobraz_rezisera();
$filmy_podrobnosti .=<<<EOD
<tr>
<td>$nazov_filmu</td>
<td>$reziser</td>
</tr>
EOD;
}
$filmy_podrobnosti .=<<<EOD
<tr>
<td>celkom filmov: $pocet_filmov</td>
</tr>
</table>
EOD;
$filmy_pata ="";
$filmy =<<<MOVIE
$film_zahlavie
$filmy_podrobnosti
$filmy_pata
MOVIE;
echo "v nasej databazi su $pocet_filmov filmy.";
echo $filmy;
?>
takze to by v podstate fungovalo.
-- teraz nieco v podstate rovnake pridam a uz hlasi chybu:
Kód:
<?php
$spojenie = mysql_connect( "localhost", "root", "programing" ) or
die( mysql_error() );
mysql_select_db( "moviesite" ) or
die( mysql_error() );
$dotaz = "SELECT movie_name, movie_director, movie_leadactor " .
"FROM movie";
$vysledok = mysql_query( $dotaz ) or
die( mysql_error() );
$pocet_filmov = mysql_num_rows( $vysledok );
$film_zahlavie = <<<EOD
<h2><center>Databaza filmovych recenzi</center></h2>
<table width="70%" border="1" cellpadding="2" cellspacing="2" align="center">
<tr>
<th>Nazov filmu</th>
<th>reziser</th>
<th>v hlavnej roli</th>
</tr>
EOD;
function zobraz_rezisera() {
global $reziser_filmu;
global $reziser;
$dotaz_d = "SELECT people_fullname " .
"FROM people " .
"WHERE people_id='$reziser_filmu'";
$vysledky_d = mysql_query( $dotaz_d ) or
die( mysql_error() );
$riadok_d = mysql_fetch_assoc( $vysledky_d );
extract( $riadok_d );
$reziser = $people_fullname;
}
function zobraz_hlavnu_rolu() {
global $hlavna_rola_vo_filme;
global $hlavna_rola;
$dotaz_a = "SELECT people_fullname " .
"FROM people " .
"WHERE people_id='$hlavna_rola_vo_filme'";
$vysledky_a = mysql_query( $dotaz_a ) or
die( mysql_error() );
$riadok_a = mysql_fetch_assoc( $vysledky_a );
extract( $riadok_a );
$hlavna_rola = $people_fullname;
}
$filmy_podrobnosti = '';
while ( $riadok = mysql_fetch_array( $vysledok ) ) {
$nazov_filmu = $riadok[ 'movie_name' ];
$reziser_filmu = $riadok[ 'movie_director' ];
$v_hlavnej_roli_filmu = $riadok[ 'movie_leadactor' ];
zobraz_rezisera();
zobraz_hlavnu_rolu();
$filmy_podrobnosti .=<<<EOD
<tr>
<td>$nazov_filmu</td>
<td>$reziser</td>
<td>$hlavna_rola</td>
</tr>
EOD;
}
$filmy_podrobnosti .=<<<EOD
<tr>
<td>celkom filmov: $pocet_filmov</td>
</tr>
</table>
EOD;
$filmy_pata ="";
$filmy =<<<MOVIE
$film_zahlavie
$filmy_podrobnosti
$filmy_pata
MOVIE;
echo "v nasej databazi su $pocet_filmov filmy.";
echo $filmy;
?>
kde je chyba ? vselico som poskusal poobzeral - navise je to prikald z knizky a aj tak m inefunguje.
chyba znie :
Kód:
Warning: extract() [function.extract]: First argument should be an array in /var/www/tabulky/tabulka2.php on line 44
Warning: extract() [function.extract]: First argument should be an array in /var/www/tabulky/tabulka2.php on line 44
Warning: extract() [function.extract]: First argument should be an array in /var/www/tabulky/tabulka2.php on line 44
dik za pomoc
. prihlasil som sa ale nevedel osm co dalej, predpokladam ze chces aby som si to dal vypisat pomocou kolonky s nadpisom "Spustiť SQL príkaz(y) na servri "localhost":"
.
.
