Help Me Please . . .

[paiman]

I have problem with php coding.
I have table named unit on sql database which its containt and I want to show it as html format like picture future_html.jpg

thank you for helping

[JVassie]

I suggest you take a look at the following:

http://uk.php.net/manual/en/ref.mysql.php - specifically mysql_connect, mysql_query and mysql_fetch_array

W3Schools MySQL Tutorial - Follow this tutorial, it will show you the basics of retrieving data from a database.

[paiman]

JVassie;10974234 wrote:

I suggest you take a look at the following:

http://uk.php.net/manual/en/ref.mysql.php - specifically mysql_connect, mysql_query and mysql_fetch_array

W3Schools MySQL Tutorial - Follow this tutorial, it will show you the basics of retrieving data from a database.

this is my script but it shows all content of the table.
I use mssql server 2005

<?php

mssql_connect("server","root","passwd");
mssql_select_db("ppv");

$query = "SELECT * FROM dbo.MS_UNIT";
$result = mssql_query($query);

echo "<table border='1'>";
echo "<tr bgcolor='".$warnaHeading."'>
      <td>Floor</td>
      <td>Number</td>
      <td>Status</td>
      </tr>";

$counter = 1;

while($data = mssql_fetch_array($result))
{

if ($counter % 2 == 0) $warna = $warnaGenap;
else $warna = $warnaGanjil;

echo "<tr bgcolor='".$warna."'>";
echo "<td>".$no."</td>";
echo "<td>".$data['Floor']."</td>";
echo "<td>".$data['Number']."</td>";
echo "<td>".$data['Status']."</td>";
echo "</tr>";

$counter++; 
}
echo "</table>";

?>

please help me ...

[paiman]

sorry, this is the script I use, not above one.

<?php 

mssql_connect("server","root","passwd"); 
mssql_select_db("ppv"); 

$query = "SELECT * FROM dbo.MS_UNIT"; 
$result = mssql_query($query); 

echo "<table border='1'>"; 
      <td>Floor</td> 
      <td>Number</td> 
      <td>Status</td> 
      </tr>"; 

while($data = mssql_fetch_array($result)) 
{ 

echo "<td>".$data['Floor']."</td>"; 
echo "<td>".$data['Number']."</td>"; 
echo "<td>".$data['Status']."</td>"; 
echo "</tr>"; 

} 
echo "</table>"; 

?>

[JVassie]

And what isn't exactly working with your script?

[paiman]

it doesn't work as I want it to be

I have problem with php coding.
I have table named unit on sql database which its containt and I want to show it as html format like picture future_html.jpg

thank you for helping

instead result.jpg.

[TheDefender]

OK, it sounds like you're dealing with two separate inquiries here...

first, you said this:
"this is my script but it shows all content of the table."

This sounds like you want to constrain your output to specific entries rather than showing all data. In that case, you need to employ the WHERE clause.

$query = "SELECT * FROM dbo.MS_UNIT WHERE some_column = 'some-value'";

The second part is that it sounds like you are looking for help formatting the output maybe? Not really sure... Sorry, but the image you referenced doesn't really explain exactly what you are wanting. Can you put your wishes into words?

[paiman]

TheDefender;10974462 wrote:

OK, it sounds like you're dealing with two separate inquiries here...

first, you said this:
"this is my script but it shows all content of the table."

This sounds like you want to constrain your output to specific entries rather than showing all data. In that case, you need to employ the WHERE clause.

$query = "SELECT * FROM dbo.MS_UNIT WHERE some_column = 'some-value'";

The second part is that it sounds like you are looking for help formatting the output maybe? Not really sure... Sorry, but the image you referenced doesn't really explain exactly what you are wanting. Can you put your wishes into words?

yes, what I want is the second part that I'm looking for help formating the output as this figure.
can u help me to make the contain table of database to that figure?
thank u for help me.

[TheDefender]

I'm sorry, but I really don't know what you are asking for help with. Are you asking for help with formatting a table or are you asking for help with outputting data into a formatted table? Sorry - but it's not clear what you are asking for help with.

[paiman]

TheDefender;10974475 wrote:

I'm sorry, but I really don't know what you are asking for help with. Are you asking for help with formatting a table or are you asking for help with outputting data into a formatted table? Sorry - but it's not clear what you are asking for help with.

I have a table on sql server database that I want to show on html table using php which is the output will be like this figure

[TheDefender]

Let's start with the basics...
You need to include the opening row tags <tr> in your code...
If this still doesn't fix the issue, post back with your current code.

<?php 

mssql_connect("server","root","passwd"); 
mssql_select_db("ppv"); 

$query = "SELECT * FROM dbo.MS_UNIT"; 
$result = mssql_query($query); 

// Modified the below lines for a bit of consistency and to separate
// out each <td> tag.

echo "<table border='1'>";
echo "<tr>"; // Add this line
echo "<td>Floor</td>";
echo "<td>Number</td>";
echo "<td>Status</td>"; 
echo "</tr>"; 

while($data = mssql_fetch_array($result)) 
{ 
echo "<tr>"; // Add this line
echo "<td>".$data['Floor']."</td>"; 
echo "<td>".$data['Number']."</td>"; 
echo "<td>".$data['Status']."</td>"; 
echo "</tr>"; 

} 
echo "</table>"; 

?>

[paiman]

that scripts result as I made.

I have a table on sql server database that I want to show on html table using php which is the output will be like this figure

which the figure show that floor in gray field vertically(1st-40th) and number in gray horizontally (1st-31st) and status B field is red and status A field is green.

it show that room which is number 1 on 1st is B status and it's red. room which is number 5 on 23rd floor is status A and it's green.

that is what I want to show from table unit in sql server to be html format as figure.

[paiman]

anyone please help me . . .

[paiman]

anyone please help me...