Getting slew of errors when running php script

**Oli Filth** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

mikey_boy said the following on 07/06/2005 21:03:[color=blue]
> Hello! Curious if anyone could give me a hand. I wrote this PHP
> script with makes a simple connection to a mysql database called
> firstdb and just pulls back the results and displays on the webpage.
>
> Here is the script.
>
> I appreciate any light that could be shed on the script and why I would
> get the errors.
>[/color]

What are the error-messages you get? (if you post the error messages,
it'll be easier for people to work out the problem then having to go
through your code looking for syntax errors, etc.)

--
Oli

**Andy Hassall** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

On 7 Jun 2005 13:03:54 -0700, "mikey_boy" <mbiehl2@gmail. com> wrote:
[color=blue]
>I appreciate any light that could be shed on the script and why I would
>get the errors.[/color]

What errors?

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

**Gordon Burditt** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

>Hello! Curious if anyone could give me a hand. I wrote this PHP[color=blue]
>script with makes a simple connection to a mysql database called
>firstdb and just pulls back the results and displays on the webpage.
>
>Here is the script.[/color]

WHERE ARE THE ERRORS?
[color=blue]
>I appreciate any light that could be shed on the script and why I would
>get the errors.[/color]

WHERE ARE THE ERRORS? Well, I'll just have to guess what's wrong.
[color=blue]
> $host = "localhost" ;[/color]

This is wrong. Your hostname should be in the .nsa.gov top-level domain.
And if you don't have clearance, they'll kill you.
[color=blue]
> $user = "root";[/color]

Wrong. This should be "Administra tor" or "Al Gore".
[color=blue]
> $pass = "*******";[/color]

Your password is incorrect, and too easy to guess.
[color=blue]
> //open a persistant connection to the database[/color]

mysql_connect() does not open a *PERSISTENT* connection.
[color=blue]
> $connect = mysql_connect($ host, $user, $pass);
>
> //Select the database
> mysql_select_db ("myfirstdb" , $connect);[/color]

You don't check whether this worked. Also, it's MyFristDB (as in
the Senator).
[color=blue]
>
> //Set and run the query
> $sql = "Select Employee_no, Last_name, First_name, Commission from
>Sales_Represen tative";[/color]

Wrong. This query should be "delete from Sales_Represent ative where Spams_Sent > 0".
[color=blue]
> $result = mysql_query($sq l, $connect);
>
> $x = mysql_num_rows( $result);
>
> //If the tenth row exists, go straight to it
> if ($x >= 10) {
> mysql_data_seek ($result, 9);
> }
>
> //Return the data from the 10th row
> $row = mysql_fetch_arr ay($result);
> Print "Employee_n o: " . $row["Employee_N o"] . "<br>\n";
> Print "Last_Name: " . $row["Last_Name"] . "<br>\n";
> Print "First_Name : " . $row["First_Name "] . "<br>\n";
> Print "Commission : " . $row["Commission "];[/color]

Isn't "print", not "Print" what you are trying to do here?[color=blue]
>
> ?>
>
>
>
></body>
></html>[/color]

Gordon L. Burditt

**mikey_boy** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

Here is the errors that display. I work in the IT field, I should've
know to post the errors...MY BAD!!
---------------------------------------------------------------------------------------------------------
Notice: Undefined variable: discovery in
C:\development_ site\Database.p hp on line 13

Notice: Undefined variable: root in C:\development_ site\Database.p hp on
line 13

Notice: Undefined variable: killer in C:\development_ site\Database.p hp
on line 13

Warning: mysql_pconnect( ) [function.mysql-pconnect]: Access denied for
user 'ODBC'@'localho st' (using password: NO) in
C:\development_ site\Database.p hp on line 13

Warning: mysql_select_db (): supplied argument is not a valid MySQL-Link
resource in C:\development_ site\Database.p hp on line 16

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in C:\development_ site\Database.p hp on line 20

Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
result resource in C:\development_ site\Database.p hp on line 22

Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL
result resource in C:\development_ site\Database.p hp on line 30
Employee_no:
Last_Name:
First_Name:
Commission:

**Andy Hassall** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

On 7 Jun 2005 14:48:59 -0700, "mikey_boy" <mbiehl2@gmail. com> wrote:
[color=blue]
>Here is the errors that display. I work in the IT field, I should've
>know to post the errors...MY BAD!!
>---------------------------------------------------------------------------------------------------------
>Notice: Undefined variable: discovery in
>C:\development _site\Database. php on line 13[/color]

This didn't come from the script you posted. It didn't contain "$discovery ".
[color=blue]
>Notice: Undefined variable: root in C:\development_ site\Database.p hp on
>line 13[/color]

This didn't come from the script you posted. It didn't contain "$root".
[color=blue]
>Notice: Undefined variable: killer in C:\development_ site\Database.p hp
>on line 13[/color]

This didn't come from the script you posted. It didn't contain "$killer".
[color=blue]
>Warning: mysql_pconnect( ) [function.mysql-pconnect]: Access denied for
>user 'ODBC'@'localho st' (using password: NO) in
>C:\development _site\Database. php on line 13[/color]

How about posting either:

(a) The errors from the script you posted, or
(b) The script that produced these errors.

Because they aren't the same. The one you posted used mysql_connect, and on a
different line number.
[color=blue]
>Warning: mysql_select_db (): supplied argument is not a valid MySQL-Link
>resource in C:\development_ site\Database.p hp on line 16[/color]

Because you didn't check for errors on the mysql_pconnect.
[color=blue]
>Warning: mysql_query(): supplied argument is not a valid MySQL-Link
>resource in C:\development_ site\Database.p hp on line 20[/color]

Because you didn't check for errors on the mysql_pconnect nor on the
mysql_select_db .
[color=blue]
>Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
>result resource in C:\development_ site\Database.p hp on line 22[/color]

Because you didn't check for errors on the mysql_pconnect nor on the
mysql_select_db nor on the mysql_query.
[color=blue]
>Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL
>result resource in C:\development_ site\Database.p hp on line 30[/color]

Because you didn't check for errors on the mysql_pconnect nor on the
mysql_select_db nor on the mysql_query nor mysql_num_rows.
[color=blue]
>Employee_no:
>Last_Name:
>First_Name:
>Commission:[/color]

You haven't got any data so they're all blank.

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

**Gordon Burditt** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

>Here is the errors that display. I work in the IT field, I should've[color=blue]
>know to post the errors...MY BAD!!
>---------------------------------------------------------------------------------------------------------
>Notice: Undefined variable: discovery in
>C:\development _site\Database. php on line 13
>
>Notice: Undefined variable: root in C:\development_ site\Database.p hp on
>line 13
>
>Notice: Undefined variable: killer in C:\development_ site\Database.p hp
>on line 13[/color]

I recommend fixing these, if necessary by using isset() on the variable
before using its value. But the big problem comes next:
[color=blue]
>Warning: mysql_pconnect( ) [function.mysql-pconnect]: Access denied for
>user 'ODBC'@'localho st' (using password: NO) in
>C:\development _site\Database. php on line 13[/color]

Here you have a serious problem: you can't connect to your
database. Test the login information using a command-line
client. And you really ought to have a password on your database,
even if it's only accessible via localhost.
[color=blue]
>Warning: mysql_select_db (): supplied argument is not a valid MySQL-Link
>resource in C:\development_ site\Database.p hp on line 16[/color]

Your connect failed, so you can't select a database. Fix previous
error first.
[color=blue]
>Warning: mysql_query(): supplied argument is not a valid MySQL-Link
>resource in C:\development_ site\Database.p hp on line 20[/color]

Your connect failed, so you can't do queries. Fix previous error first.
[color=blue]
>Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
>result resource in C:\development_ site\Database.p hp on line 22[/color]

Your query failed, so you didn't get a result. Fix previous error first.
[color=blue]
>Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL
>result resource in C:\development_ site\Database.p hp on line 30[/color]

Your query failed, so you didn't get a result. Fix previous error first.
[color=blue]
>Employee_no:
>Last_Name:
>First_Name:
>Commission:
>[/color]

Gordon L. Burditt

**glakk@potatoradio.f2s.com** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

<<<< 13 >>>>

**R. Rajesh Jeba Anbiah** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

Gordon Burditt wrote:
<snip>[color=blue][color=green]
> > Print "Commission : " . $row["Commission "];[/color]
>
> Isn't "print", not "Print" what you are trying to do here?[/color]

Isn't PHP case-insensitive?

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com

**Oli Filth** · Jul 17 '05, 01:30 PM

Re: Getting slew of errors when running php script

R. Rajesh Jeba Anbiah said the following on 08/06/2005 17:18:[color=blue]
> Gordon Burditt wrote:
> <snip>
>[color=green][color=darkred]
>>> Print "Commission : " . $row["Commission "];[/color]
>>
>>Isn't "print", not "Print" what you are trying to do here?[/color]
>
>
> Isn't PHP case-insensitive?[/color]

Indeed. PHP is case-insensitive for function names. But case-sensitive
for variable names.

P.S. Please fix your signature. It should start dash-dash-space to be
automatically trimmed.

--
Oli

**R. Rajesh Jeba Anbiah** · Jul 17 '05, 01:30 PM

[OT] Re: Getting slew of errors when running php script

Oli Filth wrote:[color=blue]
> R. Rajesh Jeba Anbiah said the following on 08/06/2005 17:18:[/color]
<snip>[color=blue][color=green]
> > Isn't PHP case-insensitive?[/color]
>
> Indeed. PHP is case-insensitive for function names. But case-sensitive
> for variable names.[/color]

Yeah, thanks:)
[color=blue]
> P.S. Please fix your signature. It should start dash-dash-space to be
> automatically trimmed.[/color]

It's not me, but GG.

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com

**mikey_boy** · Jul 17 '05, 01:45 PM

Re: Getting slew of errors when running php script

Andy-

I made the mistake and posted the wrong error message. I altered the
script a bit, but posted the orginal error message. I will post the
new error message that I get when I try running the new altered script.

Again sorry for the hassle.

I will keep you all posted.

Thanks for everyone's assistance.

Mike

Andy Hassall wrote:[color=blue]
> On 7 Jun 2005 14:48:59 -0700, "mikey_boy" <mbiehl2@gmail. com> wrote:
>[color=green]
> >Here is the errors that display. I work in the IT field, I should've
> >know to post the errors...MY BAD!!
> >---------------------------------------------------------------------------------------------------------
> >Notice: Undefined variable: discovery in
> >C:\development _site\Database. php on line 13[/color]
>
> This didn't come from the script you posted. It didn't contain "$discovery ".
>[color=green]
> >Notice: Undefined variable: root in C:\development_ site\Database.p hp on
> >line 13[/color]
>
> This didn't come from the script you posted. It didn't contain "$root".
>[color=green]
> >Notice: Undefined variable: killer in C:\development_ site\Database.p hp
> >on line 13[/color]
>
> This didn't come from the script you posted. It didn't contain "$killer".
>[color=green]
> >Warning: mysql_pconnect( ) [function.mysql-pconnect]: Access denied for
> >user 'ODBC'@'localho st' (using password: NO) in
> >C:\development _site\Database. php on line 13[/color]
>
> How about posting either:
>
> (a) The errors from the script you posted, or
> (b) The script that produced these errors.
>
> Because they aren't the same. The one you posted used mysql_connect, and on a
> different line number.
>[color=green]
> >Warning: mysql_select_db (): supplied argument is not a valid MySQL-Link
> >resource in C:\development_ site\Database.p hp on line 16[/color]
>
> Because you didn't check for errors on the mysql_pconnect.
>[color=green]
> >Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> >resource in C:\development_ site\Database.p hp on line 20[/color]
>
> Because you didn't check for errors on the mysql_pconnect nor on the
> mysql_select_db .
>[color=green]
> >Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
> >result resource in C:\development_ site\Database.p hp on line 22[/color]
>
> Because you didn't check for errors on the mysql_pconnect nor on the
> mysql_select_db nor on the mysql_query.
>[color=green]
> >Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL
> >result resource in C:\development_ site\Database.p hp on line 30[/color]
>
> Because you didn't check for errors on the mysql_pconnect nor on the
> mysql_select_db nor on the mysql_query nor mysql_num_rows.
>[color=green]
> >Employee_no:
> >Last_Name:
> >First_Name:
> >Commission:[/color]
>
> You haven't got any data so they're all blank.
>
> --
> Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
> <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool[/color]

Getting slew of errors when running php script

Getting slew of errors when running php script

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment