shiza
Members-
Posts
15 -
Joined
-
Last visited
Never
Everything posted by shiza
-
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
Thnx... base64_encode() and base64_decode() do what i want.... Problem Sloved... Thanks every1 for replying and helping me out... -
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
If I use $final=mysql_real_escape_string($encrypted); mysql_query("INSERT INTO voter(encrypt) VALUES('$final')",$con); what can be the function to get $encrypted from $final???? $data=_____($final); -
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
$final=addslashes($encrypted); mysql_query("INSERT INTO voter(encrypt) VALUES('$final')",$con); Only var $final is stored in the DB.. after retrieving its value $data=stripslashes($final); But $data is not equal to $encrypted...How to get $encrypted's original value??? -
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
Thank You soo much...now it is inserted... But now it not remains the same value as it was.and i m unable to decrpyt it... Tell me any way to get this text again as it was before addslashes(); Because i have to do decrption now... -
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
The Value of $encrypted is: ?kpt%?pg? z?-?0#;f@$????Kv?8?!?>?3C????Qv????f)?,??????\?????^+7??i?P???Z?W??y.??r????$??y?x????&???a ?!?[c???iH5???K?A??u??L?gz?lY-??1E+??69???K!???UCQ? ?E?g???hp/>2y??)???D????y ??u 8??e?:Jf]?w?(????>???,?????#??d???-f? hSl?2B?ri=k???q???L?A$&2<??j ?4?fx??q6{{?Y?t.???????H???c&?]Z? ?`?$iH?\E??-*^??{???Z???3??~c????] w?Y&{?5?/?v?L????K H?@#?<????%f?_-??"?nP0IM??L?} N?g??2m2?2)?<?-U?Q|s??I+-1??^6? ?C?o?n?m?t"}u?z~??|-?R?q??U$|G?Ty|K?????? T?'?~M?x??????~L=??\nn?E zR?S?R?]}?/sG?WG?x??G?5T6?%??M??O??? ?????V? W?!??????2??E?? ???1??.? ? ????? ??s?5??_?I ^Gj???Z?pe???h?^+?Ö@-k?7??????1C?w?:???????d???s "??=?t?r????D??????5 ?C??|?? ?-????????r?{?ht@??????????i?qf;???^&???~}??@??h???\?h?&?????R? f{N????a>?I???????_?????db&|??U???'n??+????|??Ds??{???3????????:j?=/N&? 8??? ??????;7????g?:??+X?KN??k 7~?S??4Z???F??? ?o? =:~t%?2??R>??????A?n?si????k???N???.:l?GX????+o??KPbD<?vo? ?2?^?Q???ZH~?!????}H'???]??? b?]??? ?< R?K7??|?/zaug`w1??S?????(?d??9P6- 9?p????????u"?9V9?%s?7?W????Iv?,?>b?$?,?s???ue9??1?Z?p}?|?3?zZ?????%c?? ?!??W?f?K)=%;?k+R5Z???lZ.@{???A(?S? ????l??;???T??;`)???:H?H??0??1 &?y???G???gA??_???e<???;??W????z/%?`???6?????>?6?.??@G>?J??R<??i'??? ?q??i?,?41??K_?? #K">?4q^??n=`?!?i~{??u??[?%H?N lJ??da????n ?c ??y ?{|&?x?>???q%?>??T6Z?????DA????8ws???g7j?}A[????e??q7?'?p"??hph??h?O??_q???/%???8a?6A????????w??????2?O???Yg2U}?}???6rc??t???????*]?+?(V/b??C?: ????eq?x$????/w?l???@SHw?-u?3?G ?Ky?g?HWy?Y???h/?{we??5B?L?U?tyr?< ???J?>S?Y`j??????W8 ??#???`i)b?^~??T???Z?|??f?Y??^^?????%X;?c}???R????|j??7S??"?$C????kO];?&"\?K$$??*?2??>?n?V?$???/??]z????Q???u4?? ?}??_ ?H\f??P??#?????f?e*:dY0?<?o.?Lm??57>?u???y??H?P?zs???O???]?'?????V?vXf???"f ?b?dK??l,?X?g?4??d???;?_[?#??????#g~~?$U??C?:-?(*?%d?E+?_?-???g@?{L???8?????~?J????)X?3)Z????m?? cQ????wC2!??%R???@??7???????g?Tg gg?????Wj?:?~?? WSm?9???S??A???i+??rV????:I?kJ}h?{??DO?*l??o sS??,??f?!?2_/J??i??????`-???????o?Z??S??????9??????ü?.?4??[u^??,?W?h???G?_???gL "??"Gu?f?v?????Z(????????p?{?b? V)??NK?^?.?aw?????*??W??my?[?3?*????Gz???@0:?y?R?H ?{?M?w%Ui >????X?5??2L? ????5?q???R?I R? ??????^x'??{>?8?0????????z\??[xq???E????'?#RX g??gx#??IiF??Z????Z????j????????*3???j?????4(8 Q?qG???4?a?2br?7????,?x????Aç??E?C?_ ???8?Q?C??'LAB?d-?F?S=;t+h|??? ?~??????k=#?d???T9????v??????e?v5??C?Gc??"?c??????D]qY?5?)???VGB??)&????Kg)??R??a?|a???X?'?J?t?:???X?s??"??4:????6h%z?cE??M8?????+WO???E???s???T?3??+???#^?b?t?"s????>????????pk??Y??!'???(?(?p7tc?!?x[Q??V?#??A* =????????? ?38+q&^?????{dvc?\-/{9??g??D??'?, "f# ?c??C?>?w??w.l??+#??A??=o?;???.???????E?{ ?f?G???!|?U??T? ???c?????j<?Q?;???vVw(???/T??!{???97Gj ?9}`F? ]??m????m^??? ?X???C????DwP?o~??_6??,U???H5n?UQ?A????Q??Y??\?7*{???b|>eu???~1??K_?/?Q4$????z??A1??'=?<?e?"?7?? ?&]? j??#Q#??!??i??J?o:R??g?X-?u?w??? by ????\yf??7?*?n?n?????L+n?g?????< ??490t?R5+e?????8???2?lA??v?4e%???=V{ ?????; ??}q9?6??rTo;q????hX?Re???fa?6??L V??5 m@?;?$"?6?l? ????GT??Y&c????????T9i?Q??\z????*?q??^?4Q?}???? ??1??9 ?1??? ?n>u@7?????`?????=CQ? ??oH??Aq???O? ?1V?!?V??DFYk?%ta??|????%?1?+??\?f?V?????*g>*????V!?;?Mc} rE??an???6??I??\:??Y3,7e9?????0&?D???`HP??$?[sz?3?R????G?R?? ?410I??0{<pj?%?W?F?<@O??Y??? $?????@?@??4F? u?8???2??w7?l???(H'??{i??~??z???1T??A???,?8? F??? ?^P?0???C????iv u>j ?Qnb???1&??;???0mR4?[?]????UR??,m??5?/{?Pm???????7$??c???\b4h????Xi????????Ð?>??au?%?~N???2?g&??K?^??=?{"?9?????]? ?V??P??S?}?Liv?y2??????<?i? ?6 ws]?+?z??e?Sz?{*?<?BW???&w{???b??rS|??E?2??q?n&??/?ã?? r?3?v?j??i????mZ??l?2?] ????8???;,X M?O?2?=Y? <?7??`?SV???]i?? ?4???GY*??|"??!U???o?a??D|?[??% ?VW?????2???m??1?? ???????!Sq??Lt??6\?fT^?H[???i?[?p????G~? ?e??????c;? ????P??K<:?6 t??v<???v??????????D????l<???iS#Q ~????r?U????'%?hsm???OW????.*??x?+??>²D?{m+??O???Iu????>??D?V?B???H?(/<?^?*??? ?4.??VT??s?~?N??Lu;;^;ã?~AW?>w?L4??c??l?f???SG?tO5???0K?Sp? ?t?>(??? ???-:y q1??8??Y??|F???~?{?n M?????c ?@J?O???%0O?.??N??jT????H,?a+?^!?_ A ??Q ?Cl>$?&?j????M#??>?I??[?MH_???x1_?s $V?^t3)???:??0_ymn P$S?;?????b?ov5? ?U?dX??~)EQc??:?!??E??zR"Ac??]?? ?)#?xaTXK?&?F s?83)??5?&????R&?G?"???@?i4??????hh0??r??5#?e?j???QAzn?????V{??L??NK@???#xG?/?6s??r???CpC??99t_ ????4c;???Y?$??x??*??q????`?????????b??a??{C???z:??xz?=]f?? |z?$ O?i??? v??D????e??k?????e6??Q@??? ??/[j??P?Q?~'?y=?t?FZ?xw9 ??4?? y.???C??&??Ip>???????O?7;?h?????W5`(?!q# ???A?c??Il???h??h? ?u6FG#?\; ?Q??t?i??f?Ab??c??|?|?7?H?v?c???L'?) L?ge???? !V*?bQO?i???4 |5?}?g?z???!5?F]2N??%C??}?e?????k? ??? ]@A?8?]z?F | uQxk?? ?y?k|??l?R???g"MR??")?\?^3??^???e5;@an.??5?c:???CR????>?}P??>8n?Z?q+????5??L???C????{?K?V???8?r????S???` ????a??????8%?????????W?c??}w??z? ???+<??g?c>d?J4?wg|???i?Q1(??F??d??3k????tO,?xo$+g?"???.?^ ?O??U?`??w????$]???Po?8U?]??C?-??~????Y??hk94?,#?EM?#?!Q/,2P??0m???fQh]?z?n?iH5???X77???u?????`??<? (?6AW??v?`?2<&? ??jEC?3H?nfJ???m?????t???????(.??,?NC??0?4q??-{u Z?<[,Dm ?????uF??g???????p? fd ????4?M[?????b?v>???2k??n?K=7? >R?J???F?v$??????????j ?r???yRtt???B:T8?yA????\?3?F?}??2??xO??%???,?E?1?7h?c??GM?'??L???5ú?Z?DHEb???g?R??i??4???-?^????,???"A)???l:m?k? ???9 P_?S??$??B?? i?%??#??????????u?#`F? VuruI?.3??o(VmQEs?u?.?fO????@?)??r??gS? ??????>???(zW?????? ???????RSRNHx?jx??f&;X??J?????&;?r?"?4=?qC?>V'??]????o?8:??i?*????u&hj?????????????1]???|.4??k???#9???h???GG:?&??.?-?-7?u???Wy@1?^?AO???X?t???ja??"+Je ?v]?????L.??;+?? ?!??(2???R???_yE????s?{Z??3K[@?+????l?OO?" J???? ??[???pvx ?zO)"?/?w?????5??DGJT )s?u?ws4? ??[M8@?V{8???Sv%,?B?P1??o??g???????H?QIi?? ^???^?? N???n?3?v??????B??9?ZK??;??52A???S:/%}?]?ld??1K?f? ??Dq??~gH??o?ao??P??NU????9< ??k????%Cv?f?Xk<???? p7.??R?[?I9???Ba?0?<4S?&QnK?????L????6DF?|?7QLs?`#??oBG??m?y?3T????!?????b?b?????T ??LM?U???a??Y>??)???P??ye?HM?ffh\?Hd????~?????:qI?YE?W????j2?c??/????n??Ð???8_?Q6/??"ha?B*Z!????]K? ?jl E\?>RFO7n???*??G?????q K?(XH?Q????????2$???????V???#???> ???>(<???9>?Mt&?? 4-a+????e/?!???El?$?+T?8????????P?L=??_USh?0DEE?p^???????P<???I V?A?,??>? V}??P~z???8????5????nMwC??E?p?njJ0?^?h???js;c"[??"D??B???5Z?j8????R)n?p??w"??N}Vh????Bb??U?h??????N?E??+ W?@???7?Z??v?? t?FY?#4]3?U???y?m}e? S\? ???Y???1.?:z?#"q??$\??K????q?Ya ? ???P????d{???a?<%??c?/??^9???A?]:?4?3:?? 9"N??n?s??!????J??6???$?g???\ ?S{?U??$?<?p8?[????.;????E????03d? ?^?=? ??`? B?/3?Y?_?L+???%??{??X??????ce???wJH??/U?k???pj???_???EHM?L? ?K7?#@ h6/??g?M?N{?Dj???W? {f?L???\?ySP/?V?QY?C??????dD`????? ??_??e??[??}?:??rL?@?n???Nnc ????h?Q?????????"}?.S <?Y5???p?????K?q???/??? w =?,??u&???7 ????A0?? ?rM?;???X????#?v[??????c?y?W1?H!tD? }??>?N`?????^?!?'?%????R???f ?MK?Bwq??Ah???i??^???n\#?UI??u?MY??.??!I???)?H?SG@??? ?/??I#????gJ?DX wM?L0??#?w?p?U?L?&U??x????A^?r- N!?x&?e??j:?!????G1?(? ???.??$???k?8???? ?^^?%?[?Bt?.??mw??H?H3W????y?~???':q?{.????!?}?hLOx1????k?????? `S` ?????BVG?)???W`?6??7???,??. ?? ?L -
Unable to insert Long text in MYSQL through PHP???
shiza replied to shiza's topic in PHP Coding Help
It shows the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?~M?x??????~L=??\nn?E zR?S?R?]}?/sG?WG?x??G?5T6?%??M??O??? ?????V? W?!' at line 1 -
if(!mysql_query("INSERT INTO voter(encrypt) VALUES('$encrypted')",$con)) { echo "not executed"; } But it is not executed... $encrypted is about 5000 chararcters..and the data type of encrypt is Longtext.
-
Thanx for the reply...Now i Got it ....
-
$string="this is my string"; $hash=md5($string); I strore it in database (only $hash) How can i get back the $string form $hash?
-
check the form validation script and modify it according to your own requirement link: http://www.echoecho.com/jsforms02.htm
-
No there wasn't. It is bulit-in or userdefined?
-
I use to write in this way mysqli_query($query, $dbc); instead of mysqli_query($dbc, $query); try it, may be it can solve your problem.
-
Error: call to undefined function mcrypt_module_open() I have copied this code form net. And i think so that mcrypt_module_open() would be a built in function. But I think it is not so. How can i define this function. OR any other way to solve this problem?? $cipher = mcrypt_module_open(MCRYPT_RIJNDAEL_128, '', MCRYPT_MODE_CBC, ''); $iv_size = mcrypt_enc_get_iv_size($cipher); printf("iv_size = %d\n",$iv_size); $key256 = '12345678901234561234567890123456'; $key128 = '1234567890123456'; $iv = '1234567890123456'; printf("iv: %s\n",bin2hex($iv)); printf("key256: %s\n",bin2hex($key256)); printf("key128: %s\n",bin2hex($key128)); $cleartext = 'The quick brown fox jumped over the lazy dog'; printf("plainText: %s\n\n",$cleartext); if (mcrypt_generic_init($cipher, $key256, $iv) != -1) { // PHP pads with NULL bytes if $cleartext is not a multiple of the block size.. $cipherText = mcrypt_generic($cipher,$cleartext ); mcrypt_generic_deinit($cipher); // Display the result in hex. printf("256-bit encrypted result:\n%s\n\n",bin2hex($cipherText)); } if (mcrypt_generic_init($cipher, $key128, $iv) != -1) { // PHP pads with NULL bytes if $cleartext is not a multiple of the block size.. $cipherText = mcrypt_generic($cipher,$cleartext ); mcrypt_generic_deinit($cipher); // Display the result in hex. printf("128-bit encrypted result:\n%s\n\n",bin2hex($cipherText)); } Thanks In advance