Hosting crashed. Now i cant run certain php queries.

Paul_Ferrie

All i know is my hosting company's hardrive crashed. fortunatly they were able to do restore's using mirror drives.

All is good apart from what i am experincing now.
Any Query i run were it is calls for "WHERE something = something" dosnt work, example:

"SELECT FROM idblogg" // works
"SELECT FROM idblogg WHERE id='$id'" // dosnt work

Have you changed any php settings.

I did try tweeking the code to:
"SELECT * FROM idblogg WHERE id=". $_GET['id'] // works
But this only works sometimes as i have tried the same solution with a couple of my scripts.

Anyone any ideas?
Maybe a _php setting has been changed by the hosting adminstration?

Cheers
Paul

devinemke

sounds like they turned [man]register_globals[/man] off (which is good)

Paul_Ferrie

Reading your link, your probs right. But it means me having to recode a sh*tload of scripts 🙁

devinemke

Paul Ferrie wrote:
Reading your link, your probs right. But it means me having to recode a shtload of scripts 🙁

rather than thinking that i am "probs right", why not confirm it for yourself by checking the output from [man]phpinfo[/man], and if you indeed read the link you then know by now that you need to "recode a shtload of scripts" to make them more secure.

Paul_Ferrie

And there was me thinking my 7 days hols was going to be quiet.

This is going to be fun.

Thanks for your help.
I had a sneaking suspsion that the register_globals was turned off.
I did have a look at phpinfo.info before posting but i didnt see register_globals.
Have since found it.

Thanks again
Paul

nemonoman

RTFM. There are workarounds a plenty for your situation to be found there that will reduce your coding requirements; also a lot of information on why these workarounds are not a good idea, and a full code review is.

Paul_Ferrie

Rtfm?

nemonoman

!! STFW for RTFM !! >>> RTFM: Definition and Much More From Answers.com

click here for additional guidance