Jump to content

Recommended Posts

I wouldn't recommend access frankly, it's not very good on multi-user if anything more than 50 want to use the site at once.

Is she hosting it herself? If not then very few ISPs (internet service providers) will support it either as it doesn't sit very well on IIS (microsoft's web server) and most tend to go unix/apache anyway.


MySQL is usually the way for internet sites and is completely free too. Any idea what she used to create the site?

PHP, ASP, ASP.NET, ruby on rails etc?


Let me know if too much techy speak.

(techie talk warning)


I'll second Mockney on that, if they have a website already try and use MySQL as the database as I find it's brilliant for websites (this forum uses it). Transfer the data over from Access into MySQL if possible and use just the latter as a database, although if the data has to be in Access then she could set up an ODBC connection between the two databases. Not particularly sexy but it'll work.


As to how to connect using PHP and MySQL you can use mysql_connect() function to say something like:




have a read of something like this http://www.freewebmasterhelp.com/tutorials/phpmysql


Feel free to get them to send me a Personal Message if they need more help

Mark's given you some real code, mine was more generic, but hope we've somehow helped

*edited due to mark writing much more useful answer*


Well no real simple answer.


Basically you need a web server to run some sort of scripting language. PHP seems to be the most common on t'internet.


Then you need a grasp of this language in order to take the info posted by the web user and put it in a database.

The connection isn't physical (well it is, but I'm not helping) it's done using software concepts.


So she'll need to do something like


connectionString = "stuff thatdescribes databse type and place"

putDataInDatabaseCommand = "INSERT INTO userDetails VALUES (%s, %s)" % username, userpassword


conn = DBConnection(connectionString, username, password)

cmd = DBCommand (putDataInDatabaseCommand)


conn.execute (DBCommand)


and this will be executed by the web server.


Does any of this make any sense?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Latest Discussions

    • Highly recommend Dulwich Eco Gardening.  When he came to quote Saied said he’d give our garden back so we could decide what we do next.  Under two weeks of hard work from Saied and Mo and we have the garden back and can see paving I’d forgotten about. Not only did Saied remove our very overgrown greenery. Nature had taken over. He also took back to our fence line overgrown ivy, apple and pear trees and and dealt with a neighbours bamboo that had invaded our garden.  We are now going to get quotes for what we do next so those quoting will be able to see the space.  Saied has suggested someone to quote and will be coming back when he does in case he has any questions or they can work together.  I thought Saied would be a good choice and he was. Quotes from others didn’t leave me with confidence for the end result. That was never a concern with Saied.
    • Having a BBQ (fingers crossed) in 2 weeks and need a small BBQ for veggie bits and any spare benches or garden tables and chairs to borrow to add to mine. Any going? Thanks in advance...
    • Oh dear, hope you are OK, I've had it three times and it was worse each time, but not a patch on many of those who got it before they vac' role out. Not commenting on the discussion as I got confused many days ago beyond the reminder that Corbyn would not compromise and the harm that could lead to him, the party and regards Brexit pre and post referendum the country.  Starmer goes too far the other way at times.  
    • I am  ill in bed with Covid. It's not that I "can't be bothered" to read things. I am feeling crap and don't have the mental  energy at the moment. I am not "brushing stuff aside and pleading ignorance." I am truthfully saying when I don't presently know enough about something to be able to comment. I have always been very careful to try to  differentiate between fact and opinion in both  my posts and other people's, and I am not clear what your point is. And I am certainly not trying to wind anybody up. This is a forum. If you don't want to respond to my posts, that's up to you. I'm not sure why you feel the need to announce it.   
Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...