StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POXcode 4.1 iOS consulting Joomla generated Database via PHP
text
Body
copied!<p>I am developing an iPhone app that needs to use a Joomla-generated database located on my own server.<br> There are a lot of solutions, so for more security I decided to 'talk' with the database via PHP.</p> <p>I have a PHP page like this:</p> <blockquote> <p>www.mypage.com/iphonelogin.php ?username=USER1&password=XXX&option=login</p> </blockquote> <p>The <code>option</code> can be: <code>getuserinfo</code>, <code>login</code>, <code>reset password</code>, etcetera.</p> <p>The problem is that the password stored encrypted in the database. (<code>MD5(password+Salt):Salt</code>)</p> <p>So, I am wondering how to do this the following ways:</p> <ul> <li><p>Low security way: PHP gets a plain text password from the APP and the Full encrypted password from de DB. Then PHP uses the salt, encrypts the password and does the comparison, then return YES or NO to the APP.</p></li> <li><p>Other way: PHP gets the password REVERSIBLE encrypted from the APP and decrypt it, then the same like above.</p></li> <li><p>Nice security way (pretty slow): PHP get the Full encrypted password from the DB, then shows the Salt to the APP. The APP encrypt the password Joomla way and send a full encrypted password to PHP which do the comparison and returns YES or NO to the APP.</p></li> </ul> <p>I need high security and fast connection, because every time the app needs something from the database, the login must be confirmed.</p> <p>Please tell me what to use or some another way to do it.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload