iwpg

Hi Barand, I am getting the following result. The only difference between my old server is that ldap and ldaps are active on the one that's not working. openssl: yes http wrapper: yes https wrapper: yes wrappers: Array ( [0] => compress.zlib [1] => dict [2] => ftp [3] => ftps [4] => gopher [5] => http [6] => https [7] => imap [8] => imaps [9] => ldap [10] => ldaps [11] => pop3 [12] => pop3s [13] => rtsp [14] => smtp [15] => smtps [16] => telnet [17] => tftp [18] => php [19] => file [20] => glob [21] => data [22] => phar [23] => zip )

Still not the solution (Argghh). I reverted back to Apache 2.2 due to mod_ssl not compiling correctly with 2.4.7 (a known bug issue). So far, my best guess is that I'm being blocked by their server, even though my API account is active and in good standing. Any ideas are truly welcome. Please see my posts on Microsoft's API support board for an update.

I feel that the header needs a little more color, as well as darker. I would also add left and right side columns as a background for the empty space, preferably darker to get the main content to stand out better. Looks nice though!

Ok, after a lot of frustration, I believe it has something to do with the SSL version. Enabling curl_setopt($ch, CURLOPT_SSLVERSION, 3); now returns a response code of 200, instead of 0. It does not appear that mod_ssl is installed on the current version of Apache.

Thanks for the reply, I contacted SoftLayer and they were pretty stumped as well. The firewall and Mod_Security is off, and the new server is pretty much a clone to my old one. That's all that they could come up with. To answer your questions: do you have php's error_reporting set to E_ALL and display_errors set to ON so that any php detected errors will be reported and displayed? YES what symptom are you getting that leads you to believe the code isn't working? Printing contents returns empty, no file gets written. I have confirmed that this works by testing other .zip files on my other URLs by downloading them with this same script. are you catching the exception from that code and what are you doing then in the catch code? The response is successful do you have php's output_buffing on, in your php.ini or in your script, and you are either redirecting or intentionally discarding the buffer so that any error output from the code is lost? Yes, output_buffering is on, and I was flushing the buffer. I disabled this to test and had the same result. My only suspicion at this point is that my new IP is blocked by Microsoft's server. I sent a request to them to check on it. Thank you! Mike

Hello everyone, I just started having problems using the Bing Adcenter API with downloading reports in .zip format with fopen. There are no errors, so this is a bit frustrating. The file opens fine in a browser but not in the script. Please note that the file gets deleted after download, so it will produce a 404 error. My code has been working for over a year, and I suspect that it's in the URL. I tested my code with a simple URL and did not have any issues. I am using PHP Version 5.3.27 Snippet of my code (the $reportDownloadUrl variable is automatically generated with the API, but I wanted to show the usage as well as syntax): $reportDownloadUrl = "https://download.api.bingads.microsoft.com/ReportDownload/Download.aspx?q=3XL5uFR5BeF%2b1O9DOD6ZshdhvTn6vr9%2fUl9g9iXw3%2f%2f61Ly5IInt0O%2ba34CWMNxQBSV%2b4KolQhuTaalw3hZpvTcD3sq2uDDZw2c6a4Ud3%2f8V8OnlPwulQ29P3bbt9f2BpzQ5Ubcn%2bfH2oKfitYQsoj7R9o7dx%2fD6Bd2rmgwsRLbFLZiwz8NKh%2bcVjVEMKcPGFqcYDx%2fG9rxzeBTp00k3hcmnn2iGh2JnU2dyPCL%2fKxvKZzxZYKnjY7OztS2ONLZ68TCq1b%2fR7vWpr%2f8rkGxzSGEdBvK2adr5pFWw29HyrP0tmbE8jRRmgpbaH6SgNpJfmg%3d%3d"; if (!$reader = fopen($reportDownloadUrl, 'rb')){ throw new Exception("Failed to open URL " . $reportDownloadUrl . "."); } I really appreciate your help, it's been over 3 hours for me trying to figure out why this isn't working.

I love it, thanks! This just made my day!!!

Thank you for your help! Good to go!

If you are using SQL, how about "Group By"? select name from table GROUP BY name http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

Please delete my last 2 posts. The thread was marked as answered. New post is located at http://forums.phpfreaks.com/topic/284259-preg-replace-callback-help/

This is what I have originally, any help to get this translated to preg_replace_callback will be so much appreciated! function addtemplateslashes($template) { return "?".">".$template."<?php"; } $template = preg_replace("/\?".">(\r*\n*.*)(<\?php|<\?)/esiU","addtemplateslashes('\\1')",$template); And this is what I have so far with no luck. if (!function_exists('parseTagsRecursive')) { function parseTagsRecursive($template) { $regex = '#\/\?".">(\r*\n*.*)(<\?php|<\?)#'; if (is_array($template)) { $template = $template[1]; } return preg_replace_callback($regex, 'parseTagsRecursive', $template); } } $template = parseTagsRecursive($template);

This is what I have so far, but I don't know what to do with addtemplateslashes if (!function_exists('parseTagsRecursive')) { function parseTagsRecursive($template) { $regex = '#\/\?".">(\r*\n*.*)(<\?php|<\?)/esiU#'; if (is_array($template)) { $template = $template[1]; } return preg_replace_callback($regex, 'parseTagsRecursive', $template); } } $template = parseTagsRecursive($template);

And here we go :-) Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead This is killing me. I was confused, finally got the hang of the good ol preg_replace function, and now the "e" modifer requires a callback. I am using an older CMS system that is no longer supported, so what this line of code actually accomplishes is beyond me. This is what is making this more difficult for me. My guess is that it allows PHP code to execute inside a template. This is what I have originally, any help to get this translated to preg_replace_callback will be so much appreciated! $template = preg_replace("/\?".">(\r*\n*.*)(<\?php|<\?)/esiU","addtemplateslashes('\\1')",$template);

I added a substr_replace right before that to limit the amount of text shown, and it cut of the end QUOTE tag. Thanks for straightening me up!

Please help???

Hi, I am trying to do something similar to the post at: http://www.phpfreaks.com/forums/index.php/topic,283988.msg1346588.html#msg1346588 but so far I have not had luck. I have a database filled with forum replies that some have quoted text that I want removed, and just show the response. In this case, "You're welcome!" should only be shown. This is what I have so far, but it does nothing: Example: $pagetext = "[quote=hd331;23548]That makes a lot of sense. Thanks.[/quote] You're welcome!"; $newpagetext = preg_replace('/\[quote=(.*?)\](.*?)\[\/QUOTE\]/i',' ',$pagetext);

Thanks for the help everyone, it should have been: $q = mysql_query("select * from db where (item1 like '%$keyword%' or item2 like '%$keyword%' or item3 like '%$keyword%')");

I get a blank result (Warning: mysql_result(): supplied argument is not a valid MySQL result resource)

I'm really sorry. It's the same table, but checking in different columns. Thanks, and sorry for the confusion.

This is killing me. I know it should be simple, but I cannot get the statement to run. $q = mysql_query("select * from db where item1 like '%$keyword%' or item2 like '%$keyword%' or item3 like '%$keyword%'"); Basically, the query is checking table 1,2 and 3 for the keyword, and returns the result if found. Any help will be greatly remembered and appreciated. Thanks, Mike

I still have the same problem even with the time override of php.ini. I see now that the form itself is timing out based on an impartial mysql upload on the data. I'm getting around 350-450 records in before it times out. Thanks, Mike

Thanks, I modifed php.ini to 90 seconds, and increased memory to 32M and rebooted. It still times out at around 30 seconds. Right now, I am adding around 1500 lines with 2 columns. I am thinking that the rows and columns is increasing processing time. I know how to Preg Split single entries per line, but cannot seem to get 2 columns in the database, to 2 fields. 1 row per entry. This is what I have now, and it seems to load much faster: Within a textarea form: Entry 1 Value 1 Entry 2 Value 2 Entry 3 Value 3 (and so on...) My code: //Split data $data = preg_split('/\r\n|\n/', $_POST['entry'], -1, PREG_SPLIT_NO_EMPTY); //Iterate through array foreach ($data as $entry) { mysql_query("insert into table (entry) values ('$entry')"); } Now I think that this is taking the Entry and Value array and combining them. I don't know how I can add "Value" as the corresponding Entry value. I am thinking about a comma delimeter, but I still would not know where to go with the code. Thank you so much. I've been working on the all day, and haven't had any luck.

Please?

Hello. I have a several hundred records that are imported from a CSV file, and sorted out into an HTML form first. The form is then submitted into a MYSQL database. When submitting the form, I sometimes get a timeout. I was wondering what is the best approach to splitting the data to say 200 records at a time. Any help is appreciated.