User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,023 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,556 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our MySQL advertiser: Programming Forums

Putting Databases onto Pages

•
•
Join Date: Sep 2006
Location: NYC
Posts: 133
Reputation: sn4rf3r is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 2
sn4rf3r's Avatar
sn4rf3r sn4rf3r is offline Offline
Junior Poster

Re: Putting Databases onto Pages

  #2  
Oct 2nd, 2006
•
•
•
•
Originally Posted by VisualMagix View Post
Hello,

I have a database in Access, and I know SQL coding for it. So i wrote a query that would get different things from database and put it all together in a nice table.. I update the database, it updates the output from query. I also have a website, built in xhtml, so nothing fancy.

Website files and database are both on same computer server and folder. How can I insert some code onto my webpage, that would open and run this query, and basically import my access database on website? Sure, you can say - read up on it... But i'm still reading on how to create a server, SQL coding, and further Java, so I'm fried... Any help, doens't have to be code, though that would help, would be appreciated.


Use an easier language like Python or PHP and create a file updatetable.php, which holds the code needed to run youre desired query. You can pass parameters to the file and whatever else you want to do. You can make that file a link on the first page, when the user clicks it they will be taken to the updateTable.php and once the table has been updated you can re-route the user back to the view (first page).

This is very hackish but will work for what you need to do. Also for php to run you will need to be running apache, I suggest using XAMPP or somethign similar. Google XAMPP and you should find a self installing WAMPP stack.
Reply With Quote  
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 2:50 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC