Richard Yates

Turns out the Bad Request error that i was getting using get_headers() was because there were spaces in the query string. Replacing those with %20 fixed that problem so I do not need to use file_get_contents(). Problem solved (mostly).

Thanks for the quick reply, kicken. Yes, $APIcall is the url used to access the API. Using file_get_contents() gives me a "HTTP request failed! HTTP/1.1 400 Bad Request" and the command is not executed by the API.

Trying to hook up to an API using php. The API commands are sent in url query strings. Depending on the command you are sending in the query string, the API returns an XML file or text. For commands that return an XML file I can use $response=simplexml_load_file($APIcall) and parse and store the xml that comes back into $response. But with text responses from the API I cannot find a way to handle the reply. Using xml_load_file() results in errors displayed since it was expecting xml and nothing gets stored in $response, although the command is correctly executed by the API. I can use headers('Location: $APIcall') but that just gets the text response sent to a new window. $response=get_headers($APIcall) works for some commands but still does not capture the text response.

That did it. THANKS!

My first stab at connecting to an API with php. The API takes a url and returns an xml file. When I try this: <?php $apicall = "https://www.graphicmail.com/[email protected]&Password=x&Function=get_newsletters&SID=0"; $xml = simplexml_load_file($apicall); print_r($xml); ?> My local testing server responds with: Warning: simplexml_load_file() [function.simplexml-load-file]: Unable to find the wrapper "https" - did you forget to enable it when you configured PHP? However, in the php configuration file, php.ini, I have: 'allow_url_fopen = On' which is what the manual says is all you need for https use in most functions that take urls. The url that is $apicall works correctly when just pasted into the browser. When I try the php code on the production server I get no warning (they are turned off) and no output. Any ideas?

Yes. I am once again proven blind to my own code. Thanks.

Writing a text file in php. File is created apparently okay and appears in the directory. But cannot then download it (but can open it in Dreamweaver if just using local test server). Does some kind of EOF character need to be written to the file (I'm just guessing). Simple example: <div id="mainContent"> <?php $list="abcdef"; $cellfile=fopen("celltext.txt",'w') or die("Failed to create file"); fwrite($cellfile, $list) or die ("Could not write to file"); fclose($cellfile); ?> <p><a href="cellfile.txt">Download</a> cell text file</p> </div> Clicking the link yields 404 File not found (even though it's there).

Thanks. Fixed.

I am trying to learn about regular expressions and preg_replace() starting with the absolutely simplest cases but something is not working (most likely my brain). Here is code and output: <?php $str="abcef"; $str2 = preg_replace("[a-d]","x", $str); echo '$str='.$str.' '.'$str2='.$str2; ?> $str=abcdef $str2=abcdef Why is $str2 not: xxxxef ?

Yikes! You are right. I don't know how I did that. I originally planned to parse the query to branch for UPDATE and then forgot that whole half of the job when I started testing the SELECT part. Thanks and sorry for the bother. <sheepish emoticon>

line 7: $row_rsSearch = mysql_fetch_array($rsSearch, MYSQL_BOTH) or die(mysql_error());

thanks for the reply. Yes, I am sure. The same form works when a SELECT string is input. If I insert an 'exit;' after the stripslash line it prints the string correctly and stops. Checking further, i see in the database that the UPDATE query DOES change the data in the record correctly. Something else must happen when I am trying to print the records that are changed. The full code (leaving out some irrelevant html) is: <?php require_once('../Connections/Salem_Harvest.php'); $search = "SELECT * FROM pickers WHERE ID_picker = 1"; if (isset($_GET['searchget'])) { $search = $_GET['searchget']; } mysql_select_db($database_Salem_Harvest, $Salem_Harvest); $search=stripslashes($search); $rsSearch = mysql_query($search, $Salem_Harvest) or die(mysql_error()); $row_rsSearch = mysql_fetch_array($rsSearch, MYSQL_BOTH) or die(mysql_error()); $keys = array_keys ($row_rsSearch); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>SQL</title> </head> <body class="SH"> <div id="container"> <div id="mainContent"> <h2><strong>SQL search utility</strong></h2> <form id="search" name="search" method="get" action="SQL2.php"> Type SQL String and press 'Enter' <input name="searchget" type="text" id="searchget" value="<?php echo $search ?>" size="300" maxlength="300" /> </form> <p> </p> <table width="1220" border="1" cellpadding="2" cellspacing="2" id="rsearchresults"> <tr><?php for($i=1;$i<count($keys);$i=$i+2) { ?> <th><?php echo $keys[$i];?></td> <?php } ?> </th> <?php do { ?> <tr><?php for($i=0;$i<(count($row_rsSearch)/2);$i++) { ?> <td><?php echo $row_rsSearch[$i];?></td> <?php } ?> </tr> <?php } while ($row_rsSearch = mysql_fetch_array($rsSearch, MYSQL_BOTH)); ?> </table> </div> <br class="clearfloat" /> </div> </body> </html> <?php mysql_free_result($rsSearch); ?> MOD EDIT: code tags added.

to Voip03: The link you posted refers to reusing a variable in a while loop. I'm not doing that that I can see. There is no loop until I print out the query results and the error occurs before that.

The echo out right after stripslashes is, for instance: update pickers set fname='Dick' where ID_picker=1 This comes out exactly as it was input in the form. And again, this string works in phpMyAdmin on the local server and in the code I quoted on the web server.

I have a local php test server on my computer and I also upload to a web site server. Everything works fine on both servers except: I wrote a small utility to process mysql query strings. It works fine on the web site server. On the local server, SELECT queries run fine. UPDATE and INSERT give the above error. These exact same queries work fine in the same php script on the web server and they work fine in the phpMyAdmin SQL query utility on the local server. They fail only on the local server with the php script. The relevant script is: if (isset($_GET['searchget'])) { $search = $_GET['searchget']; } mysql_select_db($database_Salem_Harvest, $Salem_Harvest); $search=stripslashes($search); $rsSearch = mysql_query($search, $Salem_Harvest) or die(mysql_error()); $row_rsSearch = mysql_fetch_array($rsSearch, MYSQL_BOTH) or die(mysql_error()); The last line is the one that dies. $search echoes out correctly.