how to add string to the random generated number using php?

Question

In my php code, while inserting new record, invoice number should be 0001. Here I want to add characters/a word(for example 'optical') and it should be like optical0001. How can I add this before the number?

$query          = "select * from cust_report_invoices order by invoiceID desc limit 1";
    $result         = $link->query($query);
    $row            = $result->fetch_assoc();
    $invoiceNo      = $row['invoiceNo'];
    $prefix = 'Baopt_'; 
    $getinvoiceNo   = $prefix . str_pad($invoiceNo + 1, 4, 0, STR_PAD_LEFT);

$sql            = "INSERT INTO cust_report_invoices (invoiceNo,invoiceDate)
VALUES ('$getinvoiceNo', '$getinvoiceDate'            )";

Possible duplicate of Adding a static prefix on an incrementing number — prasanth
– prasanth, Commented Mar 10, 2019 at 15:30

dWinder · Accepted Answer · 2019-03-12 12:25:35Z

2

str_pad return string (doc). So just concat with .:

$prefix = 'optical';
$invoice   = $prefix . str_pad($invoiceNo + 1, 4, 0, STR_PAD_LEFT);

Edit

When adding new element you need to cut the prefix out - you can use this:

$prefix = 'Baopt_';
$invoiceNo = $row['invoiceNo']; 
if (substr($invoiceNo, 0, strlen($prefix)) == $prefix) // if already has prefix
    $invoiceNo = substr($invoiceNo, strlen($prefix)); // remove it
$getinvoiceNo   = $prefix . str_pad($invoiceNo + 1, 4, 0, STR_PAD_LEFT);

edited Mar 12, 2019 at 12:25

answered Mar 10, 2019 at 15:15

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

8 Comments

becool Over a year ago

invoiceno is unique key in database.Here am facing issue ie when first time am inserting like Baopt_001.It is not adding Baopt_002 on the second time.Its still adding Baopt_001 on the second insertion and so it is showing error called duplicate entry

dWinder Over a year ago

@becool What is the code you use to insert data to DB? this seem new issue and not related to the string concatenation - Did you open new question about it?

becool Over a year ago

there is no issues in insert query.In this code invoice number is not adding thats my issue

dWinder Over a year ago

Does "invoiceNo" field in the DB is int or string?

becool Over a year ago

when i removed "Baopt_ ".it will insert like 001 ,002 etc...I am facing issue when "Baopt_ "added

|

Koen Hollander · Accepted Answer · 2019-04-14 09:53:03Z

1

When working in PHP you can use the . as concatenation-operator. I see that you use the function str_pad that returns as string.

So you can just concat the prefix with the invoice number like this.

$prefix = 'optical';
$invoice   = $prefix . str_pad($invoiceNo + 1, 4, 0, STR_PAD_LEFT);

$prefix can be anything you want.

When invoice = 0001 this example will return optical0001

edited Apr 14, 2019 at 9:53

answered Mar 10, 2019 at 15:31

Koen Hollander

1,7116 gold badges28 silver badges42 bronze badges

Comments

Błażej Kowalczyk · Accepted Answer · 2019-03-10 15:15:40Z

0

Just "Opticals".$getinvoiceNo Dot is concatenating strings.

answered Mar 10, 2019 at 15:15

Błażej Kowalczyk

1944 bronze badges

Comments

Sirapat · Accepted Answer · 2019-03-10 15:17:15Z

0

Not sure if I understand correctly, you want to prepend "optical" to $getinvoiceNo?

If yes then it is simple,

invoiceId = "optical$getinvoiceNo"

answered Mar 10, 2019 at 15:17

Sirapat

4942 gold badges9 silver badges15 bronze badges

Collectives™ on Stack Overflow

how to add string to the random generated number using php?

4 Answers 4

8 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related