store the mysql records to javascript array variable
Posted: Wed Nov 30, 2005 11:20 pm
i want to store the records from mysql in the javascript. is it possible?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
He probably wants people to haxxor his database.wtf wrote:What are you trying to accomplish by storing records in js?
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;
}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>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>