mysql - PHP Loop with multiple rows -

-

i have php code:

$number = substr_replace($_post["number"],"44",0,1);  $sql="select * channel_did did '%".$number."%' , (client_id = '' or client_id null or client_id = '611') , (extension_id = '' or extension_id null) "; $rs=mysql_query($sql,$pbx01_conn) or die(mysql_error()); while($result=mysql_fetch_array($rs)) {     $numbers_list = $result["did"].'<br>';     $email_body = '<font face="arial">     hello, here numbers have requested.<br><br>     please aware these numbers in public pool , not reservered, therefore assigned client @ time.<br><br>     please make choice possible guarantee number require.<br><br>     '.$numbers_list.'<br><br>     kind regards,<br><br>     customer services<br>     integra digital<br><br>     tel: 01702 66 77 27<br>     email: support@domain.co.uk<br>     web: www.integradigital.co.uk     </font>'; }      echo $email_body;  sendemail($_post["emailto"],"integra digital <no-reply@domain.co.uk>","voip phone numbers requested",$email_body,"no-reply@domain.co.uk");

it selects rows table , need email 1 email list of rows

when run sql know there 10 rows (did)

when sends email, using $email_body variable putting 1 row in email.

i have created $numbers_list variable should have list of rows 1 row.

create array(), push rows data it.. , use implode() in $email_body;

try this

while($result=mysql_fetch_array($rs)) {     $numbers_list[] = $result["did"];  }   $email_body = '<font face="arial">     hello, here numbers have requested.<br><br>     please aware these numbers in public pool , not reserved, therefore assigned client @ time.<br><br>     please make choice possible guarantee number require.<br><br>     '.implode('<br>',$numbers_list).'<br><br>     kind regards,<br><br>     customer services<br>     integra digital<br><br>     tel: 01702 66 77 27<br>     email: support@integradigital.co.uk<br>     web: www.integradigital.co.uk     </font>';

and mysql deprecated have mysqli or pdo


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more