DaniWeb Forum Index > Web Development > PHP

string variable question

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2007

Posts: 227

Reputation: k2k is an unknown quantity at this point

Solved Threads: 0

k2k

Offline

Posting Whiz in Training

string variable question

Jul 24th, 2009

hi, i selected everything from the table and the direct variable $cResult[3] would give me something like "street address with space as delimiter" ... however, when i tried to use it, it will give me only "street" instead of "street address with space as delimiter".

does anyone know how i can fix it so it will show the whole field?
thanks

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
 
<?php
	require_once('auth.php');
	require_once('config.php');
 
	$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
	if(!$link) 
	{
		die('Failed to connect to server: ' . mysql_error());
	}
 
	//Select database
	$db = mysql_select_db(DB_DATABASE);
	if(!$db) 
	{
		die("Unable to select database");
	}
 
	$cid = $_SESSION['SESS_CUSTOMER_ID'];
 
	$qry="SELECT fname, lname, email, streetAddress,zip_id, passwd FROM customer WHERE customer_id='$cid'";
 
/////////////////// problem begin //////////////////////////////////	
        $cResult=mysql_fetch_array(mysql_query($qry));
 
	$fn= "$cResult[0]";
	$ln= "$cResult[1]";
	$email= "$cResult[2]";
	$street= "$cResult[3]";   //---> this will give me only part of the field (the first word basically)  
///////////////// problem end ///////////////////////////////

<?php
	require_once('auth.php');
	require_once('config.php');
	
	$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
	if(!$link) 
	{
		die('Failed to connect to server: ' . mysql_error());
	}
	
	//Select database
	$db = mysql_select_db(DB_DATABASE);
	if(!$db) 
	{
		die("Unable to select database");
	}
	
	$cid = $_SESSION['SESS_CUSTOMER_ID'];
	
	$qry="SELECT fname, lname, email, streetAddress,zip_id, passwd FROM customer WHERE customer_id='$cid'";

/////////////////// problem begin //////////////////////////////////	
        $cResult=mysql_fetch_array(mysql_query($qry));
	
	$fn= "$cResult[0]";
	$ln= "$cResult[1]";
	$email= "$cResult[2]";
	$street= "$cResult[3]";   //---> this will give me only part of the field (the first word basically)  
///////////////// problem end ///////////////////////////////

•

Join Date: Sep 2007

Posts: 1,528

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 137

cwarn23

Offline

Posting Virtuoso

Re: string variable question

Jul 24th, 2009

Try replacing the problem area with the following:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];

Try not to bump 10 year old threads as it can be really annoying.
http://syntax.cwarn23.net/
Smilies: ^_* +_+ v_v -_- *~*`
My favourite PC. - Oopy Doopy Do 2U2!

•

Join Date: Nov 2007

Posts: 227

Reputation: k2k is an unknown quantity at this point

Solved Threads: 0

k2k

Offline

Posting Whiz in Training

Re: string variable question

Jul 24th, 2009

•

Originally Posted by cwarn23

Try replacing the problem area with the following:
Help with Code Tags

php Syntax (Toggle Plain Text)
$cResult=mysql_fetch_array(mysql_query($qry));
$fn=$cResult[0];
$ln=$cResult[1];
$email=$cResult[2];
$street=$cResult[3];
$cResult=mysql_fetch_array(mysql_query($qry)); $fn=$cResult[0]; $ln=$cResult[1]; $email=$cResult[2]; $street=$cResult[3];

i will try again later but i think i already tried that and didn't work.

•

Join Date: Oct 2006

Posts: 1,078

Reputation: ardav will become famous soon enough

Solved Threads: 137

ardav

Offline

Veteran Poster

Re: string variable question

-1

Jul 24th, 2009

Just a thought, is your 4th field (street) long enough to take the whole street name. Check in phpmyadmin or whatever you use to admin your db to see if the data in 'street' is complete.

If this ain't a problem, have you got any strange characters following the first word?

Happy Humbugging Christmas

•

Join Date: Nov 2007

Posts: 227

Reputation: k2k is an unknown quantity at this point

Solved Threads: 0

k2k

Offline

Posting Whiz in Training

Re: string variable question

Jul 24th, 2009

•

Originally Posted by ardav

Just a thought, is your 4th field (street) long enough to take the whole street name. Check in phpmyadmin or whatever you use to admin your db to see if the data in 'street' is complete.

If this ain't a problem, have you got any strange characters following the first word?

nope, no strange characters. the field is long enough and the street i inserted "132 main street" was already stored in the table.

but it is weird that [code] echo "$cResult[3]" returns me only "132"

•

Join Date: Sep 2007

Posts: 1,528

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 137

cwarn23

Offline

Posting Virtuoso

Re: string variable question

Jul 25th, 2009

•

Originally Posted by k2k

but it is weird that [code] echo "$cResult[3]" returns me only "132"

Perhaps it is an error in the part of the script that inserts into the table. Try using the mysql_real_escape_string() function to see if it escapes the spaces. And remember to put quotes around each string to be inserted. Below is an example:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo '`column`="'.mysql_real_escape_string('132 main street').'"';
mysql_query('INSERT INTO `table` SET `column`="132 main street"') or die(mysql_error());
echo '`column`="'.mysql_real_escape_string('132 main street').'"';
mysql_query('INSERT INTO `table` SET `column`="132 main street"') or die(mysql_error());

And check if the first line returns whats in the mysql query.

Try not to bump 10 year old threads as it can be really annoying.
http://syntax.cwarn23.net/
Smilies: ^_* +_+ v_v -_- *~*`
My favourite PC. - Oopy Doopy Do 2U2!

•

Join Date: Nov 2007

Posts: 227

Reputation: k2k is an unknown quantity at this point

Solved Threads: 0

k2k

Offline

Posting Whiz in Training

Re: string variable question

Jul 25th, 2009

still don't know why, but it magically works now with $street= $cResult[3]

and echo "$cResult[3]" return "132 main street"

..... thanks everyone tried to help.