PHP INSERT Bad data
From: Adrian Parker (adrian.parker_at_NOSPAMsympatico.ca)
Date: 04/29/04
- Next message: Jan Pieter Kunst: "Re: Forwarding to next php script on correct input?"
- Previous message: Tim Van Wassenhove: "Re: Forwarding to next php script on correct input?"
- Next in thread: Jan Pieter Kunst: "Re: PHP INSERT Bad data"
- Reply: Jan Pieter Kunst: "Re: PHP INSERT Bad data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 29 Apr 2004 12:26:31 -0400
I have the code below. It builds an INSERT command, and it gets run on the
database. Everything works fine except the database is only receiving the
first 6 characters of the phone number.
The field in the database can hold 10 digits (confirmed). The echo
statement shows that the phone number is indeed 10 characters long.
The second echo statement show the $query looks similar too:
INSERT INTO students Values ('', '1', 'SomeFirstname', 'SomeLastName',
'License', 'adrian.parker@sympatico.ca', ' 6135315960', ' ', ' ', ' ')
When I run this query in mySQL when logged onto the terminal, the phone
number appears fine.
How could truncation be happening?
if (isset($_POST["firstName"]))
{
$query = "INSERT INTO students Values ('', '1', '" . $_POST["firstName"] .
"', '
" . $_POST["lastName"] . "', '
" . $_POST["licenseNumber"] . "', '
" . $_POST["eMail"] . "', '
" . $_POST["phone"] . "', '
" . $_POST["city"] . "', '
" . $_POST["address"] . "', '
" . $_POST["birthDate"] . "')";
echo "Phone number is: " . $_POST["phone"] . "<br><br>";
echo "The query statement is: " . $query . "<br>";
$result = mysql_query($query) or die("Adding the student to the database
failed: " . mysql_error());
}
<Ade
-- Adrian Parker. Ordained priest. <adrian.parker@sympatico.ca> "A society that views graphic violence as entertainment ...should not be surprised when senseless violence shatters the dreams of it's youngest and brightest..." - Ensign (March 2004)
- Next message: Jan Pieter Kunst: "Re: Forwarding to next php script on correct input?"
- Previous message: Tim Van Wassenhove: "Re: Forwarding to next php script on correct input?"
- Next in thread: Jan Pieter Kunst: "Re: PHP INSERT Bad data"
- Reply: Jan Pieter Kunst: "Re: PHP INSERT Bad data"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
