Disappear value 0 on output form

Question

I have an ad's website. There need to enter add description some more and telephone number. The telephone number starts 0, like 07780046 but after saving add appears without 0 is like 7780046. Any idea what's wrong?

Script for filling form:

        <tr>
            <td valign="top"><b>Telefono nr.</b></td>
            <td><input name="telephone" type="telephone" id="telephone" size="30" maxlength="13" value=""></td>
        </tr>

and script output. Add page:

    <?php if($ad['telephone']){ ?>
<b><?php echo "Telephone n."; ?></b>: 
<?php echo $ad['telephone']; ?>

Thank you for your time.

What is the column type of the phone number column in your database? Have you set it to `int`? — andrewsi, Oct 30 '13 at 18:34
As a note: I think `tel` is the right input type and you could add a pattern like: `pattern="[0-9]{13}"`. — insertusernamehere, Oct 30 '13 at 18:44
Hi. Was set to bigint. Is not working with any int ether. Sets to defult value. All posted ads had same telephone number. — Audrius Gelezinis, Oct 30 '13 at 21:25
pattern="[0-9]{13}" is not working ether, but i like it. thank you. — Audrius Gelezinis, Oct 30 '13 at 21:27

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

Save the telephone number as a string. I doubt you will want to do any math operations on it.

If you want to validate your phone numbers check out the answer below:

A comprehensive regex for phone number validation

edited May 23 '17 at 12:05

Community

1
1

answered Oct 30 '13 at 18:39

otherDewi

1,098
10
24

It's working! Database set to String "chart". No Math :))) Thank you Dewi. – Audrius Gelezinis Oct 30 '13 at 21:31

Disappear value 0 on output form

1 Answers1