FUDforum: comp.lang.php » PHP sql entry is a godaweful mess

Home » Imported messages » comp.lang.php » PHP sql entry is a godaweful mess

Show: Today's Messages :: Polls :: Message Navigator

Re: PHP sql entry is a godaweful mess [message #184081 is a reply to message #184072]

Wed, 04 December 2013 16:15

Arno Welzel
Messages: 317
Registered: October 2011

Karma:

Senior Member

Am 04.12.2013 12:35, schrieb bored(at)now(dot)com:

> I've just decided to update some code so updated myself with the docs
> for mySQL entry cleaning and frankly I am totally confused.
>
> Can someone point to a very clear and unambigous instruction
> as to how to safely enter data into a mysql database?
> Because I doubt thats even possible with PHP.

It is - just do NOT use mysql but mysqli or PDO.

> We have to contend with stripslashes, magic_quotes, magic_quotes_sybase
> mysql_escape_string, mysql_real_escape_string and more...

No - you don't have to.

See:

<http://php.net/manual/en/class.mysqli.php>
<http://www.php.net/manual/en/mysqli.prepare.php>
<http://php.net/manual/en/book.pdo.php>
<http://php.net/manual/en/pdo.prepare.php>

> As for mysqli and its unnecessarily obtuse syntax... well I'll be
> looking for alternatives.

Obtuse syntax? Why?

Maybe you got confused by the fact, that mysqli comes in two flavors:
Procedural - to make it easier to migrate existing code from mysql - and
object oriented.

See <http://php.net/manual/en/mysqli.quickstart.dual-interface.php>

--
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

Report message to a moderator

[Message index]

		PHP sql entry is a godaweful mess By: <bored on Wed, 04 December 2013 11:35
		Re: PHP sql entry is a godaweful mess By: Tim Streater on Wed, 04 December 2013 12:37
		Re: PHP sql entry is a godaweful mess By: Jerry Stuckle on Wed, 04 December 2013 13:52
		Re: PHP sql entry is a godaweful mess By: bill on Thu, 05 December 2013 11:13
		Re: PHP sql entry is a godaweful mess [OT] By: adrian on Thu, 05 December 2013 13:13
		Re: PHP sql entry is a godaweful mess By: Arno Welzel on Wed, 04 December 2013 16:15
		Re: PHP sql entry is a godaweful mess By: John Smith on Tue, 07 January 2014 04:17

Previous Topic:	Loop through array, change headings
Next Topic:	foreach problem part two

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 17:15:46 GMT 2024

Total time taken to generate the page: 0.05823 seconds