store the mysql records to javascript array variable
Moderator: General Moderators
store the mysql records to javascript array variable
i want to store the records from mysql in the javascript. is it possible?
- harrisonad
- Forum Contributor
- Posts: 288
- Joined: Fri Oct 15, 2004 4:58 am
- Location: Philippines
- Contact:
yes it is possible but not recommended for large number of records because of slow performance on page.
FYI: I already tried that. look at my post at viewtopic.php?t=34928
try AJAX
FYI: I already tried that. look at my post at viewtopic.php?t=34928
try AJAX
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Code: Select all
//RECIEVE A PHP ARRAY RETURN THE STRING THAT CAN
//BE PUT INTO AJAVASCRIPT ARRAY
//RETURN FALSE IF ARRAY HAS NO VALUES
//IF $RETURN_ARRAY_KEY IS TRUE RETURN THE ARRAY KEY
function phpArrayToJavaScriptArray($a_,$return_array_key){
$r='';
$cntr=0;
if(is_array($a_)){
if($return_array_key)
$a_ = array_flip($a_);
if(count($a_)==0)
return FALSE;
foreach ($a_ as $v) {
$cntr++;
$r .= '"'.$v.'"';
if($cntr < count($a_))//last number no ,
$r.=', ';
}
}
return $r;
}to expand on that:
Code: Select all
<?php
function phpArrayToJavaScriptArray($a_,$return_array_key){
$r='';
$cntr=0;
if(is_array($a_)){
if($return_array_key)
$a_ = array_flip($a_);
if(count($a_)==0)
return FALSE;
foreach ($a_ as $v) {
$cntr++;
$r .= '"'.$v.'"';
if($cntr < count($a_))//last number no ,
$r.=', ';
}
}
return $r;
}
$jsarray = phpArrayToJavaScriptArray(array("hi","bye"),false);
?>
<script>
var someArr = new Array(<?=$jsarray;?>);
for(var i=0;i<someArr.length; i++)
alert(someArr[i]);
</script>Woot Woot Thanks Burrito...
Burrito wrote:to expand on that:
Code: Select all
<?php function phpArrayToJavaScriptArray($a_,$return_array_key){ $r=''; $cntr=0; if(is_array($a_)){ if($return_array_key) $a_ = array_flip($a_); if(count($a_)==0) return FALSE; foreach ($a_ as $v) { $cntr++; $r .= '"'.$v.'"'; if($cntr < count($a_))//last number no , $r.=', '; } } return $r; } $jsarray = phpArrayToJavaScriptArray(array("hi","bye"),false); ?> <script> var someArr = new Array(<?=$jsarray;?>); for(var i=0;i<someArr.length; i++) alert(someArr[i]); </script>