PHP Display Data

[Salchester]

Hi Everyone, hows it going?

I'm currently using the following code, inoder to create a table like structure on a page:

.cell
{
left: 0px;
top: 0px;
width: 100px;
height: 100px;
position: relative;
margin-left: 10px;
margin-bottom: 10px;
float: left;
}

how do i display all the first names and last names, stored in the database, inside different boxes, like a table? See below

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM person");

while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
  }

mysql_close($con);
?>

| FIRSTNAME | LASTNAME |
| Brian | Tims |
| Stuart | Holmes |

Many Thanks,

[redhead]

Have you tried

PHP Code:

echo "<table> <tr><td>Firstname</td><td>Lastname</td></tr>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr><td>" . $row['FirstName'] . "</td><td> " . $row['LastName'] . "</td></tr>";
  }
echo "</table>"; 


??

And please dont post two threads about the same thing, edit your previus post to reflect the code, or add a reply to the thread containing your code.

[Salchester]

Redhead,

I'm trying to use CSS instead of tables, do you know how to display the data within the database inside separate divs, using the CSS declaration i gave you earlier?

For a diagram on what I'm trying to achieve, CLICK HERE

Sorry for duplicating posts!!!

Many Thanks,

[sde]

i think this would work

<div>
  <div style="float:left;">firstname</div>
  <div>lastname</div>
</div>
<div>
  <div style="float:left;">firstname</div>
  <div>lastname</div>
</div>

[Salchester]

SDE,

Using the code at the below link, how do I load all data from the database, but only display one piece of information i.e. Firstname or Lastname per div, in order to create a tabular structure, as shown in the diagram linked below.

• CLICK HERE TO VIEW DIAGRAM!!!!
• CLICK HERE TO VIEW CODE!!!!

Many Thanks,

[DJMaze]

You ever heard of "display: table-cell"?
http://www.w3schools.com/css/pr_class_display.asp

[sde]

that's cool, i didn't know about that.

Salch, u got a problem with your layout. if you stretch it out, it's going to to display more than 2 columns. example:

first | last | first|
last

however, if you wanted to use that HTML for your display output, your php would look something like this:

PHP Code:

while($row = mysql_fetch_array($result))
  {
  echo "<div class=\"But\">". $row['FirstName'] . "</div><div class=\"But\">". $row['LastName'] . "</div>\n";
  } 


[sde]

Originally Posted by DJMaze

You ever heard of "display: table-cell"?
http://www.w3schools.com/css/pr_class_display.asp

djm, renders nicely in FF, .. any way to be able to use that with IE?

<style>
.cell {
  display: table-cell;
  width: 150px;
  border: 1px solid red;
  padding: 10px;
  margin: 0px;
}

.cell_left {
  float:left;
}
</style>

<div>
  <div class="cell">First</div>
  <div class="cell">Last</div>
</div>
<div>
  <div class="cell">First</div>
  <div class="cell">Last</div>
</div>
<div>
  <div class="cell">First</div>
  <div class="cell">Last</div>
</div>

[Salchester]

I'm trying to create a web-based application, using Xampp - Apache Server.
My creation along with the server will be run on a standalone pc.

Does anybody know if it is at all possible to lock people out of the HTDOCS folder, in order to avoid people from steeling my .html and .php code?

Many Thanks,

[DJMaze]

Originally Posted by sde

djm, renders nicely in FF, .. any way to be able to use that with IE?

As with many web-standards...... NO
But as always, there are people listed at google who do create workarounds

Mostly i just generate CSS thru php and:

PHP Code:

if (MSIE)  {
    echo '
/* stupid IE never heard of standards */
    .table { display: block; width: 200px; }
    .table-cell { display: block; width: 80px; float: left; }
';
} else {
    /* you have a cool browser */
    echo '
    .table { display: table; }
    .table div { display: table-cell; }
';
}