Databases
StackOverflow2013
Postsdbo
POreturn data set has / after every html character
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POreturn data set has / after every html character
    primarykey
    data
    text
    <p>I have got data from Ajax call. In server side I encode string to JSON and send data. But I get data as follows</p> <pre><code>" General abc\/def&lt;\/h3&gt; dsaa&lt;\/td&gt; 3&lt;\/table&gt;&lt;\/tbody&gt; dfsa&lt;\/td&gt; 3&lt;\/table&gt;&lt;\/tbody&gt; dsdsa&lt;\/td&gt; 2&lt;\/table&gt;&lt;\/tbody&gt;&lt;\/div&gt;" </code></pre> <p>Actually it is not supposed to show html charaters.</p> <p>I use Php and Jquery ajax. Where can I have done the mistake?</p> <p>Update code</p> <pre><code>function employee_deatils_search() { global $wpdb; $name=$_POST['user_name'];//retrive data from post array on form submitting //main streams for a given user will be printed such a way that subjects are gruped by main stream.The order of the main streams are arranged according //to the total of skill levels for each subject. $stream_groupby=$wpdb-&gt;get_results("SELECT tab_subject.mai_stream, SUM( tab_skilllist.skill_level ) AS total_skill FROM `tab_users` JOIN tab_skilllist ON tab_skilllist.user_id = tab_users.id JOIN tab_subject ON tab_subject.id = tab_skilllist.subject_id WHERE tab_users.first_name = '$name' and tab_users.employ = 1 GROUP BY tab_subject.mai_stream ORDER BY total_skill DESC"); //echo "&lt;div id='accordion'&gt;"; foreach($stream_groupby as $value_str){ //printing subject information, skill level and subject main stream. //user name and main stream will be passed as arguments. $employee_subjects=$wpdb-&gt;get_results("SELECT tab_subject.subject, tab_subject.mai_stream ,tab_skilllist.skill_level FROM `tab_users` JOIN tab_skilllist ON tab_skilllist.user_id = tab_users.id JOIN tab_subject ON tab_subject.id = tab_skilllist.subject_id WHERE tab_users.first_name = '$name' and tab_subject.mai_stream = '$value_str-&gt;mai_stream' ORDER BY tab_skilllist.skill_level desc"); //echo '&lt;br&gt;'; $jason = '&lt;h3 style="font-size:15px;"&gt;'; $jason .= $value_str-&gt;mai_stream; $jason .= '&lt;/h3&gt;'; $jason .= '&lt;div &gt;'; foreach($employee_subjects as $key=&gt; $value){ $jason .= '&lt;table&gt;&lt;tbody&gt;'; $jason .= '&lt;tr&gt;&lt;td style="width:90%;font-size:14px;"&gt;'.$value-&gt;subject.'&lt;/td&gt;'.'&lt;td style="font-size:14px;"&gt;'.$value-&gt;skill_level;'&lt;/td&gt;&lt;/tr&gt;'; $jason .= '&lt;/table&gt;&lt;/tbody&gt;'; // echo '&lt;/br&gt;';echo '&lt;/br&gt;'; } $jason .= '&lt;/div&gt;'; } // echo json_encode($jason) ; //echo '&lt;/div&gt;'; //wp_reset_query(); die(); } // end theme_custom_handler </code></pre> <p>Here is the javascript code</p> <pre><code>$("#sendemp").click(function(e) { e.preventDefault(); var submit_val = $("#searchbox").val(); //alert('submitval is ' + submit_val); $.ajax( { type : "POST", url : "./wp-admin/admin-ajax.php", data : { action : 'employee_deatils_search', user_name : submit_val }, success : function(data) { // alert('hhh'); $('#accordion32').html(data); $("tr:odd").css("background-color", "#F8F8F8"); // $( "#searchbox" ).autocomplete({ // source: data // }); } }); }); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USwordpressm
    1. USwordpressm
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COSince you haven't shown any of your code, how can we tell where you done the mistake?
      singulars
      1. POreturn data set has / after every html character
      1. USBarmar
    2. COShow us your server side code. What does the string look like that you encode?
      singulars
      1. POreturn data set has / after every html character
      1. USLowkase
    3. COThis is encoded to be used as a javascript literal. If used in that context it will right itself. ie `<script> var a = <?php echo $json; ?>;</script>`
      singulars
      1. POreturn data set has / after every html character
      1. USOrangepill
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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