PHP MySQL: decrypt a column value from a MySQL row that was encypted upon insertion and parse to JSON -

-

everything working, want decrypt db column containing credit card number database following example:

$decp = $crypt->decrypt($encp);

the row in question is: 

'number' => $row['cardnumber'],

the entire code is:

// cards $jsonresult = $conn->query("select nameoncard, cardnumber, cardtype, carddate, ccvcode                                 cy_user_credit_cards                                 accountnumber='$accountnumber'"); $creditcard = []; while ($row = mysqli_fetch_assoc($jsonresult)) {     array_push($creditcard, [         'name'   => $row['nameoncard'],         'number' => $row['cardnumber'],         'type' => $row['cardtype'],         'date' => $row['carddate'],         'ccv' => $row['ccvcode']     ]); }      // convert array json string , echo     $ccjson = json_encode($creditcard);     echo $ccjson; $conn->close();

i think want this:

// cards $jsonresult = $conn->query("select nameoncard, cardnumber, cardtype, carddate, ccvcode                                 cy_user_credit_cards                                 accountnumber='$accountnumber'"); $creditcard = []; while ($row = mysqli_fetch_assoc($jsonresult)) {     array_push($creditcard, [         'name'   => $row['nameoncard'],         'number' => $crypt->decrypt($row['cardnumber']),         'type' => $row['cardtype'],         'date' => $row['carddate'],         'ccv' => $row['ccvcode']     ]); }      // convert array json string , echo     $ccjson = json_encode($creditcard);     echo $ccjson; $conn->close();

keep in mind, not want store of these credit card details in database if not absolutely necessary. urge elsewhere handle credit card payments.


Comments

Post a Comment

Popular posts from this blog

asp.net mvc - Cannot display error message on Editor or EditorFor -

-
in mvc application, can display error messages inputs i.e. textboxfor , dropdownlist , etc. however, using same approach, cannot show validation error kendo().editor() or kendo().editorfor() . tried validationmessage beside validationmessagefor , not make sense. might problem be? view: <script type="text/javascript"> $(function () { //for using kendo validation: $("form").kendovalidator(); }); </script> //validation works textboxfor, dropdownlist, etc.: @html.labelfor(m => m.summary) @html.textboxfor(m => m.summary, new { maxlength = 50, @class = "k-textbox"}) @html.validationmessagefor(m => m.summary) //validation not work editor or editorfor: @html.labelfor(m => m.description, new { maxlength = 1000, @class = "editor-label" }) @(html.kendo().editor() //@(html.kendo().editorfor(m=>m.description) //also tried .name("description") .htmlattributes(new { @class...
Read more

Reliable way to get Windows Version from registry -

-
i'm checking windows version in installer (made nsis) checking following registry key: hklm "software\microsoft\windows nt\currentversion" "currentversion" according this post , this page msdn, currentversion number windows 10 should 10.0. i installed windows 10 pro insider preview , version number given in registry still 6.3, instead of 10.10 should. is there reliable way in registry detect windows 10? instead of reading value currentversion , read new values currentmajorversionnumber (which 10) , currentminorversionnumber (which 0) under windows 10. 2 keys new in windows 10 detect windows version registry .
Read more

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more