loop is not showing Zero before numbers in framework

Question

I am making a form in custom framework in which when user enter 2 numbers e.g start number and ending number . the loop shows all numbers between those numbers . for example if user enter 0300 and 0309 the result will show

0300

0301

0302

0303

0304

0305

0306

0307

0308

0309

but it is showing

0300

301

302

303

304

305

306

307

308

309

Is there a problem with my loop ?

function did_ehmad_sec_submit($editForm) {
$count=0;
$start=$editForm['from_to'];
$end=$editForm['to_range'];
$desc=$editForm['description'];

for ($i=$start;$i<=$end;$i++)
{
$result = mysql_query("INSERT into did_number(did_number, description) VALUES ('$i','$desc')");
}

return $result; 
}

There's no leading 0 in base10 numbers, you could cast to string with a padding 0 — Damien Pirsy, Apr 20 '13 at 07:39

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

Courtesy : In PHP, how do I add to a zero-padded numeric string and preserve the zero padding?

try using this..

sprintf('%04d', $num);

edited May 23 '17 at 11:57

Community

1
1

answered Apr 20 '13 at 07:40

Ashwini Agarwal

4,828
2
42
59

where? please elaborate – Ehmad Imtiaz Apr 20 '13 at 07:44
Replace `echo 0301` with `sprintf('%04d', 0301);` – Ashwini Agarwal Apr 20 '13 at 09:15
well should i use $result instead of 0301 ? – Ehmad Imtiaz Apr 20 '13 at 09:30
yeah. you got it right. – Ashwini Agarwal Apr 20 '13 at 09:31
still the same ! Only first result shows 0 . 0300 301 302 303 304 305 306 307 308 309 like this – Ehmad Imtiaz Apr 20 '13 at 09:33

score 0 · Answer 2 · answered Apr 20 '13 at 07:43

Whilst you've not tagged your question as being MySQL, this is clearly what's in use.

As such, if you want to store the numbers in the database with a set number of digits (including preceding zeros), one solution would be to make use of the ZEROFILL attribute. (See the MySQL Numeric Type Attributes manual page for more information.)

score 0 · Answer 3 · answered Apr 20 '13 at 07:43

0

0 is removed automatically. So you can append manually or use ZEROFILL for a numeric column

answered Apr 20 '13 at 07:43

web2students.com

307
2
16

In database while creating table. See http://dev.mysql.com/doc/refman/5.0/en/create-table.html like **data_type: [ZEROFILL] ** – web2students.com Apr 20 '13 at 07:49

loop is not showing Zero before numbers in framework

3 Answers3