Page 1 of 1
keyup event (v2020)
Posted: Wed Jan 25, 2023 7:05 am
by SOHIB
I need some help on:
how I can query database form client side and return some values to client side add page
I have one text field , and on I enter name values if i event is KeyUp , I want to get the balance amount from the table account and display it on popup as a text
i have try to use this code , but it does not work
{ // keys = event types, values = handler functions
"change keyup": function(e) {
// Your code
var $row=$(this).fields();
var str=$row["p_name"].val();
//function showHint(str) {
if (str.length == 0) {
document.getElementById("x_txtHint").innerHTML = "";
return;
}
const xhttp = new XMLHttpRequest();
xhttp.onload = function() {
document.getElementById("x_txtHint").innerHTML =
this.responseText;
}
xhttp.open("GET", "showcustbala.php?name="+str,true);
xhttp.send();
}
}
so many thanks for guide us
Re: keyup event
Posted: Wed Jan 25, 2023 9:12 am
by mobhar
You may press F12 and check whether any Javascript error message from Console panel of your browser.
Re: keyup event
Posted: Thu Jan 26, 2023 5:23 am
by SOHIB
this the error i found
Uncaught TypeError: Cannot set properties of null (setting 'innerHTML')
at a.onload (userevt.js:1:505)
please help
Re: keyup event
Posted: Thu Jan 26, 2023 10:58 am
by arbei
The error means in your client side code you use xxx.innerHTML
but xxx
is null, you may review your code.
Re: keyup event
Posted: Fri Jan 27, 2023 2:57 am
by SOHIB
this the code could please help and check it
{ // keys = event types, values = handler functions
"change ": function(e) {
// Your code
var $row=$(this).fields();
var str=$row["p_name"].val();
if (str.length == 0) {
document.getElementById("txtHint").innerHTML = "";
return;
}
const xhttp = new XMLHttpRequest();
xhttp.onload = function() {
document.getElementById("txtHint").innerHTML =
this.responseText;
}
xhttp.open("GET", "showcustbala.php?name="+str,true);
xhttp.send();
}
}
and this is the code from the: showcustbala.php
<?php
$name=$_GET["name"];
echo"<table>";
echo"<tr ><td><b>رصيد العميل</b></td></tr>";
$multirec=Conn()->execute("select sum(overhim) as ovh,sum(forhim) as fhm from account where acc_name='$name'");
$ROWS = $multirec->GetRows();
if (count($ROWS) > 0) {
foreach($ROWS AS $ROW){
$ovh=$ROW['ovh'];
$fhm=$ROW['fhm'];
$bal=$ovh-$fhm;
echo"<tr ><td><b>".$bal."</b></td></tr></table>";
?>
and this the field in the addpage
<div> <p> <span id="txtHint"></span></p></div>
Kindly please check it i could not find how to correct it
Re: keyup event
Posted: Fri Jan 27, 2023 10:05 am
by arbei
arbei wrote:
The error means in your client side code you use xxx.innerHTML
but xxx
is null
SOHIB wrote:
document.getElementById("txtHint").innerHTML = "";
Your id is wrong.
Re: keyup event
Posted: Sat Jan 28, 2023 11:25 pm
by SOHIB
Yes , thank you for help,
it was the id selector
I have one more question
now this div is displayed on the add page at the bottom , if I want to to display this div on overly on the page
is there any hint please how I could do it, just to inform about this value by small window and then i can close it
Re: keyup event
Posted: Mon Jan 30, 2023 8:39 am
by mobhar
Did you mean you want to display it on a Modal dialog window? You may use Javascript code in your Startup Script, for example:
ew.alert("Something");
Re: keyup event
Posted: Wed Feb 01, 2023 12:35 am
by SOHIB
Ok, thanks for help
I try to use ew.alert()
but I could not display the balance value in alert ,or exactly i don't know where i should to put this could
i have three part
1-custm template add where i have the <div> which I display the value now on which is working when I
2-other codes is client side scripts
3-other code in php file , all those parts code are submitted here in pervious
so could please look throw the codes I have sent and see how i can display the $bal variable which is in php file
Re: keyup event
Posted: Wed Feb 01, 2023 10:05 am
by arbei
Re: keyup event
Posted: Thu Feb 02, 2023 3:32 am
by SOHIB
Hello , thansk again
I am using v2020 and no route_action server
is there any way to do it with my version
Re: keyup event (v2020)
Posted: Thu Feb 02, 2023 9:37 am
by arbei
You may Create Your Own API Action (refer to the help file of your version).