Solved

how do i add stripslashes to this piece of code in php/mysql application

Posted on 2009-05-06
5
223 Views
Last Modified: 2013-12-12
how do i add the get_magic_quotes_gpc()==1 to the attached code so it will remove the slashes that are in my db.  I was able to do this for another section of the code and it works, but i can't figure out how to add it to the array_push and else statement in the code that is attached.

//$R[$row['R_NUMBER']]['ANSWER'][$row['Q_ID']]=$row['TEXT'];
                $R[$row['R_NUMBER']]['ANSWER'][$row['Q_ID']]= ((get_magic_quotes_gpc()==1)?stripslashes($row['TEXT']):$row['TEXT']);

function getRequest($requestNumber,$answerTable='ANSWER')

{

	global $db;
 

	$sql = "SELECT * FROM " . $answerTable ." WHERE R_NUMBER='".$requestNumber."' ORDER BY Q_ID";
 

	$result = mysql_query($sql,$db) or die("ERROR: " . mysql_error());
 

	while ( $row = mysql_fetch_assoc($result) )

	{

		if (preg_match("/\[\]$/", $row['Q_ID']))	//If there is a [] in the ID, it is an array

		{

			preg_match("/([^\[]+)\[\]/", $row['Q_ID'], $matches);	//Split the ID into the number and the []

			$arrayname = $matches[1];
 

			if (!is_array($answer[$arrayname]))

			{

				$answer[$arrayname]=array();

			}
 

			array_push($answer[$arrayname],preg_replace("/<br>/",$cr,$row['TEXT']));

		} else

		{

			$answer[$row['Q_ID']] = preg_replace("/<br>/",$cr, $row['TEXT']);

		}

	}

Open in new window

0
Comment
Question by:justmelat
  • 2
  • 2
5 Comments
 
LVL 50

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 24322309
I'm assuming it is $row['TEXT'] you want to strip:
on getRequest($requestNumber,$answerTable='ANSWER')

{

        global $db;

 

        $sql = "SELECT * FROM " . $answerTable ." WHERE R_NUMBER='".$requestNumber."' ORDER BY Q_ID";

 

        $result = mysql_query($sql,$db) or die("ERROR: " . mysql_error());

 

        while ( $row = mysql_fetch_assoc($result) )

        {

                $text_to_add =  ((get_magic_quotes_gpc()==1)?stripslashes($row['TEXT']):$row['TEXT']);

                if (preg_match("/\[\]$/", $row['Q_ID']))        //If there is a [] in the ID, it is an array

                {

                        preg_match("/([^\[]+)\[\]/", $row['Q_ID'], $matches);   //Split the ID into the number and the []

                        $arrayname = $matches[1];

 

                        if (!is_array($answer[$arrayname]))

                        {

                                $answer[$arrayname]=array();

                        }

 

                        array_push($answer[$arrayname],preg_replace("/<br>/",$cr,$text_to_add));

                } else

                {

                        $answer[$row['Q_ID']] = preg_replace("/<br>/",$cr, $text_to_add);

                }

        }

Open in new window

0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 24328134
Hmm... Yet another compelling argument for atomic, instead of combined, coding!

;-)

Best to all, ~Ray
0
 
LVL 1

Author Comment

by:justmelat
ID: 24366796
Hi routinet:  i tried your solution, but still get the slashes, that then can't be removed.  the only solution was to remove the addslashes.  i don't know what has gone wrong with the new server upgrade, but it has everything off now.
0
 
LVL 1

Author Closing Comment

by:justmelat
ID: 31578449
just didn't work for my application
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 24366886
>>> tried your solution, but still get the slashes, that then can't be removed

Were you trying to use this to cleanse existing data already in a database?  That's not what addslashes() does.  This function's purpose is to escape data before adding it to a database.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now