Forum
Gehe zu: » Forum » Sonstige Skriptsprachen » ajax sufu mit php
Seite: 1
Thema
Autor
hallo leute, habe hier eine ajax sufu und würde da gerne benutzernamen aus der db erscheinen lassen leider funktioniert das nciht so wie ich das möchte.. hoffe mir kann jemand helfen?
hier versuch ich die benutzerdaten auszulesen
allerdings erscheint nur ein nickname 'caro' es sind allerdings noch admin und 'sero' vorhanden
PHP-Code:<?php include "../settings/settings.php"; $mysql['handle'] = mysql_pconnect($host, $user, $pass); $db = mysql_select_db($datab) or die(mysql_error()); // Datenbank auswählen $query = mysql_query("SELECT Nickname FROM `benutzerdaten` "); while($row = mysql_fetch_object($query)){ $suche = $row->Nickname; } ?>
Code:
<script>
MS_ajax_select = function(searchopt, rows, data) {
document.write('<div ');
document.write('id="ajaxselectboxcon" ');
document.write('style="');
document.write('position:absolute;');
document.write('left:0px;');
document.write('top:0px;');
document.write('visibility:hidden;');
document.write('display:none;');
document.write('">');
document.write('<form name="ajaxform">');
document.write('<select name="ajaxselectbox" size="'+rows+'">');
document.write('</select>');
document.write('</form>');
document.write('</div>');
document.data = data;
document.searchopt = searchopt.toLowerCase();
};
MS_run_ajax_select = function(e) {
if(typeof(document.body.scrollTop) == 'number' || window.opera) {
if(window.event) {
if(!event.x) {
var px = event.clientX;
var py = event.clientY;
} else {
if(event.clientY>event.screenY) {
var px = document.body.scrollLeft+event.screenX-2;
var py = document.body.scrollTop+event.screenY-138;
} else {
var px = document.body.scrollLeft+event.clientX;
var py = document.body.scrollTop+event.clientY;
}
}
var current = event.srcElement;
} else {
var px = document.body.scrollLeft+e.clientX;
var py = document.body.scrollTop+e.clientY;
var current = e.target;
}
} else {
var px = window.pageXOffset+e.clientX;
var py = window.pageYOffset+e.clientY;
var current = e.target;
}
var obj = document.getElementById('ajaxselectboxcon');
if(current.type == 'text' || current.type == 'textarea') {
var sbox = document['ajaxform']['ajaxselectbox'];
obj.data = document.data;
obj.current = current;
obj.sbox = sbox;
obj.updatebox = function() {
var tmp = [];
for(var x in this.data[this.current.name]) {
var currentvalue = this.current.value.toLowerCase();
var currentdata = this.data[this.current.name][x];
if(document.searchopt == 'first') {
if(currentdata.toLowerCase().substr(0, currentvalue.length) == currentvalue) {
tmp[tmp.length] = currentdata;
}
} else if(document.searchopt == 'full') {
if(currentdata.toLowerCase().indexOf(currentvalue)>-1) {
tmp[tmp.length] = currentdata;
}
}
}
if(tmp.length>0) {
for(var x=this.sbox.options.length-1; x>=0; --x) {
this.sbox.options[x] = null;
}
for(var x=0; x<tmp.length; ++x) {
this.sbox.obj = this;
this.sbox.field = this.current;
this.sbox.options[x] = new Option(tmp[x], tmp[x]);
this.sbox.onchange = function() {
this.field.value = this.value;
this.obj.style.visibility = 'hidden';
this.obj.style.display = 'none';
for(var x=this.options.length-1; x>=0; --x) {
this.options[x] = null;
}
};
}
} else {
this.style.visibility = 'hidden';
this.style.display = 'none';
}
};
current.obj = obj;
current.onkeyup = function() {
this.obj.style.visibility = 'visible';
this.obj.style.display = 'block';
this.obj.updatebo
);
}
current.onclick = function() {
this.obj.style.visibility = 'hidden';
this.obj.style.display = 'none';
};
if(obj.sbox.options.length>0) {
obj.style.visibility = 'visible';
obj.style.display = 'block';
} else {
obj.style.visibility = 'hidden';
obj.style.display = 'none';
}
obj.style.top = py;
obj.style.left = px+40;
} else {
obj.style.visibility = 'hidden';
obj.style.display = 'none';
}
};
if(document.captureEvents) {
document.captureEvents(Event.CLICK);
}
document.onclick = MS_run_ajax_select;
MS_ajax_select('FULL', 25, {'feld1':["<?php echo$suche;?>"]});
</script>
<form>
<input type="text" name="feld1" size="40" />
</form>
<script>
MS_ajax_select = function(searchopt, rows, data) {
document.write('<div ');
document.write('id="ajaxselectboxcon" ');
document.write('style="');
document.write('position:absolute;');
document.write('left:0px;');
document.write('top:0px;');
document.write('visibility:hidden;');
document.write('display:none;');
document.write('">');
document.write('<form name="ajaxform">');
document.write('<select name="ajaxselectbox" size="'+rows+'">');
document.write('</select>');
document.write('</form>');
document.write('</div>');
document.data = data;
document.searchopt = searchopt.toLowerCase();
};
MS_run_ajax_select = function(e) {
if(typeof(document.body.scrollTop) == 'number' || window.opera) {
if(window.event) {
if(!event.x) {
var px = event.clientX;
var py = event.clientY;
} else {
if(event.clientY>event.screenY) {
var px = document.body.scrollLeft+event.screenX-2;
var py = document.body.scrollTop+event.screenY-138;
} else {
var px = document.body.scrollLeft+event.clientX;
var py = document.body.scrollTop+event.clientY;
}
}
var current = event.srcElement;
} else {
var px = document.body.scrollLeft+e.clientX;
var py = document.body.scrollTop+e.clientY;
var current = e.target;
}
} else {
var px = window.pageXOffset+e.clientX;
var py = window.pageYOffset+e.clientY;
var current = e.target;
}
var obj = document.getElementById('ajaxselectboxcon');
if(current.type == 'text' || current.type == 'textarea') {
var sbox = document['ajaxform']['ajaxselectbox'];
obj.data = document.data;
obj.current = current;
obj.sbox = sbox;
obj.updatebox = function() {
var tmp = [];
for(var x in this.data[this.current.name]) {
var currentvalue = this.current.value.toLowerCase();
var currentdata = this.data[this.current.name][x];
if(document.searchopt == 'first') {
if(currentdata.toLowerCase().substr(0, currentvalue.length) == currentvalue) {
tmp[tmp.length] = currentdata;
}
} else if(document.searchopt == 'full') {
if(currentdata.toLowerCase().indexOf(currentvalue)>-1) {
tmp[tmp.length] = currentdata;
}
}
}
if(tmp.length>0) {
for(var x=this.sbox.options.length-1; x>=0; --x) {
this.sbox.options[x] = null;
}
for(var x=0; x<tmp.length; ++x) {
this.sbox.obj = this;
this.sbox.field = this.current;
this.sbox.options[x] = new Option(tmp[x], tmp[x]);
this.sbox.onchange = function() {
this.field.value = this.value;
this.obj.style.visibility = 'hidden';
this.obj.style.display = 'none';
for(var x=this.options.length-1; x>=0; --x) {
this.options[x] = null;
}
};
}
} else {
this.style.visibility = 'hidden';
this.style.display = 'none';
}
};
current.obj = obj;
current.onkeyup = function() {
this.obj.style.visibility = 'visible';
this.obj.style.display = 'block';
this.obj.updatebo
}
current.onclick = function() {
this.obj.style.visibility = 'hidden';
this.obj.style.display = 'none';
};
if(obj.sbox.options.length>0) {
obj.style.visibility = 'visible';
obj.style.display = 'block';
} else {
obj.style.visibility = 'hidden';
obj.style.display = 'none';
}
obj.style.top = py;
obj.style.left = px+40;
} else {
obj.style.visibility = 'hidden';
obj.style.display = 'none';
}
};
if(document.captureEvents) {
document.captureEvents(Event.CLICK);
}
document.onclick = MS_run_ajax_select;
MS_ajax_select('FULL', 25, {'feld1':["<?php echo$suche;?>"]});
</script>
<form>
<input type="text" name="feld1" size="40" />
</form>
hier versuch ich die benutzerdaten auszulesen
Code:
MS_ajax_select('FULL', 25, {'feld1':["<?php echo$suche;?>"]});
MS_ajax_select('FULL', 25, {'feld1':["<?php echo$suche;?>"]});
allerdings erscheint nur ein nickname 'caro' es sind allerdings noch admin und 'sero' vorhanden
Hi,
was steht den hier?
(also wenn PHP die Variable ausgefüllt hat "<?php echo$suche;?>").
Gruss Patrick
was steht den hier?
Zitat:
MS_ajax_select('FULL', 25, {'feld1':["<?php echo$suche;?>"]});
(also wenn PHP die Variable ausgefüllt hat "<?php echo$suche;?>").
Gruss Patrick
stimmt das ist komisch es steht nur
Code:
MS_ajax_select('FULL', 25, {'feld1':["caro"]});
MS_ajax_select('FULL', 25, {'feld1':["caro"]});
Hi,
mit folgenden Code:
überschreibst du ja auch jedes mal die Variable $suche.
Versuch es doch mal mit:
(ggf. noch Komma/Leerzeichen
Gruss Patrick
mit folgenden Code:
PHP-Code:while($row = mysql_fetch_object($query)){ $suche = $row->Nickname; }
überschreibst du ja auch jedes mal die Variable $suche.
Versuch es doch mal mit:
PHP-Code:while($row = mysql_fetch_object($query)){ $suche .= $row->Nickname; }
(ggf. noch Komma/Leerzeichen
oder sowas dazwischen falls du es übersichtlicher machen willst.....PHP-Code:$suche .= ', ' . $row->Nickname;
Gruss Patrick
Seite: 1
Statistik
Es wurden insgesamt 2156 Beiträge geschrieben.
Wir haben 10450 registrierte Mitglieder.
Der neueste Benutzer ist Sasha - Forum Beta³ - Bug melden
Wir haben 10450 registrierte Mitglieder.
Der neueste Benutzer ist Sasha - Forum Beta³ - Bug melden
Beitrag von

