我使用PHP
的urlencode
和INSERTED
到使用PDO
的bindParamiter
的database
。。。。
我知道我不应该关心
urlencoding
数据,我应该让PHP-PDO
消毒
但是,有些我想先urlencode
在databas
之前。
类似于:
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
会转义字符串中的填充。