fix arabic cross_site_rss with ajaxcrud_PHP_编程开发_程序员俱乐部

1. change the mysql table / fields to utf8_general_ci and add a line on preheader.php
mysql_query("SET NAMES utf8");
apply utf-8 for all relative php/js files.


2. add tinyMCE in php page.

	<script language="javascript" type="text/javascript" src="tiny_mce/tiny_mce.js"></script>
	<link rel="stylesheet" href="tiny_mce/themes/advanced/skins/default/ui.css">

	<script xmlns="http://www.w3.org/1999/xhtml" language="javascript" type="text/javascript">
        tinyMCE.init({
			mode : "textareas",
			theme : "advanced",
			gecko_spellcheck : true,
			remove_linebreaks : true,
			width : "640",
			plugins : "table,advimage,advlink,emotions,iespell,insertdatetime,preview,searchreplace,xhtmlxtras,media,directionality",
			theme_advanced_buttons1 : "justifyleft,ltr,|,justifyright,rtl,|,justifycenter",
			theme_advanced_buttons2 : "bold,italic,underline,strikethrough,|,fontsizeselect,forecolor,backcolor,|,sub,sup",
			theme_advanced_buttons3 : "cut,copy,paste,pastetext,pasteword,removeformat,|,bullist,numlist,|,outdent,indent,|,undo,redo,|,preview",
			theme_advanced_disable : "charmap",
			theme_advanced_toolbar_location : "top",
			theme_advanced_toolbar_align : "left",
			theme_advanced_path_location : "bottom"
			});
	</script>

3. remember to trigger the save function before submit on page ajaxCRUD.class.php function insertHeader and function makeAjaxEditor
tinyMCE.triggerSave();

4. decode the fields on function doAction

                        foreach($submitted_array as $field){
                            $submitted_values[] = urldecode($field);
                        }

5. encodeURIComponent on function makeAjaxEditor

        $return_html .= "<span class=\"editable hand_cursor\" id=\"" . $prefield ."_show\" onClick=\"
			document.getElementById('" . $prefield . "_edit').style.display = '';
			document.getElementById('" . $prefield . "_show').style.display = 'none';
			document.getElementById('" . $input_name . "').focus();
            \">" . $field_text . "</span>
        <span id=\"" . $prefield ."_edit\" style=\"display: none;\">
            <form style=\"display: inline;\" name=\"form_" . $prefield . "\" id=\"form_" . $prefield . "\" onsubmit=\"
				tinyMCE.triggerSave();
				document.getElementById('" . $prefield . "_edit').style.display='none';
				document.getElementById('" . $prefield . "_save').style.display='';
                var req = '" . $this->ajax_file . "?ajaxAction=update&id=" . $unique_id . "&field=" . $field_name . "&table=" . $this->db_table . "&pk=" . $this->db_table_pk . "&val=' + encodeURIComponent(document.getElementById('" . $input_name . "').value);
				sndUpdateReq(req);
				return false;
			\">";

6. on file javascript_functions.js
change the charset
http_request.overrideMimeType('text/plain;charset=utf-8');

replace escape to encodeURIComponent for function getFormValues

			str += fobj.elements[i].name + "=" + encodeURIComponent(fobj.elements[i].value) + "&";

				var chkValue = encodeURIComponent(fobj.elements[i].value);

7. add <![CDATA[]]> to rss files - announcement_.php

	echo "		<title><![CDATA[" . $row['announcement_title'] . "]]></title>";
	echo "		<description><![CDATA[" . $row['announcement_description'] . "]]></description>";

8. summary
use javascript function encodeURIComponent but escape to encode value
use php function urldecode to decode value

// raw value
// <p>????? (???????</p>
$str = urldecode('%3Cp%3E%D8%B4%D8%B9%D8%A8%D9%8A%D8%A9%20(%D8%A8%D8%A7%D9%84%D8%B5%D9%8A%D9%86%D9%8A%3C%2Fp%3E');
echo $str;