Displaying data from a database

usman07 · March 7, 2012

PHP Code


<?php
$username="";
$password="";
$database="";

mysql_connect("","","");
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1-name=mysql_result($result,$i,"id");
$field2-name=mysql_result($result,$i,"Location");
$field3-name=mysql_result($result,$i,"Property type");
$field4-name=mysql_result($result,$i,"Number of bedrooms");
$field5-name=mysql_result($result,$i,"Purchase type");
$field6-name=mysql_result($result,$i,"Price range");

echo "<b>$field1-name 
$field2-name2</b><br>$field3-name<br>$field4-name<br>$field5-name<hr><br>";

$i++;
}

?>

HTML code for the form


<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

	<td><p class="PT">Property type:</p></td>
<td><div id="PS">
	<form action="insert.php" method="post">
	<select name="property type" style="width: 170px;">
	<option value="none" selected="selected">Any</option>
	<option value="Houses">Houses</option>
	<option value="Flats / Apartments">Flats / Apartments</option>
	</select>
		</form>
	</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post"> 
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale 

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

	</table>

	<div id="table2">
	<table id="NBtable">
	<tr>
	<td><p class="NBS">Number of bedrooms:</p></td>
	<td><div id="NB">
	<form action="insert.php" method="post">
	<select name="number of bedrooms">
	<option value="none" selected="selected">No Min</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select> to

	<select name="number of bedrooms">
	<option value="none" selected="selected">No Max</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select>
</form>		
	</div>
</td>

	<td><p class="PR">Price range:</p></td>
	<td><div id="PR">
	<form action="insert.php" method="post">
	<select name="price range">
	<option value="none" selected="selected">No Min</option>
	<option value="50,000">50,000</option>
	<option value="60,000">60,000</option>
	<option value="70,000">70,000</option>
	<option value="80,000">80,000</option>
	<option value="90,000">90,000</option>
	<option value="100,000">100,000</option>
	<option value="110,000">110,000</option>
	<option value="120,000">120,000</option>
	<option value="130,000">130,000</option>
	<option value="140,000">140,000</option>
	<option value="150,000">150,000</option>
	<option value="160,000">160,000</option>
	<option value="170,000">170,000</option>
	<option value="180,000">180,000</option>
	<option value="190,000">190,000</option>
	<option value="200,000">200,000</option>
	<option value="210,000">210,000</option>
	<option value="220,000">220,000</option>
	<option value="230,000">230,000</option>
	<option value="240,000">240,000</option>
	<option value="250,000">250,000</option>
	<option value="260,000">260,000</option>
	<option value="270,000">270,000</option>
	<option value="280,000">280,000</option>
	<option value="290,000">290,000</option>
	<option value="300,000">300,000</option>
	<option value="310,000">310,000</option>
	<option value="320,000">320,000</option>
	<option value="330,000">330,000</option>
	<option value="340,000">340,000</option>
	<option value="350,000">350,000</option>
	</select> to

	<select name="price range">
	<option value="none" selected="selected">No Max</option>
	<option value="50,000">50,000</option>
	<option value="60,000">60,000</option>
	<option value="70,000">70,000</option>
	<option value="80,000">80,000</option>
	<option value="90,000">90,000</option>
	<option value="100,000">100,000</option>
	<option value="110,000">110,000</option>
	<option value="120,000">120,000</option>
	<option value="130,000">130,000</option>
	<option value="140,000">140,000</option>
	<option value="150,000">150,000</option>
	<option value="160,000">160,000</option>
	<option value="170,000">170,000</option>
	<option value="180,000">180,000</option>
	<option value="190,000">190,000</option>
	<option value="200,000">200,000</option>
	<option value="210,000">210,000</option>
	<option value="220,000">220,000</option>
	<option value="230,000">230,000</option>
	<option value="240,000">240,000</option>
	<option value="250,000">250,000</option>
	<option value="260,000">260,000</option>
	<option value="270,000">270,000</option>
	<option value="280,000">280,000</option>
	<option value="290,000">290,000</option>
	<option value="300,000">300,000</option>
	<option value="310,000">310,000</option>
	<option value="320,000">320,000</option>
	<option value="330,000">330,000</option>
	<option value="340,000">340,000</option>
	<option value="350,000">350,000</option>

	</select>
</form>		
	</div>
</td>


</tr>

	</table>	

	</div>
	 <form id="submit" action="">
      <input type="submit" value="search" />
      </form>

xyph · March 7, 2012

What a well versed question. This should be stickied as an ideal example of such.

Psycho · March 7, 2012

This is a duplicate. The first one did not have code in code tags. Perhaps he meant to update the original post and ended up creating a duplicate. I already responded to the other one.

smerny · March 7, 2012

i dont know.. subjects are nearly identical but there are 2 different users and the content is different.

usman07 · March 7, 2012

Sorry i want to know what im doing wrong? to be able to display data from a database?

Pikachu2000 · March 7, 2012

Maybe THIS will help you.

l0gic · March 8, 2012

Have a squizz at this.

<?php
$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error

mysql_select_db($database, $con);  // Select database to use

$result = mysql_query("SELECT * FROM tablename");  // Query database

while($row = mysql_fetch_array($result)) {     // Loop through results
  echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
  echo $row['location'] . "<br>\n";            // Where 'location' is the column/field title in the database
  echo $row['property_type'] . "<br>\n";       // as above
  echo $row['number_of_bedrooms'] . "<br>\n";  // ..
  echo $row['purchase_type'] . "<br>\n";       // ..
  echo $row['price_range'] . "<br>\n";         // ..
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>

Also you should use underscores "_" rather than dashes/hyphens "-" when naming a variable.

usman07 · March 8, 2012

I have done the above and basically i click search but it just refreshes the page,doesn't give me any error message and it doesnt display the correct results from mysql database. what is it im doing wrong, i'm guessing it hasn't connected with my database? any help will be appreciated.

HTML Code of my form


<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

	<td><p class="PT">Property type:</p></td>
<td><div id="PS">
	<form action="insert.php" method="post">
	<select name="property type" style="width: 170px;">
	<option value="none" selected="selected">Any</option>
	<option value="Houses">Houses</option>
	<option value="Flats / Apartments">Flats / Apartments</option>
	</select>
		</form>
	</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post"> 
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale 

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

	</table>

	<div id="table2">
	<table id="NBtable">
	<tr>
	<td><p class="NBS">Number of bedrooms:</p></td>
	<td><div id="NB">
	<form action="insert.php" method="post">
	<select name="number of bedrooms">
	<option value="none" selected="selected">No Min</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select> to

	<select name="number of bedrooms">
	<option value="none" selected="selected">No Max</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select>
</form>		
	</div>
</td>

	<td><p class="PR">Price range:</p></td>
	<td><div id="PR">
	<form action="insert.php" method="post">
	<select name="price range">
	<option value="none" selected="selected">No Min</option>
	<option value="50,000">50,000</option>
	<option value="60,000">60,000</option>
	<option value="70,000">70,000</option>
	<option value="80,000">80,000</option>
	<option value="90,000">90,000</option>
	<option value="100,000">100,000</option>
	<option value="110,000">110,000</option>
	<option value="120,000">120,000</option>
	<option value="130,000">130,000</option>
	<option value="140,000">140,000</option>
	<option value="150,000">150,000</option>
	<option value="160,000">160,000</option>
	<option value="170,000">170,000</option>
	<option value="180,000">180,000</option>
	<option value="190,000">190,000</option>
	<option value="200,000">200,000</option>
	<option value="210,000">210,000</option>
	<option value="220,000">220,000</option>
	<option value="230,000">230,000</option>
	<option value="240,000">240,000</option>
	<option value="250,000">250,000</option>
	<option value="260,000">260,000</option>
	<option value="270,000">270,000</option>
	<option value="280,000">280,000</option>
	<option value="290,000">290,000</option>
	<option value="300,000">300,000</option>
	<option value="310,000">310,000</option>
	<option value="320,000">320,000</option>
	<option value="330,000">330,000</option>
	<option value="340,000">340,000</option>
	<option value="350,000">350,000</option>
	</select> to

	<select name="price range">
	<option value="none" selected="selected">No Max</option>
	<option value="50,000">50,000</option>
	<option value="60,000">60,000</option>
	<option value="70,000">70,000</option>
	<option value="80,000">80,000</option>
	<option value="90,000">90,000</option>
	<option value="100,000">100,000</option>
	<option value="110,000">110,000</option>
	<option value="120,000">120,000</option>
	<option value="130,000">130,000</option>
	<option value="140,000">140,000</option>
	<option value="150,000">150,000</option>
	<option value="160,000">160,000</option>
	<option value="170,000">170,000</option>
	<option value="180,000">180,000</option>
	<option value="190,000">190,000</option>
	<option value="200,000">200,000</option>
	<option value="210,000">210,000</option>
	<option value="220,000">220,000</option>
	<option value="230,000">230,000</option>
	<option value="240,000">240,000</option>
	<option value="250,000">250,000</option>
	<option value="260,000">260,000</option>
	<option value="270,000">270,000</option>
	<option value="280,000">280,000</option>
	<option value="290,000">290,000</option>
	<option value="300,000">300,000</option>
	<option value="310,000">310,000</option>
	<option value="320,000">320,000</option>
	<option value="330,000">330,000</option>
	<option value="340,000">340,000</option>
	<option value="350,000">350,000</option>

	</select>
</form>		
	</div>
</td>


</tr>

	</table>

PHP code

<?php
$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error

mysql_select_db($database, $con);  // Select database to use

$result = mysql_query("SELECT * FROM tablename");  // Query database

while($row = mysql_fetch_array($result)) {     // Loop through results
  echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
  echo $row['location'] . "<br>\n";            // Where 'location' is the column/field title in the database
  echo $row['property_type'] . "<br>\n";       // as above
  echo $row['number_of_bedrooms'] . "<br>\n";  // ..
  echo $row['purchase_type'] . "<br>\n";       // ..
  echo $row['price_range'] . "<br>\n";         // ..
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>

smerny · March 8, 2012

why do you have so many form tags?

all elements should be within one set of form tags, ie:

<form>

</form>

you have this:

<form id="submit" action="">
      <input type="submit" value="search" />
</form>

which, unless you have some js doing something somewhere... all it's going to do is reload the page you are on with submit=search

usman07 · March 8, 2012

I had problems with positioning them, so put them in separate forms, but within each form i have the form action which should run the php page. at the moment im getting nothing, is there some sort of parse file i should i have to run php on a html file?

usman07 · March 8, 2012

ahh right how should my submit button be?i basically want it to search the mysql database?

l0gic · March 8, 2012

Ok, so I'm pretty sure you just took the code I posted above and copy/pasted it expecting it to work without reading any of the comments or filling several needed details like the name or address of your MySQL server, user credentials and even the database you're trying to connect to.

It doesn't quite work like that, as smart as computers are they aren't quite capable of mind reading and completing tasks based off of ideas you have. You will need to give them instructions and details. You tell it to stand infront of a bus and it will, you tell it to move if a bus is coming and it will. Tell it nothing and there is no bus, no standing, no staying nor moving.

Think of the code I pasted as a template.

$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

Now enter your own details into it.

$server = "localhost";      // My server is localhost, as it's my dev machine
$username = "testuser";    // My username to coonect to my MySQL is testuser
$password = "testpass";    // My username to coonect to my MySQL is testpass
$database = "testdb";    // My database is called testdb

Please do note that there is a very hight chance that your details there will be different to mine, so you will need to fill them out.

May I suggest some reading: http://www.w3schools.com/php/php_mysql_intro.asp

Sign In

Displaying data from a database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information