StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO2d array falls apart in ajax call
text
Body
copied!<p>I have a 2D array in JS.</p> <p>I alert the array before I ajax it and the array is intact and all good.</p> <p>When I ajax it, I get an error, so I have now ajax'd the array to a page that just runs a var dump and the array tails off half way through and loses structure and data</p> <p>heres the js</p> <pre><code> $.ajax({ type: "POST", url: "ajax/updateElements.php", data: {outerarray:outerarray}, success: function(data){ alert("data="+data); }, error: function(data){ alert("error"); } }); </code></pre> <p>the php</p> <pre><code> <?php var_dump($_POST['outerarray']); ?> </code></pre> <p>and the returned data</p> <pre><code> data=array(40) { [0]=> array(20) { [0]=> string(2) "47" [1]=> string(2) "46" [2]=> string(2) "-1" [3]=> string(3) "100" [4]=> string(2) "35" [5]=> string(5) "shape" [6]=> string(190) "shape" [7]=> string(1) "0" [8]=> string(1) "0" [9]=> string(5) "solid" [10]=> string(3) "000" [11]=> string(1) "0" [12]=> string(0) "" [13]=> string(1) "1" [14]=> string(2) "st" [15]=> string(3) "206" [16]=> string(2) "54" [17]=> string(1) "0" [18]=> string(1) "1" [19]=> string(1) "F" }...until [12]=> array(20) { [0]=> string(2) "33" [1]=> string(3) "179" [2]=> string(3) "376" [3]=> string(3) "578" [4]=> string(3) "203" [5]=> string(4) "text" [6]=> string(933) "text" [7]=> string(2) "11" [8]=> string(1) "1" [9]=> string(5) "solid" [10]=> string(3) "000" [11]=> string(1) "0" [12]=> string(0) "" [13]=> string(1) "1" [14]=> string(0) "" [15]=> string(3) "206" [16]=> stri </code></pre> <p>and thats where it tails off</p> <p>any clues? I have been banging my head against a wall for a week over this</p> <p>heres the PDO code</p> <pre><code> $arraycount=count($_POST['outerarray']); for($m=0; $m<$arraycount; $m++){ $box_id = $_POST['outerarray'][$m][0]; $top= $_POST['outerarray'][$m][1]; $left = $_POST['outerarray'][$m][2]; $width = $_POST['outerarray'][$m][3]; $height = $_POST['outerarray'][$m][4]; $type = $_POST['outerarray'][$m][5]; $content = str_replace("\n", "<br>",$_POST['outerarray'][$m][6]); $zindex = $_POST['outerarray'][$m][7]; $borderwidth = $_POST['outerarray'][$m][8]; $borderstyle = $_POST['outerarray'][$m][9]; $bordercolor = $_POST['outerarray'][$m][10]; $padding = $_POST['outerarray'][$m][11]; $weblink = $_POST['outerarray'][$m][12]; $opacity = $_POST['outerarray'][$m][13]; $shapetype = $_POST['outerarray'][$m][14]; $page_ref = $_POST['outerarray'][$m][15]; $site_ref = $_POST['outerarray'][$m][16]; $deletedelement = $_POST['outerarray'][$m][17]; $allpages = $_POST['outerarray'][$m][18]; $pageSection = $_POST['outerarray'][$m][19]; $stmt = $db->prepare("SELECT * FROM site_content WHERE site_ref=:site_ref AND page_ref=:page_ref AND box_id=:box_id"); $stmt->execute(array(':site_ref' => $site_ref, ':page_ref' => $page_ref, ':box_id' => $box_id)); $row_count = $stmt->rowCount(); if($row_count==0){ $stmt = $db->prepare("INSERT INTO site_content(page_ref, site_ref, box_type, box_id, box_top, box_left, box_width, box_height, content, weblink , zindex, border_width, border_colour, border_style, padding, image_opacity, shapetype, allPages, pageSection) VALUES(:field1,:field2,:field3,:field4,:field5,:field6,:field7,:field8,:field9,:field10,:field11,:field12,:field13,:field14,:field15,:field16,:field17,:field18,:field19)"); $stmt->execute(array(':field1' => $page_ref, ':field2' => $site_ref, ':field3' => $type, ':field4' => $box_id, ':field5' => $top, ':field6' => $left, ':field7' => $width, ':field8' => $height, ':field9' => $content, ':field10' => $weblink, ':field11' => $zindex, ':field12' => $borderwidth, ':field13' => $bordercolor, ':field14' => $borderstyle, ':field15' => $padding, ':field16' => $opacity, ':field17' => $shapetype, ':field18' => $allpages, ':field19' => $pageSection)); $affected_rows = $stmt->rowCount(); if($affected_rows !=0){ echo "<br>content added succesfully"; }else{ echo "<br>no content added"; } }else{ if($deletedelement=="1"){ $stmt = $db->prepare("DELETE FROM site_content WHERE site_ref=:site_ref AND page_ref=:page_ref AND box_id=:box_id"); $stmt->execute(array(':site_ref' => $site_ref, ':page_ref' => $page_ref, ':box_id' => $box_id)); $stmt->execute(); $affected_rows = $stmt->rowCount(); if($affected_rows !=0){ echo "<br>content deleted succesfully"; }else{ echo "<br>no content deleted"; } }else{ if($pageSection==''){ $pageSection="C";} $stmt = $db->prepare("UPDATE site_content SET box_type=:box_type, box_top=:box_top, box_left=:box_left, box_height=:box_height, box_width=:box_width, content=:content, weblink=:weblink, zindex=:zindex, image_opacity=:image_opacity, border_width=:border_width, border_colour=:border_colour, border_style=:border_style, padding=:padding, shapetype=:shapetype, allPages=:allPages, pageSection=:pageSection WHERE site_ref=:site_ref AND page_ref=:page_ref AND box_id=:box_id"); $stmt->execute(array(':box_type' => $type, ':box_top' => $top, ':box_left' => $left, ':box_height' => $height, ':box_width' => $width, ':content' => $content, ':weblink' => $weblink, ':zindex' => $zindex, 'image_opacity' => $opacity, ':border_width' => $borderwidth, ':border_colour' => $bordercolor, 'border_style' => $borderstyle, 'padding' => $padding, 'shapetype' => $shapetype, 'allPages' => $allpages, 'pageSection' =>$pageSection, ':site_ref' => $site_ref, ':page_ref' => $page_ref, ':box_id' => $box_id)); $affected_rows = $stmt->rowCount(); if($affected_rows !=0){ echo "<br>content updated succesfully"; }else{ echo "<br>no content updated"; } } } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload