retreive data from database

eugz · February 10th, 2006, 12:36 AM

Hi All.
I'm new in PHP. I created form for web page and connected that page to MS SQL database. I don't know how to put database data to according cells. For instance, to get data for Classroom, Date, ets.

Code:

<form action="" method="post" name="frmInfo"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
          <tr> 
            <td>&nbsp;</td> 
            <td>Classroom</td> 
            <td colspan="2">&nbsp;</td> 
          <tr> 
            <td>&nbsp;</td> 
            <td>Date</td> 
            <td colspan="2">&nbsp;</td> 
          <tr> 
            <td>&nbsp;</td> 
            <td>Salary</td> 
            <td colspan="2">&nbsp;</td> 
          <tr> 
            <td>&nbsp;</td> 
            <td>Other</td> 
            <td colspan="2">&nbsp;</td> 
          </tr> 
        </table> 
      </form>/

I will appreciate if somebody show me example how to do it.
Thanks.

Mantis · February 12th, 2006, 06:34 PM

I have no Idea how to access a MS SQL database .. because I use My SQL.. but for the PHP side it should look like this:

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="25%">Classroom</td>
    <td width="25%">Date</td>
    <td width="25%">Salary</td>
    <td width="25%">Other</td>
  </tr>
  <tr>

* Acces you database here and run the Query to get your data *
* Start a loop from 1 to the amount of responces you got from the Query *
* for the example will will say that the variable $Classroom contain the data about Classroom, $Date about Date etc.. *

    <td width="25%"><?php echo $Classroom; ?></td>
    <td width="25%"><?php echo $Date; ?></td>
    <td width="25%"><php echo $Salary; ?></td>
    <td width="25%"><?php echo $Other; ?></td>
  </tr>
* place here the code for the end loop *
</table>

Hope this help.

adam_kahtava · February 15th, 2006, 08:45 PM

PHP and MS SQL is completely possible..

Check out the following link: http://www.phpdig.net/ref/rn40.html

- A.Kahtava