Re: [PHP-DB] What is my Mistake?
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is then
tested for validity, and if valid the results of the query are displayed. I
cannot get to the display part.
Here is the code:
...
TIA
Ethan
Hi Ethan,
Try this. I did it on the fly and haven't tested, but I think it will put you
on the right path.
You most likely will have to put your own juice on $return_string.
I tried to follow as best as I could to the type of output your wanting.
HTH.
[CODE]
switch (step) {
case 'step28':
$return_string = 'Here we are, Step 28';
$Phone = ;
$phn = $_POST['phone'];
$dsh = '-';
$i = 0;
while($i strlen($phn)) {
if($i === 2 || $i === 6) {
$Phone .= $phn[$i].$dsh;
} else {
$Phone .= $phn[$i];
}
$i++;
}
$sql1 =SELECT Cust_Num, Lname, Fname FROM Customers WHERE Phone =
'.mysqli_real_escape_string($Phone).' ;
$result1 = mysqli_query($cxn, $sql1);
$return_string .= 'here2';
if ( 0 === $result1-num_rows ) {
$return_string = 'div style=text-align:center;strong
style=margin-bottom:32px;No Match Found/strong/div';
} else {
$return_string .= 'here3';
$return_string .= 'br /result. '.$result1;
$result = 0;
$return_string .= 'div style=text-align:center;
table border=4 cellpadding=5 cellspacing=55 rules=all
frame=box
tr class=heading
thCust. Number/th
thLast Name/th
thFirst Name/th
/tr';
$row1 = mysqli_fetch_row($result1);
while($row1) {
$return_string .= 'tr
td'.htmlspecialchars($row1[0]).'/td
td'.htmlspecialchars($row1[1]).'/td
td'.htmlspecialchars($row1[2]).'/td
/tr';
}
}
$return_string .= '/table/div';
break;
}
[END CODE]
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] What is my Mistake?
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is
then tested for validity, and if valid the results of the query are
displayed. I cannot get to the display part.
Here is the code:
...
TIA
Ethan
Hi Ethan,
Try this. I did it on the fly and haven't tested, but I think it will put you
on the right path.
You most likely will have to put your own juice on $return_string.
I tried to follow as best as I could to the type of output your wanting.
HTH.
[CODE]
switch (step) {
case 'step28':
$return_string = 'Here we are, Step 28';
$Phone = ;
$phn = $_POST['phone'];
$dsh = '-';
$i = 0;
while($i strlen($phn)) {
if($i === 2 || $i === 6) {
$Phone .= $phn[$i].$dsh;
} else {
$Phone .= $phn[$i];
}
$i++;
}
$sql1 =SELECT Cust_Num, Lname, Fname FROM Customers WHERE Phone =
'.mysqli_real_escape_string($Phone).' ;
$result1 = mysqli_query($cxn, $sql1);
$return_string .= 'here2';
if ( 0 === $result1-num_rows ) {
$return_string = 'div style=text-align:center;strong
style=margin-bottom:32px;No Match Found/strong/div';
} else {
$return_string .= 'here3';
$return_string .= 'br /result. '.$result1;
$result = 0;
$return_string .= 'div style=text-align:center;
table border=4 cellpadding=5 cellspacing=55 rules=all
frame=box
tr class=heading
thCust. Number/th
thLast Name/th
thFirst Name/th
/tr';
$row1 = mysqli_fetch_row($result1);
while($row1) {
$return_string .= 'tr
td'.htmlspecialchars($row1[0]).'/td
td'.htmlspecialchars($row1[1]).'/td
td'.htmlspecialchars($row1[2]).'/td
/tr';
}
}
$return_string .= '/table/div';
break;
}
[END CODE]
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
Oh and you might have to check if $i is equal to the string length to get the
10th number.
So swap this part.
while($i strlen($phn)) {
with this...
while($i = strlen($phn)) {
Thought of it after the fact.. sorry.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] What is my Mistake?
On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is
then tested for validity, and if valid the results of the query are
displayed. I cannot get to the display part.
Here is the code:
...
TIA
Ethan
Hi Ethan,
Try this. I did it on the fly and haven't tested, but I think it will put
you on the right path.
You most likely will have to put your own juice on $return_string.
I tried to follow as best as I could to the type of output your wanting.
HTH.
[CODE]
switch (step) {
case 'step28':
$return_string = 'Here we are, Step 28';
$Phone = ;
$phn = $_POST['phone'];
$dsh = '-';
$i = 0;
while($i strlen($phn)) {
if($i === 2 || $i === 6) {
$Phone .= $phn[$i].$dsh;
} else {
$Phone .= $phn[$i];
}
$i++;
}
$sql1 =SELECT Cust_Num, Lname, Fname FROM Customers WHERE Phone =
'.mysqli_real_escape_string($Phone).' ;
$result1 = mysqli_query($cxn, $sql1);
$return_string .= 'here2';
if ( 0 === $result1-num_rows ) {
$return_string = 'div style=text-align:center;strong
style=margin-bottom:32px;No Match Found/strong/div';
} else {
$return_string .= 'here3';
$return_string .= 'br /result. '.$result1;
$result = 0;
$return_string .= 'div style=text-align:center;
table border=4 cellpadding=5 cellspacing=55 rules=all
frame=box
tr class=heading
thCust. Number/th
thLast Name/th
thFirst Name/th
/tr';
$row1 = mysqli_fetch_row($result1);
while($row1) {
$return_string .= 'tr
td'.htmlspecialchars($row1[0]).'/td
td'.htmlspecialchars($row1[1]).'/td
td'.htmlspecialchars($row1[2]).'/td
/tr';
}
}
$return_string .= '/table/div';
break;
}
[END CODE]
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
Oh and you might have to check if $i is equal to the string length to get the
10th number.
So swap this part.
while($i strlen($phn)) {
with this...
while($i = strlen($phn)) {
Thought of it after the fact.. sorry.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
Also Ethan,
Here are some links I'd like to share with you which I think if you peruse
through these,
will give you a better understanding on,
one: how to protect the database
http://us2.php.net//manual/en/mysqli.real-escape-string.php
two: how to display the data from that database.
http://www.php.net//manual/en/function.htmlspecialchars.php
Both are pretty quick reads and will give you more familiarity with what your
working on I believe.
I noticed you never use these and IMO they are essential to good database
programming.
HTH,
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
PS: Others may have a better way then I, but this was a quick throw together.
Forgive me if it isn't 100% on the money.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] What is my Mistake?
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is
then tested for validity, and if valid the results of the query are
displayed. I cannot get to the display part.
Here is the code:
case 'step28':
{
echo here
we are, step 28;
$phn =
$_POST['phone'];
$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];
$sql1 =select Cust_Num, Lname, Fname from Customers where
Phone = '$Phn' ;
echo
$sql1;
$result1 = mysqli_query($cxn, $sql1);
echo
'here2';
if ( 0 ===
$result1-num_rows )
{
?
div
align=center
strongNo Match Found/strong
br
/br /
/div
?php
}
echo
'here3'; //stops at this point .
echo br
/result. $result1;
print_r($result1);
$result
= 0;
?
div
align=center
table border=4 cellpadding=5 cellspacing=55 rules=all
frame=box
tr
class='heading'
thLast
Name/th
thFirst
Name/th
?php
while($row1 = mysqli_fetch_row($result1))
{
$Cust_Num = $row1[0];
$Lname = $row1[1];
$Fname = $row1[2];
?
tr
td
?php echo $Cust_Num; ? /td
td
?php echo $Lname; ? /td
td
?php echo $Fname; ? /td
/tr
?php
}
?
/table
/div
?php
break;
}
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
