Parse Error

tdcaron

I am a newbie to PHP and need a little assistance please.

We are familiar with MA Access and ASP and have a situation where we need to put a similar program on a unix box.

The program is a statistical program for a dart league. (Very similar to recording bowling stats or any kind of sporting statics.

The program works fine on a Windows system using asp but I am not a programmer by any means.

We have coverted all the asp script to php using MyAccess addon for MS Access.

And we have loaded everything up to the server at the below
url. http://northerndarts.net/north-php/login.php

When I go to the url in my browser I get the following error:

Parse error: parse error, unexpected T_DNUMBER in /home/wwwnort/public_html/north-php/tblTeamWeeklyGamelist.php on line 57

I should be getting a login screen instead.

Now I know very little about proper connection strings in php / ms access. and I have searched through the forums.

I am really stumped.
If someone would kindly look through our script the path to view the script is available at http://northerndarts.net/north-php

I really would appreciate some help here.
Lost and confused.

Thanks alot guys & gals
Tim

trooper

Your link didn't work m8

Post the code in lines 60-77 here and we'll have a look at it for ya.

HTH

tdcaron

I'm sorry, I might Have given the wrong link to the website.
Here's the link.

Here's the code that was generated by MyAccess when generating the db connection string.

This is asp code:
<%
xDb_Conn_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("northdb.mdb") & ";"
%>

Here's the php code:
<?
$xDb_Conn_Str="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".$DOCUMENT_ROOT."northdb.mdb".";";
?>

Also, when you goto:
http://northerndarts.net/north-php/login.php you get the following error:

Parse error: parse error, unexpected T_VARIABLE in /home/wwwnort/public_html/north-php/login.php on line 75

Her is part of the code that you asked for lines 66 -77

<?
$validpwd=true;

if ($HTTP_POST_VARS["submit"]!="")
{

// setup variables
$userid=$HTTP_POST_VARS["userid"];
$passwd=$HTTP_POST_VARS["passwd"];

// $conn is of type "ADODB.Connection"

$a2p_connstr=$odbc_connect
$a2p_uid=strstr($a2p_connstr,'uid');
$a2p_uid=substr($d,strpos($d,'=')+1,strpos($d,';')-strpos($d,'=')-1);
$a2p_pwd=strstr($a2p_connstr,'pwd');
$a2p_pwd=substr($d,strpos($d,'=')+1,strpos($d,';')-strpos($d,'=')-1);
$conn=mysql_connect("localhost",$a2p_uid,$a2p_pwd);
mysql_select_db("",$conn);
$rs_query=mysql_query(("Select * from [tblUser] where [LogonName] = '".strtoupper($userid)."'"),$conn);

$rs=mysql_fetch_array($rs_query);
if (!($rs==0))
{

I hope that this helps give a better understanding.

I want the program to look and work like the below url:

http://www.leaguerepublic.com/darts.jsp

If anyone could help program this I would greatly appreciate it.
Thank You
Tim Caron

HalfaBee

Try changing this line
$rs_query=mysql_query(("Select * from [tblUser] where [LogonName] = '".strtoupper($userid)."'"),$conn);

$rs_query=mysql_query("Select * from tblUser where LogonName = '".strtoupper($userid)."'",$conn);

You can't have [] in the sql. These are only in the manual to indicate there are a few choices.

HalfaBee

tdcaron

Dear HalfaBee,

We tried your suggestion but still got the same error.
Could it be that I'm using php 4.0.2 and trying to connect to an MS Access db.

I really don't know where to start.

Thanks Again
Tim Caron

HalfaBee

The mysql commands are for mysql.
Try using the mssql_ commands.

Halfabee

tdcaron

I don't know the mssql commands, see I told you I was a newbie
Or is it a matter of just changing the mysql to mssql?

Thanks again

HalfaBee

I would suggest you have a look at the manual at www.php.net.

I have no idea about mssql type commands, but they look similar to the mysql commands.

HalfaBee

crosbystillsnas

$xDb_Conn_Str="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".$DOCUMENT_ROOT."northdb.mdb".";";

think there's a "/" missing before the mdb-file.

$xDb_Conn_Str="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".$DOCUMENT_ROOT."/northdb.mdb".";";

Weedpacket

The functions you'll be wanting are the odbc functions (mssql are for SQL Server). There are no MS Access-specific functions, because - let's be honest about this - Access is utterly terrible at driving a web site (the fact that it is possible at all is entirely due to technicalities of satisfying ODBC). Get a real database system. MySQL is good (and cheaper).