Code:
<html>
<body>
<?php
include("dbconnection.php");
$sql=pg_query("SELECT * FROM division");
while($row = pg_fetch_array($sql));
{
echo $row;
}
?>
</body>
</html>
-
Last edited by Dormilich; Mar 21 '12, 06:41 AM. Reason: Please use [CODE] [/CODE] tags when posting code. -
enable error reporting/display and post the complete error message.
btw. do you have the PostgreSQL extension installed at all? -
i had created a table named as division with 4 columns, i want to display the data stored in that table.i had tried the above mentioned code and i am not getting any error message only a blank page is shown.i installed WAPP stack.please help me out, as i am new to php.i am doing my project on php using postgresql as database and apache 2.2 as a server.Comment
-
then you would have to check the server's error logs. if you get a blank screen there are only 2 possibilities
a) you don't output anything in the script
b) you have a server side error (script or server)
did you check the HTML source code?Last edited by Dormilich; Mar 21 '12, 07:20 AM.Comment
-
no i did not check the html source code
when i checked by writing the above code its coming as error resource id4#Code:<html> <body> <?php include("dbconnection.php"); $sql=pg_query("SELECT * FROM division"); echo $sql; ?> </body> </html>Last edited by Dormilich; Mar 21 '12, 07:41 AM. Reason: Please use [CODE] [/CODE] tags when posting code.Comment
-
that's not an error, that is expected when you print a PHP resource.when i checked by writing the above code its coming as error resource id4#Comment
-
i think nothing is wrong on server side ..i m getting correct output for all other validations but something wrong with this code i think...what should i do to display the data stored in database..plz help me out sirComment
-
are there data in this table at all?Comment
-
yes we stored some data..Comment
-
then your original code should print "Array" as many times as there are rows.Comment
-
are there any mistakes in the code i posted above..?Comment
-
depends on what you consider a mistake. but pg_fetch_array( ) returns an array and if you echo an array you get "Array".Comment
-
nothing is displayed sir..what should i do now to dispay the data..?plz help me outComment
-
I doubt that, you already had output (post #5) so the HTML code must be there.nothing is displayed sir..Comment
Comment