FUDforum: comp.lang.php » str

Home » Imported messages » comp.lang.php » str_replace ?

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

Re: str_replace ? [message #183360 is a reply to message #183357]

Mon, 21 October 2013 02:11

David Robley
Messages: 23
Registered: March 2013

Karma:

Junior Member

richard wrote:

> On Sun, 20 Oct 2013 21:02:10 -0400, Lew Pitcher wrote:
>
>> On Sunday 20 October 2013 20:48, in comp.lang.php, "richard"
>> <noreply(at)example(dot)com> wrote:
>>
>>> In my database I am noting that none of the song names containing a
>>> single quote are being written.
>>> If I use str_replace, how exactly should I write it?
>>
>> By using mysql_real_escape_string()
>>
>> http://ca1.php.net/manual/en/function.mysql-real-escape-string.php
>>
>> See example #1, and modify for INSERT
>
> I don't quite follow the example.
> What I have is this:
>
$played = mysql_real_escape_string($playme[$number][2]);
>
> mysql_query(
> "INSERT INTO top20 (songs,name,hits)
> VALUES (' ".$song." ',' ".$played." ',1)
> ON DUPLICATE KEY UPDATE hits=hits+1");
>
> Assume that $played="I'm Sorry".
>
> Please show me how and where to put the proper coding.

Use the above; this is simpler than trying to introduce you to the
complexities of sprintf. You should use mysql_real_escape_string on any
strings you send to mysql.
--
Cheers
David Robley

"I teach at a university," Tom professed.

Report message to a moderator

[Message index]

		str_replace ? By: Mr Oldies on Mon, 21 October 2013 00:48
		Re: str_replace ? By: Lew Pitcher on Mon, 21 October 2013 01:02
		Re: str_replace ? By: Mr Oldies on Mon, 21 October 2013 01:55
		Re: str_replace ? By: David Robley on Mon, 21 October 2013 02:11
		Re: str_replace ? By: Mr Oldies on Mon, 21 October 2013 13:16
		Re: str_replace ? By: Jerry Stuckle on Mon, 21 October 2013 01:06
		Re: str_replace ? By: Denis McMahon on Mon, 21 October 2013 18:43
		Re: str_replace ? By: Norman Peelman on Mon, 21 October 2013 23:10
		Re: str_replace ? By: Norman Peelman on Mon, 21 October 2013 23:14
		Re: str_replace ? By: Tobiah on Wed, 23 October 2013 17:04
		Re: str_replace ? By: Scott Johnson on Thu, 24 October 2013 00:03

Previous Topic:	has anyone used multithreaded PHP appserver.io for application?
Next Topic:	Observation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:32:59 GMT 2024

Total time taken to generate the page: 0.03576 seconds