Troy1960 — Mon, 22 Nov 2004 15:22:48 +0000

Try that one.

Dorn — Mon, 22 Nov 2004 04:56:52 +0000

bad link

Troy1960 — Mon, 22 Nov 2004 04:53:32 +0000

You can convert asp to php using this tool.

asp2php.naken.cc/

Dorn — Thu, 11 Nov 2004 19:37:11 +0000

there is nothing... I checked to see if it was on my code and when I took all of what was provided out, the template worked again.

Could it be that php on the server is screwy?

Greg K — Thu, 11 Nov 2004 18:20:11 +0000

Hmm. I placed it on a server I use jsut to check to make sure the code itself looked ok (I knew the connection wouldn't work).

I got a page with the date at the top, the table headings, and then an error stating DB Connection Failed: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (this I expected)

When the page loads for you, if you do a view source is there anything at all??

-Greg

Dorn — Thu, 11 Nov 2004 15:22:29 +0000

Thank you!

I got no result with the code... I used what was provided exactly and the result page was blank. Not sure what is happening.

Greg K — Thu, 11 Nov 2004 08:08:03 +0000

Unfortuently, I do not have access to a Windows server to test the following, but give it a try to see if it works.

The connection string, I just left the way you had it, just formatted it in a way that is easier to read. (My personal pref). I don't know if it is right since I don't have a way to test it. For now, we'll assume it's right until you can test it.

This code has error reporting that should give a better idea of where it is failing and possibly why.

Let me know what errors you get with this version.

-Greg

<?php
  // For a display such as 3/4/2004 use this one:
  $strDate = date(\"n/j/Y\");

  // For a display such as 03/04/2004 use this one:
  // $strDate = date(\"m/d/Y\");


<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<!-- InstanceBegin template=\"/Templates/09.22.04 Intranet.dwt\" codeOutsideHTMLIsLocked=\"false\" -->

<head>
  <title>FMC</title>
</head>

<body>
  <div id=\"container\">
    <div id=\"header\"></div>        
    <div id=\"content\">
      <div align=\"center\">
        <p style=\"font-size: x-small; color: #006699;\">= $strDate </p>
      </div>
      <div>
        <table align=\"center\" cellpadding=\"3\" cellspacing=\"0\" id=\"menu_table\">
          <thead>
            <tr>
              <td><div align=\"center\"><b>DEPARTMENT</b></div></td>
              <td><div align=\"center\"><b>POSITION TITLE</b></div></td>
              <td><div align=\"center\"><b>POS #</b></div></td>
              <td><div align=\"center\"><b>STS</b></div></td>
              <td><div align=\"center\"><b>SHIFT</b></div></td>
              <td><div align=\"center\"><b>PAY RANGE</b></div></td>
              <td><div align=\"center\"><b>PAY GRADE</b></div></td>
              <td><div align=\"center\"><b>DATE POSTED</b></div></td>
            </tr>
          </thead>
          
          
            $cfg_dsn = \"DRIVER=Microsoft Access Driver (*.mdb);\" .
                       \"DBQ=Career Oppotunities.mdb;\" .
                       \"UserCommitSync=Yes;\" .
                       \"Threads=3;\" .
                       \"SafeTransactions=0;\" .
                       \"PageTimeout=5;\" .
                       \"MaxScanRows=8;\" .
                       \"MaxBufferSize=2048;\" .
                       \"DriverId=281;\" .
                       \"DefaultDir=C:/ProgramFiles/CommonFiles/ODBC/DataSources\"; 
                        
            $cfg_dsn_login = \"\"; 
            $cfg_dsn_mdp = \"\"; 
            
            $dbConn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
            
            if ($dbConn)
            {
              // Connection was made, continue
              
              $sqlString = \"Select [DEPARTMENT], \" .
                           \"       [POSITION TITLE], \" .
                           \"       [POS #], \" . 
                           \"       [STS], \" . 
                           \"       [SHIFT], \" . 
                           \"       [PAY RANGE], \" . 
                           \"       [PAY GRADE], \" . 
                           \"       [DATE POSTED] \" . 
                           \"From [Career Opportunities] \" .
                           \"Order By [DEPARTMENT]\";
                         
              $dbResult = odbc_exec($dbConn,$sqlString);
              
              if ($dbResult)
              { 
                // Results were found, process them
                
                while (odbc_fetch_row($dbResult)) 
                {
                  $thisDept     = odbc_result($dbResult, \"DEPARTMENT\");
                  $thisPos      = odbc_result($dbResult, \"POSITION TITLE\");
                  $thisPosNo    = odbc_result($dbResult, \"POS #\");
                  $thisSTS      = odbc_result($dbResult, \"STS\");
                  $thisShift    = odbc_result($dbResult, \"SHIFT\");
                  $thisPayRange = odbc_result($dbResult, \"PAY RANGE\");
                  $thisPayGrade = odbc_result($dbResult, \"PAY GRADE\");
                  $thisDatePost = odbc_result($dbResult, \"DATE POSTED\");
      
                  echo \"<tr>\n\";
                  echo \"<td bgcolor='#F4F4F4'><div align=center>\" . $thisDept . \"</td>\n\";
                  echo \"<td><div align=center>\" . $thisPos . \"</td>\n\";
                  echo \"<td bgcolor='#F4F4F4'><div align=center>\" . $thisPosNo . \"</td>\n\";
                  echo \"<td><div align=center>\" . $thisSTS . \"</td>\n\";
                  echo \"<td bgcolor='#F4F4F4'><div align=center>\" . $thisShift . \"</td>\n\";
                  echo \"<td><div align=center>\" . $thisPayRange . \"</td>\n\";
                  echo \"<td bgcolor='#F4F4F4'><div align=center>\" . $thisPayGrade . \"</td>\n\";
                  echo \"<td><div align=center>\" . $thisDatePost . \"</td>\n\";
                  echo \"</tr>\";
                }
              }
              else
              {
                // No results were found
                
                echo \"<tr>\n\";
                echo \"<td colspan='8'>** NO RECORDS FOUND**</td>\n\";
                echo \"</tr>\n\";
              }
              
              odbc_close($dbConn);
            }
            else
            {
              // Connection to database failed

              echo \"<tr>\n\";
              echo \"<td colspan='8'>DB Connection Failed:<br>\" . odbc_errormsg() . \"</td>\n\";
              echo \"</tr>\n\";
            }
          
          
        </table>
      </div>
  </div>
</body>

<!-- InstanceEnd -->

</html>
?>

Dorn — Tue, 09 Nov 2004 18:52:41 +0000

it is on an IIS server...
Here is what I am trying to do.
There is a Microsoft Access database that is kept in the same directory that the index.php/asp file is. The index page needs to pull the data from that and display it in a table. I have the ASP page that does work but there is no way for me to include the required includes which are PHP.

I am willing to pay someone $20 (or more if needed) if they can help me get it to work. I have spent much to much time on this one file and have not gotten any closer.

I dont know both languages enough to make it work.

Greg K — Tue, 09 Nov 2004 00:07:20 +0000

Well if you are using an access file, then definately one big issue is your use of the mysql functions (mysql_fetch_array and mysql_query) There apears to be similar ones for ODBC, see http://us2.php.net/manual/en/ref.uodbc.php for all the ODBC functions.

Also, the server you are running it on, what operating system is it? Check out the second comment down at the bottom of http://us2.php.net/manual/en/function.odbc-connect.php someone posted the instructions it looks like for accessing a access database.

I didn't try it, but it looked like a pretty good sample with instructions how how to set it up on the server. (in that case, using a win server).

-Greg

PS. You mentioned you needed to go to PHP becasue you had include files. Are these files done in PHP or you just need the ability to include another file? If it is just the ability is needed, I'm sure ASP has something to do that as well.

Dorn — Mon, 08 Nov 2004 21:51:23 +0000

The file that I need to display is a MS access file. It sits in the same directory as the index page. I have the ASP page that works but the site was just converted to PHP. There are several include files that will be required so this page has to be PHP...