PHP Array to JS dont work

Question

I'm pretty lost, all I want to do is spend a array to my javascript code. I've seen a lot of examples, but none ends me working. I need some help. I'm pretty stuck.

functions.js

function cargaTemperatura(idsem){
    $.ajax({
        type: "POST",
        url: "load_temp.php",
        data: { idsem :  idsem },
        dataType: "json",
        success: function(data){
            alert(JSON.parse(data));
        },error: function(data){
            alert('error');
        }
    });
};

load_temp.php

<?php
include_once 'Includes/db.php';
$select = "SELECT * FROM CalTmp WHERE idsem='".$_POST['id_sem']."'";
$result = mysqli_query($link, $select) or die($select);
$array = mysqli_fetch_all($result,MYSQLI_ASSOC);
debug_to_console($result->num_rows);
debug_to_console($_POST['id_sem']);
echo json_encode($array);

Warning: Your code is wide open to SQL Injection attacks. — David
– David, Commented Aug 14, 2016 at 20:30

KmasterYC · Accepted Answer · 2016-08-14 20:23:24Z

1

My suggestion:
- Step 1: In load_temp.php. Hardcode idsem value. Check on browser. Make sure there has a json string
- Step 2: Add this line

header("Content-type: application/json");

after

<?php

answered Aug 14, 2016 at 20:23

KmasterYC

2,35413 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jtg · Accepted Answer · 2016-08-15 20:18:09Z

Solved!!

I've resolved through library MooTools. My final code is:

Functions.js

function cargaTemperatura(idsem){
    var idsemJSON = JSON.encode(idsem);
    alert(idsemJSON);
    var miAjax = new Request({
        url: "carga_temp.php",
        data: "idsem=" + idsemJSON,
        onSuccess: function(data){
            alert(data);
        },
        onFailure: function(){
            $('resultado').set("html", "fallo en la conexion Ajax");
        }
    });
    miAjax.send();
};

load_temp.php

<?php
$misDatosJSON = json_decode($_POST["idsem"]);

include_once 'Includes/db.php';
$select = "SELECT * FROM CalTmp WHERE idsem='".$misDatosJSON."'";
$result = mysqli_query($link, $select) or die($select);
$array = mysqli_fetch_all($result);
debug_to_console($result->num_rows);
debug_to_console($_POST['id_sem']);
echo json_encode($array);

I hope someone will serve useful. Certainly the mistake was in sending the variable that was not in JSON format.

Thanks,

Collectives™ on Stack Overflow

PHP Array to JS dont work

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related