User Name Password Register
DaniWeb IT Discussion Community
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 374,019 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,757 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.
Please support our MySQL advertiser:
Views: 896 | Replies: 1
Reply
Join Date: Sep 2006
Posts: 1
Reputation: VisualMagix is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
VisualMagix VisualMagix is offline Offline
Newbie Poster

Putting Databases onto Pages

  #1  
Sep 30th, 2006
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Sep 2006
Location: NYC
Posts: 133
Reputation: sn4rf3r is an unknown quantity at this point 
Rep Power: 2
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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MySQL Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 11:09 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC