PHP Page and Database Not Interfacing

PHP Page and Database Not Interfacing

am 23.02.2006 23:08:47 von Neil

Our hosting company's server went down a few days ago. After they fixed
it, our PHP Page and Database are not interfacing. They are not
believing me that I have done nothing on my end in several months with
uploading new files or doing anything with the database, insisting I
have to fix this myself. I am somewhat adept at html, but had a friend
get me started on the database -- then I took over, entering new data,
revising fields, but know nothing of what is done before that.

I will be happy to attach to an email to you the php file and a screen
shot of the database summary page (that appears after using PHPMyAdmin
to enter the database).
To protect your email address, you can go to our website:

carolwilsongallery.com

and send an email on this subject. I'll respond with the attachments.
And I promise to post the solution here after we are done.

I'm quite sure the solution is very simple, and an expert would be able
to tell me exactly what to do in a few minutes.

Thanking you in advance.

Re: PHP Page and Database Not Interfacing

am 24.02.2006 07:29:10 von Jim Michaels

"Neil" wrote in message
news:1140732527.747967.121570@t39g2000cwt.googlegroups.com.. .
> Our hosting company's server went down a few days ago. After they fixed
> it, our PHP Page and Database are not interfacing. They are not
> believing me that I have done nothing on my end in several months with
> uploading new files or doing anything with the database, insisting I
> have to fix this myself. I am somewhat adept at html, but had a friend
> get me started on the database -- then I took over, entering new data,
> revising fields, but know nothing of what is done before that.
>
> I will be happy to attach to an email to you the php file and a screen
> shot of the database summary page (that appears after using PHPMyAdmin
> to enter the database).
> To protect your email address, you can go to our website:
>
> carolwilsongallery.com
>
> and send an email on this subject. I'll respond with the attachments.
> And I promise to post the solution here after we are done.
>
> I'm quite sure the solution is very simple, and an expert would be able
> to tell me exactly what to do in a few minutes.
>
> Thanking you in advance.
>

it would be interesting to see some of the PHP db code (don't post passwords
or usernames or server names). Is it able to connect, but just not able to
do queries or select the db?

did you ever make periodic backups of your data or your site?

Re: PHP Page and Database Not Interfacing

am 24.02.2006 07:35:45 von Jim Michaels

"Neil" wrote in message
news:1140732527.747967.121570@t39g2000cwt.googlegroups.com.. .
> Our hosting company's server went down a few days ago. After they fixed
> it, our PHP Page and Database are not interfacing. They are not
> believing me that I have done nothing on my end in several months with
> uploading new files or doing anything with the database, insisting I
> have to fix this myself. I am somewhat adept at html, but had a friend
> get me started on the database -- then I took over, entering new data,
> revising fields, but know nothing of what is done before that.
>
> I will be happy to attach to an email to you the php file and a screen
> shot of the database summary page (that appears after using PHPMyAdmin
> to enter the database).
> To protect your email address, you can go to our website:
>
> carolwilsongallery.com
>
> and send an email on this subject. I'll respond with the attachments.
> And I promise to post the solution here after we are done.
>
> I'm quite sure the solution is very simple, and an expert would be able
> to tell me exactly what to do in a few minutes.
>
> Thanking you in advance.
>

if the db got corrupted, it would be a task to go through all the queries in
the PHP source code to recreate the tables from scratch, but it could be
done.

Did they do a tape restore of the database, or was it completely wiped?

Re: PHP Page and Database Not Interfacing

am 24.02.2006 17:40:26 von Neil

I found the answer at:

http://us2.php.net/register_globals

Our hosting company evidently upgraded their version of php, and I had
to insert some new statements into the php file that interfaces with
the data base.