justhost

Does anyone have any input on this?

Hello all, I have just taken over a site which was developed in php / mySQL. It is a large shopping cart system. I was shocked to learn that their mySQL database was over 1GB in size. I have seen forum DB's get very large but never that large for a shopping cart site so I investigated further. It turns out they have stored all of the product images and I believe even many of the basic site images in the database itself as a longblob type. There is one table that is 860MB in size. Although I knew you could store images in this fashion I have personally never done this. Now my question I have is would this cause the site to load very slow. The client has been complaining that all of the product images load extremely slow since the site was changed from osCommerce over to this new custom site? When I sit and think about the logic it makes sense that it would be slower and would also be much more resource intensive. I wouldnt think that the images would ever cache then on the client PC and that evey time the page loads it is going to have to transfer all of the images from the DB to the client... For example once a page has loaded completely and then you click refresh it takes nearly as long to load the page again as it did the first time. That simply doesnt make sense. Does anyone have any input or comments on this? I have uploaded a demo of the site at the following: http://www.justhosting-test.com Thank you. Keith

[quote author=HuggieBear link=topic=112913.msg458503#msg458503 date=1161946561] I think that the short answer is no.  It can be done the other way around, you can log into an .htaccess protected directory and automatically be authenticated with php, but not the other way around. Regards Huggie [/quote] Would you mind telling me how you would do this then? This would work for what I am trying to do. Thank you. Keith G

Did you ever get a resolution to this? This is exactly what I am trying to do with similar results..... Thank you.

See the issue I am having is this. I have used php / mySQL login authentication to secure all of the php pages in the members area of a site. The problem I have is what if there are html files or pdf files in the members folder that I dont want people to have access to? For example, my members folder is /public_html/members/ and I have a documents folder in there where I store pdf files for members only at /public_html/members/documents/. If I only use php for authentication (ie user/pass from mysql database) then someone can browse directly to one of the pdf files and view it without a password (ie www.domainname.com/members/documents/file1.php). The only way I know of to prevent this is with htaccess file. I need to maintain the php login which integrates with the mySQL table since the members area is customized per member? Can anyone give me an idea as to what I need to do??? Thank you. Keith G

Hello I am just wondering if someone might have a step-by-step for installing phpmyadmin on a Windows Server 2003 box running IIS and Helm CP? I am also curious on a few of the config.in.php settings? host, controluser/pass, auth-type, user/pass? Thank you in advance.