Member Avatar for Raju_3

How to add the string before increment values with letters like A0001 increment to A0002---- please help me

  • 3 Contributors
  • 2 Replies
  • 486 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by AndrisP

Dani AI

Generated

asked for IDs like A0001 → A0002. correctly pointed out that keeping the numeric sequence in the database and only adding the letter when presenting the value is usually simpler and safer. ’s PHP example shows how to pad a number in memory, but that approach doesn’t persist across requests or scale to multiple web processes — it’s fine for quick demos but not for production use.

A robust pattern is to let the table use an INT AUTO_INCREMENT primary key and generate the display label only when needed (SELECT or right after INSERT). This keeps queries, joins and indexes fast and avoids duplicate IDs. Example (PHP + PDO): 

$pdo->beginTransaction();
$pdo->prepare("INSERT INTO items (payload) VALUES (:p)")->execute([':p'=>$payload]);
$id = $pdo->lastInsertId();
$pdo->commit();
$label = 'A' . sprintf('%04d', $id);

If the letter must roll (A9999 → B0001 or eventually AA0001), compute the prefix from the integer using a base-26 mapping and the numeric remainder. A concise conversion:

function numToLetters($n) {
    $s = '';
    while ($n > 0) {
        $n--;
        $s = chr(65 + ($n % 26)) . $s;
        $n = intdiv($n, 26);
    }
    return $s;
}
$block = intdiv($id - 1, 10000) + 1;      // which letter block
$seq   = (($id - 1) % 10000) + 1;         // 1..10000
$label = numToLetters($block) . sprintf('%04d', $seq);

Notes and cautions: if the formatted code must be stored and guaranteed unique, use a dedicated counter row with transactions (SELECT … FOR UPDATE) or a database-generated/stored column (MySQL generated columns) rather than generating in-memory. Avoid using the formatted string as the primary key for joins — keep the INT PK and index the label if searches require it.

Recommended Answers

All 2 Replies

Member Avatar for pritaeas

I suggest you don't do this in the table, but just format the ID when you want to output it.

Member Avatar for AndrisP 
$incr = 0;
function my_increment()
    {
    global $incr;
    $my_string = "Bla-bla-bla";
    $my_increment = str_pad($incr, 4, "0", STR_PAD_LEFT); // how many digits you need (eg.4)
    $incr++ ;
    return $my_string.$my_increment;
    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.