FUDforum: comp.lang.php » str

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

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

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

Mon, 21 October 2013 01:55

Mr Oldies
Messages: 241
Registered: October 2013

Karma:

Senior Member

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=$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.

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: Mon Feb 17 22:02:37 GMT 2025

Total time taken to generate the page: 0.04336 seconds