PHP(PDO)url编码如何在javascript中解码?decodeURI?或解码URI组件


PHP (PDO) urlencoded how to decode in javascript? decodeURI? or decodeURIcomponent?

我使用PHPurlencodeINSERTED到使用PDObindParamiterdatabase。。。。

我知道我不应该关心urlencoding数据,我应该让PHP-PDO消毒

但是,有些我想先urlencodedatabas之前。

类似于:

if(isset($_POST['url']))  {
$_POST['url'] = urlencode($_POST['url']);
//INSERT QUERY:
"INSERT INTO table_name (url_1) VALUES (:url_1)"

PDO绑定:

 /*** bind the paramaters ***/
        $stmt->bindParam(':url_1', $_POST['url'])
}

要检索数据,请执行以下操作:PHP

    if(isset($_GET['url_string'])){
    //RUN Select Query using PDO Mysql
    $getURL = "SELECT url_1 FROM table_name"
    //The $getURL variable will contain an associative array like: 
   // array [0]['url_1'] ///This will be the valued inserted previously.
    ///Then json_encode()
    $sendOut = json_encode(array('url_DATA' => $getURL))
    echo $sendOut;
    }

问题:

我使用jQuery的$.getJSON函数从数据库中获取数据。

类似于:

$.getJSON('ulr.func.php',{url_string:""},function(myOutPut){

    // Then I decode the URL retrieved from the DATABASE here.
      decodeURIComponent(myOutPut.url_DATA)

decodeURIComponent尖叫:

URI错误:格式错误的URI序列

})

在Firebug控制台的响应下,我看到了完美的期望输出,比如:

[{"unit_id":"46","unit_name":"21A","unit_pic_url":"*uProf/46/pcs/pdsp/p500/c2f971b1e92b2dce68489198cf0a300a_158_15875.jpg*uProf-46/pdsp/p500/b5c4045574cb0f927fb096b6369f4ba5_78_72234.jpg*uPro/46/pcs/pdsp/p00/6fb26702857b0f464c43a9c13a1f7b1_333_228657.jpg*uProv/46/pcs/ssp/p00/69c18d8cbf8e940b23f9be8138d0e7f_303_2 11896.jpg*uProf/46/pcs/pdsp/p500/9e74b1d7d037cd9de95c0b78522e04a2_321_79258.jpg","unit_default_pic":"uProf/46/pcs/pdsp/p500/c2f971b1e92b2dce68489198cf0a300a_158_15875.jpg","unit_building":"21","unit_building_name":"ELIZABETH+PLACE","unit _location":"4","location_name":"Salcedo+Village","city":"2","city _name":ovements":"家具齐全","unit_view":"ELIZABETH+PLACE","unit_condition":"维护良好","unit_status":"Vacant+","unit_availability":"Anytime","unit_parkings":"1","unit_price":"75000.00","unit _amenities":"Swimming+pool%2Gym+and+Function+Room","unit_remarks":"2+Bedroom+For+Rent+%40+ELIZABETH+PLACE%0D%0描述%3A+FULLY+FUNISHED+%0D%0要价%3A+P75%2C000+包含+协会+会费+%0D%0A楼层+面积%3A109+sqm%0D%0楼层+楼层%3A+较高楼层%0D%0联系人+人员%3A+女士+Angel+Velo%0D%0ACel+号码+3A+09175790257%2F+009989748767%0D%0电话+号码%3A+894-4745%2F+9794842","unit_map":"%3 iframe+width%3D%222425%22+height%3D%22350%22+frameborder%3D%220%22+滚动%3D%22no%22+marginheight%3D+220%22+marginwidth%3D%220%22+src%3D%22Hps%3A%2F%2F%2Fmaps.google.com.ph%2Fmaps%3F%3Dq%26amp%3Bsource%3Ds_q%26amp%3Bhl%3Den%26amp%3地理代码%3D%26amp%3%3Bq%3Elisabeth%2Bplace%2Bmakati%2Salcedo%2Bvillag%26amp%3Baq%3D%26amp%3Bsll%3D14.546956%2C121.05351%26amp%3 sspn%3D0.007685%2C0.013078%26amp%3Bie%3DUTF8%26amp%3Bhq%3Elizabeth%2Place%2Bmakati%2Salcedo%2Bvillag%26amp%3Bhnear%3D%26amp%3球%3D14.561158%2C121.022669%26amp%3Spn%3D0.030738%2C0052314%26amp%3%3Bit%3Dm%26amp%3Bz%3D14%26amp%3Biwoc%3DA%26amp%3%n酸%3D8098826603847629943%26amp%3Output%3Embedd%22%3E%3C%2Ffarame%3E%3Br+%2F%3E%3小型%3E%3Ca+href%3D%22https%3A%2F%2Fmaps.google.com.ph%2Fmaps%3F%3Dq%26amp%3Source%3Embedd%26amp%3Bhl%3Den%26amp%3地理代码%3D%26amp%3Bq%3Elisabeth%2Bplace%2Bmakati%2Salcedo%2Bvillag%26amp%3%3Baq%3D%26amp%3Bsll%3D14.546956%2C121.05351%26amp%3%3Sspn%3D0.007685%2C0.013078%26amp%3Bie%3DUTF8%26amp%3%3Bhq%3Elizabeth%2Place%2Bmacati%2Salcendo%2Bvilrag%26amp%3%n spn%3D0.030738%2C0052314%26amp%3Bt%3Dm%26amp%3%3Bz%3D14%26amp%3Bifloc%3DA%26amp%3酸%3D8098826603847629943%22+样式%3D%22color%3A%223000FF%3文本对齐%3Left%22%3EView+较大+地图%3C%2Fa%3E%3C%2Fsmall%3E","unit_display_mode":"1","added_by":"Angel_Baldo_Velo","added_by_mail":"eirishanjelavelo@yahoo.com","added_date":"2013-12-0501:17:08","舞台":"2BR,109平方米,伊丽莎白广场,[1]停车场,空缺+,Makati"}]

编辑*复制并粘贴到此处:*http://meyerweb.com/eric/tools/dencoder/

不会产生错误,但CCD_ 12完全符合要求。

他们在做什么,以便他们的网站可以轻松解码编码数据?。。。任何建议都将不胜感激。

我认为您可以先尝试unescape字符串,然后再尝试decodeURI,因为PHP-PDO会转义字符串中的填充。