Jump to content

Web Designer needed / database connections

Ma

By Ma
in The Lounge

 Share

Recommended Posts

mockney piers

mockney piers

Posted
Posted

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.

Mark

Mark

Posted
Posted

(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

mockney piers

mockney piers

Posted
Posted

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
 Share
Go to topic listing
  • Advertise Here

  • Latest Discussions

    • Dogkennelhillbilly
      Cllr Williams to stand down

      By Dogkennelhillbilly · Posted

      OOOOooooOOOooohhhHHHHHH 👜 👜 👜 
    • Dogkennelhillbilly
      Cyclists be careful

      By Dogkennelhillbilly · Posted

      That's actually why the Sherlock Holmes stories were so popular. There was so little crime people found it exciting to imagine robberies and murders happening in London.
    • bonaome
      Cyclists be careful

      By bonaome · Posted

      Yes, because of course there were no violent robberies in the olden days. Pretty much no crime happened at all I believe through the entire Victorian era.
    • Bernadette 12
      Ring doorbell question etc

      By Bernadette 12 · Posted

      Hi all, Im a Southwark council leaseholder and live downstairs in a ground floor flat, there is one flat above me, it's a house with individual front doors leading from the street into the shared pathway. My neighbour told me he has had a ring doorbell installed, no discussion as to how I would feel being on camera everytime I go in and out or in my front garden. I was told it's only for deliveries and doesn't record and only activates when pressed, however I don't know this and I feel really uncomfortable everytime I'm out in garden or on doorstep talking to people. Everytime I walk in/out, it lights up and in the eve it has a  infra red  light. Now I've read up that as he said its only for deliveries, he could set it so it only activates when pressed, however it activates with its motion sensor. Had he said to me about getting it installed, I could have had the opportunity to ask about it recording etc but nothing except it's being installed and when I arrived home it was there. I don't like being horrible to people however I feel I have not been considered in his decision and I feel very uncomfortable as, some times I have to stand on doorstep to get signal for my mobile and I really don't like the idea of being watched and listened to. Has anyone got any advice as I'm beginning to get angry as I've asked about it once and was told it only activates when pressed. I believe this is not true. I know southwark council say you need to ask permission to make sure the neighbours are OK with it, I don't really want to go down that road but I don't know how to approach the subject again. They also put a shed approx 3 foot from my back room window, these places are built so my window faces their rear garden and there upstairs window  faces mine. They said it's there temporarily, that was over a year ago and it does affect the light, plus I'm hoping to sell up soon and the view from window is mainly a dark brown shed. When I've mentioned this, I was told they have no where else to put it, whereas originally they said its only temporary, Also the floorboards above are bare and I get woke early morning and at night, the thudding is so bad my light shakes and window rattles, so I mentioned this and asked if they have rugs, I was told when they get the boards re sanded they will get rugs, I should have asked if they could get rugs and just take them up when boards being done, which I would have done had it been me living above someone, their attitude was I can just put up with it until they are ready. so they had the floor boards done, and the workmen was hammering screws, yes screws, in the floorboards, I spoke to workmen to ask how much longer and they said yes, are using screws to make less noise! I could hear the cordless screwdriver, not an issue but for every screw there were at least 8 whacks, the owners had gone out to avoid the noise  so I  spoke to workmen as the noise was unbearable, the sanding, not an issue at all, people need to get things done to their home and I'm fine that on occasions there will be temporary noise. now I have a nice crack on my bedroom ceiling, I mentioned this to owner but no response, he said there were alot of loose floorboards and it will be much better now, not so noisy, as though I don't know the difference between squeaking floor boards and thudding, and nothing was mentioned re the crack or that they now have rugs, which if it were me, I'd be trying to resolve the issue so we can get on with feeling happy in our homes. so I'm feeling it's a total lack of consideration. these places are old and Edwardian and I've lived here over 40 years, had 4 different neighbours and it's only now the noise of thudding is really bad and the people before had floorboards but nothing like this. As you can probably tell I'm really wound up and I don't want to end up exploding at them, I've always got on with neighbours and always said if there's a problem with my dog, pls let me know, always tell me, however I feel it's got to the point where I say something and I'm fobbed off. I know I should tell them but I'm angry, perhaps I should write them a letter. Any suggestions greatly appreciated and thank you for reading my rant. 

East Dulwich Forum

Established in 2006, we are an online community discussion forum for people who live, work in and visit SE22.

Home
Events
Sign In

Sign In



Or sign in with one of these services

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