Notice: Undefined variable: str in suggest.php on line 26
Czyli w: $str .= $wiersz['title']."\n";
Czasami też jak wpisze trochę więcej to wyświetla mi:
Notice: Undefined variable: str in suggest.php on line 28
Czyli w: $str .= "empty \n";
suggest.php
<?php function lacz_bd() { $db = new mysqli('localhost','uzyt_zak','haslo','uzytkownik'); if (! $db) return false; $db->autocommit(TRUE); return $db; } $db = lacz_bd(); if (mysqli_connect_errno() ===0){ $db -> query("SET NAMES 'utf8'"); } $zapytanie = "select title from suggest where title LIKE '%$search%' LIMIT 10"; $wynik = $db->query($zapytanie); $ile_znalezionych = $wynik->num_rows; for ($i=0; $i<$ile_znalezionych; $i++) { $wiersz = $wynik->fetch_assoc(); $str .= $wiersz['title']."\n"; } $str .= "empty \n"; } ?>
suggest.js
function searchSuggest(){ var str = encodeURI(document.getElementById('searchinput').value); var myAjax = new Ajax.Request( 'suggest.php', { method: 'get', parameters: "search="+str, onComplete: showResponse, onFailure: showAlert }); } function showResponse(text){ if(text.responseText==''){ var search_suggest = document.getElementById("search_suggest"); search_suggest.style.visibility = "visible"; var ss = document.getElementById('search_suggest'); ss.innerHTML = ''; }else{ var search_suggest = document.getElementById("search_suggest"); search_suggest.style.visibility = "visible"; var ss = document.getElementById('search_suggest'); ss.innerHTML = ''; for(i=0; i < str.length - 1; i++) { var suggest = '<div onmouseover="java script:suggestOver(this);" '; suggest += 'onmouseout="java script:suggestOut(this);" '; suggest += 'onclick="java script:setSearch(this.innerHTML);" '; suggest += 'class="suggest_link">' + str[i] + '</div>'; ss.innerHTML += suggest; } } } function showAlert(MyRequest) { alert("Operacja nie powiodła się"); } function suggestOver(div_value) { div_value.className = 'suggest_link_over'; } function suggestOut(div_value) { div_value.className = 'suggest_link'; } function setSearch(value) { var search_suggest = document.getElementById("search_suggest"); search_suggest.style.visibility = "hidden"; document.getElementById('searchinput').value = value; document.getElementById('search_suggest').innerHTML = ''; }
styl.css
#search fieldset { margin: 0; padding: 0; border: none; } #search legend { display: none; } .search { background:url("grafika/searchtext.jpg"); border:none; background-repeat:no-repeat; width:94px; height:21px; cursor:pointer; } .suggest_link { background-color: #f9f8f0; padding: 2px 6px 2px 6px; border-bottom: #E9E9E9 solid 1px; padding:5px 5px 5px 5px; } .suggest_link_over { background-color: #ffffff; padding: 2px 6px 2px 6px; cursor:pointer; border-bottom: #E9E9E9 solid 1px; padding:5px 5px 5px 5px; } #search_suggest { width:208px; position: absolute; background-color: #FFFFFF; text-align: left; border: #edebd5 solid 1px; visibility:hidden;