php-general Digest 29 Sep 2013 02:33:32 -0000 Issue 8381
Topics (messages 322201 through 322206):
create a local temp table in local machine
322201 by: iccsi
322202 by: Bastien
322203 by: iccsi
322204 by: Bastien
322205 by: iccsi
Switch Statement
322206 by: Ethan Rosenberg
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
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,
--- End Message ---
--- Begin Message ---
Thanks,
Bastien
> On Sep 28, 2013, at 3:24 PM, "iccsi" <inu...@gmail.com> 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
--- End Message ---
--- Begin Message ---
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" <inu...@gmail.com> 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
--- End Message ---
--- Begin Message ---
> On Sep 28, 2013, at 6:00 PM, "iccsi" <inu...@gmail.com> 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" <inu...@gmail.com> 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
--- End Message ---
--- Begin Message ---
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" <inu...@gmail.com> 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" <inu...@gmail.com> 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=
--- End Message ---
--- Begin Message ---
Dear List -
I have a working program. I made one change in a switch statement, and
it does not work. I'm probably missing something fundamental.
Here are some code SNIPPETS... [please note that all my debug
statements are at the left margin]
Setup...
<?php
session_start();
session_name("STORE");
set_time_limit(2400);
ini_set('display_errors', 'on');
ini_set('display_startup_errors', 'on');
error_reporting(-2);
ini_set('error_reporting', 'E_ALL | E_STRICT');
ini_set('html_errors', 'On');
ini_set('log_errors', 'On');
require '/home/ethan/P/wk.inc'; //password file
$db = "Store";
$cxn =mysqli_connect($host,$user,$password,$db);
if (!$cxn)
{
die('Connect Error (' . mysqli_connect_errno() . ') '
. mysqli_connect_error());
}// no error
if($_REQUEST['welcome_already_seen']!= "already_seen")
show_welcome();
//end setup
function show_welcome() //this is the input screen
{
<snip>
echo " <input type='hidden' name='welcome_already_seen'
value='already_seen'>";
echo " <input type='hidden' name='next_step' value='step20' />";
<snip>
}
//end input screen
//Switch statement
echo 'before';
print_r($_POST); //post#1
switch ( $_POST['next_step'] )
{
case 'step20':
{
pint_r($_POST); //post#2
echo 'step20';
if(!empty($_POST['Cust_Num']))
good();
if(empty($_POST['Cust_Num']))
bad();
break;
} //end step20
<snip>
} //end switch
post#1
beforeArray
(
[Cust_Num] => 123
[Fname] =>
[Lname] =>
[Street] =>
[City] =>
[state] => NY
[Zip] => 10952
[PH1] =>
[PH2] =>
[PH3] =>
[Date] =>
[welcome_already_seen] => already_seen
[next_step] => step20
)
Cust_Num state and Zip are as entered.
The switch statement is never entered, since post#2 is never displayed,
and neither good() or bad() functions are entered.
TIA
Ethan
--- End Message ---