-
Posts
23 -
Joined
-
Last visited
Profile Information
-
Gender
Male
Ifaiden's Achievements

Newbie (1/5)
0
Reputation
-
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"
-
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?
-
Yes, I am. Is this the wrong way to use it? (correction: how do I make it work? )
-
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
-
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.
-
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.
-
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>