Re: [PHP] create a local temp table in local machine

[iccsi]

Thanks for the message,
Do you have any information how to create JS file and how to access from 
jQuery auto complete?

Thanks again for helping,

Regards,

Iccsi,



"Bastien"  wrote in message 
news:57469e24-56e6-40c9-8176-64cd8444f...@gmail.com...




Thanks,

Bastien


On Sep 28, 2013, at 8:24 PM, "iccsi"  wrote:

Thanks for the information and help,
Yes, my data is pretty much static,
Can you please give me some link for the solution?
It is the solution I am looking for my current situation,

Thanks a million for helping,

Regards,

Iccsi,


I don't have a link unfortunately. The system I did it for is proprietary. 
But I do recall it was a pretty switch in the JS to view the list from the 
static file. The JS file with the static data was just an array and the 
autocomplete looked at that as the data source


Sorry

Bastien 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] create a local temp table in local machine

[iccsi]

Thanks for the information and help,
Yes, my data is pretty much static,
Can you please give me some link for the solution?
It is the solution I am looking for my current situation,

Thanks a million for helping,

Regards,

Iccsi,

"Bastien"  wrote in message 
news:deb5dfe9-ec7f-4bc5-9e2e-acfb85039...@gmail.com...





On Sep 28, 2013, at 6:00 PM, "iccsi"  wrote:

Thanks for the message and help,
because I use jQuery autocomplete which has performance issue for 
thousands records due to network load data.
I want to load the data to local table to resolve performance issue, if it 
possible I can load to an array in the memory.


Thanks again for helping,

Regards,

iccsi,

"Bastien"  wrote in message 
news:2fd3037d-f68d-47b3-ac4f-007d9559d...@gmail.com...




Thanks,

Bastien


On Sep 28, 2013, at 3:24 PM, "iccsi"  wrote:

I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side 
or jQuery to do the work.

Your information and help is great appreciated,

regards,


Iccsi


If you're looking to create a SQl table then most but not all browsers can 
use SQLite locally for data storage ( it does require newer browsers).


You haven't stated the goal for this so other options could include 
sending csv or json data down to the browser and using jquery, angular or 
some other JS framework to manipulate that data may also be an option




I had exactly this situation, large list with the autocomplete. I cached the 
list to a JS file and ran the autocomplete from that. It works well if the 
list is relatively static which mine was. It will be tougher if the list is 
dynamic, but you could send the data down after the initial page load.


HTH

Bastien= 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] create a local temp table in local machine

[iccsi]

Thanks for the message and help,
because I use jQuery autocomplete which has performance issue for thousands 
records due to network load data.
I want to load the data to local table to resolve performance issue, if it 
possible I can load to an array in the memory.


Thanks again for helping,

Regards,

iccsi,

"Bastien"  wrote in message 
news:2fd3037d-f68d-47b3-ac4f-007d9559d...@gmail.com...




Thanks,

Bastien


On Sep 28, 2013, at 3:24 PM, "iccsi"  wrote:

I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side 
or jQuery to do the work.

Your information and help is great appreciated,

regards,


Iccsi


If you're looking to create a SQl table then most but not all browsers can 
use SQLite locally for data storage ( it does require newer browsers).


You haven't stated the goal for this so other options could include sending 
csv or json data down to the browser and using jquery, angular or some other 
JS framework to manipulate that data may also be an option



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] create a local temp table in local machine

[iccsi]

I need create a local table on the local machine.
I would like to know is it possible to down on server side or client side or 
jQuery to do the work.

Your information and help is great appreciated,

regards,


Iccsi, 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] jquery fill select option value

[iccsi]

 --
 BMW
 Audi


I use above code to have my select drop down on the form and would like to 
use jQuery to fill option value on change event.
I would like know is it possible to do, if yes, any hint or example code at 
server site is appreciated,


Your help and information is great appreciated,

Regards,

Iccsi, 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] assign database result to iinput text box

[iccsi]

I have following html code to show my input text box and php to connect 
server and select result from database server.
I would like to know how I can I use php to assign the value to my input 
text.

Your help and information is great appreciated,

Regards,

Iccsi,




";

//select a database to work with
$selected = mysql_select_db("iccsimd",$dbhandle)
 or die("Could not select aerver");

//execute the SQL query and return records
$result = mysql_query("SELECT invid, invdate, note, amount FROM invheader");


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] message to user after complete POST

[iccsi]

Thanks a million for the information and help,
yes, I will use jQuery to have my success function call in jQuery.ajax.

Thanks again,

Regards,

Iccsi,

"Rodrigo Santos"  wrote in message 
news:caombckqonakxoc4tnhcpn2ycdpy8503xttc7sosjywhtd5x...@mail.gmail.com...


hey, if you are just trying to give the user a feedback about the
information sent, there is a Global variable for this, and it's the $_POST.
When you receive the information on the script you called on the "Action"
atribute of the form, via the $_POST global variable, you will test the
information end echo the feedback on that script.

Note that, unless you are using ajax (jquery, or any other javascript ajax
method), when you post a form, you will be intantly redirected to the
"action" path. then you have nothing to do in the source page.

hope you got it.


2013/9/4 iccsi 


I have a POST form and action itself like following



I want to show success message when POST complete or error message if
there is any.
I would like to know are there any property or global variable I can check
to show message to users.
If not, it seems that the only solution is jQuery, since it has success
function that jQuery call after POST.

Your help and information is great appreciated,


Regards,

Iccsi,


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] message to user after complete POST

[iccsi]

I have a POST form and action itself like following



I want to show success message when POST complete or error message if there 
is any.
I would like to know are there any property or global variable I can check 
to show message to users.
If not, it seems that the only solution is jQuery, since it has success 
function that jQuery call after POST.


Your help and information is great appreciated,


Regards,

Iccsi,


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: SELECT data base on a upper level SELECT

[iccsi]

Thanks for the information and help,
The query can solve server side, but client side, user might select any one 
dropdown, for example, user might select manager from drop down without 
choose Department dropdown.


For this case, application needs inject data for supervisor and lower level,

Thanks again for helping,

Regards,

Iccsi,

"Jim Giner"  wrote in message news:8c.41.29774.c0e5a...@pb1.pair.com...

On 7/31/2013 9:37 PM, iccsi wrote:

I have 5 SELECT for Department, Manager, supervisor, Group Leader and
Employees
I want to every SELECT list narrow down for an upper SELECT.
For example, once user select Department then all Manager, Supervisor,
Group Leader and Employee list will be narrow down by department and
same for manager and supervisor and so on.

I can use iframe or jQuery to do every level, but it needs to call
iframe or jQuery to 5 levels.
I would like to know are there any better way to handle this situation,

Your help and information is great appreciated,

Regards,


Iccsi,


How about using just one select and add variables to the where clause?
Set the variable(s) to the values that you want to filter on.

For ex.:

your query is
$sel = 1;
$q = "select Department, Manager, supervisor, Group Leader,Employees
where $sel";

Then when the user selects a department $d:

$sel = "Department = '$d'";

OR if you have selected a department $d and a manager $m:

$sel = "Department ='$d' and Manager='$m'";

One query.  A variable 'where' clause. 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SELECT data base on a upper level SELECT

[iccsi]

I have 5 SELECT for Department, Manager, supervisor, Group Leader and 
Employees

I want to every SELECT list narrow down for an upper SELECT.
For example, once user select Department then all Manager, Supervisor, Group 
Leader and Employee list will be narrow down by department and same for 
manager and supervisor and so on.


I can use iframe or jQuery to do every level, but it needs to call iframe or 
jQuery to 5 levels.

I would like to know are there any better way to handle this situation,

Your help and information is great appreciated,

Regards,


Iccsi,


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] POST action

[iccsi]

Your name: 
Your age: 

In the PHP tutorial manual, it says that we can have post action to 
the form itself just like above coding.I would like to know in the real 
projects, can we have action to the same PHP file, since that we only need 
have one filebut not 2 files foe POST request,Your help and information is 
great appreciated,regards,Iccsi, 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] pass parameter from client to server

[iccsi]

I have a select control on the form and need to pass value user select to my 
query parameter.
I just realized that user entry value is client side and query parameter is 
server side.

Are there any way to read client parameter to pass to server?

You information and help is great appreciated,

Regards,

Iccsi, 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: pass parameter via URL

[iccsi]

Thanks a million for helping,
I just need to have a JS function to return a string var which contains my 
variable from sending page and call the function onClick on the button.

Please let me know if I am wrong,
Thanks again for helping,

Regards,

Iccsi,

"Jim Giner"  wrote in message news:40.54.04612.03b2a...@pb1.pair.com...

On 5/20/2013 9:17 AM, iccsi wrote:

I would like to know how can I pass a parameter via URL using control
value on the form.
something like myPage.php?MyID=txtMyID.value
I can use myPage.php?MyID=1, but cannot use myPage.php?MyID=txtMyID.value.

Your help and information is great appreciated,

Regards,

Iccsi

Yes - this is a JS question.  But - the answer is:

var url="myPage.php?MyID="+txtMyId.value;

Now the variable 'url' contains your url 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] pass parameter via URL

[iccsi]

Thanks for the message and helping,
Your js looks like to parse URL.
Please let me know if I am wrong,
Do you have any code to generate the URL parameter using control value?

Thanks again for helping,

Iccsi,


"shiplu"  wrote in message 
news:cado5mdcvbrquxcviuay9fvajjb+6ba872lbhrrhtdd8bjoa...@mail.gmail.com...


On Mon, May 20, 2013 at 7:17 PM, iccsi  wrote:


I would like to know how can I pass a parameter via URL using control
value on the form.
something like myPage.php?MyID=txtMyID.value
I can use myPage.php?MyID=1, but cannot use myPage.php?MyID=txtMyID.value.

Your help and information is great appreciated,



This is more a js question. Because form.controlname.value is only
available in javascript. A similar question I answered long ago on
Stackoverflow is
http://stackoverflow.com/questions/9009311/get-change-remove-url-parameters-with-jquery/9009558#9009558

And here is function I wrote that does it using pure javascript.
http://shiplu.mokadd.im/61/parse-query-string-by-pure-javascrirpt/



--
Shiplu.Mokadd.im
ImgSign.com | A dynamic signature machine
Innovation distinguishes between follower and leader 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] pass parameter via URL

[iccsi]

I would like to know how can I pass a parameter via URL using control value 
on the form.

something like myPage.php?MyID=txtMyID.value
I can use myPage.php?MyID=1, but cannot use myPage.php?MyID=txtMyID.value.

Your help and information is great appreciated,

Regards,

Iccsi 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php