php code + data apo database ....Επείγον!!!

Stuff · 13 Ιανουαρίου 2004

Geia sse olous, Exo ftiaksei afto ton php kodika o opoio xrisimopoieitai gia na kano transfer-data apo mia database kai webpage. Alla den leitourgei. Mipos einai kati lathos?

<HTML>

<HEAD>

<TITLE>

<?php

$title = $_REQUEST["title"];

echo $title;

?>

</TITLE>

</HEAD>

<?php

$conn = pg_connect("host=dcsun2 user=wwwuser

dbname=dwt password=wwwuser");

if (!$conn) {

echo "An error occured.\n";

exit;

}

?>

<?php

$sql="SELECT * FROM jfs where city = '$title';";

$result_set = pg_Exec ($conn, $sql);

$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {

echo "<H1>ERROR - no rows returned</H1><P>";

exit; //exit the script

}

for ($j=0; $j < $rows; $j++)

{

$name = pg_result($result_set, $j, "issue");

$address = pg_result($result_set, $j, "author");

$city = pg_result($result_set, $j, "title");

$stars = pg_result($result_set, $j, "format");

$no_of_beds = pg_result($result_set, $j, "url");

?>

<TR>

<TD>

</TD>

<TD>

<?php echo $author ?>

</TD>

<TD>

<?php echo $title ?>

</TD>

<TD>

<?php echo $format ?>

</TD>

<TD>

<?php echo $url ?>

</TD>

</TR>

<?php

}

?>

<?php

pg_FreeResult($result_set);

pg_Close($conn);

?>

</TABLE>

</BODY>

</HTML>

Σύνδεση

php code + data apo database ....Επείγον!!!

Προτεινόμενες αναρτήσεις

Stuff

Αρχειοθετημένο

Σύνδεση