field string variables with spaces

HOTLIPS · Feb 4, 2004

Hi
Can anyone help ... i am reading in from mysql database...and
setting php variable equal to a $_request variable from database....but because the variable ...
ie "name" is John Smith....the variable only picks up the John and not the Smith...is this because of the space between the name John Smith????...
Code sample
$name=$_request['name']...
Cant find any details in manuals regarding this

Hotlips

KarveR · Feb 4, 2004

$name="$_request['name']"; should fix it.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

HOTLIPS · Feb 4, 2004

Hi

thanks but tried that and get error message ....

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Program Files\Apache Group\Apache2\htdocs\index.php on line 14

Hotlips

KarveR · Feb 5, 2004

show us yer code

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

HOTLIPS · Feb 5, 2004

Hi
I enclose my code
I seem to have sorted the space problem on variable($Manufacturer)...("Smith Jones&quot

..(not $name which I used as example) .. by inserting double quotes in the href link codeing .. this sends the variable back ok including the space.....the name or manufacturer name I originally had trouble with was "Smith & Jones" ......I realised that the "&" was also causing a problem..so I missed it out...... Can u confirm that mysql or php does not like "&"

Many thanks
Hotlips

<html><head><title>W&WCOUK</title>
<link rel="stylesheet" type="text/css" href="wandw.css">
<script language=JavaScript src=catlist.js type=text/javascript></script>
<script language=JavaScript src=stdinc.js type=text/javascript></script>
<script language=JavaScript type=text/javascript>
</script>
<?php>
//session_start() ;
include_once("dbconnectwandw.php&quot

;
$page="";
$Manufacturer="Startup";
$range="";
$page=$_REQUEST['page'];
$Manufacturer=$_REQUEST['Manufacturer'];
$range=$_REQUEST['range'];
// $page="";
// $Manufacturer="";
$today = date("l&quot

." ".date("d F Y&quot

;
$string=""
//echo ($page) ;
//echo ($Manufacturer) ;

?>
</head><body>
<div style='position:absolute;top:0px;left:0px;visibility:hidden;color:#000000;background-color:#000000'>
</div>
<div style='position:absolute; left:1; top:0; width:780' >
<div style='position:absolute; left:0; top:0; width:779; height:119'><img src=images/wwetc2.gif width=779 height=120>

<div style='position:absolute; left:0; top:95; width:779; height:24'>
<table class=menu4 width=779>
<tr><th><a href="index.php?page=Home">Home</a></th><th><a href="index.php?page=aboutus">About us</a></th><th>Home</th><th>Home</th><th>Terms & conditons</th><th>Contact us</th></tr>
</table>
</div>

</div>

<div style=' z-index:2; position:absolute; right:10; top:10; text-align:right; color:#000000'><?php echo($today)?><br></div>
<div class=Main2 style='position:absolute; width:119; left:1; text-align:left; top:119; height:500'>

<?php
//**************** Do query to get list of products categories and descriptions for left menu************************
$sqlcat = "SELECT * FROM Category";
$resultcat = mysql_query($sqlcat, $conn) or die(mysql_error());

//**************** Do query to get list of manufacturers.by category..ie wallpapers..fabrics ************************
$sql1 = "SELECT DISTINCT c1.Category, c1.Manufacturer, c2.categoryno, c2.categorydesc
FROM stockcatalog AS c1, category AS c2
WHERE c1.category = c2.categoryno
GROUP BY c1.category, c1.manufacturer";
$result1 = mysql_query($sql1, $conn) or die(mysql_error());
//$myrow= mysql_fetch_array($result1);
//$rangename=$myrow1['range'];
// if (mysql_num_rows($result1)>0){ //does the range already exist?

$stylepicked="style='color: green '" ;

//**************** Do query to get Range or collection from selected manufacturer ************************
$sql = "SELECT DISTINCT range FROM stockcatalog WHERE category = '$page' and Manufacturer = '$Manufacturer'";
$result = mysql_query($sql, $conn) or die(mysql_error());
//************ loop through query result and create sub list of ranges/collections ***********************add   at end of field to print cell border if cell empty
while ($myrow = mysql_fetch_array($result))
{
$string.="      <a href="."\""."/index.php?page=".$page."&Manufacturer=".$Manufacturer."&range=".$myrow['range']."\"";
//if (($page==$myrowcat['categoryno'])&&($Manufacturer==$myrow1['Manufacturer'])&&($range==$myrow['range'])) {
if ($range==$myrow['range']) {
$string.="  style='color: green'";
$s="OKOK" ;
}

$string.=">".$myrow['range']."</a><br>\n" ;
//$string.="     ".$myrow['range']."</a><br>\n" ;
}
?>

<table class=menuLeft>
<?php

while ($myrowcat = mysql_fetch_array($resultcat)) {
echo("<tr><th>".$myrowcat['categorydesc']."</th></tr><tr><td>&quot

; // list CATEGORIES

mysql_data_seek($result1,0); // put the array pointer to the start of the array

while ($myrow1 = mysql_fetch_array($result1)) {
if ($myrow1['Category']==$myrowcat['categoryno']) {
// echo($myrow1['category']) ;
echo("<a href="."\""."/index.php?page=".$myrow1['Category']."&Manufacturer=".$myrow1['Manufacturer'])."\"" ;
//************ change font color to green for selected manufacturer
if (($page==$myrowcat['categoryno'])&&($Manufacturer==$myrow1['Manufacturer'])) {
echo ("  style='color: green'&quot

;
}
echo (">".$myrow1['Manufacturer']."</a><br>\n&quot

; // list MANUFACTURES
if (($page==$myrowcat['categoryno'])&&($Manufacturer==$myrow1['Manufacturer'])) {
$catdesc=$myrowcat['categorydesc']; // get the category desc for main section of page
echo($string) ;} // create list of RANGES OF CATEGORIES by SELECTED MANUFACTURER
}
}
echo("<br><br></td</tr>&quot

; // put spaces between categories

}
// echo ($page) ;
// echo ($Manufacturer)."<br>";
// echo ($range)."<br>";
// echo $_GET['Manufacturer'] ;
//**********end of left menu ************************************************
?>
</td</tr>
<?php

?>
<style type="text/css" ></style> 
</div>

<div class=main2 style='position:absolute; left:120; top:0; width:658; height:500'>
<?php

// ********** first create details of ALL RANGES by manufacturer as per category ***************
if (($page>0)&&($Manufacturer<>Startup)&&($range=="&quot

){
//********** Do query to FULL Range of ALL collection from selected manufacturer of ALL categories************************
$sql2a = "SELECT * FROM stockcatalog WHERE category = '$page' and Manufacturer ='$Manufacturer'";
$result2a = mysql_query($sql2a, $conn) or die(mysql_error());
//************ loop through query result and create table ***********************add   at end of field to print cell border if cell empty
$string2a.="<table class=menu5 width=658 ><Caption align=top>".$catdesc." by ".$Manufacturer."</caption><tr><th>StockID</th><th>Pattern No</th><th>Description</th><th>Price</th><th>Prod code</th><th>Width/<br>Depth</th><th>Pattern Repeat</th><th>Sample</th></tr>";
while ($myrow2a = mysql_fetch_array($result2a)) {
$string2a.="<tr><td>".$myrow2a['stockID']."</td><td> ".$myrow2a['patternname']."</td><td>".$myrow2a['description']."</td><td> ".$myrow2a['price']."</td><td> ".$myrow2a['productcode']."</td>
<td>".$myrow2a['width']."<br>".$myrow2a['depth']."</td><td> ".$myrow2a['patternrepeat']."</td>
<td><a href='../images/{$myrow2a['pix2']}' border='0'><img src='../images/{$myrow2a['pix1']}' border='0'width='100' height='80'></a></td></tr>\n" ;
}
echo ($string2a);} //create table of ALL RANGES in ALL CATEGORIES
//**************************** now do JUST the RANGE in category ONLY ***********************************************************

if (($page>0)&&($Manufacturer<>Startup)&&($range<>"&quot

){
//$stylepicked="<style='color: green'>" ;
//**************** Do query to get Range or collection from selected manufacturer ************************
$sql2 = "SELECT * FROM stockcatalog WHERE category = '$page' and Manufacturer ='$Manufacturer' and range='$range'";
$result2 = mysql_query($sql2, $conn) or die(mysql_error());

//************ loop through query result and create table ***********************add   at end of field to print cell border if cell empty
$string2.="<table class=menu5 width=658 ><CAPTION align=top>".$catdesc." - ".$range." range by ".$Manufacturer."</CAPTION><tr><th>StockID</th><th>Pattern No</th><th>Description</th><th>Price</th><th>Prod code</th><th>Width/<br>Depth</th><th>Pattern Repeat</th><th>Sample</th></tr>";
while ($myrow2 = mysql_fetch_array($result2)) {
$string2.="<tr><td>".$myrow2['stockID']."</td><td> ".$myrow2['patternname']."</td><td>".$myrow2['description']."</td><td> ".$myrow2['price']."</td><td> ".$myrow2['productcode']."</td>
<td>".$myrow2['width']."<br>".$myrow2['depth']."</td><td> ".$myrow2['patternrepeat']."</td>
<td><a href='../images/{$myrow2['pix2']}' border='0'><img src='../images/{$myrow2['pix1']}' border='0'width='100' height='80'></a></td></tr>\n" ;
}
echo ($string2);} // create table of SELECTED RANGE
?>
</table>

<?php
if (($page==Home)or ($page=="&quot

){
$stringhome.="<div class=main2 style='position:absolute; left:120; top:0; width:658; height:500'>";
$stringhome.="This our HOME PAGE";
echo($stringhome);
}
if ($page==aboutus){
$stringhome.="<div class=main2 style='position:absolute; left:120; top:0; width:658; height:500'>";
$stringhome.="This our ABOUT US PAGE";
echo($stringhome);
}
?>
</div>
</div>
</body>

</html>

DRJ478 · Feb 5, 2004

Look at this line:

Code:

<a href=&quot;.&quot;\&quot;&quot;.&quot;/index.php?page=&quot;.$page.&quot;&Manufacturer=&quot;.

Code:

$Manufacturer.

Code:

&quot;&range=&quot;.$myrow['range'].&quot;\&quot;&quot;;

Note that you just printed the name "X & Y" in there. The ampersand is used to concatenate GET elements in the URL. If you variable $Manufacturer contains an ampersand you have to URL encode it first before inserting it. Otherwise the ampersand is literally interpreted as separator for the next GET parameter.

Have a look at the urlencode() function:

http://www.php.net/urlencode

HOTLIPS · Feb 5, 2004

Thanks alot
I have now put my "&" and "spaces" back in my manufacturers name field in my data base and its working a treat.

Many thanks again

Hotlips

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

field string variables with spaces

HOTLIPS

Technical User

KarveR

MIS

HOTLIPS

Technical User

KarveR

MIS

HOTLIPS

Technical User

DRJ478

IS-IT--Management

HOTLIPS

Technical User

Similar threads

Part and Inventory Search

Sponsor