On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
> On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
>
>> On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx> 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">
>> <th>Cust. Number</th>
>> <th>Last Name</th>
>> <th>First 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
