php variable passed to mysql query

Question

Not sure what I am doing wrong? Never ran into this issue before? But this is also the first function I have written.

<?php
function category($string){
if(preg_match("/(Slimming|Laser|Spa|Massage|Manicure|Pedicure)/i", $string)){  
echo 'Spa';
}
}  // This is function.php

$title = 'Spa';

include 'function.php';
$category = category($title);
$category = mysql_real_escape_string($category);
echo "$category<br>"; // I get Spa
var_dump("$category"); //added for testing, I get string(0) ""

$category is then sent to a mysql insert, the value is blank in the database...

Thanks for the help.

BGPHiJACK · Accepted Answer · 2011-02-20 00:10:46Z

2

echo 'Spa';

Should be:

return 'Spa';

and

var_dump("$category");

Should be:

var_dump($category);

Functions should always return a value if you're defining a variable otherwise you're doing nothing.

answered Feb 20, 2011 at 0:10

BGPHiJACK

1,4071 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BGPHiJACK Over a year ago

No problem, just remember to pick this as the best answer. :)

Audio · Accepted Answer · 2011-02-20 00:11:35Z

0

You get the ouput "Spa" when you call category($title), because in the function is echo instead of return.

answered Feb 20, 2011 at 0:11

Audio

4766 silver badges13 bronze badges

Collectives™ on Stack Overflow

php variable passed to mysql query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related