How to send values with Zeros to left SQL SERVER

Question

When trying to send values with zero on the left, when checking in the database I receive the values in zeros. Ex: 000431, appears in the database as 431. This value is being placed in the $prefix variable

Follow the code:

    <?php


$bomba1 = $_POST["bomba"]; 
$bomba = floatval($bomba1);

$prefixo1 = strval($_POST["prefixo"]);

$combustivel = $_POST["combustivel"];

$prefixo2 = str_pad($prefixo1, 6, '0', STR_PAD_LEFT);

$prefixo = substr($prefixo2, -5);     

echo $bomba ;
    echo $prefixo ;
    echo $combustivel ;

$serverName = "GALAXY\BDTL";
$connectionInfo = array( "Database"=>"Abastecimento", "UID"=>"", "PWD"=>"" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
     die( print_r( sqlsrv_errors(), true));
}

$sql = "INSERT INTO Abastecimento (prefixo, empresa) VALUES ($prefixo, 'TT' )";
//$params = array(1, "some data");

//$stmt = sqlsrv_query( $conn, $sql, $params);
$stmt = sqlsrv_query( $conn, $sql);
if( $stmt === false ) {
     die( print_r( sqlsrv_errors(), true));
}else{
    print_r("Gravação concluída");
}
?>

Answer 1

can use the following function:

replicate(string expression, integer expression);

example:

select empid,          
       replicate('0', 6 - len(salary)) + cast (salary as varchar) as salary
from   emp;  

empid       salary
----------- -----------
1           000300
2           000030
3           500000
4           001000

(4 row(s) affected)

follows the source of these examples: https://www.tech-recipes.com/rx/30469/sql-server-how-to-left-pad-a-number-with-zeros/

---

For php use the function str_pad:

<?php
$input = "300";
print str_pad($input, 10);                      // produz "300     "
print str_pad($input, 10, "0", STR_PAD_LEFT);  // produz "0000000300"
print str_pad($input, 10, "0", STR_PAD_BOTH);   // produz "000300000"
print str_pad($input, 6 , "0");               // produz "300000"
?>