phone number (text) drop starting 0 on datatable

phone number (text) drop starting 0 on datatable

LapointeLapointe Posts: 430Questions: 81Answers: 4

Datatable display varchar number with leading 0 without this (these) 0

    var table = $('#donnees').DataTable( {
        dom: "PQBlfrtp",
            ajax: {
....
        columns: [ 
            {data: 'utilisateurs.Telephone'}
        ],....

show

when database data is

php is

            Editor::inst( $db, $TblName )
                ->fields(
                    Field::inst( 'utilisateurs.ID'),
                    Field::inst( 'utilisateurs.Telephone' )
                        ->validator( Validate::notEmpty( ValidateOptions::inst()
                            ->message( 'le numéro de téléphone doit être renseigné...' )
                        )
                    ),
                    Field::inst( 'utilisateurs.ID_Statut' ), ...

Any help please ?

Answers

This discussion has been closed.