• 0

database and php question


Question

Could anyone of you loverly people direct me to a tutorial (written so a thicko like me can understand it) about ODBC databases being accessed from a PHP script.

I'll explain. I have a PHP script that outputs a form to a .txt or .csv file. Now then, my webhosting is on a Windows 2003 server and therfore doesnt allow file permissions to be set (i.e CHMOD) so I can't simply have a file that the script updates by itself. However I have enabled the database engine on the hosting to allow a .txt or .csv file in a specific location (......\_private\myfolder\myfile.txt).

OK with me so far? I'n new at this so bare with me.

I need to know what i do to get the PHP script to output to that particular place. I think its more like a database than a file, but I don't really understand.

Any help welcomed.

P.S. the help, FAQ's and forum on my hosting are crap. and don't mention anything.

Link to comment
https://www.neowin.net/forum/topic/326182-database-and-php-question/
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Even though Windows doesn't support CHMOD, you can do (almost) the same thing through user permissions. Which, of course, would require access to the system. I used to run a site built on ASP that needed to access an Access database - and this file was placed directly into the web path. Though using permissions, the host was able to allow IIS to access the file but not the web user. I can't remember any more than that, but maybe that'll help you.

  • 0

thanks for the reply's but not exactly what I wa looking for. I really want a tutorial on how to use the database aspect of the website. As I said I have enable the ODBC database engine on my hosting to allow .txt or .csv files in a specific folder.

Any help appreciated. I know absolutely nothing about databases.

  • 0

ODBC is for connecting to a database. I believe there are ODBC drivers for dealing with .csv or some delimited .txt file and that is what you are talking about when you say ODBC being enabled on your hosting (though I'm still kinda unclear). That being said, ODBC wasn't made for dealing with delimited text files, it was made for dealing with relational databases.

Here is a tutorial on how to use ODBC to work on a Microsoft Access file through php:

Microsoft Access Database ODBC and PHP on phpfreaks.com

Interfacing with the text file is probably very similar, but I'm not sure how you send a text file a SQL string. Look up the specifics for whatever ODBC driver you are using.

-nic

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Russia is based in Cyprus. AdGuard is about as Russian as Telegram is.
    • Pixel Recall anyone? Or LiveRecall, OpenRecall or WindRecorder? Someone, somewhere wants your data.
    • HP 15.6-inch laptop is 20 percent off for students and everyday users by Paul Hill If you’re a student or casual user, this HP 15.6-inch laptop (model 15-fc0499nr) may be a good fit for you, as it has been discounted by 20% from $499.99 to just $399.99. It’s not a cutting-edge machine, but at this price, its core specs are solid, making it a great back-to-school option. It’s worth pointing out that this laptop carries an Amazon’s Choice badge and has over 1,000 purchases in just the last month, highlighting its popularity. Next, we'll discuss the specifications, followed by a buying link if you're interested in purchasing it. Powering this laptop is an AMD Ryzen 5 7520U processor, 8GB of LPDDR5 RAM, and a 512GB PCIe NVMe M.2 SSD. These aren’t the highest specs ever, but for everyday tasks, you should get your tasks done efficiently. The inclusion of the SSD means your system will boot quickly and your apps will launch fast, even if launching for the first time. It has a 15.6-inch HD touchscreen display, which is a key feature and a pretty big deal at this price point. If you find yourself with a task where a mouse isn’t suited, just touch the screen instead; it seems pretty useful for graphics work if you need to do some. One shortcoming of this device is that it uses integrated AMD Radeon Graphics, which is enough for casual entertainment and light creative work, but don’t expect to be playing heavy games. As for the operating system, this laptop ships with Windows 11 Home. It’s worth pointing out here that this is not a Copilot+ PC, so it will be missing Recall and other AI features, but it does have a Copilot key. This laptop is great if you’re going to be taking it to school or college, as it’s lightweight at just 3.52 lbs (1.6kg). It also has decent connectivity with 1 USB Type-C (data transfer only), 2 USB Type-A, 1 HDMI 1.4b, and a headphone/microphone combo jack. It also features Wi-Fi 6 and Bluetooth 5.3 for modern connectivity. Other notable features include the HP True Vision 720p HD camera with noise reduction for video calls and a camera privacy shutter. The laptop also has a long-lasting battery life of up to 12 hours and supports Fast Charge, which gets you to 50% in 45 minutes. If you’re convinced by this solid entry-level laptop, check out the buying link below: HP 15.6-inch laptop (model 15-fc0499nr): $399.99 (Amazon US) / MSRP $499.99 This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • Install a cheap Chinese clone of Adguard and then take support from call center to restore to Windows XP.
    • Does the job, although it can't run windows 11 officially. Currently running Windows 10 modded with ReviOS
  • Recent Achievements

    • Dedicated
      Snake Doc earned a badge
      Dedicated
    • One Month Later
      Philsl earned a badge
      One Month Later
    • One Year In
      armandointerior640 earned a badge
      One Year In
    • One Month Later
      armandointerior640 earned a badge
      One Month Later
    • Week One Done
      Itbob513626 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      614
    2. 2
      ATLien_0
      236
    3. 3
      Xenon
      155
    4. 4
      +FloatingFatMan
      123
    5. 5
      Michael Scrip
      115
  • Tell a friend

    Love Neowin? Tell a friend!