Re: What is my Mistake?

On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers <karl@designdrumm.com> wrote: > On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers <karl@designdrumm.com> wrote: > >> On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg <erosenberg@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"> >> <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.