reakt

Boss just linked me to this http://php.net/manual/en/language.types.float.php The php manual actually says "never compare floating point numbers for equality". Guess I'll know for next time.

Hi all. I am having an issue with PHP comparing variables and returning inconsistent (and i think incorrect) results. Here is my script: function isItMeOr($invoiceId) { // Tally invoice amount $invTotal = 0; $sql8 = mysql_query("SELECT qty, discountPercent, amount FROM Invoice_Items WHERE Invoice_Items.invoiceId = '$invoiceId' AND Invoice_Items.active = '1'"); while ($result8 = mysql_fetch_array($sql8)) { $qty = $result8['qty']; echo "qty: $qty\n"; $amount = $result8['amount']; echo "amount: $amount\n"; $discountPercent = $result8['discountPercent']; echo "discountPercent: $discountPercent\n"; $invTotal = $invTotal + ($qty * round(($amount - ($amount * ($discountPercent / 100))), 2)); echo "invTotal: $invTotal\n"; } echo "\n"; // Tally payments $invPayments = 0; $sql9 = mysql_query("SELECT amount FROM Payment_Allocations WHERE invoiceId = '$invoiceId'"); while ($result9 = mysql_fetch_array($sql9)) { $payAmount = $result9['amount']; echo "payAmount: $payAmount\n"; $invPayments = $invPayments + $payAmount; echo "invPayments: $invPayments\n"; } echo "\n"; // Compare echo "invTotal: $invTotal (" . gettype($invTotal) . ")\n"; echo "invPayments: $invPayments (" . gettype($invPayments) . ")\n"; if ($invTotal == $invPayments) { echo "invTotal == invPayments\n"; } if ($invTotal < $invPayments) { echo "invTotal < invPayments\n"; } if ($invTotal > $invPayments) { echo "invTotal > invPayments\n"; } // Convert to string and compare again $invTotalAsStr = (string) $invTotal; $invPaymentsAsStr = (string) $invPayments; echo "invTotalAsStr: $invTotalAsStr (" . gettype($invTotalAsStr) . ")\n"; echo "invPaymentsAsStr: $invPaymentsAsStr (" . gettype($invPaymentsAsStr) . ")\n"; if ($invTotalAsStr == $invPaymentsAsStr) { echo "invTotalAsStr == invPaymentsAsStr\n"; } if ($invTotalAsStr < $invPaymentsAsStr) { echo "invTotalAsStr < invPaymentsAsStr\n"; } if ($invTotalAsStr > $invPaymentsAsStr) { echo "invTotalAsStr > invPaymentsAsStr\n"; } echo "\n\n"; } isItMeOr('15126'); isItMeOr('15171'); And here is the output: qty: 1 amount: 55 discountPercent: 0 invTotal: 55 qty: 1 amount: 49.95 discountPercent: 0 invTotal: 104.95 payAmount: 104.95 invPayments: 104.95 invTotal: 104.95 (double) invPayments: 104.95 (double) invTotal == invPayments invTotalAsStr: 104.95 (string) invPaymentsAsStr: 104.95 (string) invTotalAsStr == invPaymentsAsStr qty: 1 amount: 64.9 discountPercent: 0 invTotal: 64.9 qty: 1 amount: 49.95 discountPercent: 0 invTotal: 114.85 qty: 1 amount: 99 discountPercent: 0 invTotal: 213.85 payAmount: 213.85 invPayments: 213.85 invTotal: 213.85 (double) invPayments: 213.85 (double) invTotal > invPayments invTotalAsStr: 213.85 (string) invPaymentsAsStr: 213.85 (string) invTotalAsStr == invPaymentsAsStr As you can see, the results for invoice '15126' come back as you would expect. The result for '15171' says invTotal > invPayments even though they are the same. Changing them to strings fixes the issue, however I'd still like to know why it's happening in the first place. Does anyone know what's going on here or what I can do to avoid such a pitfall in future? Thanks

I apologise for wasting your time guys. I've just realized I was running my php script on one mysql installation, and testing the query in phpmyadmin on another installation. They are supposed to be the same, but I just found the table Service_Groups doesn't exist on the dev installation. Once again, sorry!

I have a connection with the db, just didn't want to copy it in for security reasons. To prove the connection is ok, I added another query before the offending one, which works fine. I added your error reporting bit too and now I get a warning: $sql = mysql_query("SELECT * FROM Recurring_Charges"); $num_rows1 = mysql_num_rows($sql); echo "num_rows1 is $num_rows1<br />\n"; $itemId = '3806'; $sql4 = mysql_query("SELECT Recurring_Charges.serviceType, Recurring_Charges.description, Recurring_Charges.period, Recurring_Charges.amount, Service_Groups.name FROM Recurring_Charges, Service_Groups, Hosting_Services WHERE Hosting_Services.id = Recurring_Charges.serviceId AND Service_Groups.id = Hosting_Services.groupId AND Recurring_Charges.invoiceItemId = '$itemId'"); $num_rows = mysql_num_rows($sql4); echo "num_rows is $num_rows<br />\n"; while ($result4 = mysql_fetch_array($sql4)) { echo "got a result<br />\n"; print_r($result4); } Returns: num_rows1 is 2426 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/websites/something/www/test.php on line 29 num_rows is Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/websites/something/www/test.php on line 31 The variable it's referring to is obviously $sql4, but why does it think it's a boolean? As stated when I copy and paste the exact statement into phpmyadmin and change $itemId to 3806 I get a proper result containing 1 row.

Hi Guys, this one is driving me mental. What have I done wrong? $itemId = '3806'; $sql4 = mysql_query("SELECT Recurring_Charges.serviceType, Recurring_Charges.description, Recurring_Charges.period, Recurring_Charges.amount, Service_Groups.name FROM Recurring_Charges, Service_Groups, Hosting_Services WHERE Hosting_Services.id = Recurring_Charges.serviceId AND Service_Groups.id = Hosting_Services.groupId AND Recurring_Charges.invoiceItemId ='$itemId' "); $num_rows = mysql_num_rows($sql4); echo "num_rows is $num_rows<br />\n"; while ($result4 = mysql_fetch_array($sql4)) { echo "got a result<br />\n"; print_r($result4); } Output is simply: num_rows is When I copy and paste the same query into phpmyadmin I get a proper result. Why doesn't it work and why don't I get an error or even 0 row count? Thanks

Thanks for all the responses guys. Unfortunately none of them worked. However I finally got a response from the helpdesk of my cheap host and they told me to send the email via SMTP (through localhost, not my other SMTP server) and it actually works! Problem solved

OK I've gotten into the mail server configuration a bit and it looks like it's been setup to only allow mail to be sent from IPs on the local network. I can add an exception, but how would I find out what IP my cheap domain host is sending from?

I've found that for SMTP authentication you have to use PEAR Mail. I get the following error: Failed to connect to mail.myserver.com.au:25 [sMTP: Failed to connect socket: Connection refused (code: -1, response: )] Port 26 times out and gives me this: Failed to connect to mail.myserver.com.au:26 [sMTP: Failed to connect socket: Connection timed out (code: -1, response: )]

Hi Nudd, thanks for the reply. I tried setting the SMTP port to 26, still no go. It did get me thinking though and I believe the server requires authentication before it will send. How would I use php to authenticate before sending? Thanks

Hi guys, I'm sending mail from php running on a cheap webhost with the following: $to = '[email protected]'; $header = 'MIME-Version: 1.0' . "\r\n"; $header .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $header .= "From: Name <[email protected]>" . "\r\n"; $subject = "Interest registered"; $message = "<!DOCTYPE HTML.. a bunch of html"; mail($to, $subject, $message, $header); As you can see I've set "from" in the headers. When I receive the email however, it says from: [email protected] on behalf of Name [[email protected]] I need to get rid of the on behalf bit as it looks completely unprofessional. I just want it to say from: Name [[email protected]] Obviously this is probably something to do with the setup of the server, some of which I have no control over. I have access to another mail server which I can use to send email, so I put this at the start of my code: ini_set('SMTP', 'mail.myotherserver.com.au'); echo ini_get('SMTP'); Which returns mail.myotherserver.com.au however, when I use the mail function, it still comes from [email protected] on behalf of Name [[email protected]] Is there something I'm missing, is the mail function not tied to the SMTP value? Thanks

Hi Guys I have a datetime field in my database which is updated when a user loads a particular page. What I want to do is create a graph showing how many users hit that page each day for a range of dates. The only way I can think of to do this is to increment through each date in the range, counting how many matches in the database for each date. 1. Is there a better (more efficient) way to do this, considering that on some days there will be no matches? 2. I'm trying to count like this: $date = date('Y/m/d'); $sql = "SELECT COUNT(*) FROM MailMerge WHERE landed= '$date';"; but I get "Data type mismatch in criteria expression". I guess I have to format the date somehow so MS SQL knows how to match it? Here is how I'm storing my dates: $now = date('Y/m/d'); $sql = "UPDATE MailMerge SET landed = '$now' WHERE membership = '$membership';"; Any help would be appreciated.

OK I have for the moment given up on DOM and used XMLReader instead. I still can't figure out how to write and entire node to a file. Surely there is a way to do it without parsing each child of that node? Here is what I have so far: <?php $xml = new XMLReader(); $xml->open('sample.xml'); $noticeids = array(); while ($xml->read()) { if ($xml->name == 'Notice' AND $xml->nodeType == 1) { //apparently nodeType 1 is opening element, 15 is closing array_push($noticeids, $xml->getAttribute('Id')); } } $xml->close; sort($noticeids, SORT_NUMERIC); foreach ($noticeids as $id) { $xml = new XMLReader(); $xml->open('sample.xml'); while ($xml->read()) { if ($xml->name == 'Notice' AND $xml->nodeType == 1 AND $xml->getAttribute('Id') == $id) { //somehow write/append the entire node to a file } } $xml->close; } ?> Any help would be greatly appreciated. Thanks!

Hi guys, this is my first time working with xml and the dom and I'm just not getting it. What I need to do is reorder some nodes within an xml document, based on the value of an attribute of that node (which happens to be a number). I figured I would load the said attribtues into an array, re-order the array numerically, and then loop through the array, grabbing each node and outputting it to a new xml file, in order. First off, is that a feasible way to approach the problem? It's the best I could think of with my limited knowledge of php and extremely limited knowledge of dom/xml. The basic structure of the xml file looks something like this: <Notice Id="125891" Sequence="6" Amount="175.06" Discount_Amount_1="17.16" Discounted_Amount_1="157.90"> </Notice> <Notice Id="199193" Sequence="7" Amount="175.06" Discount_Amount_1="17.16" Discounted_Amount_1="157.90"> </Notice> <Notice Id="356841" Sequence="8" Amount="175.06" Discount_Amount_1="17.16" Discounted_Amount_1="157.90"> </Notice> and I need to be able to sort by the Id number. If the approach I outlined above sounds ok, is anyone able to give me an idea on how to code it? Thanks

ob_flush worked great, thank you

Hi there, I was previously running on php on IIS and have recently switched over to Apache 2.2. I have a php script that starts with something like: echo "Processing, please wait..."; It then reads in a text file line by line, outputting the lines to other text files depending on several conditional statements. The input file can be up to 100MB so the script sometimes takes 5-10 mins to run. After the process is complete it goes: echo "Done!"; Previously on IIS when you first loaded the page you would see "Processing, please wait..." while the script processed, then when it finished, you would see on the screen "Processing, please wait...Done!". The word Done having appeared only after the script finished processing. Now since changing to apache when the page loads nothing is displayed on screen for 5-10 minutes while the script is processing, then when it finishes, you get Processing, please wait...Done!" all at once. For some reason it processes the whole script before doing any of the echo commands. Basically I just want to know how I can display something on the screen before the processing begins. Thanks!