beermaker74

i figuredit was something like that thanks

if ($row_Recordset3['access'] !== ('var1' || 'var2')){do something} I need it to evaluate both vars and if one of them are not true its not evaluating both vars it works fine if i only use one ie if ($row_Recordset3['access'] !== 'var2'){do something} i have been up too many hours my brain is fried. can someone help please

Ok going thru the xml dom for php 4 i came up with this that works for anybody else having the same problem $dom = domxml_open_mem($response, DOMXML_LOAD_PARSING, $errors); $noderoot = $dom->document_element(); $childnodes = $noderoot->child_nodes(); foreach($childnodes as $books) { if (($books->node_type() == 1) && ($books->node_name() == "entry")) { foreach ($books->child_nodes() as $theBook) { if (($theBook->node_type() == 1) && ($theBook->node_name() == "id")) { $id = $theBook->get_content(); } if (($theBook->node_type() == 1) && ($theBook->node_name() == "published")) { $published = $theBook->get_content(); } if (($theBook->node_type() == 1) && ($theBook->node_name() == "updated")) { $updated = $theBook->get_content(); } /* if (($theBook->node_type() == 1) && ($theBook->node_name() == "category")) { $category = $theBook->get_attribute('term'); }*/

ok i am trying to parse some xml and it is becoming a royal pain in my arse. $base = 'http://google.com/base/feeds/snippets/-/'; $params = 'rental+%5blocation:@%22San+Francisco,CA%22%2b50mi%5d&max-results=3'; $url = $base . 'housing?bq=' . $params; $c = curl_init($url); curl_setopt($c, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($c); curl_close($c); $dom = domxml_open_mem($response, DOMXML_LOAD_PARSING, $errors); foreach ($dom->documentElement->childNodes as $books) { if (($books->nodeType == 1) && ($books->nodeName == "entry")) { foreach ($books->childNodes as $theBook) { if (($theBook->nodeType == 1) && ($theBook->nodeName == "id")) { $id = $theBook->textContent; } It gives me an error in the foreach statement. It works fine on my local machine with php5. But not on my server with php4.4.4 here is the error Warning: Invalid argument supplied for foreach() before I had $doc = new DOMDocument(); $doc->load( 'books1.xml' ); to start the dom and I was getting errors. undefined function etc. dom needs a parameter. Once again worked fine on php5 but not on my server. So i changed that to $dom = domxml_open_mem($response, DOMXML_LOAD_PARSING, $errors); and that seemed to solve that problem but then the foreach problem came up. Somebody mentioned that the syntax I am using is for php 5. They recomended changing' foreach ($dom->documentElement->childNodes as $books) { to foreach ($dom->document_element->child_nodes as $books) { it is still giving me the same error my main goal in this is to display feeds from google base. So all i need to do is parse and display the feed in my own format. This code does exactly what I want in php 5. but im stuck woth 4.4.4

ok i have a query to the google base and i am using curl to get the response. ok if i have dom load (something.xml) it works fine. but if i try and put the var from curl in there it breaks. says itis empty in my error. what do i need to do to load it in the dom so i can parse it? thanks $url ='http://google.com/base/feeds/snippets/-/housing?bq=rental+%5blocation:@%22athens,AL%22%2b50mi%5d&max-results=6'; $c = curl_init($url); curl_setopt($c, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($c); curl_close($c); $dom = new DomDocument; $dom->load("$response"); foreach ($dom->documentElement->childNodes as $books) { if (($books->nodeType == 1) && ($books->nodeName == "entry")) { foreach ($books->childNodes as $theBook) { if (($theBook->nodeType == 1) && ($theBook->nodeName == "id")) { $id = $theBook->textContent; } if (($theBook->nodeType == 1) && ($theBook->nodeName == "published")) { $published = $theBook->textContent; }

ok I am just trying to query google base and parse the result. here is the result from one item from google <?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gm='http://base.google.com/ns-metadata/1.0' xmlns:g='http://base.google.com/ns/1.0' xmlns:batch='http://schemas.google.com/gdata/batch'> <id>http://www.google.com/base/feeds/snippets</id> <updated>2007-02-26T20:33:03.539Z</updated> <title type='text'>Items matching query: (rental [location:@"San Francisco,CA"+50mi]) [item type:housing]</title> <link rel='alternate' type='text/html' href='http://base.google.com'></link> <link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://www.google.com/base/feeds/snippets'></link> <link rel='http://schemas.google.com/g/2005#batch' type='application/atom+xml' href='http://www.google.com/base/feeds/snippets/batch'></link> <link rel='self' type='application/atom+xml' href='http://www.google.com/base/feeds/snippets/-/housing?start-index=1&max-results=1&bq=rental+%5Blocation%3A%40%22San+Francisco%2CCA%22%2B50mi%5D'></link> <link rel='next' type='application/atom+xml' href='http://www.google.com/base/feeds/snippets/-/housing?start-index=2&max-results=1&bq=rental+%5Blocation%3A%40%22San+Francisco%2CCA%22%2B50mi%5D'></link> <author> <name>Google Inc.</name> <email>base@google.com</email> </author> <generator version='1.0' uri='http://base.google.com'>GoogleBase</generator> <openSearch:totalResults>5812</openSearch:totalResults> <openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>1</openSearch:itemsPerPage> <entry> <id>http://www.google.com/base/feeds/snippets/2978077361409212904</id> <published>2007-02-26T12:10:23.000Z</published> <updated>2007-02-26T12:12:20.000Z</updated> <category scheme='http://base.google.com/categories/itemtypes' term='Housing'></category> <title type='text'>3 bedroom apartment rental in Berkeley California</title> <content type='html'>Elegant 3BR victorian unit available for short term rental 1/2 block to Bart transportation and close to the Berkeley Bowl (a great gourmet food market) and close to UC Berkeley.Unit was featured in Architectural Digest and has black walls wtih ...</content> <link rel='alternate' type='text/html' href='http://www.sublet.com/spider/supplydetails_adv.asp?SupplyId=337581&source=10228'></link> <link rel='self' type='application/atom+xml' href='http://www.google.com/base/feeds/snippets/2978077361409212904'></link> <author> <name>landlords@sublet.com</name> <email>landlords@sublet.com</email> </author> <g:image_link type='url'>http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_1.jpg&dhm=53a74726&size=6</g:image_link> <g:city type='text'>Oakland</g:city><g:image_link type='url'>http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_4.jpg&dhm=57e7adc0&size=6</g:image_link> <g:label type='text'>apartment for rent</g:label> <g:customer_id type='int'>1072962</g:customer_id> <g:bathrooms type='float'>1.0</g:bathrooms> <g:label type='text'>Oakland</g:label> <g:expiration_date type='dateTime'>2007-03-12T12:10:23.000Z</g:expiration_date> <g:label type='text'>vacation rental</g:label> <g:label type='text'>short term rental</g:label><g:item_type type='text'>Housing</g:item_type> <g:property_type type='text'>apartment</g:property_type> <g:label type='text'>temporary housing</g:label> <g:price type='floatUnit'>2500.0 usd</g:price> <g:label type='text'>California</g:label> <g:area type='text'>Berkeley</g:area> <g:item_language type='text'>EN</g:item_language> <g:image_link type='url'>http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_3.jpg&dhm=5b620579&size=6</g:image_link> <g:location type='location'>California, 94703, USA</g:location> <g:label type='text'>vacation home</g:label> <g:label type='text'>holiday rental</g:label> <g:label type='text'>Berkeley</g:label> <g:area type='float'>1500.0</g:area> <g:bedrooms type='int'>3</g:bedrooms> <g:agent type='text'>Rinna</g:agent> <g:image_link type='url'>http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_2.jpg&dhm=ffffffffac1031de&size=6</g:image_link> <g:listing_type type='text'>vacation rental</g:listing_type> <g:target_country type='text'>US</g:target_country> <g:id type='text'>337581</g:id> <g:image_link type='url'>http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_5.jpg&dhm=ffffffffee4c399a&size=6</g:image_link> </entry> </feed> here is my code that I hacked from yahoo to parse it <?php $base = 'http://google.com/base/feeds/snippets/-/'; $params = 'rental+%5blocation:@%22San+Francisco,CA%22%2b50mi%5d&max-results=1'; $url = $base . 'housing?bq=' . $params; $c = curl_init($url); curl_setopt($c, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($c); curl_close($c); $dom = domxml_open_mem($response, DOMXML_LOAD_PARSING, $errors); function xml_to_result($dom) { $root = $dom->document_element(); $res['totalResultsAvailable'] = $root->get_attribute('totalResultsAvailable'); $res['totalResultsReturned'] = $root->get_attribute('totalResultsReturned'); $res['firstResultPosition'] = $root->get_attribute('firstResultPosition'); $node = $root->first_child(); $i = 0; while($node) { switch($node->tagname) { case 'entry': $subnode = $node->first_child(); while($subnode) { $subnodes = $subnode->child_nodes(); if(!empty($subnodes)) { foreach($subnodes as $k=>$n) { if(empty($n->tagname)) { $res[$i][$subnode->tagname] = trim($n->get_content()); } else { $res[$i][$subnode->tagname][$n->tagname]=trim($n->get_content()); } } } $subnode = $subnode->next_sibling(); } break; default: $res[$node->tagname] = trim($node->get_content()); $i--; break; } $i++; $node = $node->next_sibling(); } return $res; } $res = xml_to_result($dom); echo '<pre>'; print_r($res); echo '</pre>'; ?> here is the result from that code print_r Array ( [totalResultsAvailable] => [totalResultsReturned] => [firstResultPosition] => [id] => http://www.google.com/base/feeds/snippets [updated] => 2007-02-26T20:42:47.146Z [title] => Items matching query: (rental [location:@"San Francisco,CA"+50mi]) [item type:housing] [link] => [author] => Google Inc.base@google.com [generator] => GoogleBase [totalResults] => 5805 [startIndex] => 1 [itemsPerPage] => 1 [0] => Array ( [id] => 337581 [published] => 2007-02-26T12:10:23.000Z [updated] => 2007-02-26T12:12:20.000Z [title] => 3 bedroom apartment rental in Berkeley California [content] => Elegant 3BR victorian unit available for short term rental 1/2 block to Bart transportation and close to the Berkeley Bowl (a great gourmet food market) and close to UC Berkeley.Unit was featured in Architectural Digest and has black walls wtih ... [author] => Array ( [name] => landlords@sublet.com [email] => landlords@sublet.com ) [city] => Oakland [item_language] => EN [image_link] => http://base.google.com/base_image?q=http%3A%2F%2Fwww.sublet.com%2Faptimages%2F337581_5.jpg&dhm=ffffffffee4c399a&size=6 [label] => apartment for rent [target_country] => US [agent] => Rinna [price] => 2500.0 usd [bathrooms] => 1.0 [area] => Berkeley [listing_type] => vacation rental [property_type] => apartment [expiration_date] => 2007-03-12T12:10:23.000Z [item_type] => Housing [bedrooms] => 3 [location] => California, 94703, USA [customer_id] => 1072962 ) ) the links are not coming through. they are blank. It seems that most other elements are there. The feed is an atom feed and the links seem to be encoded differently. I would really like to have access to the links. I am sure it is an easy fix. I am still a bit confused at all this xml parsing stuff. By the way I don't have php5 on my server so i cant use simplexml. thanks

this might be a silly question but anyway here it goes. I want to have a link that goes to page 2 and displays data based on a post var without a form . I know i can do this very easily with get but I am always weary about attackers with that method so i always try and hide my info. So how can i pass a post var from a standard link? thanks

thanks just what i was looking for

thanks for the link. much easier than the custom database solution. I dont know what I would do without the great online communities here. damn i saw that they pop up an ad. or you can pay 10 a month for 10000 requests. Guess I will be using the maxmind solution. Has anybody here used it?

I need to do some checks for someof my dynamic pages. What I need to do is go thru the complete table for one field and see if a value exists. the values are either y n or null. I only need to check for y. IS there a quick and dirty method to do this? Thanks for the help

i have a page that has photos on it and i have a form that has a delete button. I have it directred to another page where the unlinking occursand the database field is updated. So I have a list menu that lists the photo numbers ie delete photo1 etc. This value is the name of the file that needs to be deleted. The problem i have is when they select photo1 to delete it sends that value to the next page but it does not know what field to delete it from. So what I want is when they click on photo1 it sends the name of the file and the named of the field. the field names are like photo1url photo2url etc. So if they select photo1 to delete i need it to send the name photo1.jpg plus photo1url for the field. Hope I am explaing it well enough. I have a hidden field hard coded right now to test it.works perfect so all i need it to dynamically assign this value. thanks

check out http://www.maxmind.com/ they have a free version of their service that you can put in a mysql database to lookup the ip. the free service is updated once a month. I am about to do the same thing for my site so i can show info customized for their state

is there a list of special chars that will mess up a linux system? I am creating xml with the files so I need to make sure everything is compliant. If I used str replace do I need to list every character? I was hoping there was some function that automatically did it. thanks

is there a function that strips special characters. I already have it where it replaces spaces with underscores. I have been having problems with the & I am sure that there are a tremendous amount of special chars that will mess up my xml. So if there is something quick that can strip them please let me know thanks

I have been developing this site and I have finally got around to doing the mod rewrite. i have a dynamic page www.myserver.com/listings.php?houseid=1. I have the rewrite now working with www.myserver.com/listings/1 I am more than happy with this address. The one thing I need to do is include the slash at the end of the url ie www.myserver.com/listings/1/ so that if they put this in the address bar that it directs them to www.myserver.com/listings/1. Since I am new at this rewriting I am not quite sure what is going on in the background. My issue is the links that I have on the page are all broken. But they work if I put absolute links. Is this what is required for it to work? Since it is only a few dynamic pages that I have to change it is no big deal but if i had 100 pages to change I would be a bit frustrated. So is there a way to deal with this. Maybe in the htaccess where my rewrite rules are? thanks

is it possible to have a script at the top of the page that can figure what state a user is in. I want to display information that is customized for that state. I know i can get the ip address. is it possible to do a quick lookup. Also if that is possible how long would it take. I wouldnt want them waiting for all this to work if it takes a long time. thanks

in your sql query use distinct http://www.webdevelopersnotes.com/tutorials/sql/online_mysql_guide_the_distinct_keyword.php3 that should solve your problem

I have this basic script that I am trying to work with. It works fine on my local machine. But when I upload itto my server it doesnt work. It consists of two pages. the upload page and an include. here is the upload form <!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=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php include('http://www.myserver.com/vhtest/includes/test4.php'); ?> <form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> <input name="image" type="file" id="image" /> <input type="submit" name="Submit" value="Submit" /> </form> </body> </html> here is the include <?php if($_POST){ $img = $_FILES['image']['tmp_name']; //$percent = $_GET['percent']; $constrain = 1; $w = 500; $h = 380; // get image size of img $x = @getimagesize($img); // image width $sw = $x[0]; // image height $sh = $x[1]; if ($percent > 0) { // calculate resized height and width if percent is defined $percent = $percent * 0.01; $w = $sw * $percent; $h = $sh * $percent; } else { if (isset ($w) AND !isset ($h)) { // autocompute height if only width is set $h = (100 / ($sw / $w)) * .01; $h = @round ($sh * $h); } elseif (isset ($h) AND !isset ($w)) { // autocompute width if only height is set $w = (100 / ($sh / $h)) * .01; $w = @round ($sw * $w); } elseif (isset ($h) AND isset ($w) AND isset ($constrain)) { // get the smaller resulting image dimension if both height // and width are set and $constrain is also set $hx = (100 / ($sw / $w)) * .01; $hx = @round ($sh * $hx); $wx = (100 / ($sh / $h)) * .01; $wx = @round ($sw * $wx); if ($hx < $h) { $h = (100 / ($sw / $w)) * .01; $h = @round ($sh * $h); } else { $w = (100 / ($sh / $h)) * .01; $w = @round ($sw * $w); } } } $im = @ImageCreateFromJPEG ($img) or // Read JPEG Image $im = @ImageCreateFromPNG ($img) or // or PNG Image $im = @ImageCreateFromGIF ($img) or // or GIF Image $im = false; // If image is not JPEG, PNG, or GIF if (!$im) { // We get errors from PHP's ImageCreate functions... // So let's echo back the contents of the actual image. readfile ($img); } else { // Create the resized image destination $thumb = @ImageCreateTrueColor ($w, $h); // Copy from image source, resize it, and paste to image destination @ImageCopyResampled ($thumb, $im, 0, 0, 0, 0, $w, $h, $sw, $sh); // Output resized image $filename = "../vhtest/upload/jim/2/". $_FILES['image']['name']; imagejpeg($thumb,$filename,100); } } ?> my local machine has php 5. my server has php 4.4 first question is there something in the include that doesnt work for php4.4? I looked up almost every function and they were all supported. And by the way the folder that I am trying to write to are all chmod 777. the second question is does it need a absolute path or can it use a relative path? on my local machine it works with a relative path. I have tried changing the path to include 1 a relative path ie "../vhtest/upload/jim/2/". $_FILES['image']['name']; 2 the full path to the folder ie /home/usr/vhtest/upload/ etc 3 an http path ie htttp://www.myserver.com.vhtest/upload etc none of them seem to work. I had this in a much more complicated page where I have multiple upload and mysql insert. I thought there might be someproblem in there so I built this simple form to test it out. Once again everything works on my local machine but not on the server. Any help would be greatly appreciated. thanks

i need to examine one sql row and display the results in a xml file. [code]<?php $colname_Recordset1 = "-1"; if (isset($_POST['houseid'])) {   $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['houseid'] : addslashes($_POST['houseid']); } mysql_select_db($database_vhtest, $vhtest); $query_Recordset1 = sprintf("SELECT * FROM photo WHERE houseid = %s", $colname_Recordset1); $Recordset1 = mysql_query($query_Recordset1, $vhtest) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?>[/code] here is my query there will be only one record displayed. I need to display some of the rows to be inserted into an xml file. Here is my problem. I need to display the column values only of they are filled. So sometimes the columns will be completely filled and sometimes they will be blank. Is there an easy way to do this? I also only need to pick certain values. ie table row id | photoid| folderurl | photo1url | photo1caption | photo2url | etc etc up to 20 photos and captions so for the xmlfile I need to grab the folderurl and the photourl and caption from each column if it is filled. I hope I explained it well enough.

I have this script that I am playing with to create an xml file from a mysql query [code=php:0]<?php $file= fopen("results.xml", "w"); $xml_output  = "<?xml version=\"1.0\"?>\n"; $xml_output .= "<gallery>\n"; for($x = 0 ; $x < mysql_num_rows($Recordset1) ; $x++){     $totalRows_Recordset1 = mysql_fetch_assoc($Recordset1);     $xml_output .= "\t<listings>\n";     $xml_output .= "\t\t<houseid>" . $totalRows_Recordset1['houseid'] . "</houseid>\n";     $xml_output .= "\t\t<username>" . $totalRows_Recordset1['username'] . "</username>\n"; $xml_output .= "\t\t<address>" . $totalRows_Recordset1['address'] . "</address>\n";     $xml_output .= "\t</listings>\n"; } $xml_output .= "</gallery>"; fwrite($file, $xml_output); fclose($file); echo "XML has been written.  <a href=\"results.xml\">View the XML.</a>"; ?> [/code] here is the result of a query with one record <gallery> <listings> <houseid/> <username/> <address/> </listings> </gallery> the result is not listed. Here is the result of a query with 2 records <gallery> <listings> <houseid>26</houseid> <username>jerry</username> <address>55 fake ave</address> </listings> <listings> <houseid/> <username/> <address/> </listings> </gallery> there is 2 records in that query. For some reason it is only outputing anything over 1 record. yet it is displaying blank tags if you see my problem please let me know. I am just trying to write from a simple query now. MY real task is to write the xml from a more advanced query. So I need to figure out the simple problem first thanks

do you mean to set a session var when the user hits the index page? Let me see if I can work through this. I set session_start() on my index page. When a user visits my home page they will be assigned a random ssid. So if they goto my slideshow search page I could name the xml file variable the same as their ssid. i see that. but if 2 or more people are on slideshow search page and trying to view the flash app. will it cause a conflict? even though the xml file name will be unique the flash app is coming fromthe same location on the server. AM I explaining this right? let me explain further. here is the embed code for the flash player [code]<script type="text/javascript" src="swfobject.js"></script> <div id="flashcontent"> <strong>You need to upgrade your Flash Player</strong></div>                 <script type="text/javascript"> // <![CDATA[ var so = new SWFObject("customslideshow.swf", "ssp", "550", "400", "7", "#FFFF99"); so.addVariable("xmlfile", "<?php echo $usersearch; ?>"); so.write("flashcontent"); // ]]> </script>[/code] $usersearch will be created on the fly. So if 2 people are trying to view a slideshow am i goiing to have a problem? sorry for the convoluted question.

ok I  have an odd question here I will have a page that has a dynamic flash slideshow fed by an xml file. The page will have a search feature. So when somebody does a search. I will make an xml file on the fly with php of the results of their search. The flash slideshow will be embedded with swfobject and the xml file will be assigned dynamically to a mysql variable. So if 20 people at the same time are trying to view the page is this going to cause problems. since each search will be different and the xml will be assigned a  different variable.  The xml file variable could have different names if need be. I hope I am explaining this right. the page name will be something like slideshow search. I am not sure if I am going to send them to another page to display results. IF that is easier then I am all for it. The main goal I have is to let the user customize a slideshow. say they wanted to see only wolves or birds and wolves. Is this possible thanks

thanks for all the responses by the time I saw the rest of the posts I had already used mjdamato's suggestion. but thanks for the help

ok on page 1 I have a form that has multiple search parameters ie State City Zipcode Price etc the form action is post and its goes to searchlistings.php on this page  I have my recordset I want to be able to display the results from page 1 with the multiple parameters. This is my problem.  if the user  picks two of the parameters then it doesnt pull the records from both fields it only pulls it from one of them. I need the query to be smart and know that only one parameter was posted. if multiple params were posted I need the query to use all of them. Example if you search for alabama it pulls all the records from alabama if you search for athens and not list a state it pulls all the records that match athens. if you search for athens and alabama it pulls all the records from alabama and isnt distinct. $query_search = "SELECT houseid, address, city, `state`, zipcode, county, status, zoning, sqft, housetype, yearbuilt, schooldistrict, bedrooms, baths, totalrooms, housedescription, specialfeatures, price, virtualtour FROM house WHERE (city = '$city' AND state = '$state')OR (city = '$city') OR (state = '$state')"; the $city and $state variables are listed above= to the post im sure it is an easy fix I am just stumped I hope that I explained this properly. Basically I need to filter the results by whatever the user entered but I need the flexibility to filter if the user only uses one of the params from the search thanks

if I had a real popular site, wouldnt that really eat into my bandwith. It would be nice to have an app that can resize a folder on the clients machine then upload. I have seen some ajax stuff that kind of does that. If it wont affect bandwith much then I guess I will go with the php method. thanks