PHP Variables and MYSQL

sunit_modi

just wondering if some one can help me.

problem 1

I am writing data from a html form into the database.
The problems i am having are with the strings that use the html text tab i.e.

I basically want to write the data entered in that variable into a database costomer table field called address_line1

What happens is that the data is store but only up the first space in the variable i.e.

if i want to store :

31 Ham Street

It would only store 31 and craps out after the first space, what can i do about this.

Problem 2

Also in the customer table i have a number of fields that are set to NULL i.e. a telephone number.
But if i do a select statement and recall the phone number, it always missis the first '0' i.e. if i enter 01234, it would return on a select statement after an insert 1234 in addition, if i dont want to store any values in that field, it returns '0' for some reason even when in the table there is default value.

I know it seems alot but can somone help me please.

Many Thanks

mrmufin

First, make sure your form action is "POST". The 31 Ham street problem sounds like you've either set the column type to 'INT' where it should be a CHAR or VARCHAR, or you're doing something to the data on the PHP to typecast it...

Check the data that's coming in from the form with a simple loop:

while(list($k,$v)=each($HTTP_POST_VARS)) {
	print($k . ":" . $v . "<br />");
}

You should see all the data that got posted from the form. Make sure you're getting the data you think you should be getting.

Problem 2 sounds also sounds like the wrong column data type...

Check your table structure.

kubis

Hi,

the first problem:
if only the first word stores into the DB, you may have an incorrect SQL query...
maybe you have something like:
insert into customers (id,address) values ($id,$address), what would produce "insert into customers (id, address) values (1, 30 elm street) and this may be wrong. Try to enclose the string variable into quotes, like insert into customers (id, address) values ($id,'".$address."') and it may work now.

problem 2:
try to insert the phone number not as a varchar, but as a string, it may help. and if not, try to use the sprintf() function or the number_format() function in PHP.

regards

edwardsbc

And just an aside: To be valid XHTML or HTML 4.0 every attribute in a tag must be in double quotes --

Most browsers are forgiving in this respect, but XML parsers are not.

kubis

Well sure, when speaking about XHTML, you should also note that input tag is not a pair tag, that means it should have the <tagname attrib="param" /> syntax (also add a slash before the closing '>') 🙂