Wilian Brain Wilian Brain - 1 year ago 79
SQL Question

add value +1 in phrase number

I want to add value in phrase in database sql in database i save phrasr like this


now my question how can add
in last value like this
DO-2500-03 / DO-2500-04

this my code

$getse = $DB_con->prepare("SELECT serial FROM `customer` WHERE user_add=:id ORDER BY serial DESC LIMIT 1");
$getse = $getse->fetch(PDO::FETCH_OBJ);
$addone = $getse->serial + 1;
echo $addone;

this is my code i get last serial and i want to add +1 for example last serial in database is
I want to get this value and add
To become like this

Answer Source

Split string, increase the last part and combine it back

$addone = explode('-', "DO-2500-04"); 
$addone[count($addone)-1] += 1;
// Append 0 if the last part less then 10
$addone[count($addone)-1] = str_pad($addone[count($addone)-1], 2, 0, STR_PAD_LEFT);
echo $addone = implode('-', $addone);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download