Re: PHP Mystery
| From: | Ashley Sheridan | Date: | Sun, 22 Jun 2014 07:39:22 +0000 |
| Subject: | Re: PHP Mystery | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-323508@lists.php.net to get a copy of this message | ||
On 22 June 2014 06:00:17 BST, "Ethan Rosenberg, PhD"
<erosenberg@hygeiabiomedical.com> wrote:
>Dear List -
>
>Here is a simple program.
>
>It ran before, but not now...
>
><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
>"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"B
>ææ¥ìñ™É…!0Âæ>
><html xmlns="http://www.w3.org/1999/xhtml">
>
><html>
> <head>
> </head>
> <body>
> <div align="center">
> <form method="post">
> <input type='text' name=phone></input>
> <input type='submit'>
> <br /><br /><br />
> </form>
> </div>
><?php
> error_reporting(-1);
> require '/home/ethan/PHP/ethan.inc';
> $db = "Store";
>$cxn = mysqli_connect($host,$user,$password,$db);
> if (!$cxn)
> {
> die('Connect Error (' . mysqli_connect_errno() . ') '
> . mysqli_connect_error());
> }
>
>//if no connection no error message
>
> $phn = $_POST[phone];
>
>//Phone is a 10 digit numerical string, no spaces
>
> $phn = (string)$phn;
>
> $dsh = '-';
> $Phn =
>$phn[0].$phn[1].$phn[2].$dsh.$phn[3].$phn[4].$phn[5].$dsh.$phn[6].$phn[7].$phn[8].$phn[9];
>
>//construct phone number 123-466-7890
>
> $sql1 ="select Lname, Fname from Customers where Phone = '$Phn' ";
>
> $result1 = mysqli_query($cxn, $sql1);
> if(!$result1)
> {
>?>
> <div align="center">
>
> <strong>No Match Found</strong>
> <br /><br />
> </div>
><?php
> }
>
>//if query fails, no error message.
>
>
>//code to display query results, not listed.
>
>
>
>TIA
>
>Ethan
How is it failing? When you say no error message, do you mean none displayed? It's unusual for
an error not to appear in your error logs. Have you checked them?
Thanks,
Ash