PHP leer2.php
include("conex.php");
$ssql = "SELECT * FROM proves WHERE nom LIKE 'david'";
$p=mysqli_query($mysqli, $ssql);
while($row = mysqli_fetch_assoc($p)) {
$nom = $row['nom'];
$descrip = $row['descrip'];
$numero = $row['cant'];
$return_arr = array("nom" => $nom,
"descrip" => $descrip,
"numero" => $numero);
}
//$directors = array( "Alfred Hitchcock", "Stanley Kubrick", "Martin Scorsese", "Fritz Lang" );
header('Content-type: application/json; charset=utf-8');
echo json_encode($return_arr);
-----------------------------------------
SCRIPT DE ANIMATE
var root = this;
function ono(){
var ev = "david";
$.ajax({
url:'leer2.php',
dataType:'json',
type:'post',
data:{ev:ev},
success: function(resp){
var nom = resp.nom;
var descrip = resp.descrip;
var numero = parseInt(resp.numero);
root.textos.dave_te.text = nom + descrip + numero;
console.log(resp);
}
});
}
ono();