Command List for PHP programing

[jimneely]

I am developing a Web Site using PHP scripting to work with my ACCESS Database (mdb). I am having problems finding the commands to query, add, change and delete records. Can some one point me in the right direction

[ItsMe]

I really do not know the answer to that but I will guess the solution is somewhere in ADO

This is Active X reference area for desktop but talks about an ADO recordset.
http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx
Make sure that you are using an Indexed column/field when referencing a field within a table object. I do not know if that rule applies to all methods within ADO but I know at least some methods require indexed fields.

Here is an example
http://stackoverflow.com/questions/1...rn-a-recordset

There is plenty of help available here on this forum for SQL statements. Access SQL is very similar to Transact SQL. There are some Operators available in T-SQL that are not available in SQL for Access. Once you have a conection, you should be able to manipulate objects like QueryDefs, TableDefs, etc using SQL. So, I do not belive MySQL will be of any help when using the ADO connection but, I could be wrong.
http://www.w3schools.com/sql/sql_syntax.asp

[jimneely]

I really do not know the answer to that but I will guess the solution is somewhere in ADO

This is Active X reference area for desktop but talks about an ADO recordset.
http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx
Make sure that you are using an Indexed column/field when referencing a field within a table object. I do not know if that rule applies to all methods within ADO but I know at least some methods require indexed fields.

Here is an example
http://stackoverflow.com/questions/1...rn-a-recordset

There is plenty of help available here on this forum for SQL statements. Access SQL is very similar to Transact SQL. There are some Operators available in T-SQL that are not available in SQL for Access. Once you have a conection, you should be able to manipulate objects like QueryDefs, TableDefs, etc using SQL. So, I do not belive MySQL will be of any help when using the ADO connection but, I could be wrong.
http://www.w3schools.com/sql/sql_syntax.asp

I am seeing ADO in MSDN, and I see ADO in a PHP build, and I see ADO in W3Schools for asp, but nothing anywhere that specifically has PHP for ADO. Grrrrrr !!!! I guess that's why ADODB was created at http://phplens.com/adodb/ .... I prefer to write my own code and not use a predefined library, looks like I have no choice.
I want to thank you for all your time you have spent on helping me understand ADO and PHP marriage.

[ItsMe]

phplens looks like a bunch of prebuilt classes that they will sell to you. I will imagine that could save a lot of time if you are only developing one or two medium sized apps.

If you want to create your own classes, there is an example in the answer to the link I provided. The other link (to MSDN) I provided will show you how Access sees ADO. Once you have a connection established, save that as a class. Call on that connection from other classes and use methods like MoveNext (referring to the PHP from the example link).

Incorporate SQL to retrieve datasets that will require the fewest ADO methods as possible.