对ajax响应的echo查询(echo query on ajax response)

编程入门 行业动态 更新时间:2024-10-26 03:28:20
对ajax响应的echo查询(echo query on ajax response)

我正在尝试通过AJAX发送php表单数据(没有刷新)并以新的形式显示数据。 我回应查询,但它没有工作。 在AJAX响应中它显示我在调用getReportAj表单。代码如下:

使用Javascript

function getReport() { var dataString = "grNo=" +$(".grNo").val(); $.ajax({ type: "GET", url: "getReportAj.php", data: dataString, success:function(data) { $('#result').html(data); } }); }

getReportAj.php

<?php include "include/config.inc.php"; if(!isset($_SESSION['s_activName']) && !isset($_SESSION['s_userType']) || isset($_SESSION['s_userType']) && $_SESSION['s_userType'] == 'Student') { $_SESSION['s_urlRedirectDir'] = $_SERVER['REQUEST_URI']; header("Location:checkLogin.php"); } else { if(isset($_REQUEST['submit'])) { $selectReport = "SELECT * from gradeterm1 WHERE studentId = ".$_POST['studentId']." AND termValue = 1 LEFT JOIN studentmaster ON studentmaster.studentId = gradeterm1.studentId"; $selectReportRes = mysql_query($selectReport); if($reportRow = mysql_fetch_array($selectReportRes)); { $eReadingPro = $reportRow['eReadingPro']; $eReadingFlu = $reportRow['eReadingFlu']; $eReadingCom = $reportRow['eReadingCom']; $eWritingCre = $reportRow['eWritingCre']; $eWritingHan = $reportRow['eWritingHan']; $eWritingGra = $reportRow['eWritingGra']; $eWritingSpe = $reportRow['eWritingSpe']; $eWritingVoc = $reportRow['eWritingVoc']; $ewSpeakinCon = $reportRow['ewSpeakinCon']; $ewSpeakinRec = $reportRow['ewSpeakinRec']; $ewSpeakinCla = $reportRow['ewSpeakinCla']; $eListingComp = $reportRow['eListingComp']; $eListingCon = $reportRow['eListingCon']; $extraReading = $reportRow['extraReading']; $activityPro = $reportRow['activityPro']; $hiReadingPro = $reportRow['hiReadingPro']; $hiReadingFlu = $reportRow['hiReadingFlu']; $hiReadingCom = $reportRow['hiReadingCom']; $hiWritingCre = $reportRow['hiWritingCre']; $hiWritingHan = $reportRow['hiWritingHan']; $hiWritingGra = $reportRow['hiWritingGra']; $hiWritingSpe = $reportRow['hiWritingSpe']; $hiWritingVoc = $reportRow['hiWritingVoc']; $hiwSpeakinCon = $reportRow['hiwSpeakinCon']; } } } include("./bottom.php"); $smarty->display('getReportAj.tpl'); ?>

I'm trying to send a php form data via AJAX (without the refresh) and display data in new form. I echo query but it didnt work. On AJAX response it shows me getReportAj form on call.The code goes like this:

Javascript

function getReport() { var dataString = "grNo=" +$(".grNo").val(); $.ajax({ type: "GET", url: "getReportAj.php", data: dataString, success:function(data) { $('#result').html(data); } }); }

getReportAj.php

<?php include "include/config.inc.php"; if(!isset($_SESSION['s_activName']) && !isset($_SESSION['s_userType']) || isset($_SESSION['s_userType']) && $_SESSION['s_userType'] == 'Student') { $_SESSION['s_urlRedirectDir'] = $_SERVER['REQUEST_URI']; header("Location:checkLogin.php"); } else { if(isset($_REQUEST['submit'])) { $selectReport = "SELECT * from gradeterm1 WHERE studentId = ".$_POST['studentId']." AND termValue = 1 LEFT JOIN studentmaster ON studentmaster.studentId = gradeterm1.studentId"; $selectReportRes = mysql_query($selectReport); if($reportRow = mysql_fetch_array($selectReportRes)); { $eReadingPro = $reportRow['eReadingPro']; $eReadingFlu = $reportRow['eReadingFlu']; $eReadingCom = $reportRow['eReadingCom']; $eWritingCre = $reportRow['eWritingCre']; $eWritingHan = $reportRow['eWritingHan']; $eWritingGra = $reportRow['eWritingGra']; $eWritingSpe = $reportRow['eWritingSpe']; $eWritingVoc = $reportRow['eWritingVoc']; $ewSpeakinCon = $reportRow['ewSpeakinCon']; $ewSpeakinRec = $reportRow['ewSpeakinRec']; $ewSpeakinCla = $reportRow['ewSpeakinCla']; $eListingComp = $reportRow['eListingComp']; $eListingCon = $reportRow['eListingCon']; $extraReading = $reportRow['extraReading']; $activityPro = $reportRow['activityPro']; $hiReadingPro = $reportRow['hiReadingPro']; $hiReadingFlu = $reportRow['hiReadingFlu']; $hiReadingCom = $reportRow['hiReadingCom']; $hiWritingCre = $reportRow['hiWritingCre']; $hiWritingHan = $reportRow['hiWritingHan']; $hiWritingGra = $reportRow['hiWritingGra']; $hiWritingSpe = $reportRow['hiWritingSpe']; $hiWritingVoc = $reportRow['hiWritingVoc']; $hiwSpeakinCon = $reportRow['hiwSpeakinCon']; } } } include("./bottom.php"); $smarty->display('getReportAj.tpl'); ?>

最满意答案

<script> function getReport() { var dataString = "grNo=" +$(".grNo").val(); $.ajax({ type: "GET", url: "getReportAj.php", data: dataString, success:function(data) { $('#result').html(data); console.log(data); } }); } </script>

在成功事件中..放入console.log(数据)然后运行脚本并检入控制台。

<script> function getReport() { var dataString = "grNo=" +$(".grNo").val(); $.ajax({ type: "GET", url: "getReportAj.php", data: dataString, success:function(data) { $('#result').html(data); console.log(data); } }); } </script>

in success event.. put the console.log(data) then run the script and check in console.

更多推荐

本文发布于:2023-08-01 19:45:00,感谢您对本站的认可!
本文链接:https://www.elefans.com/category/jswz/34/1363788.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
本文标签:echo   ajax   response   query

发布评论

评论列表 (有 0 条评论)
草根站长

>www.elefans.com

编程频道|电子爱好者 - 技术资讯及电子产品介绍!