PHP/VB/Access Friend or Foe?

• • Reply

  17 years ago

  by blainehilton

  Blaine Hilton

  Indiana, USA, India

  Joined 17 years ago

  There does not seem to be much discussion here so I thought I would see what you guys think about a project I'm working on.  I'm doing some work in an environment with Windows, Linux and Iris operating systems.  I'm developing a reporting type program with a database backend.  I was going to start with PHP for the language and use each computer’s browser to access it with a mySQL database.  Now though we are using VB6 and Access.  The problem though is VB only runs on Windows so I will probably be using PHP accessing the Access database either with a DSN connection, or through ODBC.
  

  
  Does anyone have experience with this and what should I watch out for?

  Report abuse
• • Reply

  17 years ago

  by paulfp

  Paul Freeman-Powell

  Liverpool, United Kingdom

  Joined 19 years ago

  i have experience with access and i say watch out for it..... and AVOID IT LIKE THE PLAGUE!
  

  
  run that past me again...... why did you decide to change from MySQL to Access??!!
  

  
  Access is to MySQL as pen and paper is to Word XP!!
  

  
  dont dont dont dont use access, especially if u use PHP, cos PHP and MySQL are designed to run together, there are special functions specialyl for mysql in php

  Report abuse
• • Reply

  17 years ago

  by lostboy

  bastien

  toronto, canada, Canada

  Joined 18 years ago

  why use vb at all?

  Report abuse
• • Reply

  17 years ago

  by blainehilton

  Blaine Hilton

  Indiana, USA, India

  Joined 17 years ago

  We are using VB mainly because another person on the project is familiar with VB and not PHP/mySQL.  The other reason though is we are interested in interfacing biometric devices into the system in the near future and they only have SDKs available for VB and Visual C++.
  

  
  However I am going to probably be doing most work now with PHP and will probably end up using a mySQL database and using the mySQL link to connect the one instance of VB to the rest of the system...

  Report abuse