Re: [PHP-DB] What is my Mistake?
On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers wrote:
> On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers wrote:
>
>> On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
>> 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 = '> style="margin-bottom:32px;">No Match Found';
>> } else {
>> $return_string .= 'here3';
>> $return_string .= 'result. '.$result1;
>> $result = 0;
>> $return_string .= '
>> > frame="box">
>>
>> Cust. Number
>> Last Name
>> First Name
>> ';
>> $row1 = mysqli_fetch_row($result1);
>> while($row1) {
>> $return_string .= '
>> '.htmlspecialchars($row1[0]).'
>> '.htmlspecialchars($row1[1]).'
>> '.htmlspecialchars($row1[2]).'
>> ';
>> }
>> }
>> $return_string .= '';
>> 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
Re: [PHP-DB] What is my Mistake?
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers wrote:
> On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
> 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 = ' style="margin-bottom:32px;">No Match Found';
> } else {
> $return_string .= 'here3';
> $return_string .= 'result. '.$result1;
> $result = 0;
> $return_string .= '
>frame="box">
>
> Cust. Number
> Last Name
> First Name
> ';
> $row1 = mysqli_fetch_row($result1);
> while($row1) {
> $return_string .= '
> '.htmlspecialchars($row1[0]).'
> '.htmlspecialchars($row1[1]).'
> '.htmlspecialchars($row1[2]).'
> ';
> }
> }
> $return_string .= '';
> 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 12:27 AM, Ethan Rosenberg
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 = 'No Match Found';
} else {
$return_string .= 'here3';
$return_string .= 'result. '.$result1;
$result = 0;
$return_string .= '
Cust. Number
Last Name
First Name
';
$row1 = mysqli_fetch_row($result1);
while($row1) {
$return_string .= '
'.htmlspecialchars($row1[0]).'
'.htmlspecialchars($row1[1]).'
'.htmlspecialchars($row1[2]).'
';
}
}
$return_string .= '';
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
