rdrews

I get: Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: xmlParseEntityRef: no name in Entity, line: 1 in /path/to/page.php on line 106 Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: xmlParseEntityRef: no name in Entity, line: 1 in /path/to/page.php on line 106 Line 106 is: $xmlDoc->loadXML($tmpDoc);

I have some code that works fine on my dev server but does not work on my production server. Dev server has PHP version 5.2.5 and production server has PHP version 5.1.6. This is the part of the code that isn't working on the prod. server: $xmlDoc=new DOMDocument(); $xmlDoc->loadXML($tmpDoc); $x=$xmlDoc->getElementsByTagName('link'); //get the q parameter from URL $q=$_GET["q"]; //lookup all links from the xml file if length of q>0 if (strlen($q)>0) { $hint=""; for($i=0; $i<($x->length); $i++) { $y=$x->item($i)->getElementsByTagName('title'); $z=$x->item($i)->getElementsByTagName('url'); if ($y->item(0)->nodeType==1) { //find a link matching the search text if (stristr($y->item(0)->childNodes->item(0)->nodeValue,$q)) { if ($hint=="") { $hint="<tr><td><a href='" . $z->item(0)->childNodes->item(0)->nodeValue . "' target='_blank'>" . $y->item(0)->childNodes->item(0)->nodeValue . "</td></tr>"; } else { $hint=$hint . "<tr><td><a href='" . $z->item(0)->childNodes->item(0)->nodeValue . "' target='_blank'>" . $y->item(0)->childNodes->item(0)->nodeValue . "</a></td></tr>"; } } } } } $tmpDoc is a variable that holds database information in xml form. It basically looks like this: $tmpDoc = $tmpDoc . "<link><title>" . $row['CustomerName'] . "****" . $row['Rep'] . "****" . $row['InstallDate'] . "****" . $row['PaidDate'] . "</title><url>accountPage.php?AccNum=" . $row['AccountNum'] . "</url></link>"; ...that is inside a while loop that loops through the rows returned by a query. Basically, as I said, the whole thing works fine on my dev server but on the production server it never makes it into the for loop so I guess the condition $i<($x->length) isn't being met. I'm at a bit of a loss here. Is there anything like the PHP version or Apache version that may cause the "->" operator to not work? The prod PHP version isn't that much older than my dev PHP version so I doubt that's the issue but it's about all I can think of. Thanks!

Amazing, worked like a charm, thanks!

I'm trying to get live search set up for one of my pages and have been successful for the most part. I basically used the code provided by w3schools (http://www.w3schools.com/php/php_ajax_livesearch.asp) but need to make a modification. Their code is set up to read the link titles and urls from an xml file and search through the xml file but I would like to just search through a variable. So in the w3schools code there is this... $xmlDoc=new DOMDocument(); $xmlDoc->load("links.xml"); $x=$xmlDoc->getElementsByTagName('link'); And I have this variable that I want it to search instead of "links.xml"... $searchTest = "<pages><link><title>Search this text</title><url>www.gohere.com</url></link></pages>"; How do I get that into the $xmlDoc variable? If I simply replace "links.xml" with $searchTest like this $xmlDoc=new DOMDocument(); $xmlDoc->load($searchTest); $x=$xmlDoc->getElementsByTagName('link'); I get nothing when I try to search. But if I create a file in the php code and write the contents of $searchTest to that file then put that file in the $xmlDoc->load("newfile.xml"); line it searches and works fine. Any ideas?

Cags!!! Thanks for the help again. I'm still working through the problem I was having a few days ago and I'm using both of your solutions to get through it. I think I've finally got it working now. Thanks again!

I need a function that will search a string and return the contents of the string between two other strings. For example: $str = "1234567 this is a test and I want this text 999999"; $start = "1234567"; $end = "999999"; $textIWant = " this is a test and I want this text "; So basically I have a huge string and I want to search it for some starting string and copy all the contents between the starting string and a defined ending string into another variable. Can this be done easily? Thanks

Posted this here http://www.phpfreaks.com/forums/index.php/topic,280070.0.html but don't seem to be getting a lot of assistance (cags actually provided great help but I'm still lost) so I figure maybe regex isn't the right way to go (also suggested by cags). Here is my problem... Ok, here is a sample of the string I need broken up... ******Begin Sample********* <div class="PubSectionHeader"><font size="+0">Bill Smith 48415126</font></div> <br> <a name="NDR4pDQoQv5rq1MQk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Called Customer and blah blah blah blah. abc. 10/12/09<blockquote class="gn_c"> She doesn&#39;t want to be contacted on this number but said okay. 10/12/09</blockquote></div> </div> <a name="NDRLWDAoQ2qq687wk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Spoke to customer on alternate number. She said she blah blah blah blah blah. I told her as long as we receive it within a week, no problems. abc 9/18/09</div> </div> <a name="NDRykDAoQv__VvaUk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Left message on premise about issues. abc 7/7/09</div> </div> <a name="NDQrlDAoQxbL1_54k"></a> <div class="PubNote"> <div class="PubNoteContentArea">this is another part of the comment that I need. I think I am going about things the wrong way. abc 6/17/09<blockquote class="gn_c"> She said she&#39;ll call tech support. abc 6/17/09</blockquote></div> </div> <a name="NDQopDQoQ18mwt5wk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Called customer about issue. Left message on alternate number. abc 6/9/09 </div> </div> <a name="NDQduDQoQoNiBhZMk"></a> <div class="PubNote"> <div class="PubNoteContentArea">call was returned &#39;. abc 5/11/09<blockquote class="gn_c"> Customer said she doesn&#39;t want to be transferred to tech support (even though she said her system doesn&#39;t work). She asked why we&#39;re so hard to get a hold of. I let her know she can call the number to contact us. abc 5/11/09<br>Removed from list. abc 5/11/09</blockquote></div> </div> <a name="NDQ7QIgoQ9aWRsJgj"></a> <div class="PubNote"> <div class="PubNoteContentArea">Big problems. abc </div> </div> <a name="SDUThIgoQrLX5r5gj"></a> <div class="PubSectionHeader"><font size="+0">Mark and Larry 700002</font></div> <br> <a name="NDSOkDAoQ5-TduIgk"></a> <div class="PubNote"> <div class="PubNoteContentArea"><span>update per user, told the customer if he gets two remotes we can wave fee . bill 04/08/09 2:00 pm </span><div> </div></div> </div> <a name="NDQmeDQoQjdS-uIgk"></a> <div class="PubNote"> <div class="PubNoteContentArea">yada yada yada yada . <div>bill 04/08/09</div></div> </div> <a name="NDSGpIgoQ56b7r5gj"></a> <div class="PubNote"> <div class="PubNoteContentArea">another note here. abc </div> </div> <a name="SDQqRIwoQyIDmr5gj"></a> *********End Sample************** Ok...all of this is HTML source from Google Docs that I saved into a large .txt file. Basically, I need all of this broken into two parts. Account numbers and comments. All the account numbers are found right after the name which is AFTER the <div class="PubSectionHeader"><font size="+0"> and BEFORE the </font> And all the comments look to be between <div class="PubNoteContentArea"> and </div> but there are usually several separate notes for each account number. So a single account number may have several <div class="PubNoteContentArea"> note areas. Ideally I would like to run through this whole text file and end up with two arrays. One array would be all account numbers (accountNum[0] = "123", accountNum[1] = "456", etc...) and the other array would be all the notes (notes[0] = "notes for account 123", notes[1] = "notes for account 456", etc...) but if it's easier/makes more sense to do one array where the first element would be the account number, the second the notes for the account in the first element, the third, another account number, etc.... then I can work with that too. I realize there is some additional formatting in between some of the <div class="PubNoteContentArea"> note areas like "<blockquote class="gn_c">" and maybe some other stuff but for now I'm not really worried about all that. I can maybe put the whole file into word or excel and do a few find/replaces to get rid of some of that. Up to this point I have loaded the whole file contents into a string and then split the string into a character array where every character (including whitespaces) is an element in the array. I then tried to start messing with the regex part of it and decided I wasn't getting anywhere after a while of playing around with it. Any help is greatly appreciated. If I didn't explain things very well feel free to ask me to clarify. UPDATE* With Cags provided code I get $matches[2] which holds all the account numbers for me but I can't figure out how to get all the notes associated with all those account numbers. It won't be as straight forward as getting the account numbers (I think) because there may be several notes per account number. If I am going about this the wrong way (with regex) suggestions are more than welcome. Thanks!

No one? Is there another route I should be taking here?

Ok...so with your help I get $matches[2] which holds all the account numbers so that's step one. I've been working on step two and can't quite get there...apparently I need to be spoon fed. I'm having trouble figuring out how to get ALL the notes under a particular account number into one element of an array. If I use something like $pattern = '#<div class="PubNoteContentArea">.</div>#is'; preg_match_all($pattern, $contents, $matches); (which I haven't gotten working quite yet) won't that just put each note between the div tags into a separate element? How do I tell it to combine all the notes after one account number and before the next account number into one element? I know that cags mentioned possibly using DOMDocument(). Should I post this somewhere else or can this be done using regex? Thanks again for the help!

Awesome, thanks! That looks like it is very close to what I am looking for. I will play with it for a little bit and come back if I have anymore issues.

...I forgot to mention... The above example would be two accounts if it isn't immediately clear. The first is account number 48415126 and the second is account number 700002.

Ok, here is a sample of the string I need broken up... ******Begin Sample********* <div class="PubSectionHeader"><font size="+0">Bill Smith 48415126</font></div> <br> <a name="NDR4pDQoQv5rq1MQk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Called Customer and blah blah blah blah. abc. 10/12/09<blockquote class="gn_c"> She doesn&#39;t want to be contacted on this number but said okay. 10/12/09</blockquote></div> </div> <a name="NDRLWDAoQ2qq687wk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Spoke to customer on alternate number. She said she blah blah blah blah blah. I told her as long as we receive it within a week, no problems. abc 9/18/09</div> </div> <a name="NDRykDAoQv__VvaUk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Left message on premise about issues. abc 7/7/09</div> </div> <a name="NDQrlDAoQxbL1_54k"></a> <div class="PubNote"> <div class="PubNoteContentArea">this is another part of the comment that I need. I think I am going about things the wrong way. abc 6/17/09<blockquote class="gn_c"> She said she&#39;ll call tech support. abc 6/17/09</blockquote></div> </div> <a name="NDQopDQoQ18mwt5wk"></a> <div class="PubNote"> <div class="PubNoteContentArea">Called customer about issue. Left message on alternate number. abc 6/9/09 </div> </div> <a name="NDQduDQoQoNiBhZMk"></a> <div class="PubNote"> <div class="PubNoteContentArea">call was returned &#39;. abc 5/11/09<blockquote class="gn_c"> Customer said she doesn&#39;t want to be transferred to tech support (even though she said her system doesn&#39;t work). She asked why we&#39;re so hard to get a hold of. I let her know she can call the number to contact us. abc 5/11/09<br>Removed from list. abc 5/11/09</blockquote></div> </div> <a name="NDQ7QIgoQ9aWRsJgj"></a> <div class="PubNote"> <div class="PubNoteContentArea">Big problems. abc </div> </div> <a name="SDUThIgoQrLX5r5gj"></a> <div class="PubSectionHeader"><font size="+0">Mark and Larry 700002</font></div> <br> <a name="NDSOkDAoQ5-TduIgk"></a> <div class="PubNote"> <div class="PubNoteContentArea"><span>update per user, told the customer if he gets two remotes we can wave fee . bill 04/08/09 2:00 pm </span><div> </div></div> </div> <a name="NDQmeDQoQjdS-uIgk"></a> <div class="PubNote"> <div class="PubNoteContentArea">yada yada yada yada . <div>bill 04/08/09</div></div> </div> <a name="NDSGpIgoQ56b7r5gj"></a> <div class="PubNote"> <div class="PubNoteContentArea">another note here. abc </div> </div> <a name="SDQqRIwoQyIDmr5gj"></a> *********End Sample************** Ok...all of this is HTML source from Google Docs that I saved into a large .txt file. Basically, I need all of this broken into two parts. Account numbers and comments. All the account numbers are found right after the name which is AFTER the <div class="PubSectionHeader"><font size="+0"> and BEFORE the </font> And all the comments look to be between <div class="PubNoteContentArea"> and </div> but there are usually several separate notes for each account number. So a single account number may have several <div class="PubNoteContentArea"> note areas. Ideally I would like to run through this whole text file and end up with two arrays. One array would be all account numbers (accountNum[0] = "123", accountNum[1] = "456", etc...) and the other array would be all the notes (notes[0] = "notes for account 123", notes[1] = "notes for account 456", etc...) but if it's easier/makes more sense to do one array where the first element would be the account number, the second the notes for the account in the first element, the third, another account number, etc.... then I can work with that too. I realize there is some additional formatting in between some of the <div class="PubNoteContentArea"> note areas like "<blockquote class="gn_c">" and maybe some other stuff but for now I'm not really worried about all that. I can maybe put the whole file into word or excel and do a few find/replaces to get rid of some of that. Up to this point I have loaded the whole file contents into a string and then split the string into a character array where every character (including whitespaces) is an element in the array. I then tried to start messing with the regex part of it and decided I wasn't getting anywhere after a while of playing around with it. Any help is greatly appreciated. If I didn't explain things very well feel free to ask me to clarify. Thanks!

Okay, thanks for the help guys. I was just trying to keep the code to a minimum using that function but I went ahead and pulled the query out of the function and it's working like a charm now. Thanks again!

Again, I appreciate your help but I have been writing like this for a long time and have never had a problem before. I don't believe the problem has anything to do with syntax. It seems to me that there is some problem with the logic of the while statement or something. To prove this, I change the code to what you suggested and I have the exact same problem. Code now looks like this... function reportQuery($reportName, $accountNumber){ $rq = "SELECT * FROM " . $reportName . " WHERE AccountNum = " . $accountNumber; $retq = mysql_query($rq); echo mysql_error(); return $retq; } $query = "select * from accountinfo WHERE Paid = ''"; $rt = mysql_query($query); echo mysql_error(); while($kt = mysql_fetch_array($rt)){ echo $kt['AccountNum'] . "<br />"; echo "<table border='1' cellspacing='1' cellpadding='1'><tr><th>Type</th><th>Account Number</th><th>Employee</th><th>Pay</th></tr>"; while($rd = mysql_fetch_array(reportQuery('adjustmentsreport', $kt['AccountNum']))){ echo "<tr><td>Adjustment</td><td>" . $rd['AccountNum'] . "</td><td>" . $rd['Name'] . "</td><td>yes/no</td></tr>"; } echo "</table>"; }

I appreciate your quick response but unfortunately, that did not help. Still having the same problem.

Okay, I "fixed" those but now I get an error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampplite\htdocs\webs\zen\payroll.php on line 29 Line 29 is: echo "$kt['AccountNum'] <br />"; All the code now looks like this... function reportQuery($reportName, $accountNumber){ $rq = "SELECT * FROM $reportName WHERE AccountNum = $accountNumber"; $retq = mysql_query($rq); echo mysql_error(); return $retq; } $query = "select * from accountinfo WHERE Paid = ''"; $rt = mysql_query($query); echo mysql_error(); while($kt = mysql_fetch_array($rt)){ echo "$kt['AccountNum'] <br />"; echo "<table border='1' cellspacing='1' cellpadding='1'><tr><th>Type</th><th>Account Number</th><th>Employee</th><th>Pay</th></tr>"; while($rd = mysql_fetch_array(reportQuery('adjustmentsreport', $kt['AccountNum']))){ echo "<tr><td>Adjustment</td><td>$rd['AccountNum']</td><td>$rd['Name']</td><td>yes/no</td></tr>"; } echo "</table>";

Not sure if this should go in the mysql section or the php section so I'm putting it in both. Sorry if that's not what I should do... Okay, here's the code that I have... <?php function reportQuery($reportName, $accountNumber){ $rq = "SELECT * FROM $reportName WHERE AccountNum = $accountNumber"; $retq = mysql_query($rq); echo mysql_error(); return $retq; } $query = "select * from accountinfo WHERE Paid = ''"; $rt = mysql_query($query); echo mysql_error(); while($kt = mysql_fetch_array($rt)){ echo "$kt[AccountNum] <br />"; echo "<table border='1' cellspacing='1' cellpadding='1'><tr><th>Type</th><th>Account Number</th><th>Employee</th><th>Pay</th></tr>"; while($rd = mysql_fetch_array(reportQuery('adjustmentsreport', $kt[AccountNum]))){ echo "<tr><td>Adjustment</td><td>$rd[AccountNum]</td><td>$rd[Name]</td><td>yes/no</td></tr>"; } echo "</table>"; } [code] My accountinfo table has various records with a field called AccountNum that are all unique (no duplicates). My adjustmentsreport table also has various records with a field called AccountNum that match numbers in the accountinfo table but are all again unique within the adjustmentsreport table. My problem is when I open this page and the code executes I get an infinite loop on the first matching AccountNum it finds. I have looked over the code way too many times and I can't figure out what is going on. Any help would be greatly appreciated!

Not sure if this should go in the mysql section or the php section so I'm putting it in both. Sorry if that's not what I should do... Okay, here's the code that I have... <?php function reportQuery($reportName, $accountNumber){ $rq = "SELECT * FROM $reportName WHERE AccountNum = $accountNumber"; $retq = mysql_query($rq); echo mysql_error(); return $retq; } $query = "select * from accountinfo WHERE Paid = ''"; $rt = mysql_query($query); echo mysql_error(); while($kt = mysql_fetch_array($rt)){ echo "$kt[AccountNum] <br />"; echo "<table border='1' cellspacing='1' cellpadding='1'><tr><th>Type</th><th>Account Number</th><th>Employee</th><th>Pay</th></tr>"; while($rd = mysql_fetch_array(reportQuery('adjustmentsreport', $kt[AccountNum]))){ echo "<tr><td>Adjustment</td><td>$rd[AccountNum]</td><td>$rd[Name]</td><td>yes/no</td></tr>"; } echo "</table>"; } My accountinfo table has various records with a field called AccountNum that are all unique (no duplicates). My adjustmentsreport table also has various records with a field called AccountNum that match numbers in the accountinfo table but are all again unique within the adjustmentsreport table. My problem is when I open this page and the code executes I get an infinite loop on the first matching AccountNum it finds. I have looked over the code way too many times and I can't figure out what is going on. Any help would be greatly appreciated!

Nevermind, I got something figured out. Thanks for your help.

Okay, so I figured out why I wanted to append the new comment to the old comment and leave it all in the same record...I can't figure out how to display the comments how I want them now. So now I have a database with a record for every comment entered. Each record has a Date and Comment field. A lot of the Date entries are, obviously, the same because I am inserting a new record for each new comment and multiple people can make a comment for a single game. I'm trying now to get a nice pretty table that displays all of the comments along with the date of the game the comment was for. Which give me this: $querydisp = 'SELECT * FROM comments ORDER BY Date DESC'; $result = mysql_query($querydisp); echo "<table border='1' cellspacing='3' cellpadding='5'><tr><th>Date</th><th>Comments</th></tr>"; while($row = mysql_fetch_array($result)){ echo "<tr><td>" . $row['Date'] . "</td><td>" .$row['Comments']. "</td><tr>"; } echo "</table>"; Problem is, now I get the Date displayed for every comment even though the date is the same for say...the first 4 then the next 3 then the next 6 and so on. I just want the date to be displayed once per set of comments. So I wrote this up: $querydisp = 'SELECT * FROM comments ORDER BY Date DESC'; $result = mysql_query($querydisp); echo "<table border='1' cellspacing='3' cellpadding='5'><tr><th>Date</th><th>Comments</th></tr>"; $DateCheck = "a"; while($row = mysql_fetch_array($result)){ if($row['Date'] == $DateCheck){ $DateCheck = $row['Date']; echo "<tr><td></td><td>" .$row['Comments']. "</td><tr>";} else{ $DateCheck = $row['Date']; echo "<tr><td>" . $row['Date'] . "</td><td>" .$row['Comments']. "</td><tr>"; } } echo "</table>"; This isn't BAD except now, because I have a border set I get a bunch of funky looking empty cells. I think rowspan is probably what I am looking at to fix my problem but I can't figure out how to change the rowspan dynamically with how many dates match the previous date. $querydisp = 'SELECT * FROM comments ORDER BY Date DESC'; $result = mysql_query($querydisp); echo "<table border='1' cellspacing='3' cellpadding='5'><tr><th>Date</th><th>Comments</th></tr>"; $DateCheck = "a"; $span = 1; while($row = mysql_fetch_array($result)){ if($row['Date'] == $DateCheck){ $DateCheck = $row['Date']; $span = $span +1; echo "<tr><td rowspan = '" . $span . "'></td><td>" .$row['Comments']. "</td><tr>";} else{ $span = 1; $DateCheck = $row['Date']; echo "<tr><td>" . $row['Date'] . "</td><td>" .$row['Comments']. "</td><tr>"; } } echo "</table>"; I tried the above but didn't get the results that I was looking for at all because I assume the table is getting created as the code is run and not at the end after reading all the code and adding up all the $span. Does this make sense? Should I go a different route? or can I make this work? I am very open to suggestions. Also, sorry for all the code iterations. I just wanted to show you guys that I am working on figuring it out and not just counting on you all to write my pages for me. Thanks again!

Thanks a lot for your help. That makes perfect sense, I just wasn't really thinking.

Well, admittedly, I am fairly new to mysql so I am certainly open to suggestions but it just made more sense to me to keep all the comments in one record. Basically, I have a table with a Date field and Comment field. The Date corresponds to the date the game was played and I want to allow the players to add comments to a given game if they want to. So...many comment entries would correspond to a single game. It just makes more sense to me to do it this way but I suppose I could create a new record for each comment entered if need be. Is adding a new line in the CONCAT command complicated?

I have the following line... $query = "UPDATE pics SET Comments = CONCAT(COALESCE(Comments, ''),'$Comm') WHERE Date = '$Day'"; I want to append $Comm to whatever is already in the "Comments" field where the Date of that record matches $Day. The code works fine but I want to add a new line each time something is appended to the field. I need to do this because when I display the comments I want to be able to distinguish between each entry. How can I do this? I can't figure out where to put a \n or <br /> or <p> in the string. Thanks in advance, Ryan

Thank you, it's all working now. My server was doing something weird caching and I wasn't seeing the changes I was making. Thanks for all your help!

Thanks to both of you for the quick responses. Your help is appreciated but something is still just not working. Here are the two files I am working with to give a clearer explanation. H ere is my file1: <?php $gameDate = $_POST['gameDate']; ?> <form name="form" method="post" action="file2.php"> <?php $i = 0; while(isset($gameDate[$i])){ ?> <p>Enter comments for the <?php echo $gameDate[$i]; ?> game:<br /> <textarea name="C<?php echo $i; ?>" COLS=40 ROWS=6></textarea></p> <?php $i = $i + 1; } ?> <p><input type="submit" name="Submit" value="Submit" /></p> </form> ...all that is between the html and body tags. file2.php: <?php $i=0; while(isset($_POST['C' .$i])){ $test[$i] = $_POST['C' .$i]; $i++; } echo $test[0]; echo $test[1]; echo $test[2]; ?> In file1, the "gameDate" is data sent over from another form. For simplistic sake let's just say it just contains a number starting with 0 and ending wherever the user that submits the form sets. So...that textarea will be generated however many times the user has set in the previous form with the "gameDate" variable. I need each textarea name to be unique (or any array) so that I can access them on file2.php. I tried changing the name attribute for the textarea to "C[]" as suggested but could not get that to work either. I also tried the other methods mentioned to run through the C0, C1, C2, ... and couldn't get anything to work. Am I missing something here? I would like the textarea data to be saved to an array but I don't know how to do that within the form. Again, thanks for the quick responses.