View Full Version : Queries without a webserver
01-04-2005, 08:51 AM
I've tried Apache and Abssy websever to run a local server but there seems to be a problem with my computer so I want to know if it's possible that I can be able to make live queries to MySql without having a webserver. All I want to see is if the data in my database will appear on my website.ie I want to display data using drop-downs.
I thought I can do that using just static html pages but it seems that it's not the case. What's the plan?
01-04-2005, 02:59 PM
Not sure. but just a couple of thoughts.
For people to view the SQL results they would have to access where the SQL is. This would mean that you would have to run your local PC as a server and have it permantly connected to the web with a decent to and from speed. Given that hosting is so cheap I can't see the point unless you are going to create a local intranet and restrict web access.
01-05-2005, 06:23 AM
I do have my website hosted already. I only need these because I don't have the internet at home so I still have to export the databases to the hosting server.
So it's just a matter of working offline
01-05-2005, 06:47 AM
Have you managed to install Apache, MySql, PHP and something like PHPMySql (to manage the databases) on your PC?
It might just be easier to design your database in Access and then export the tables as sql scripts. They might need a little tweaking befoer loading into the MySql database on the server but most of the work would have been done database-wise.
01-05-2005, 07:27 AM
I used Apache and PHP4 2 months ago and everthing worked exceptionally well but a couple of days ago I tried but the files look a bit different do you have a simple way of configuring using the current files?
Which ones will you recomend if I'm using XP Pro?
I do have mySql already installed.
If you have a second would you please list for me all downloads I need inorder to carry the folowing tasks:
1. A database with information about images and Images('m still not sure about this)
2. Show categories of images on the website and under each categories show a drop-down will references of images in that category.
3. If a user selects a reference of from the drop-down, the image is displayed.
Please help me on these I know I might not be clear in my description.
01-05-2005, 07:40 AM
Sorry, I don't even apache, php and mysql on my pc, so I can't advise on that.
Your drop down lists are a feature of the form that you want to use rather than anything to do with the database.
I don't know if you want to store image file names in the database or actual images.
Since you have php and mysql, why don't you insall a ready-made software package for images? Coppermine or Gallery are good, there are many others too.
What do you mean the files looked diferent? Which files? your images?
01-05-2005, 08:41 AM
I mean the files I download from php.net
01-06-2005, 03:15 AM
I used Apache and PHP4 2 months ago and everthing worked exceptionally well but a couple of days ago I tried but the files look a bit different do you have a simple way of configuring using the current files? and the computer is not connected to the internet you say?
If so it's something you did more than likely. btw Apache, MySQL, PHP4 and phpMyadmin work perfectly on xp pro -I use it - just make sure you take regular exports of the MySQL to be on the safe side and store them to disc. Any hitches or problems I know I can go back to where I want.
In your case - I would have backed every thing up first - data base etc - then this
reboot to safe mode options screen/select ' Start from Last Known good config' - This generally sorts the kind of 'Glitches' you describe, which is just the usual naf windows crap messing about. If that doesn't work, I would then use System restore and go back a day or two.
I also have 1 more option but that involves doing registry export/imports - i.e. I will export my current registry - and import a registry where I knew every thing was ok. To me it is the most powerful administrative option. However 2 points
1. BE SURE YOU KNOW EXACTLY WHAT YOUR DOING FIRST
2. ALLWAYS EXPORT YOUR CURRENT REGISTRY BEFORE YOU IMPORT A BACK UP/RESTORE REGISTRY
I have capitalised these 2 points on purpose - they are very (id I say 'Very' ;) ) Important.
I can rebuild my system virtually from scratch - or change from say my web-design work to music simply by doing this and using iso's - Like I say though be sure to know what your doing first - Otherwise you have a lot of formatting work on your hands but you learn by the mistakes - I know I did LOL ;)
Anyway from what I can see that was your first problem you mentioned....:)
01-06-2005, 05:28 AM
Nomad, I have no idea how you deduced all this from this thread. :lol:
I'm not clear at all what the problem is or if there is a problem, much less what the solution might be :lol:
01-06-2005, 06:18 AM
I always ask myself how on earth was I lucky to join this forum....you guys are so knowledgeable. By the way I managed to get PHP4 running using the .zip package so I'm sorted.
You seem to be using exactly what I intend to use, do you mind giving me an idea as to how I can carry this task,
I need to have a database which keeps image information for 11 different animal species(http://www.africanwildlifephotos.co.za), these 11 categories have a number of sub-categories. So I need to design my database such that under amphibians(check the website: http://www.africanwildlifephotos.co.za) on the last column I replace the number of available images with a drop-down showing references to images.
I do have the database in excel format and all images named ie. if the reference is AB_1 then the name of the image is AB_1.jpg.
How I can I achieve this?
Also please help me with this:
After having Apache, PHP, MySql, MySqlAdmin,PHPMYSQL how to I use all these utilities as 1 system?
vBulletin® v3.8.5, Copyright ©2000-2013, Jelsoft Enterprises Ltd.