variable types

Brazil

Hi Guys!
I've got a insert stmt in my form.The structure of my table is:

id int primary key auto increment
First_name varchar
Surname varchar
Tel_no num
Fax_no num

When i try and insert information in this form then it is automatically inserted in my database.This is the form that insert data in the db.
<?php
include("connect.php");

if ($submit == "submit")
{

$query = "insert into details
(id,first_name,surname,tel_no,fax_no)
values ('$id','$first_name','$surname','$tel_no','$fax_no')";

$result = mysql_query($query) or
die (mysql_error());

echo "thanks for entering information<b>\n";

}

else

{

echo "View Information";

}

My problem is i can enter a string in the id text field,enter an integer in the first_name text field which not the way its supposed to be.

What i want is that if i enter a wrong data type in the specific field i must get an error , and the error should tell me the correct data type i should enter.

thanx in advance

stolzyboy

your gonna have to check then with php

just because you have someting set as varchar, doesn't mean mysql isn't going to let you input it

you will need to check your variables with

www.php.net/is_bool
www.php.net/is_float
www.php.net/is_integer
www.php.net/is_numeric
www.php.net/is_string
www.php.net/is_array
www.php.net/is_object

Brazil

Hi!
Can you be more precise plz cuz i cant get clear examples of how to do this and in which form.
My form to enter information is below:

<?php
include ("connect.php");
?>

<h2>Please Enter Your Information </h2>

<form action= add.php action=post>
<input type=int name=id>id <br>
<input type=text name=first_name>first_name <br>
<input type=text name=surname>surname <br>
<input type=text name=tel_no>tel_no <br>
<input type=text name=fax_no>fax_no<p>
<input type="submit" name="submit" value="submit">
</form>

After submition,the information is inserted in the database by this code:

<?php
include("connect.php");

if ($submit == "submit")
{

$query = "insert into details
(id_no,first_name,last_name,tel_no,fax_no)
values ('$id_name','$first_name','$last_name','$tel_no','$fax_no')";

$result = mysql_query($query) or
die (mysql_error());

echo "thanks for entering information<b>\n";

}

else

{

echo "View Information";

}

My question is how do i make sure that users insert int where relevant and string as defined by the data types i've defined.

stolzyboy

well if you have a text box names integer, check on php page with

if (!is_integer($_POST['integer']))
{
echo "field integer must be an integer";
}

and

if (!is_string($_POST['string']))
{
echo "field integer must be a string";
}

etc......

just wrap the variable on the php page with what function you
want to check with and use an if to check