ready to publish?? bit of help needed.

gat

hello,

Obviously at home i have apachie running so i can test my php pages.

in the database, i have hundreds of image paths.
and they are all currently,

http://localhost/images

so i heard that you can either dump the whole database to a text file and do a find & replace.

Or becuase i use phpmyadmin, i can do a query to replace all the localhost address's with my actual domain.

Could someone please tell me how this can be done?

many thanks,

mullz

Im not too hot on databases but cant you just have a relative link instead of absolute?

e.g

../images/myimage.jpg

instead of

http://www.myserver.com/folder1/images/myimage.jpg

gat

true, but then im going to have to edit each row, and i have 575.
thats a lot of editing.

Im really after the search and replace method, or if it can be done in php myadmin?

anyone else know?

kevinsequeira

continuing on what mullz, dont hard code the server name in the table, use relative links to store the image path.
like /images/image_name.jpg
or even better just store the image name like image_name.jpg and use the script where u display the image to append the full path to the image

reg
kevin

gat

ok, so relative links are better.

but if each row currently has http://localhost/images?

is there an easy way to delete the "http://localhost"
form each row, because like i said above, i have 575 image paths.....

there must be an efficient way?

mullz

the txt pad is probably the easiest but your better off using a comma delimited file or csv file..

That'l keep your tables in order and can easily imported back into databases etc..

I may be talking complete dog poop.. I don't know. :rolleyes:

gat

ok, i have heard about converting into a text file,
But i want to know...How to do it?

because i have about 10 or so tables?
so do i do each table individually?

or can i do the whole DB???

someone must have done this before?

mullz

What options do you get when you want to export?

If you export to a csv file it should take all tables with it because its just a raw data file..

mullz

Save an object's output as a Rich Text Format file

In the Database window, click the name of the object you want to save. To save a selection of a datasheet, open the datasheet and select the portion of the datasheet before continuing.

On the File menu, click Export.

In the Save as type box, click Rich Text Format (*.rtf).

Click the arrow to the right of the Save in box, and select the drive or folder to save to.

In the File name box, enter a name for the file (or use the suggested name).

Do one of the following:

If you are saving a datasheet, click Export All to save the entire datasheet or click the arrow to the right of the Export All box, and select Save Selection if you selected a portion of the datasheet in step 1.

For all other database objects, click Export.

Any help?

(using Microsoft Access)

Davidc316

Could you let me know your domain name once you get it up and running?

I'm just starting out with PHP and I'd be very interested to your site in action.