Re: What is my Mistake?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux