Jump to content

Ifaiden

Members
  • Posts

    23
  • Joined

  • Last visited

Profile Information

  • Gender
    Male

Ifaiden's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. From the link: "session.cookie_lifetime specifies the lifetime of the cookie in seconds which is sent to the browser. The value 0 means "until the browser is closed." Defaults to 0.". It doesn't state anything about "session stays active even after the browser has been closed"
  2. Ok, thanks for the quick answer. If I don't want to use cookies, can I instead place the file temporarily in a database (mysql?) and have like a timeout that removes and updates the database? Is this more optimized than cookies?
  3. Yes, I am. Is this the wrong way to use it? (correction: how do I make it work? )
  4. Hi! I'm working on a simple e-commerce script. I have some $_SESSION variables that is defined and works fine while surfing on the site. But when I close the browser and reenter the site, all the session-variables are not defined (unset?), until i click on a link on the site. Weird behavior... please help! /I
  5. Solved this with: if(detect_ie()){ // Converts the input to UTF-8 $q=utf8_encode($q); } $q is the input string. And detect_ie checks if it's IE.
  6. I identified the problem and it seems that the string you type in the input field is in ISO-8859-1. I tested to type in: "Mangold SG Hävstångscertifikat Sverige Select - (5 år)" and got a hit. This problem only occurs in Internet Explorer.
  7. I don't know if this is a specific ajax problem or if it's just Internet Explorer. I'm working on an ajax live search function ( i followed the guide here http://www.w3schools.com/php/php_ajax_livesearch.asp). I'm converting an excel-file to XML. When I fill in the form with the letters å, ä, ö (Swedish) in internet explorer I get no hits. In any other browsers it works fine. I have defined UTF-8 in all the browsers, tested ISO-8859-1 (recommended Swedish) and even tried combining them. Nothing works... Any ideas? Example: http://mindu.mine.nu/amazing_solutions/XLStoXML/search.html XML-file: http://mindu.mine.nu/amazing_solutions/XLStoXML/Varderingar.xml XLS To XML <?php header('Content-Type: text/html; charset=UTF-8'); require_once('/var/www/amazing_solutions/XLStoXML/reader.php'); $data = new Spreadsheet_Excel_Reader(); $data->setUTFEncoder('iconv'); $data->setOutputEncoding('CP-1251'); // Read in excel file $data->read('/var/www/amazing_solutions/XLStoXML/Varderingar.xls'); //Count XLS-data rows // Get first sheet $sheet = $data->sheets[0]; // Get all rows in the sheet $rows = $sheet['cells']; // Find total number of rows $rowCount = count($rows); /* // Show data from last row echo "<table><tr>"; foreach($rows[$rowCount -1] as $col) { echo "<td>$col</td>"; } echo "</tr></table>"; */ //Skips the two first rows (Data begins at row 3) $rowCount=$rowCount-2; echo "Antalet rader data i excel-filen (Data börjar i rad 3): ".$rowCount.""; // End of count XLS-data rows $myFile = "Varderingar.xml"; $fh = fopen($myFile, 'w') or die("$myFile gick inte att hitta"); $stringData = "<?xml version='1.0' encoding='ISO-8859-1'?>\n<pages>\n"; fwrite($fh, $stringData); //Import XLS-data to XML-file in right format $loop_count = 0; //Data begins in row 3 $row_start_count = 3; $search = array('&'); $replace = array('&'); //title = Kolumn A, URL = ISIN.htm while($loop_count!=$rowCount){ $stringData = "<link>\n<namn>".str_replace($search, $replace, $data->sheets[0]['cells'][$row_start_count][1])."</namn>\n<url>".$data->sheets[0]['cells'][$row_start_count][5].".htm</url>\n"; fwrite($fh, $stringData); $stringData = "<dagskurs>".$data->sheets[0]['cells'][$row_start_count][2]."</dagskurs>\n"; fwrite($fh, $stringData); $stringData = "<langsiktigtvarde>".$data->sheets[0]['cells'][$row_start_count][3]."</langsiktigtvarde>\n"; fwrite($fh, $stringData); $stringData = "<index>".$data->sheets[0]['cells'][$row_start_count][4]."</index>\n"; fwrite($fh, $stringData); $stringData = "<isin>".$data->sheets[0]['cells'][$row_start_count][5]."</isin></link>\n"; fwrite($fh, $stringData); $loop_count++; $row_start_count++; } // End of import XLS-data to XML-file $stringData = "</pages>"; fwrite($fh, $stringData); fclose($fh); ?> Livesearch.php <?php header('Content-Type: text/html; charset=UTF-8'); $xmlDoc=new DOMDocument(); $xmlDoc->load("Varderingar.xml"); $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('namn'); $z=$x->item($i)->getElementsByTagName('url'); $t=$x->item($i)->getElementsByTagName('isin'); $a=$x->item($i)->getElementsByTagName('dagskurs'); $b=$x->item($i)->getElementsByTagName('langsiktigtvarde'); $c=$x->item($i)->getElementsByTagName('index'); if ($y->item(0)->nodeType==1 && $t->item(0)->nodeType==1) { //find a link matching the search text if (stristr($y->item(0)->childNodes->item(0)->nodeValue,$q) || stristr($t->item(0)->childNodes->item(0)->nodeValue,$q) ) { if ($hint=="") { $hint= "<table border='0' width='850' cellspacing='0' cellpadding='5px'> <tr id='headertable'> <td width='350px'> <b><font size='2'>Produkt </font></b> </td> <td width='95px'> <b><font size='2'>Isinkod </font></b> </td> <td width='105px'> <b><font size='2'>Indiaktivt Marknadsvärde </font></b> </td> <td width='78px'> <b><font size='2'>Långsiktigt Värde </font></b> </td> <td width='90px'> <b><font size='2'>Underliggande Index </font></b> </td> </tr> </table><table border='0' width='850' cellspacing='0' cellpadding='5px'><tr class='tablestyle'> <td width='350px'> <a href='" . $z->item(0)->childNodes->item(0)->nodeValue . "' target='_blank'>" . $y->item(0)->childNodes->item(0)->nodeValue . "</a><td width='95px'>" . $t->item(0)->childNodes->item(0)->nodeValue . "</td><td width='105px'>" . $a->item(0)->childNodes->item(0)->nodeValue . "</td><td width='78px'>" . $b->item(0)->childNodes->item(0)->nodeValue . "</td><td width='90px'>" . $c->item(0)->childNodes->item(0)->nodeValue . "</td></tr> </table>"; } else { $hint=$hint . "<table border='0' width='850' cellspacing='0' cellpadding='5px'><tr class='tablestyle'><td width='350px'><a href='" . $z->item(0)->childNodes->item(0)->nodeValue . "' target='_blank'>" . $y->item(0)->childNodes->item(0)->nodeValue . "</a><td width='95px'>" . $t->item(0)->childNodes->item(0)->nodeValue . "</td><td width='105px'>" . $a->item(0)->childNodes->item(0)->nodeValue . "</td><td width='78px'>" . $b->item(0)->childNodes->item(0)->nodeValue . "</td><td width='90px'>" . $c->item(0)->childNodes->item(0)->nodeValue . "</td> </tr> </table>"; } } } } } // Set output to "no suggestion" if no hint were found // or to the correct values if ($hint=="") { $response="Inga träffar"; } else { $response=$hint; } //output the response echo $response; ?> search.html <!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>LiveSearchTest</title> <style type="text/css"> #livesearch{ width: 850px; padding-left: 10px; padding-top: 5px; } #livesearch a:link, #livesearch a:visited, #livesearch a:focus{ text-decoration: none; outline: none; color: #808080; font-family: arial; font-size: 12px; } #livesearch a:hover{ text-decoration: underline; color: #505050; } #header { text-decoration: none; outline: none; color: #808080; font-family: arial; font-size: 12px; } .tablestyle { text-decoration: none; outline: none; color: #808080; font-family: arial; font-size: 12px; text-align: left; } #headertable { color: #808080; font-family: arial; font-size: 11px; } </style> <script type="text/javascript"> function showResult(str) { if (str.length==0) { document.getElementById("livesearch").innerHTML=""; document.getElementById("livesearch").style.border="0px"; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("livesearch").innerHTML=xmlhttp.responseText; document.getElementById("livesearch").style.border="1px solid #A5ACB2"; } } xmlhttp.open("GET","livesearch.php?q="+str,true); xmlhttp.send(); } </script> </head> <body> <form action=""> <input type="text" size="30" onkeyup="showResult(this.value)" value='Sök här...' onfocus="if(this.value==this.defaultValue){this.value='';}" onblur="if(this.value==''){this.value=this.defaultValue;}" /> <div id="livesearch"></div> </form> </body> </html>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.