Display data from database with space in php

Question

How to show data from my database, but with space in it? I have data "6285398980808" on my database, but i want to show it like "62 853 9898 0808". Any suggestion greatly appreciated.

@paranoid what do you mean? If You mean that what I've worked, here some my code $b="select * from tb_dinilai"; $display=mysql_query($b); $row=mysql_fetch_array($display); $nip2=$row['nip_dinilai']; echo $nip2; — Anditya Pratama
– Anditya Pratama, Commented Feb 2, 2016 at 6:21
@AjayMakwana I want to show it as 62 853 9898 0808 (with space) — Anditya Pratama
– Anditya Pratama, Commented Feb 2, 2016 at 6:25

devpro · Accepted Answer · 2016-02-02 06:25:54Z

3

If your number fixed as 13 digits number than you can use preg_replace() as:

<?php
//62 853 9898 0808 required
$number = 6285398980808;

$formatted_number = preg_replace("/^(\d{2})(\d{3})(\d{4})(\d{4})$/", "$1 $2 $3 $4", $number);
echo $formatted_number; // 62 853 9898 0808
?>

answered Feb 2, 2016 at 6:25

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anditya Pratama Over a year ago

It's working, i can use it for other separate format too

devpro Over a year ago

@AndityaPratama: ahan, best of luck bro... happy coding.

skz · Accepted Answer · 2016-02-02 06:19:07Z

2

There is a special function for that number_format - just play with parameters.

answered Feb 2, 2016 at 6:19

skz

1214 bronze badges

1 Comment

Edrean Ernst Over a year ago

The OP's request for formatting is not separated in thousands.

Ninju · Accepted Answer · 2016-02-02 06:26:23Z

2

You can use number_format():

number_format — Format a number with grouped thousands

answered Feb 2, 2016 at 6:26

Ninju

2,5322 gold badges16 silver badges21 bronze badges

1 Comment

Edrean Ernst Over a year ago

The OP's request for formatting is not separated in thousands.

Edrean Ernst · Accepted Answer · 2016-02-02 06:36:40Z

2

Use CONCAT_WS(' ', SUBSTR(str, 1, 2), SUBSTR(str, 3, 3), SUBSTR(str, 6, 4), SUBSTR(str, 10, 4)) in your SELECT statement. Just replace 'str' with the name of the field.

If the field name is nip_dinilai and your table name is tb_dinilaithen the query will look like this :

SELECT CONCAT_WS(' ', SUBSTR(nip_dinilai, 1, 2), SUBSTR(nip_dinilai, 3, 3), SUBSTR(nip_dinilai, 6, 4), SUBSTR(nip_dinilai, 10, 4)) AS nip_dinilai FROM tb_dinilai

edited Feb 2, 2016 at 6:36

answered Feb 2, 2016 at 6:24

Edrean Ernst

3801 silver badge15 bronze badges

Collectives™ on Stack Overflow

Display data from database with space in php

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related