Re: Re: What is my Mistake?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On 06/24/2014 08:12 PM, Ethan Rosenberg, PhD wrote:
On 06/24/2014 01:55 PM, Jim Giner wrote:
Looking at your code again, I think that your query failed and your lack
of error reporting isn't showing the error that occurred when  you tried
to access a property of the result which is not a resource but merely a
value of 'false'.

One should ALWAYS check the result of operations before assuming that
they succeeded and proceeding onwards in code.  Saves lots of lost time.

Jim -


Error checking as per your instructions.
No errors.

Attached are two files.  I tried to mimic the behavior of the program.
One file does the data input and the second processes it.

The display on the browser screen is

select Cust_Num, Lname, Fname from Customers where Phone =
'845-123-3298' here2here3
Last Name     First Name

When the above query is run from the command line -

mysql> select Cust_Num, Lname, Fname from Customers where Phone =
| Cust_Num | Lname  | Fname |
|        1 | Kitten | Gingy |
|     1153 | Puppy  | Woofy |
|     1154 | Puppy  | Woofy |



Jim -

I think I know the problem.

These two lines of code were added -

									$nmbr=mysqli_num_rows ( $result1 );
									echo '<br />number of rows $nmbr';

The echo statement does not return a number.
Therefore ... bad connection. The script failed at the output stage because there were no results.

I'm again attaching the two files. They are somewhat modified. The only thing in the first file is the form. The second file contains the calculations



I have made the linnk $cxn a global variable in the in both scripts.

Attachment: TestPh.php
Description: application/httpd-php

Attachment: StartTestPh2.php
Description: application/httpd-php

PHP Database Mailing List (
To unsubscribe, visit:

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux