Passing PHP Javascript PHP Parameters

Question

Passing PHP Javascript PHP Parameters

Asked 7 years ago

Viewed 246 times

-3

I need to pass a parameters via JSON of a PHP page Javascript PHP, I’m using the Ajax method of Jquery but I’m not getting, follow code snippet.

✓ Index.php

<html>
    <head></head>
    <body>
        <input id="dateS" name="dateS"  type="text" class="form-control" maxlength="10" placeholder="mm/dd/yyyy"></div>
        <label class="col-form-label">entre</label>
        <div class="col-3">
            <input id="dateE" name="dateE"  type="text" class="form-control" maxlength="10" placeholder="mm/dd/yyyy"></div>
            <input id="pesquisa" type="submit" class="btn btn-primary" value="Pesquisar"/>
   </body>
</html>

Ajax

function mostrarValor() {
    alert(document.getElementById("data1").value);
}
var datainicio = document.getElementById('data1');
var datafim = document.getElementById('data2');

document.getElementById("pesquisa").onclick = function(e) {
    mostrarValor();
    e.preventDefault();
}

$.ajax({
  method: 'post',
  url: '/dash/charts/data_acesso.php',
  data: { 'DataInicio': datainicio, 'DataFim': datafim, }
});

$.post('/dash/charts/data_acesso.php', data, function(data) {
    console.log(data);
});

File that receives Json for another generation

<?php
//Setting Json
header('content-type: application/json');
$datainicio = $_POST['datainicio'];
$datafim = $_POST['datafim'];

//Query por superintendência
$sql = "SELECT SUBSTRING(u.department FROM 1 FOR 12) AS 'department' , COUNT(l.action) AS 'qtdacesso'
FROM mdl_user u
INNER jOIN mdl_logstore_standard_log l ON u.id = l.userid
WHERE action LIKE 'loggedin' AND u.department NOT LIKE '' 
GROUP BY l.action,u.department";

//Execute 
$result=$DB->get_records_sql($sql); 

//Array
$dados = array();
    foreach($result as $row){
        $dados[] = $row;
    }

print json_encode($dados,  JSON_PRETTY_PRINT);
?>

2 answers

Browser other questions tagged php jquery json getjson

You are not signed in. Login or sign up in order to post.

by Dobrychtop • **835** points · Answer 1 · 2017-11-16T12:49:22+00:00

var datainicio = document.getElementById('data1');
var datafim = document.getElementById('data2');

In this code snippet, you are taking the element by the ID, but in your HTML the field Ids are different, and as you are using jQuery, to take the value of a field can be used the method. val() http://api.jquery.com/val/ which is much easier

Stay like this

var dateS = $('#dateS').val();

The passing of the parameters is correct, but you did not get them correctly. I hope I’ve helped

by Guilherme Santos • 1 point · Answer 2 · 2017-11-16T11:56:38+00:00

Hello ,

Index.HTML

<html>
<head></head>
<body>
<input id="dateS" name="dateS"  type="text" class="form-control" maxlength="10" placeholder="mm/dd/yyyy"></div>
<label class="col-form-label">entre</label>
<div class="col-3">
<input id="dateE" name="dateE"  type="text" class="form-control" maxlength="10" placeholder="mm/dd/yyyy"></div>
<input id="pesquisa" type="submit" class="btn btn-primary" value="Pesquisar"/>
</body>
</html>

AJAX

$("#pesquisa").click(function(){

           var datainicio = $("#dateS").val();
		   var datafim =  $("#dateE").val();

            jQuery.ajax({
				type:'POST',
				url:'/dash/charts/data_acesso.php',
				data: {'DataInicio' : datainicio ,'DataFim' : datafim ,},
				success: function(data)
				{
				     console.log(data);
				}
			});




}

PHP file that receives Json

<?php
//Setting Json
header("Content-Type: text/plain");
$datainicio = $_POST['DataInicio'];
$datafim = $_POST['DataFim'];

//Query por superintendência
$sql = "SELECT SUBSTRING(u.department FROM 1 FOR 12) AS 'department' , COUNT(l.action) AS 'qtdacesso'
FROM mdl_user u
INNER jOIN mdl_logstore_standard_log l ON u.id = l.userid
WHERE action LIKE 'loggedin' AND u.department NOT LIKE '' 
GROUP BY l.action,u.department";

//Execute 
$result=$DB->get_records_sql($sql); 

//Array
$dados = array();
    foreach($result as $row){
        $dados[] = $row;
    }

print_r(json_encode($dados));
?>

I hope I’ve helped :)