On 6/22/2014 1:00 AM, Ethan Rosenberg, PhD 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";>
<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
I fail to see how this script can do anything since you output an html
form that has errors in it (you just don't see the value in '' marks, do
you?) and then attempt to use php to process results. Is this just
sloppy programming and did you already run this script once to put this
same form out to the client?
Plus you insist on using deprecated styles in your tags. Also you
really must get used to wrapping your literal array indices in quotes
because it is going to bite you you-know-where one of these days.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
