Jump to content


Photo

simple (?) question


  • Please log in to reply
1 reply to this topic

#1 matstuff

matstuff
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 19 November 2003 - 08:00 PM

Hi,

Am new to MySQL and relatively new to PHP. Am trying to marry the two together, but have met with confusion at the first hurdle. My server (www.aspfreeserver.com) provides me with two folders - \'www\' and \'db\'. I create my PHP offline, on my home machine and then ftp it to the server. Similarly, my MySQL db is on my local disk, but not online. I\'ve not set up my home pc as a server, hence the need to upload.

However, from what I can tell, MySQL doesn\'t create a discrete file (like Access, or something) for the database, rather a folder for it. Do I just upload this folder to my server, and if so do I upload it into the \'db\' folder or the \'www\' folder. Once uploaded, how do I then connect to the database in PHP, since there is basically no file on the server for it to recognise. I\'m pretty sure that the server supports MySQL, since if I run phpinfo() there is a MySQL section that reports all its settings.

I\'m may be missing some obvious point here, and probably am, but if anyone can point me in the right direction I\'d be really grateful!

Thx in advance,

Mat
---[/code]

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 19 November 2003 - 09:47 PM

Taken from http://www.aspfreese...ecification.asp

Connect to Microsoft Access 97  2002 databases

You can connect to Microsoft Access 97 or 2000 databases using DNS-less connections. DSN-less connections are faster than System DSN connections because DSN-less avoids doing a registry lookup. Furthermore you can receive additional performance benefits by directly using the OLEDB layer. You will also have a /db directory to store your databases in, this is above your webspace and so is a much safer place to store sensitive information. Your sites visitors will not be  able to browse this folder.


So this means they dont Mysql and you can just create a Ms acess database locally which may be uploaded to the db folder :)

So the Mysql and PHP marriage is pre-matured right now :) lol
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users